GOOGLEFINANCE Crypto: 17 of 30 Coins Work, Tested (2026)

Yes, GOOGLEFINANCE still returns crypto prices in Google Sheets, but only for some coins. On October 15, 2026 we ran =GOOGLEFINANCE("CURRENCY:BTCUSD")Copy and the same formula for 29 more of the largest coins: 17 returned a price and 13 returned #N/A, including Dogecoin, Chainlink, Avalanche and both big stablecoins. The shorter =GOOGLEFINANCE("BTCUSD")Copy worked for exactly three: BTC, ETH and BCH.

So if your coin is on the working list below, GOOGLEFINANCE is fine for a casual sheet. If it isn't, no syntax trick will fix it. For every other way to pull prices, from add-ons to one-line IMPORTDATA hacks, see the complete guide to getting crypto prices in Google Sheets.

GOOGLEFINANCE crypto ticker list (tested October 15, 2026)

Google doesn't publish a list of supported crypto pairs. Its GOOGLEFINANCE help page doesn't mention crypto at all. So we checked by hand.

Tested on October 15, 2026 in Google Sheets. One cell per coin, two syntaxes, nothing else in the sheet.

Scorecard: 17 of 30 with the CURRENCY: prefix, 3 of 30 without it. We also tried a euro pair, =GOOGLEFINANCE("CURRENCY:BTCEUR")Copy, and it worked.

A few results surprised us. DOGE and TRX sit near the top of the market-cap list and get nothing. USDT and USDC fail too, which matters if you park cash in stablecoins and want your totals to add up. Meanwhile ICP, APT and POL, all much smaller, work fine. Coverage doesn't track market cap in any way we could spot, so test your own coins before you build a sheet around them.

CURRENCY:BTCUSD vs BTCUSD: which syntax to use

Use the prefix. CURRENCY: tells GOOGLEFINANCE to treat the string as a currency pair, the same form it uses for CURRENCY:EURUSD. Without it, Sheets has to guess what BTCUSD means, and in our test it guessed right three times out of thirty.

=GOOGLEFINANCE("CURRENCY:BTCUSD")   → works
=GOOGLEFINANCE("BTCUSD")            → works, but only for BTC, ETH and BCH
=GOOGLEFINANCE("CURRENCY:SOLUSD")   → works
=GOOGLEFINANCE("SOLUSD")            → #N/A
Copy

Plenty of older tutorials teach the short form. That's probably where the Reddit complaint "GOOGLEFINANCE only gives you 4 cryptos" comes from: people tried the short form, got a handful of hits and gave up.

To keep tickers in a column instead of hard-coding each one, build the string:

=GOOGLEFINANCE("CURRENCY:" & A2 & "USD")
Copy

Google Finance (the website) vs GOOGLEFINANCE (the function)

People search "google finance crypto" and end up in two different places. Same name, two different things.

• Google Finance is the website at google.com/finance. You read it. Its crypto pages put a hyphenated pair in the address, like BTC-USD.
• GOOGLEFINANCE is a function inside Google Sheets. You call it from a cell with a string like "CURRENCY:BTCUSD".

Seeing a coin on the website doesn't mean the function will return it. Google documents the function on its own help page, which says quotes "may be delayed up to 20 minutes" and are "not for trading purposes or advice." It lists no crypto pairs. For the function, the dated table above is the closest thing to a ticker list you'll find.

The result for GOOGLEFINANCE is not available

This message (or a plain #N/A) almost always means GOOGLEFINANCE has no data for that pair. Check the table above. If your coin shows #N/A there, the formula is fine and the coin simply isn't covered. If the coin is on the working list, make sure you used CURRENCY: and the bare ticker.

The usual causes, roughly in order of how often they come up:

1. The coin isn't covered. DOGE, LINK, AVAX, TRX, PEPE and friends. Nothing you type will change that.
2. No CURRENCY: prefix. "SOLUSD" fails, "CURRENCY:SOLUSD" works.
3. A hyphen or slash in the pair. BTC-USD is the website's address format, and BTC/USD is the old CRYPTOFINANCE add-on's format. Use CURRENCY:BTCUSD.
4. A gap on Google's side. Coins that worked yesterday sometimes return #N/A for a while. More on that below.

Stuck on cause #1? Swap that one cell for a formula that covers the coin. CoinTable, a Google Sheets add-on for cryptocurrency prices, takes the plain ticker:

=COINTABLE("DOGE")
=COINTABLE("LINK")
=COINTABLE("AVAX/EUR")
Copy

Do this only for crypto. COINTABLE reads every ticker as a coin, and some stock and index tickers are also coins: TSLA, META, SPX and GOLD.

It covers 10,000+ coins in 63 currencies, and the free plan gives you 300 updates a month. An update is one coin in one currency, so fifty cells of =COINTABLE("BTC")Copy count as one, and the same coin again within 6 hours is free. Full syntax for every attribute is in the COINTABLE reference.

GOOGLEFINANCE not working

When GOOGLEFINANCE isn't working for crypto, first work out which kind of broken you have: #N/A on some coins, #N/A on every coin, or a number that never changes. Each has a different cause, and only one is fully in your hands.

• #N/A on some coins: coverage. See the table and the section above.
• #N/A on every coin, BTC included: paste =GOOGLEFINANCE("CURRENCY:BTCUSD")Copy into an empty cell. If that fails too, Google's feed is having a bad day. Sheets users have reported multi-day freezes where even BTC stopped moving, and the top reply was that there's nothing to do but wait.
• #VALUE! after converting to another currency: if you multiply a USD price by a second GOOGLEFINANCE call for the exchange rate, one failed call sinks the whole cell. Ask for the pair directly. CURRENCY:BTCEUR worked in our test.
• A number that won't move: that's the next section.

GOOGLEFINANCE("CURRENCY:BTCUSD") not updating

If =GOOGLEFINANCE("CURRENCY:BTCUSD")Copy shows a number that won't change, it's usually Google's schedule, not your sheet. Google says GOOGLEFINANCE quotes "may be delayed up to 20 minutes," and Sheets' calculation settings page gives the same figure for how often the function recalculates.

What you can and can't do about it:

• Twenty minutes behind is normal. That's the documented behavior. Don't fight it.
• Hours or days behind is an outage. One r/Bitcoin user watched the formula keep returning $63,127 while the market moved on. You wait it out.
• The recalculation setting won't speed it up. File → Settings → Calculation decides when your own formulas recompute. Google's page lists GOOGLEFINANCE separately, with its own delay.

If a 20-minute lag and the odd frozen day are fine for a weekly check-in, keep GOOGLEFINANCE. If they aren't, the CoinTable formulas above update when you press Refresh (on Plus, also when you open the file and every hour), and their prices are up to 30 minutes old on Free and up to 5 minutes on Plus.

What GOOGLEFINANCE gives you for crypto, and what it doesn't

We tested one thing: the default attribute, price. Google's help page lists attributes such as marketcap, volume and changepct, but it describes them for stocks. Whether a CURRENCY: pair returns them is undocumented, and we wouldn't build a sheet on it.

Here's the swap when you need more than a price:

"changepct" returns a plain number, as in GOOGLEFINANCE, so 7.5 means +7.5%. Format the cell however you like. Periods other than 24h may need Plus.

Moving an existing sheet over is mostly find-and-replace. For crypto, you can keep a GOOGLEFINANCE formula and swap the function name: =GOOGLEFINANCE("CURRENCY:BTCEUR")Copy becomes =COINTABLE("CURRENCY:BTCEUR")Copy. Do this only for crypto. COINTABLE reads every ticker as a coin, and some stock and index tickers are also coins: TSLA, META, SPX and GOLD. A stock formula would quietly show a coin's price.

If you're also leaving the old CRYPTOFINANCE add-on behind, the CRYPTOFINANCE migration guide maps its pair syntax. Starting from scratch? The crypto portfolio tracker walkthrough puts these formulas into a working sheet.

When GOOGLEFINANCE is still the right call

It's built in. No install, no permissions screen, nothing to keep an eye on. If you hold BTC and ETH, open the sheet once a week and don't mind a price that's up to 20 minutes old, =GOOGLEFINANCE("CURRENCY:BTCUSD")Copy is all you need. Close this tab and go use it.

The trouble starts later. You add a stablecoin, then a meme coin, then a market cap column, and half the sheet turns into #N/A. That's the point where you want a formula that covers the coin, instead of guessing which ones Google decided to keep.