For the last three years, I’ve been sharing a way to get cryptocurrency prices like Bitcoin or Ethereum into Google Spreadsheets via Google Finance. There are a few ways to get cryptocurrency prices using Google Sheets and Google Finance, for example:
- Using the
GOOGLEFINANCEfunction in a cell to retrieve current or historical cryptocurrency prices - Using a Google Sheets add-on such as Cryptofinance, CoinMarketCap, CryptoSheets, Blockchain Data, …
- Using an API to import data into Google Sheets. For example, CoinGecko, CoinMarketCap, CryptoCompare, …
In this post, we’ll check the first option, as it is very straightforward and does not require installing or registering anything or anywhere at all.
Google Finance updated its API pretty much yearly, so the way of doing the same thing may change. In 2021 and 2022 they updated their API to make it much simpler to pull this data, as now is treated as a proper currency, rather than just values to fetch from a table.
FAQ
- How to get crypto prices into Google Spreadsheet in 2023
- Are there new crypto and currencies available?
- What formula can I use to get Solana and Polkadot prices
- My data isn’t refreshing to track current prices. What am I doing wrong?
How to get crypto prices into Google Spreadsheet in 2023
n 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 and No.
Google Finance provides information for a limited number of cryptocurrencies, and the availability of data may vary depending on your location and the type of data you are trying to retrieve.
Last year they 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, …
The most popular crypto generally are fine, for example at the time of writing this post, the following cryptocurrencies are available on Google Finance:
- Bitcoin (BTC)
- Ethereum (ETH)
- Bitcoin Cash (BCH)
- Litecoin (LTC)
- Ripple (XRP)
What formula can I use to get Solana, Polkadot, or other non-conventional crypto prices?
The ones that are not available in Google Finance can’t be used with the approach described above, however, you can use alternatives like Binance or other tools like cointracking.info
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.
