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")
Leave a Reply