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.


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


Find me on Twitter, or email me.