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.
Be notified of new posts. Join the mailing list.I won't spam you.