CRYPTOFINANCE in Google Sheets Not Working? The Fix (2026)

If your CRYPTOFINANCE formulas in Google Sheets stopped working, replace them. =CRYPTOFINANCE("BTC/USD")Copy becomes =COINTABLE("BTC/USD")Copy: the same pair, the same slash. One regex find-and-replace converts a whole sheet in about five minutes. CRYPTOFINANCE ran on the Cryptowatch API, and Kraken announced in July 2023 that the Cryptowatch API would be shut down along with the rest of Cryptowatch.

The replacement here is CoinTable, a Google Sheets add-on for cryptocurrency prices. No signup, no API key to paste, 300 free updates a month. If you'd rather compare every option first, including GOOGLEFINANCE and the free IMPORTDATA one-liners, start with the full guide to crypto prices in Google Sheets and come back for the migration.

The 30-second version

Before:  =CRYPTOFINANCE("BTC/USD")
After:   =COINTABLE("BTC/USD")

Before:  =CRYPTOFINANCE("ETH/EUR")
After:   =COINTABLE("ETH/EUR")

That's most sheets done. The pair notation (BTC/USD) stays as it is. USD is the default, so =COINTABLE("BTC")Copy gives the same price. The rest of this post covers the other attributes, the bulk replace and what you lose.

Is CRYPTOFINANCE still working?

For most people, no. Here's what the public record says, with links so you can check it yourself:

• What it ran on. The add-on's Marketplace listing names Cryptowatch as the developer and says it was "powered by the Cryptowatch API."
• What happened to that API. On July 31, 2023 Kraken wrote that "Cryptowatch Web, Desktop and Mobile products will sunset. This includes Cryptowatch Social and Cryptowatch API."
• When the listing last changed. The Marketplace page shows "Listing updated: April 2, 2023", which is before that announcement.
• What users report. Reviews on the listing from 2024 and 2025 call it dead or say it no longer returns data. One reviewer wrote that it still asks for a Cryptowatch API key, and a fresh Kraken key didn't fix it.

We can't see inside the add-on, so we won't call it officially discontinued. But if your cells show #ERROR!, or a value that hasn't moved in months, reinstalling won't help. The thing it depended on is gone.

CRYPTOFINANCE to CoinTable: the formula mapping

The left column shows the usual CRYPTOFINANCE patterns. Older sheets sometimes spell an attribute a little differently, so match on what the cell used to show, not the exact string.

Two more that CRYPTOFINANCE users tend to like once they find them:

=COINTABLE("BTC", "ath")                → all-time high
=COINTABLE("BTC", "athchangepct")       → % below the all-time high
=COINTABLE("BTC", "changepct", "7d")    → 7-day change (also 1h, 30d, 1y)
Copy

"changepct" and "athchangepct" return a plain number: 7.5 means +7.5%, and -42 means 42% below the peak. Every attribute and argument is in the COINTABLE reference, including which periods need Plus.

Migrate a whole sheet with one find-and-replace

Doing this cell by cell is fine for five coins. For fifty, let regex do it.

1. Install CoinTable from the Google Workspace Marketplace listing. Takes about 30 seconds, plus however long the permissions screen takes to load.

2. Make a copy of the sheet (File → Make a copy). Regex replace on formulas is quick, and so are mistakes.

3. Open Edit → Find and replace and tick both Search using regular expressions and Also search within formulas.

4. Replace the price formulas. Find:

   CRYPTOFINANCE\("([A-Z0-9]+/[A-Z]+)"\)
   

   Copy

   Replace with:

   COINTABLE("$1")
   

   Copy

   That turns CRYPTOFINANCE("SOL/USD") into COINTABLE("SOL/USD"): the same pair, the same slash.

5. Handle exchange-prefixed pairs like KRAKEN:BTC/USD. Find CRYPTOFINANCE\("[A-Z]+:([A-Z0-9]+/[A-Z]+)"\) and use the same replacement. COINTABLE has no exchange prefix, so this drops it.

6. Do the attribute formulas by hand, using the table above. There are usually only a few, and they're the ones where a careful look pays off.

7. Search for CRYPTOFINANCE once more. Zero matches means you're done. Then remove the old add-on under Extensions → Add-ons → Manage add-ons.

If a cell shows an error after the switch, hover over it and check the ticker first. Some coins were renamed since your sheet was built: Polygon's MATIC is now POL, for example.

Errors you might see after switching

Most migrations go clean. When they don't, it's one of these:

• #NAME? or an unknown-function error. The coin isn't in quotes (curly quotes from a chat or notes app count too), or CoinTable hasn't been opened in this spreadsheet yet. Choose Extensions > CoinTable > Open once.
• An error on one coin. Usually a ticker that changed or a typo. Hover over the cell to read the message, then search the coin's current ticker.
• The same number all day. CoinTable updates when you press Refresh, and on Plus also when you open the file and every hour if you turn that on. It doesn't tick like a trading screen.
• Leftover #ERROR! cells. That's a CRYPTOFINANCE formula your regex missed, often one with an extra argument. Search for CRYPTOFINANCE again.

What the add-on can see

Fair question when you're installing a replacement for something that broke on you. CoinTable asks for access to the spreadsheet you have open (not your whole Drive), permission to fetch prices over the internet, and permission to show its menu and sidebar. Google's install screen also lists a few standard scopes, including your email and profile; CoinTable's code doesn't read your email. Only each formula's ticker, currency, field and period or date leave Google Sheets, with an anonymous key. Your amounts and the rest of the spreadsheet stay where they are.

If you ever uninstall it, COINTABLE formulas stop recalculating and show an unknown-function error. To keep the last values, copy the range and use Paste special → Values only before you remove it. Worth knowing now, given how the last add-on ended.

Feature comparison

One update is one coin in one currency, for all its fields. A refresh that touches fifty =COINTABLE("BTC/USD")Copy cells costs one update, not fifty, and the same coin again within 6 hours is free. Prices update when you press Refresh (on Plus, also when you open the file), and they're up to 30 minutes old on Free and up to 5 minutes on Plus.

What you give up by switching

CRYPTOFINANCE's listing advertises data from more than 20 exchanges and 40,000 markets, so you could ask for the price on one specific exchange. Some sheets also used it to look up a price on a past date. CoinTable gives one market price, not per-exchange quotes, and its prices on a past date (Plus) go back one year. If either was the reason you used CRYPTOFINANCE, find-and-replace won't cover it.

• Past-date prices: CoinTable Plus covers the last year. For older dates, the other big crypto add-on, covered in our second head-to-head comparison, handles this, at the cost of setting up an API key. Or download a daily price CSV once and paste it in as a static tab.
• Exchange-specific quotes: you'll need that exchange's own API through Apps Script. That's a real project, not a formula.

For a tracker that shows today's price, change, market cap and your profit or loss, you lose nothing that mattered. The crypto portfolio tracker guide walks through that setup, from empty sheet to P&L column.

Free fallback for the big coins

If you only held BTC and ETH and don't want any add-on, =GOOGLEFINANCE("CURRENCY:BTCUSD")Copy is built into Sheets. In our test on October 15, 2026 it returned prices for 17 of the 30 largest coins and #N/A for the other 13, with quotes up to 20 minutes behind. The full list is in our GOOGLEFINANCE crypto test. Check your coins there before you rely on it.