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

Reduce Subscription

How to Reduce your Subscription Fee for NY Times or Washington Post or other Subscription-based products

My hack to reducing your subscription fee for NY Times, Washington Post and Classpass!

Bypassing Paywalls

How to Bypass a Paywall to Access Articles for Free

My hack to bypass any paywall to read gated articles for free (works for WSJ, FT, Bloomberg and more!)

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