TickerFetch

Prices GOOGLEFINANCE won’t return.

One function for your spreadsheet — =TFETCH("AAPL") — covering crypto, EU-domiciled ETFs, funds and smaller exchanges that Google’s built-in leaves as #N/A.

Get a free trial key

7-day free trial. No credit card.
$2.99/month or $24/year after that.

Illustration — figures are examples, not live quotes.

What it covers

GOOGLEFINANCE is free and fine until it isn’t. The gaps people hit most often:

  • Cryptocurrencies
  • EU-domiciled ETFs (Xetra, Euronext and similar)
  • Mutual funds
  • Smaller and non-US exchanges

Prices come from Yahoo Finance and are cached for about five minutes, so this is a portfolio-tracking tool rather than a trading feed. Your sheet refreshes when you open it, or on demand from the TickerFetch menu.

The add-on asks for the narrowest permissions Google offers: it can only see the spreadsheet you use it in — never your other files — and the only thing that leaves the sheet is the ticker symbol and your licence key. No cookies, no analytics, no third-party scripts on this page.

Get your key

New here? You get a 7-day free trial — no card, nothing is charged, and no subscription starts on its own.
Lost your key? Enter the same address and we’ll send it again.

We email the key here. This address also identifies your licence if you subscribe later, so use one you’ll keep.

Pricing

One price, every feature. Cancel whenever you like.

  • Monthly

    $2.99 / month

    Billed monthly. Cancel any time.

  • Yearly Save 33%

    $24 / year

    $35.88 if you paid monthly — so roughly two months free.

Subscribing

Card payments open shortly. If your trial is ending and you want to keep going, email support@tickerfetch.com and we’ll sort it out and tell you the moment self-service checkout is live.

When it is, here is how it will work — no surprises:

  • You keep the same key. Nothing changes in your spreadsheet.
  • Checkout is handled by Stripe; we never see your card details.
  • The subscription is tied to the email address your key was issued to.
  • Cancel any time — access runs to the end of the period you already paid for.

What happens when the trial ends

On day 8 your cells show #TRIAL_ENDED instead of a price. That is the whole of it:

  • Nothing is charged. There is no card on file to charge.
  • Nothing is deleted. Your formulas and sheets are untouched — the prices come back as soon as you subscribe, with the same key.
  • No reminder email is sent. We don’t email you as the trial runs out, so note the expiry date from your key email if that matters to you.

Help

My cells show an error

#SET_LICENSE_KEY
Either no key is saved in this Google account, or the saved key wasn’t recognised. Open Extensions › TickerFetch › Set license key… and paste your key. If you already did, the key may be mistyped — have it sent again and paste it fresh.
#TRIAL_ENDED
The trial or subscription for that key has expired. See subscribing.
#INVALID_TICKER
The symbol isn’t recognised upstream. Check the exchange suffix — Xetra listings look like VWCE.DE, crypto like BTC-USD.
#QUOTA
More than 600 requests in an hour on one key. It clears itself; large sheets are cached, so this usually means a formula is recalculating in a loop.
#ERROR
Something else went wrong — a network problem or an upstream outage. Try a refresh, and email support if it persists.

I lost my licence key

Go to Get your key and enter the same email address you used before. The same key is sent again — you will not get a second trial, and nothing is charged.

I saved my key but the cells still show #SET_LICENSE_KEY

Google Sheets caches the result of a custom function, so the cells don’t re-run on their own. Use Extensions › TickerFetch › Refresh data now. If nothing changes, wait a minute and click it again — refreshes are throttled to one a minute.

How do I set it up?

  1. Open your spreadsheet.
  2. Extensions › TickerFetch › Set license key…
  3. Paste the key and click Save key.
  4. Use =TFETCH("AAPL") or =TFETCH(A2:A100) in any cell.

When do prices update?

Whenever you open the spreadsheet, and on demand via Extensions › TickerFetch › Refresh data now. Prices are cached for about five minutes, so a refresh within that window returns the same number.

Something else

Email support@tickerfetch.com.