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