All Formulas
CoinTable gives you 10 formulas to pull real-time cryptocurrency data into Google Sheets. Each formula works with 10,000+ coins on the Plus plan.
| Formula | Description |
|---|---|
| CT_PRICE | Get real-time cryptocurrency prices |
| CT_CHANGE | Track price change percentages (1h, 24h, 7d, 30d) |
| CT_MARKETCAP | Get market capitalization |
| CT_VOLUME | Get 24-hour trading volume |
| CT_RANK | Get market cap rank |
| CT_SUPPLY | Get circulating, total, or max supply |
| CT_ATH | Get all-time high price |
| CT_ATHCHANGE | Get percentage from all-time high |
| CT_HIGH | Get 24-hour high price |
| CT_LOW | Get 24-hour low price |
Quick start
Type any formula in a Google Sheets cell:
=CT_PRICE("BTC")
No API keys. No setup. Just formulas.