COINTABLE
COINTABLE works like GOOGLEFINANCE, for crypto. =COINTABLE("BTC") is the Bitcoin price in US dollars, and =COINTABLE("BTC/EUR") is the price in euros. It covers 10,000+ coins in 63 currencies.
Syntax
=COINTABLE(coin, [attribute], [period or date])
- coin: A ticker like "BTC", or "BTC/EUR" for another currency (USD by default). Or a cell like A2.
- attribute: Optional, "price" by default.
- period or date: Optional, and only after attribute.
If your spreadsheet uses a decimal comma, as in most of Europe, separate arguments with semicolons: =COINTABLE("BTC"; "changepct"; "7d").
Pairs
Write a pair with a slash: "BTC/EUR", "ETH/BTC". A colon, a dash or a comma shows an error with the right spelling, such as For a pair write "BTC/EUR". GOOGLEFINANCE's "CURRENCY:BTCEUR" works too.
Attributes
| Formula | Returns | Period or date |
|---|---|---|
=COINTABLE("BTC/EUR") | price, the default | a date (Plus) |
=COINTABLE("BTC", "change") | price change in money | 1h, 24h, 7d, 30d, 1y |
=COINTABLE("BTC", "changepct") | price change in percent: 1.5 means +1.5% | 1h, 24h, 7d, 30d, 1y |
=COINTABLE("BTC", "marketcap") | market capitalization | — |
=COINTABLE("BTC", "volume") | 24-hour trading volume | 24h |
=COINTABLE("BTC", "high") | 24-hour high price | 24h |
=COINTABLE("BTC", "low") | 24-hour low price | 24h |
=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 | — |
- change is in money and changepct in percent, as in GOOGLEFINANCE: 1.5 means +1.5%.
- rank, maxsupply, totalsupply and fdv are blank when the coin has none.
- Money values come in the pair's currency; rank, supply and name need no currency.
Periods
| Period | Plan |
|---|---|
| 24h | Default, Free |
| 1h | Plus |
| 7d, 30d, 1y | Plus* |
*If your CoinTable account was created before Nov 1, 2026, 7d, 30d and 1y stay free for you. A period that needs Plus shows a message in the cell and uses no update.
Periods work with change and changepct; high, low and volume accept "24h".
Price on a date (Plus)
=COINTABLE("BTC", "price", DATE(2026,6,30)) shows Bitcoin's price on June 30, 2026. The date can also be text like "2026-06-30" or a cell with a date. It works for price only, within the last year, and the day is counted in your spreadsheet's time zone.
Each price is the day's closing price in UTC. Past prices don't change, so Refresh doesn't look them up again.
A whole column
=COINTABLE(A2:A20) fills a column of the same height, one value per coin. Use one column: A2:B20 shows "Use one column, like A2:A20." If row 1 of the sheet is in the range, it's a header and gets no value. A row with a problem shows its message as text, with a red corner. SUM skips text, so look for red corners before you trust a total. If the cells below the formula aren't empty, Sheets shows #REF!: clear them. Each coin uses its own update, and the CoinTable panel shows what the column costs.
Move from GOOGLEFINANCE
| GOOGLEFINANCE | COINTABLE |
|---|---|
=GOOGLEFINANCE("CURRENCY:BTCUSD") | =COINTABLE("BTC") |
=GOOGLEFINANCE("CURRENCY:BTCEUR") | =COINTABLE("BTC/EUR") |
=GOOGLEFINANCE("CURRENCY:ETHUSD", "changepct") | =COINTABLE("ETH", "changepct") |
=INDEX(GOOGLEFINANCE("CURRENCY:BTCUSD", "price", DATE(2026,6,30)), 2, 2) | =COINTABLE("BTC", "price", DATE(2026,6,30)) (Plus) |
For crypto, you can keep a GOOGLEFINANCE formula and swap the function name: =GOOGLEFINANCE("CURRENCY:BTCEUR") becomes =COINTABLE("CURRENCY:BTCEUR"). Do this only for crypto. COINTABLE reads every ticker as a coin, and some stock and index tickers are also coins: TSLA, META, SPX and GOLD. A stock formula would quietly show a coin's price.
Errors
A formula that can't return a value shows #ERROR!. Hover over the cell to read why. These are the common messages.
| The cell says | What to do |
|---|---|
#NAME? | Put the coin in quotes: =COINTABLE("BTC"), not =COINTABLE(BTC). Retype curly quotes. If the quotes are right, choose Extensions > CoinTable > Open once in this spreadsheet. |
For a pair write "BTC/EUR". | Write the pair with a slash. |
EUR is a currency. Write it with the coin: "BTC/EUR". | Put the currency after the coin: =COINTABLE("BTC/EUR"). |
"7d" is a period. Put it 3rd, after an attribute like "changepct". | Add the attribute: =COINTABLE("BTC", "changepct", "7d"). |
Add an attribute before "7d", e.g. "changepct". | The period goes third, after an attribute. |
Unknown attribute "chnage". Did you mean "change"? | Fix the spelling. The attributes are in the table above. |
"price" has no period. For the change use "changepct". | Leave the period out, or use "changepct". |
"high" is a 24h value. Use "24h" or leave the period out. | high, low and volume take only "24h". |
Unknown period "1w". Periods: 1h · 24h · 7d · 30d · 1y. | Use one of the listed periods. |
"7d" needs Plus. Free includes 24h. To use it: Extensions > CoinTable > Upgrade to Plus. | Use "24h", or upgrade. The message uses no update. |
Too many values. COINTABLE takes up to 3: coin · attribute · period. | Put the currency in the coin, like "BTC/EUR". |
Coin "XYZQ" not found. Check the ticker, e.g. "BTC". | Check the spelling of the ticker. |
BITCOIN is another coin's ticker. Write "BTC". | Use the ticker, not the coin's name. |
BTCUSD is another coin's ticker. For BTC in USD write "BTC/USD". | Write the pair with a slash. |
Unknown currency "XYZ". Use a code like USD or EUR. | Use a supported currency. |
Currency "USDT" isn't supported. Try "BTC/USD". | Use USD. USDT and USDC work as coins, not as currencies. |
COINTABLE is for crypto. For fiat rates use GOOGLEFINANCE. | Use GOOGLEFINANCE for a pair of two fiat currencies. |
Cyrillic letters in "ВТС". Switch the keyboard to English and type it again, like "BTC". | Retype the ticker in English letters. |
"APE" is listed, but its data didn't load. Try again in an hour. | Wait and press Refresh. |
Unclear date "31.12.2025". Write it as "2025-12-31" or use a date cell. | Write the date as "2025-12-31", use DATE(2025,12,31), or a date cell. |
Dates work only with price. | Use a date only with "price". |
Price on a date needs Plus. To use it: Extensions > CoinTable > Upgrade to Plus. | Price on a date is part of Plus. |
Prices on a date go back one year, to YYYY-MM-DD. | Pick a date within the last year. |
No closing price for YYYY-MM-DD yet. It comes at 01:00 UTC the next day. For the current price, leave out the date. | Wait until 01:00 UTC, or leave out the date. |
No price for SYMBOL on YYYY-MM-DD. The coin may not have been trading yet. | Pick a later date. |
Daily limit for prices on a date reached. Try again after 00:00 UTC. | Try again the next day (UTC). |
Use one column, like A2:A20. | Give a whole-column formula one column. |
Use up to 1,000 rows, like A2:A1001. | Split a longer list into two formulas. |
No free updates left until Nov 1. To load this value now: Extensions > CoinTable > Upgrade to Plus. | Your free updates are used up. See what happens at the limit. |
Legacy CT_ functions
Using CT_PRICE and the other CT_ functions? They keep working. See Legacy CT_ functions.