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")