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.