Follow Brian Li (@DecryptoBL) on Twitter.
Follow Brian Li (@bwhli) on Instagram.

How to Display Cryptocurrency Prices in Google Sheets

September 21, 2018

A few days ago, I was using CryptoFinance to import cryptocurrency prices into Google Sheets. Unfortunately, the import function kept on timing out due to a CoinMarketCap API error. I suspect this has something to do with CMC’s recent move to a tiered API system which limits non-paying users to 6,000 calls per month. After a little research, I discovered the stock =GoogleFinance function supports major cryptocurrency pairs.

Just copy and paste the function below.

=GoogleFinance("CURRENCY:BTCUSD")

Supported currencies (for now) are limited to BTC, ETH, BCH, and LTC.


Questions?

Find me on Twitter, or send me an email.