FAQ
Answers to common technical questions about CoinTable formulas.
How do I refresh prices?
Press Ctrl+Shift+F9 (Windows) or ⌘+Shift+F9 (Mac) to refresh all formulas in your sheet.
Plus and Pro plans include auto-refresh at regular intervals — no manual action needed.
What does #ERROR! mean?
The #ERROR! result usually means the ticker symbol is misspelled. Double-check the symbol and try again.
Use standard symbols like BTC, ETH, SOL. On the Plus plan, you can also use CoinGecko IDs like bitcoin or ethereum.
What does N/A mean?
N/A means the coin is not available on your current plan. The Free plan supports 20 popular cryptocurrencies.
Upgrade to Plus for access to 10,000+ coins.
How often do prices update?
Prices update when you manually refresh or automatically on Plus and Pro plans. CoinTable sources data from CoinGecko, which updates every few minutes.
Can I use CoinGecko IDs?
Yes, on the Plus plan. Both formats work:
=CT_PRICE("BTC") // ticker symbol
=CT_PRICE("bitcoin") // CoinGecko ID
What data source does CoinTable use?
CoinTable uses the CoinGecko API for all cryptocurrency data: prices, market caps, volume, supply, rankings, and historical data.
Does CoinTable work on mobile?
Yes. CoinTable formulas work in Google Sheets on any device, including the mobile app. Add-on features like auto-refresh require the desktop version.
Is historical price data available?
Historical price data is coming soon on the Pro plan. Currently, all formulas return real-time data only.
What happens when I hit my request limit?
Formulas return the last cached value instead of an error. Your sheet continues to show the most recent prices. The limit resets on the 1st of each month.
See Limits & Quotas for plan details.
How do I get support?
Email support@cointable.pro. Plus and Pro users receive priority support with faster response times.