Overview

CRYPTOFINANCE is a Google Sheets add-on that provide the CRYPTOFINANCE() function. It connects to Coinmarketcap and 20 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. Go to the Add-ons menu, and click on Get add-ons…:
  2. On the Add-ons panel, search for cryptofinance, click on + FREE to install it:
  3. Select under which Google account you want to install it:
  4. Review the permissions and click on Allow.
  5. Make sure the add-on is activated in your sheet:
    1. Go to Add-on > CRYPTOFINANCE > Help
    2. Click on View in store, then click on Manage and check Use in this document:
  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.