Skip to content
Docs menu

Formulas

Supported Currencies

CoinTable supports cryptocurrencies and fiat currencies. Every plan includes all 10,000+ coins and 63 currencies.


Cryptocurrencies

Available to all users at no cost.

SymbolName
BTCBitcoin
ETHEthereum
USDTTether
BNBBNB
SOLSolana
XRPXRP
USDCUSD Coin
ADACardano
DOGEDogecoin
AVAXAvalanche
TRXTRON
DOTPolkadot
LINKChainlink
SHIBShiba Inu
LTCLitecoin
UNIUniswap
ATOMCosmos
XLMStellar
NEARNEAR Protocol

10,000+ coins on every plan

Free and Plus both cover 10,000+ coins, from Bitcoin and Ethereum to small altcoins. Use the standard ticker symbol. Tickers aren't case-sensitive and can come from another cell.

=COINTABLE("BTC")          // ticker symbol
=COINTABLE(A2)             // ticker from cell A2

Each formula takes one ticker, not a coin name. If several coins share a ticker, CoinTable uses the one the data provider ranks first for it, usually the largest. When a coin changes its ticker, the old ticker may stop working or point to a different coin. A ticker CoinTable doesn't know shows an error such as Coin "XYZQ" not found. Check the ticker, e.g. "BTC".


Currencies

All plans support 63 currencies. Write the currency after the coin with a slash, as in COINTABLE: fiat currencies, crypto such as BTC and ETH, and units such as sats and gold.

=COINTABLE("BTC/EUR")      // Bitcoin price in euros
=COINTABLE("ETH/JPY")      // Ethereum price in yen
=COINTABLE("SOL/SATS")     // Solana price in satoshis

USDT and USDC aren't supported as a currency yet: =COINTABLE("BTC/USDT") shows Currency "USDT" isn't supported. Try "BTC/USD". As coins they work: =COINTABLE("USDT") is the Tether price.

Fiat currencies

CodeCurrencyRegion
AEDUAE DirhamUnited Arab Emirates
ARSArgentine PesoArgentina
AUDAustralian DollarAustralia
BDTBangladeshi TakaBangladesh
BHDBahraini DinarBahrain
BMDBermudian DollarBermuda
BRLBrazilian RealBrazil
CADCanadian DollarCanada
CHFSwiss FrancSwitzerland
CLPChilean PesoChile
CNYChinese YuanChina
CZKCzech KorunaCzech Republic
DKKDanish KroneDenmark
EUREuroEuropean Union
GBPBritish PoundUnited Kingdom
GELGeorgian LariGeorgia
HKDHong Kong DollarHong Kong
HUFHungarian ForintHungary
IDRIndonesian RupiahIndonesia
ILSIsraeli New ShekelIsrael
INRIndian RupeeIndia
JPYJapanese YenJapan
KRWSouth Korean WonSouth Korea
KWDKuwaiti DinarKuwait
LKRSri Lankan RupeeSri Lanka
MMKMyanmar KyatMyanmar
MXNMexican PesoMexico
MYRMalaysian RinggitMalaysia
NGNNigerian NairaNigeria
NOKNorwegian KroneNorway
NZDNew Zealand DollarNew Zealand
PHPPhilippine PesoPhilippines
PKRPakistani RupeePakistan
PLNPolish ZłotyPoland
RUBRussian RubleRussia
SARSaudi RiyalSaudi Arabia
SEKSwedish KronaSweden
SGDSingapore DollarSingapore
THBThai BahtThailand
TRYTurkish LiraTurkey
TWDNew Taiwan DollarTaiwan
UAHUkrainian HryvniaUkraine
USDUS DollarUnited States
VEFVenezuelan Bolívar Fuerte (old)Venezuela
VNDVietnamese DongVietnam
ZARSouth African RandSouth Africa

Crypto

CodeCurrency
BCHBitcoin Cash
BNBBNB
BTCBitcoin
DOTPolkadot
EOSEOS
ETHEthereum
LINKChainlink
LTCLitecoin
SOLSolana
XLMStellar
XRPXRP
YFIyearn.finance

Other units

CodeUnit
BITSBits (one millionth of a bitcoin)
SATSSatoshis (one hundred-millionth of a bitcoin)
XAGSilver (troy ounce)
XAUGold (troy ounce)
XDRIMF Special Drawing Rights

Default currency is USD if not specified.