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

For the last two years, I’ve been sharing a way to get cryptocurrency prices like Bitcoin or Ethereum into Google Spreadsheets via Google Finance.

Google Finance updated its API pretty much yearly, so the way of doing the same thing may change. In 2021 they updated their API to make it much simpler to pull this data, as now is treated as a proper currency.

FAQ

How to get crypto prices into Google Spreadsheet in 2022

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

Are there new crypto and currencies available?

Yes. It seems they have added several more (e.g. ADA and BNB prices) but many others are missing. They add more with time, but at the moment Google Finance only works for certain pairs. It doesn’t work for certain altcoins like DOGE, AAVE, DOT, LUNA, etc, …

What formula can I use to get Solana and Polkadot prices

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. For example, by using websites like cointracking.info, the following approach should work for plenty of crypto 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))

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

Google Finance does not update this data in real-time, generally, there is a 10-20 minutes delay.


by

Comments

One response to “How to get Crypto prices using Google Finance and spreadsheets easy (Updated: 2022)”

  1. The Dude Avatar
    The Dude

    The last part, getting any price into google sheets is not working anymore. 🙁

Leave a Reply

%d bloggers like this: