Crypto market data in Google Sheets

Combine cryptocurrency market data from dozens of exchanges with Google Sheets to create powerful tools and visualizations.

Cryptowatch integration with CRYPTOFINANCE

CRYPTOFINANCE adds cryptocurrency data to Google sheets, allowing you to build your own powerful tools — whether tracking your balances, visualizing complex data, or more.
Use Cryptofinance to create powerful crypto-tracking spreadsheets.


​CRYPTOFINANCE is a Google Sheets add-on that provides the CRYPTOFINANCE() function. It connects to various data sources and exchange APIs to return cryptocurrency prices, volume, marketcap and much more. You can use CRYPTOFINANCE to keep track of your portfolio, analyze markets and exchanges performance, or build just about anything that requires cryptocurrency market data.

What is Google Sheets?

​Google Sheets is a web-based spreadsheet application similar in functionality to Microsoft Excel that allows anyone to create templates, perform advanced calculations, and organize data. Google Sheets can also be easily shared, allowing multiple users to collaborate on a single spreadsheet.

How do I get started?

  1. 2.
    Follow the instructions on Cryptowatch Docs to install the =CRYPTOFINANCE() function in your Google sheet
  2. 3.
    Input your Cryptowatch API key into the plugin using the following menu option
    (you don't need the secret key for this):
Find the API key option by clicking CRYPTOFINANCE in the menu bar.
That's it! You can now start using the =CRYPTOFINANCE() functions in your sheet. Read the full documentation to learn everything you can do with CRYPTOFINANCE.

What can I build with this?

Here are just a few things you can do:
  1. 1.
    Put your favorite assets and indicators in a customized dashboard.
  2. 2.
    Create custom indicators in real time using the extensive calculation abilities of Google Sheets and the array of real-time data provided by CRYPTOFINANCE.
  3. 3.
    Create a customized portfolio tracker for the value of all your holdings.
  4. 4.
    Compute your own custom volume-weighted averages that aggregate asset prices across the crypto market.
  5. 5.
    Spot high spreads quickly by building arbitrage dashboards that compute spreads in real time.
  6. 6.
    Connect Cryptowatch data in Google Sheets to other applications, like Zapier, to execute unique trading strategies.