How to fix GOOGLEFINANCE #N/A and 'no data' errors
GOOGLEFINANCE throws #N/Amore than any other Sheets function. Most of the time it's one of a handful of causes. Here's how to fix each — and when it's a dead end.
Free to start · no sign-up needed · real-time on every plan.
July 5, 2026 · 6 min read
1. The ticker is wrong or needs an exchange prefix
The most common cause. Double-check the symbol, and for non-US or ambiguous tickers add the exchange: =GOOGLEFINANCE("NASDAQ:AAPL") or "LON:VOD". A delisted or renamed ticker will also return #N/A.
2. The attribute isn't supported
GOOGLEFINANCE supports a fixed set of attributes — price, priceopen, high, low, volume, marketcap, pe, and a few others. Ask for something outside that list (most notably dividends or dividend yield, which it simply doesn't have) and you get #N/A.
3. It's crypto beyond the top few coins
Crypto needs the CURRENCY: pair syntax and only works for a handful of major coins. Anything else returns #N/A because there's no data — more on why crypto fails here.
4. The data is temporarily missing or the sheet hasn't recalculated
Sometimes it's a transient hiccup. Re-enter the cell, or change the spreadsheet's recalculation setting to nudge it. Remember GOOGLEFINANCE only updates while the sheet is open — a closed tab shows stale values, and reopening can briefly show #N/A while it reloads.
When it isn't a bug — it's a limit
Three of the four causes above are fixable typos or timing. But two are hard walls: dividends and most crypto aren't #N/Ayou can fix — they're data GOOGLEFINANCE doesn't have. If that's what you need (or you want real-time prices and a self-updating portfolio), Stealth Quotes does all of it with no formulas to break — you type a ticker and get a price, dividends and crypto included.
Keep reading
Frequently asked questions
Why does GOOGLEFINANCE show #N/A?
Usually one of: a wrong or delisted ticker, an unsupported attribute (dividends, most crypto), a symbol that needs an exchange prefix, or a temporary data hiccup. GOOGLEFINANCE also only recalculates while the sheet is open.
Does GOOGLEFINANCE work for crypto?
Only for a few major coins via the CURRENCY: syntax (e.g. CURRENCY:BTCUSD). For most coins it returns #N/A because there's no data.
How do I refresh GOOGLEFINANCE data?
It recalculates while the sheet is open. You can force a recalculation by editing and re-entering the cell, or toggling the sheet's recalculation setting — but it won't update at all while the tab is closed.
What if GOOGLEFINANCE just can't do what I need?
For dividends, most crypto, real-time prices, or a self-updating portfolio, GOOGLEFINANCE hits hard limits. A no-formula tool like Stealth Quotes covers those without any of the error-prone formula wiring.
Skip the #N/A entirely.
No formulas to break — type a ticker, get a real-time price. Stocks, crypto and dividends. Free, no sign-up.