GOOGLEFINANCE is brilliant for stocks — and it's free. But for crypto it covers only a few coins, lags, and throws #N/A. Here's how to get reliable crypto (and stocks) in the same sheet.
Let's be fair up front: GOOGLEFINANCE is a great built-in function. For stocks, ETFs, mutual funds and currencies it's free, fast enough for most people, and already in every Google Sheet. If you only track equities, you may not need anything else.
The trouble starts with crypto. A recurring frustration among spreadsheet users is that GOOGLEFINANCE recognises only a handful of major coins, its quotes can be delayed by up to 20 minutes, and anything outside its short supported list simply returns #N/A. If your portfolio holds anything beyond Bitcoin and Ethereum, that's a wall.
| GOOGLEFINANCE | CryptoTrackPro | |
|---|---|---|
| Stocks & ETFs | ✓ Excellent (built-in) | ✓ 700+ tokenized |
| Crypto coverage | A few majors, many #N/A | ✓ 10,000+ coins |
| Data freshness | Up to ~20-min delay | ✓ Near-live |
| Fiat currencies | Major only | ✓ 150+ |
| Historical crypto prices | Limited / unreliable | ✓ Any date |
| RSI / MACD indicators | ✗ | ✓ Built in |
| Setup | Built in | Free add-on, no API key |
Where GOOGLEFINANCE gives up on a coin, CryptoTrackPro takes over with the same one-cell simplicity:
=GOOGLEFINANCE("SOL") → #N/A
=cryptotrackpro("SOL-USD") → 182.40
And you don't have to choose. Keep GOOGLEFINANCE for your equities and use CryptoTrackPro for crypto — or price stocks with it too via =cryptotrackproRWA("AAPL") and keep everything in one consistent syntax. See tracking stocks and crypto together.
Free plan, 50 lookups a day. No API key, no card.
Install CryptoTrackPro freeOnly a few major coins, and often with delays or #N/A. Most altcoins aren't supported at all.
The ticker is probably outside its short supported list, or the feed is lagging. =cryptotrackpro("TICKER-USD") resolves thousands of coins reliably.
Yes — 50 lookups a day on the free plan. Base and Pro raise or remove the limit.
See also: live crypto prices → · stocks & crypto together → · CryptoFinance alternative →