Why GOOGLEFINANCE returns #N/A for crypto

GOOGLEFINANCE is genuinely great for stocks — it's free, built in, and covers thousands of equities, ETFs and currencies. But the moment people point it at crypto, a common wall appears: #N/A, or a price that's clearly hours old. Here's why, and what actually fixes it.

Reason 1 — the coin isn't supported

This is the big one. GOOGLEFINANCE recognises only a short list of large-cap cryptocurrencies. Bitcoin and Ethereum usually resolve; the long tail of altcoins — think SOL, ARB, ONDO, or anything mid-cap — typically returns #N/A because there's simply no data behind the function for that symbol.

There's no setting to fix this — the coverage just isn't there. If your portfolio is anything but the two biggest coins, you'll hit this fast.

Reason 2 — the ticker format is wrong

For the coins it does support, GOOGLEFINANCE is picky about format. It expects a concatenated pair, not a dash:

=GOOGLEFINANCE("BTC-USD") → #N/A (wrong)

=GOOGLEFINANCE("BTCUSD") → resolves (right, for supported coins)

So if you're only after Bitcoin or Ethereum, dropping the dash may be all you need. It won't help for unsupported coins, though.

Reason 3 — the feed is delayed or dropped

Even for supported coins, GOOGLEFINANCE data is "for informational purposes," can lag by up to 20 minutes, and occasionally returns #N/A intermittently when the source hiccups. A common band-aid is to wrap it so a blank shows instead of an error:

=IFERROR(GOOGLEFINANCE("BTCUSD"), "")

That hides the symptom, not the cause — you still don't get a price.

The one-line fix

For crypto specifically, a dedicated add-on solves all three problems at once. Install the free CryptoTrackPro add-on (Extensions → Add-ons → Get add-ons → search "CryptoTrackPro"), then:

=cryptotrackpro("BTC-USD")

Where GOOGLEFINANCE gives up, this resolves — the same coins that returned #N/A now return a price:

=cryptotrackpro("SOL-USD") → 182.40 =cryptotrackpro("ONDO-USD") → 0.94 =cryptotrackpro("ETH-GBP") → 2,841 (any of 150+ currencies)

It covers 10,000+ coins, needs no API key, and the free plan does 50 lookups a day. There's a matching =cryptotrackproPrice("BTC","2021-04-14") for historical prices, too — handy for cost basis.

Keep GOOGLEFINANCE for stocks — or replace it entirely

You don't have to choose. Keep GOOGLEFINANCE for your equities and use CryptoTrackPro for crypto. Or, if you'd rather have one consistent syntax, CryptoTrackPro also prices tokenized stocks and commodities with =cryptotrackproRWA("AAPL"), so your whole portfolio can live in one sheet. More on that in the GOOGLEFINANCE alternative guide and tracking stocks & crypto together.

FAQ

What crypto does GOOGLEFINANCE support?

Only a limited set of large caps (e.g. BTC, ETH) via tickers like "BTCUSD". Most altcoins aren't covered.

Is CryptoTrackPro free?

Yes — 50 lookups a day on the free plan, no API key. Base and Pro raise or remove the limit.

← Back to the blog