Why your Bitcoin (or crypto) price isn't working in Google Sheets
You typed a crypto ticker into GOOGLEFINANCE and got #N/Aor “no data.” You're not doing it wrong — GOOGLEFINANCE just barely supports crypto. Here's why, and how to track any coin in real time.
Free to start · no sign-up needed · real-time on every plan.
July 5, 2026 · 5 min read
Does GOOGLEFINANCE support crypto at all?
Only a handful of coins. GOOGLEFINANCE can return a few major cryptocurrencies through a currency-pair syntax like =GOOGLEFINANCE("CURRENCY:BTCUSD"). It works for Bitcoin and a couple of others — but the moment you try most altcoins, you get #N/A or a blank. There is no broad crypto coverage; it was never really built for it.
Why does it show #N/A or 'no data' for my coin?
Two usual reasons:
- The coin isn't supported. Beyond the largest few, GOOGLEFINANCE simply has no crypto data to return.
- The ticker format is finicky. Crypto needs the
CURRENCY:pair syntax, not a plain ticker — and even then, only for supported coins.
So if you hold anything outside the majors, a Google Sheets crypto portfolio is broken from the start.
The API workaround (and why it's a pain)
The usual fix is to pull prices from a crypto API — CoinGecko or CoinMarketCap — using IMPORTDATA or a custom IMPORTJSONscript. It can cover far more coins, but it comes with real friction: you sign up for an API key, paste it into a script, wrangle the JSON into cells, and then babysit rate limits and breakages. That's a project, not a portfolio.
The no-setup way
Stealth Quotes has crypto built in. Type a ticker with a .X suffix — BTC.X, SOL.X, DOGE.X — and the live price appears right next to your stocks, in the same spreadsheet-style grid. No API keys, no scripts, no #N/A. Stocks and crypto, real-time, in one place.
| GOOGLEFINANCE | Crypto API + script | Stealth Quotes | |
|---|---|---|---|
| Major coins (BTC, ETH) | |||
| Altcoins beyond the top few | |||
| Real-time | |||
| No API key or script | |||
| Stocks + crypto together |
Note on tickers: in Stealth Quotes a plain ticker is a stock, and the .X suffix marks crypto — so AAPL is Apple and BTC.X is Bitcoin, side by side.
Keep reading
Frequently asked questions
Does GOOGLEFINANCE support crypto?
Only partially. GOOGLEFINANCE covers a small set of major coins using a CURRENCY: syntax (for example CURRENCY:BTCUSD), but it returns #N/A or 'no data' for most coins beyond the top few, and the coverage is inconsistent.
Why does GOOGLEFINANCE show #N/A for my coin?
Usually because the coin isn't in GOOGLEFINANCE's limited crypto set, or the ticker format is off. Beyond the largest coins there simply is no data to return.
How do I get live crypto prices in Google Sheets?
You can wire up a crypto API (CoinGecko, CoinMarketCap) with IMPORTDATA/IMPORTJSON and an API key — which means setup, rate limits and maintenance — or use a tool like Stealth Quotes that has crypto built in and shows any coin in real time next to your stocks.
Can I track stocks and crypto in the same place?
Yes. Stealth Quotes shows both in one spreadsheet-style grid — type a stock ticker, or a crypto ticker with a .X suffix (e.g. BTC.X, SOL.X), and both update in real time.
Is Stealth Quotes free?
Yes — real-time stock and crypto prices are free on every plan, with no sign-up needed to try it.
Track any coin — no #N/A, no scripts.
Real-time crypto and stocks in one spreadsheet-style grid. Free, no sign-up needed.