Real-Time Crypto Prices on Google Sheets — Meme Coin Update

Photo by Crystal Mapes on Unsplash

Google Finance is a fantastic free tool you can use to build an investment tracker using some simple formulae. Earlier in 2021 Google added a Crypto database that users could so now you could have real-time price updates for your crypto as well as your stocks.

Here is an example of the Google Finance formula:

=GOOGLEFINANCE(“CURRENCY:BTC:USD”)

The problem with this google finance update is that their database is very limited at the moment and only covers large-cap coins such as Bitcoin, Eth, Ada, etc.

As a workaround for all other cryptocurrencies, it is possible to pull prices from the CoinMarketCap website straight into your google docs sheet using an Import XML formula.

I covered how to do this in the following story.

Real-time Crypto Prices on Google Sheets — 3 Simple Steps

Since I posted that story Meme Coin investing has seen a massive resurgence. Although many would not recommend investing in Meme Coins, if you do then you should be able to at least properly track the performance of your investments. A…