Help & support

Email support@tickerfetch.com — a real person answers, usually within a day.

Getting started

Install TickerFetch and open your spreadsheet.
Extensions › TickerFetch › Get free trial key, then click Get free trial key in the sidebar and confirm on tickerfetch.com — the key arrives by email. Seven days free, no card.
Paste the key in the same sidebar (Extensions › TickerFetch › Set license key…) and click Save key.
Type =TFETCH("AAPL") in any cell.

Every formula and attribute is listed on the cheat sheet.

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 — it is checked as you save, and the sheet refreshes automatically. If the key won’t save, it may be mistyped — have it sent again and paste it fresh. If the cells still show this error after saving, save the key once more — it may have been accepted while our service was briefly unreachable.
#TRIAL_ENDED: The free trial for that key has ended. Nothing is charged and nothing is deleted — see subscribing to keep going with the same key.
#SUBSCRIPTION_ENDED: The subscription for that key has lapsed — it was cancelled and the paid period ran out, or a renewal payment didn’t go through. Subscribe again with the same email and the same key starts working again.
#INVALID_TICKER: The symbol isn’t recognised, or the cell the formula reads is empty — type a ticker there and the error clears. TickerFetch uses Yahoo Finance symbols — look the ticker up on finance.yahoo.com and copy it exactly. Xetra listings look like VWCE.DE, crypto like BTC-USD.
#UNKNOWN_ATTRIBUTE: The second argument of =TFETCH() isn’t a known attribute — usually a typo. Valid: price, name, currency, changepct, change, previousclose, dayhigh, daylow, week52high, week52low, volume, exchange, type, tradetime, yieldpct, dividend12m, lastdividendexdate, lastdividendamount (capitals and underscores are ignored).
#UNKNOWN_TYPE: The third argument of =TFETCHHISTORY() isn’t a known table type — usually a typo such as "dividend". Valid: prices (the default) or dividends.
#NO_DATA: The ticker is fine, but this attribute isn’t available for it — for example dividend yield on a symbol we have no dividend data for, or intraday attributes (dayhigh, daylow, volume) on a mutual fund, which prices once a day. Note that 0 is different: it means the symbol paid no dividends in the last 12 months.
#QUOTA: An unusually high number of requests in a short time — far more than normal use, even for large sheets. The limit is 240 requests an hour per key. It clears itself within the hour; this almost always 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.

Frequently asked

I lost my license key

Go to Get your key and enter the same email address you used before, or open Extensions › TickerFetch › Set license key… and use Lost your key? Have it sent again. 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

Saving a key refreshes your sheet automatically, so this should clear on its own. If it doesn’t, use Extensions › TickerFetch › Refresh data now. If nothing changes, wait a minute and click it again — menu refreshes are throttled to one a minute.

Which ticker symbols do I use?

Yahoo Finance symbols. If a ticker works on finance.yahoo.com, it works in =TFETCH() — copy it exactly as shown there.

When do prices update?

Whenever you open the spreadsheet, and on demand via Extensions › TickerFetch › Refresh data now. Quotes move on a few-minute cycle, so two refreshes close together will usually show the same price — that’s expected, not an error.

Day change (changepct) tracks the regular trading session — pre- and post-market moves aren’t included. Price history is cached longer: history for ranges above five days can run up to an hour behind.

How do I cancel?

Cancel any time from the billing portal linked on the subscription section. Your key keeps working until the end of the period you already paid for — nothing is deleted from your sheet.

Still stuck?

Email support@tickerfetch.com with the formula you used and the symbol — that is usually enough to spot the problem straight away.