CoinTable documentation
CoinTable is a Google Sheets add-on that puts crypto prices and market data in a cell with one formula. Type =COINTABLE("BTC") and the cell shows Bitcoin's price; the same works for 10,000+ coins in 63 currencies, with no API key to paste.
Help topics
Start
- Set up CoinTable in 2 minutes: install, open the panel, add coins, refresh prices.
- Getting started with formulas: your first COINTABLE formula, pairs and attributes.
Use
- COINTABLE: syntax, attributes, periods, price on a date, whole columns and error messages.
- Examples: portfolio tracker, watchlist, multi-currency tables.
- Supported currencies: the 63 currencies and how tickers work.
- Legacy CT_ functions: the older formulas keep working; how to switch to COINTABLE.
- Refresh and limits: Refresh, auto-refresh, and what counts as an update.
Plan and support
- Plan and billing: upgrade, switch to yearly, change your card, cancel, refunds.
- FAQ: error messages, refresh questions, shared spreadsheets.
- Contact support: email hi@cointable.pro.
Attributes
| Formula | Returns |
|---|---|
=COINTABLE("BTC") | price, the default |
=COINTABLE("BTC", "change") | price change in money |
=COINTABLE("BTC", "changepct") | price change in percent: 1.5 means +1.5% |
=COINTABLE("BTC", "marketcap") | market capitalization |
=COINTABLE("BTC", "volume") | 24-hour trading volume |
=COINTABLE("BTC", "high") | 24-hour high price |
=COINTABLE("BTC", "low") | 24-hour low price |
=COINTABLE("BTC", "rank") | market cap rank |
=COINTABLE("BTC", "supply") | circulating supply |
=COINTABLE("BTC", "totalsupply") | total supply |
=COINTABLE("BTC", "maxsupply") | maximum supply |
=COINTABLE("BTC", "fdv") | fully diluted valuation |
=COINTABLE("BTC", "ath") | all-time high price |
=COINTABLE("BTC", "athchangepct") | percent from the all-time high |
=COINTABLE("BTC", "athdate") | date of the all-time high |
=COINTABLE("BTC", "atl") | all-time low price |
=COINTABLE("BTC", "atlchangepct") | percent from the all-time low |
=COINTABLE("BTC", "atldate") | date of the all-time low |
=COINTABLE("BTC", "name") | the coin's name, as text |
=COINTABLE("BTC", "tradetime") | when the price was last updated |
For another currency, write a pair with a slash: =COINTABLE("BTC/EUR"). For the change over a period, add it third: =COINTABLE("BTC", "changepct", "7d"). The COINTABLE page has every option.