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")
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))
Seems like it’s still lacking a lot of crypto coins.
Yep, they’re just tracking these 4-5 at the moment.