Overview

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

  1. Open a Google sheet where you wish to use CRYPTOFINANCE()
  2. Go to Tools › Script editor
  3. Copy the content of CRYPTOFINANCE.gs and paste it in the script editor (replace any existing content)
  4. Save the script with File › Save, name it CRYPTOFINANCE, then close the script editor tab
  5. Back to your Google sheet, refresh the page, a CRYPTOFINANCE menu will appear next to Help
  6. 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.

Next Step

Check out the Best Practices page to get the best from the add-on.