CoinTable vs CRYPTOFINANCE for Google Sheets (2026)

What Happened to CRYPTOFINANCE?

If you used Google Sheets for crypto before 2023, you probably used CRYPTOFINANCE. It was the go-to add-on: type =CRYPTOFINANCE("BTC/USD") and get a live price. It worked well for years.

Then Kraken acquired Cryptowatch (the data provider behind CRYPTOFINANCE) and eventually shut it down. The add-on didn't disappear from the Marketplace overnight, but the backend degraded. Users started seeing #ERROR! values, rate limits, and stale prices. Today, CRYPTOFINANCE is effectively abandonware — still installable, rarely functional.

CoinTable, a Google Sheets add-on for cryptocurrency prices, fills that gap. It does the same job — live crypto data in Sheets via formulas — but with an actively maintained backend. If you're looking for the full setup walkthrough, see how to get crypto prices in Google Sheets.

Feature Comparison

The key difference beyond reliability: CoinTable has dedicated formulas for market cap, rank, ATH, supply, 24h high/low, and 24h change. CRYPTOFINANCE only offered price and volume (via a second parameter). This means CoinTable lets you build richer dashboards without workarounds.

Formula Migration Guide

Replacing CRYPTOFINANCE formulas with CoinTable equivalents is straightforward. Here's the mapping:

New Formulas With No CRYPTOFINANCE Equivalent

After migrating, take advantage of functions that CRYPTOFINANCE never offered:

=CT_CHANGE("BTC")       → 24h price change (%)
=CT_RANK("BTC")         → CoinGecko market cap rank
=CT_ATH("BTC")          → All-time high price
=CT_SUPPLY("BTC")       → Circulating supply
=CT_HIGH("BTC")         → 24h high
=CT_LOW("BTC")          → 24h low

Step-by-Step Migration

1. Install CoinTable

Open your Google Sheet, go to Extensions → Add-ons → Get add-ons, search for "CoinTable", and install it. No API key, no configuration. It's ready to use immediately.

2. Find All CRYPTOFINANCE Formulas

Use Edit → Find and replace (Ctrl+H / Cmd+H):

• Find: CRYPTOFINANCE
• Check "Search using regular expressions" if you want to be precise
• Click "Find" to see how many cells use it

Note the count. You'll replace them in batches.

3. Replace USD Price Formulas

Most CRYPTOFINANCE usage follows the pattern =CRYPTOFINANCE("TICKER/USD"). The fastest approach:

1. Find: =CRYPTOFINANCE("BTC/USD")
2. Replace with: =CT_PRICE("BTC")
3. Click Replace all

Repeat for each coin ticker in your sheet: ETH, SOL, ADA, etc.

If you have dozens of coins and they all use the same pattern, a more efficient method:

1. Add a helper column with =SUBSTITUTE(FORMULATEXT(A2), "CRYPTOFINANCE(""", "CT_PRICE(""") to generate the new formula text
2. Review the output
3. Copy-paste as formulas

4. Replace Non-USD Price Formulas

For formulas like =CRYPTOFINANCE("BTC/EUR"):

1. Find: =CRYPTOFINANCE("BTC/EUR")
2. Replace with: =CT_PRICE("BTC", "EUR")

The syntax difference: CRYPTOFINANCE used a slash-separated pair (BTC/EUR), CoinTable uses a second argument ("BTC", "EUR").

5. Replace Volume Formulas

If you used =CRYPTOFINANCE("BTC/USD", "volume"):

1. Find: CRYPTOFINANCE("BTC/USD", "volume")
2. Replace with: CT_VOLUME("BTC")

6. Verify and Clean Up

After replacing all formulas:

1. Search for CRYPTOFINANCE one more time — the count should be zero
2. Check that all cells show values (not #ERROR! or #NAME?)
3. Uninstall the CRYPTOFINANCE add-on: Extensions → Add-ons → Manage add-ons → find CRYPTOFINANCE → click the three dots → Uninstall

Removing the old add-on prevents conflicts and cleans up your Extensions menu.

Common Questions During Migration

"My CRYPTOFINANCE formulas still work sometimes — should I bother migrating?"

Yes. "Sometimes" is the problem. Intermittent failures corrupt portfolio totals, trigger false alerts, and make your sheet unreliable. A migration now takes 10 minutes; debugging random #ERROR! values wastes more time than that every week.

"Does CoinTable support the same coins?"

CoinTable covers 10,000+ coins via CoinGecko data. If your coin is listed on CoinGecko, CoinTable has it. The only coins you might miss are very new or very obscure tokens that had exchange-specific pairs on Cryptowatch.

"What about historical prices?"

CRYPTOFINANCE had limited historical price support. CoinTable focuses on current market data (price, volume, market cap, rank, ATH, supply, 24h high/low, 24h change). For historical OHLCV data, you'd need a separate API integration.

What to Explore Next

Once your migration is done, your sheet is running on a maintained, reliable backend. From here you can expand:

• Compare CoinTable with other alternatives in the best crypto add-ons for Google Sheets roundup
• See how CoinTable stacks up against the CoinGecko API approach in CoinTable vs CoinGecko for Sheets
• Bookmark the crypto formulas cheat sheet for a quick reference of every CoinTable function