Last year I published a post explaining a way to get cryptocurrency prices like Bitcoin or Ethereum into Google Spreadsheets via Google Finance. Now Google Finance has updated their API and there’s a much simpler way to do it, as now is treated as a proper currency.
In order to get cryptocurrency prices into Google Spreadsheets for Bitcoin, Ethereum, Litecoin, and Bitcoin cash, you can use the following formulas:
BTC to USD:
=GOOGLEFINANCE("CURRENCY:BTCUSD")ETH to USD:
=GOOGLEFINANCE("CURRENCY:ETHUSD")LTC to USD:
=GOOGLEFINANCE("CURRENCY:LTCUSD")BCH to USD:
=GOOGLEFINANCE("CURRENCY:BCHUSD")What if you want other currency, like EURO? Just change the USD bit in the formula and will work with any currency ticker:
BTC to EURO:
=GOOGLEFINANCE("CURRENCY:BTCEUR")
what formula can I use to get SOLANA and POLKADOT prices?
These are not available in Google Finance at the moment, so can’t be used. You’ll need to use alternatives like Binance or other tools.
Either of the following show me a price.
=GOOGLEFINANCE(“BTCUSD”)
or
=GOOGLEFINANCE(“CURRENCY:BTCUSD”)
my bad, did not realize you were referring to the specific ones asked about.
This is amazing, thank you! This is a huge, easy upgrade to my crypto tracking spreadsheet.
It seems they have added several more (e.g., I can get ADA and BNB prices) but many others are missing. I’ll try the solution mentioned in another comment.
My data isn’t refreshing to track current prices. What am In doing wrong?
Ok it’s updating. It just takes a few minutes.
Hi Eric. Yes, Google Finance API may take 15-20 minutes to update information, so is not real-time.
The following approach should work for most (any?) coins:
Where A1 = let’s say “https://cointracking.info/coin_charts.php?cur=GRT”
=IF(ISURL(INDEX(IMPORTXML(A1,”//td”),22,1)),INDEX(IMPORTXML(A1,”//td”),9,1),INDEX(IMPORTXML(A1,”//td”),9,1))
WHAT SUPPOSE TO BE “//td” ??
Seems like it’s still lacking a lot of crypto coins.
Yep, they’re just tracking these 4-5 at the moment.