Crypto pricing

How to Import Crypto Prices into Google Sheets

Deborah KayBy Deborah KayNovember 25, 20231 Minutes

Whether you’re an active trader, a long-term investor, or a crypto enthusiast, you may want to track crypto prices in Google Sheets to do data analysis or to track the value of your portfolio. While there are several importXML formulas for Coingeko or CoinMarketCap, these often take time to load and often break.

The best solution that I found for this is a very useful website by Alan Grainger called Crypto Rates.

This website contains a live feed of the prices of the top 5,000 coins by market capitalisation, and is updated every 30 minutes. The feed is in CSV format.

Using the query and import data formula, you can extract data from either his standard feed (which contains the symbol, name and price) or his full feed (which contains the symbol, name, price, market cap, volume, supply, 24 hour and 7 day change).

Formulas are shared on his Crypto Rates website and his Github repo.

Very cool indeed.

Related Posts

Syncing weight to garmin connect

How To Sync or Import Weight to Garmin Connect

My hack to sync weight from any bluetooth weighing scale to Garmin Connect (via Apple Health and MyFitnessPal)!

Slow Imac

Fixing my Slow iMac

My $200 solution to speed up my slow 2013 iMac. Now it is blazingly fast.