How to get Crypto prices using Google Finance and spreadsheets easy (Updated: 2021)

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

7 thoughts on “How to get Crypto prices using Google Finance and spreadsheets easy (Updated: 2021)

  1. 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.

      1. Hi Eric. Yes, Google Finance API may take 15-20 minutes to update information, so is not real-time.

  2. 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))

Leave a Reply