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.