Tracking Cryptocurrency Prices With Google Sheets: How to…
By Damilola Esebame
AI summary of the source article
Google Sheets offers built-in functions and add-ons like CoinTable to track cryptocurrency prices. However, GOOGLEFINANCE returned data for only 17 of the top 30 coins in testing and carries up to a 20-minute delay.
Why it matters
Google's up to 20-minute delay "makes the function suitable for portfolio tracking and daily monitoring but inadequate for active trading decisions that depend on real-time price movements across volatile crypto markets."
Key facts
- In an October 2026 test by CoinTable, GOOGLEFINANCE returned price data for only 17 of the top 30 cryptocurrencies by market capitalization.
- GOOGLEFINANCE quotes may be delayed up to 20 minutes, while cryptoprices.cc via IMPORTDATA can be up to one hour old.
- CoinTable's free tier provides 300 monthly updates with prices up to 30 minutes old, while automatic refresh on open is a paid feature.
Source excerpt · FinanceFeeds
KEY TAKEAWAYS The GOOGLEFINANCE function supports cryptocurrency prices but returned data for only 17 of the top 30 coins in a test conducted by CoinTable on 15 October 2026, leaving significant coverage gaps. The IMPORTDATA function retrieves cryptocurrency prices from the free cryptoprices.cc endpoint using a simple formula that requires no API key or programming knowledge, although its data can…