CRYPTOFINANCE is a Google Sheets add-on that provide the
CRYPTOFINANCE() function. It connects to CoinMarketCap and 30 other exchanges’ API to return cryptocurrencies prices, volume, marketcap and much more.
You can use CRYPTOFINANCE to keep track of your portfolio, to analyse markets and exchanges performance, or build just anything that requires cryptocurrencies data — Think of it as LEGO for crypto data.
Here is an example of what can be done:
How to Install
- Open a Google sheet where you wish to use
- Go to ›
- Copy the content of
CRYPTOFINANCE.gsand paste it in the script editor (replace any existing content)
- Save the script with › , name it CRYPTOFINANCE, then close the script editor tab
- Back to your Google sheet, refresh the page, a menu will appear next to
- And that’s it! From there the
=CRYPTOFINANCE()function is available in your spreadsheet. Try it out by typing
=CRYPTOFINANCE("BTC/USD")in an empty cell.