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

by

Comments

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

  1. […] Google Finance is a financial service that provides real-time stock prices. It also allows access to market indices and other financial data. It is also a great tool to use for finding the current price of Bitcoin or any other cryptocurrency. […]

  2. aukanishka Avatar
    aukanishka

    what formula can I use to get SOLANA and POLKADOT prices?

    1. Gabriel Maldonado Avatar
      Gabriel Maldonado

      These are not available in Google Finance at the moment, so can’t be used. You’ll need to use alternatives like Binance or other tools.

      1. morningsleeperJK Avatar

        Either of the following show me a price.

        =GOOGLEFINANCE(“BTCUSD”)

        or

        =GOOGLEFINANCE(“CURRENCY:BTCUSD”)

      2. morningsleeperJK Avatar

        my bad, did not realize you were referring to the specific ones asked about.

  3. Pablo Avatar
    Pablo

    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.

  4. Eric Avatar
    Eric

    My data isn’t refreshing to track current prices. What am In doing wrong?

    1. Eric Avatar
      Eric

      Ok it’s updating. It just takes a few minutes.

      1. Gabriel Maldonado Avatar
        Gabriel Maldonado

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

  5. CT Avatar
    CT

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

    1. Ramza Avatar
      Ramza

      WHAT SUPPOSE TO BE “//td” ??

  6. 00newen Avatar
    00newen

    Seems like it’s still lacking a lot of crypto coins.

    1. Gabriel Maldonado Avatar
      Gabriel Maldonado

      Yep, they’re just tracking these 4-5 at the moment.

Leave a Reply

%d bloggers like this: