Cryptofinance: Pricing and Installation

This page demonstrates how to generate and connect API keys to enable Cryptofinance’s advanced data calls.

Cryptofinance is a Google Sheets add-on that lets you create your own personalized crypto tools. Combining Google Sheets’ powerful formulae with at-hand cryptocurrency data helps you build sophisticated spreadsheets — whether you’re visualizing data, making calculations, tracking your portfolio, or more.

For help using Cryptofinance, see cryptofinance.ai.

Use the Table of Contents to navigate to specific walkthroughs on this page.

The Table of Contents is on the right side of the screen on web, and viewable by tapping theicon on mobile.

Cryptofinance Plans

Price for paid plans

Plan

Credits Price

Fundamental and Ratings

Always Free

Standard

2500

Standard + Derivatives

3500

Click to see Credits Costs & Bonuses.

Free trial details

Connecting Cryptofinance to your Cryptowatch account gives you access to all paid datasets for one (1) week, free.

Information about data plan pricing is available in the Pricing & Subscriptions section below.

Which Cryptofinance data is free?

All fundamental and ratings data is free to use forever. See the table in the Pricing & Subscriptions section below for a list of free Cryptofinance data calls.

How to Upgrade to a paid plan

Sign in to Cryptowatch and go to the Pricing page.

Here you can exchange Credits for monthly subscriptions to premium Cryptowatch features, like Cryptofinance connectivity.

Follow the instructions below to connect Cryptofinance to your Cryptowatch account. Connecting Cryptofinance to your Cryptowatch account gives you access to all paid datasets for one (1) week, free.

How to install Cryptofinance in Google Sheets

Important: Before starting, uninstall the webstore version of Cryptofinance to avoid duplication. You can do this via Add-ons › Manage Add-ons and selecting Remove from the drop-down menu next to Cryptofinance.

Installation steps

  1. Open or create a new Google sheet.

  2. Go to Tools › Script editor

  1. Rename the script CRYPTOFINANCE (or something similar)

  2. Copy the content of CRYPTOFINACE.gs and paste it in the script editor (replacing any existing content).

  3. Save the script by clicking the Save icon.

  1. Click Run to run the script (right of the Save icon). You may need to grant Google permission to run the script.

  1. Go back to your Google sheet and refresh the page. CRYPTOFINANCE will appear next to Help in the toolbar.

Creating a Cryptowatch Account

Creating a Cryptowatch account lets you generate Cryptowatch API keys, which are required to access Cryptofinance data in Google Sheets. If you already have a Cryptowatch account, click the link below to skip this step:

How to generate API keys in Cryptowatch

Click the profile icon in the top-right of any Cryptowatch page to create a new Cryptowatch account:

The profile icon is in the top-right of every page on Cryptowatch. Click it to create an account.

A “Create Account” window will open over the Cryptowatch page. Enter your email, choose a username and password to create a new account. You can opt-in for product emails at this stage as well, if you want to stay informed of Cryptowatch releases and updates.

Cryptowatch password requirements:

  • At least 8 characters

  • At least one letter

  • At least one number

  • At least one special character

Once you’ve entered your account info, click Get Started to create the account.

How to generate API keys in Cryptowatch

When you are signed in to Cryptowatch, click the profile icon in the top-right of the page again. Click API Access from the drop-down menu.

Navigate to the API Access page by opening the profile menu in Cryptowatch.

Go to the Generate a key section and give your API key a relevant name to help you identify it in the future. You can also check the Read only box — Cryptofinance doesn’t need to send any information to Cryptowatch in order to work.

Enter a unique name and click “Read only” in the Generate a key section.

Next, click the Generate key button to create your new API key. If you have existing API keys, the one you’ve just created will appear at the bottom of the list.

Clicking Generate key will create a Public and a Private key in a new box under the Key name you entered above.

Only the Public key is required to connect Cryptofinance to your Cryptowatch account.

How to connect API keys in Cryptofinance

Open the Google Sheet where you’ve installed Cryptofinance. If you’ve followed the instructions above, you will have another option in the toolbar (to the right of Help) titled CRYPTOFINANCE.

Click the CRYPTOFINANCE button and select the second option —

Enter Cryptowatch Public API Key

The script you installed earlier will open a window over your spreadsheet. Copy and Paste the Public key you generated in Cryptowatch into the field:

Click OK and Cryptofinance will automatically connect to your Cryptowatch using the API key.

Pricing & Subscriptions

Price for paid plans

Plan

Credits

Fundamental and Ratings

Always Free

Standard

2500

Standard + Derivatives

3500

The data you can call using Cryptofinance falls into one of four (4) categories:

Fundamental, Ratings, Standard, and Derivative.

Category

Description

Fundamental

Fundamental metrics of the cryptocurrency, such as circulating supply and block size.

Ratings

Information from the Fundamental Crypto Asset Score — a metric used to measure the health of crypto projects.

Standard

Standard data calls include information such as OHLC data, % change and the current price of an asset.

Derivative

Derivative data calls access information relevant to exchanges as well as generate single-cell visualizations, such as sparklines.

The plan required for a data point is determined by its category. The table below lists each data point by its category and states which pricing plan it requires.

Data point availability by plan

Category

Plan

Data point

Fundamental

Free

active_addresses

Fundamental

Free

adjusted_tx_volume_usd

Fundamental

Free

average_difficulty

Fundamental

Free

block_count

Fundamental

Free

block_size

Fundamental

Free

circulating_supply

Fundamental

Free

fees

Fundamental

Free

generated_coins

Fundamental

Free

max_supply

Fundamental

Free

median_fee

Fundamental

Free

median_tx_value_usd

Fundamental

Free

payment_count

Fundamental

Free

realized_cap_usd

Fundamental

Free

total_supply

Fundamental

Free

total_volume

Fundamental

Free

tx_count

Fundamental

Free

tx_volume_usd

Ratings

Free

dev

Ratings

Free

dev_change

Ratings

Free

grade

Ratings

Free

market_maturity

Ratings

Free

market_maturity_change

Ratings

Free

score

Ratings

Free

score_change

Ratings

Free

utility

Ratings

Free

utility_change

Standard

2500 Credits/month

ask

Standard

2500 Credits/month

bid

Standard

2500 Credits/month

close

Standard

2500 Credits/month

high

Standard

2500 Credits/month

last

Standard

2500 Credits/month

last_trades

Standard

2500 Credits/month

low

Standard

2500 Credits/month

ob

Standard

2500 Credits/month

open

Standard

2500 Credits/month

price

Standard

2500 Credits/month

price_history

Standard

2500 Credits/month

price_usd

Standard

2500 Credits/month

quote_usd

Standard

2500 Credits/month

volume

Standard

2500 Credits/month

volume_base

Standard

2500 Credits/month

change_24h

Standard

2500 Credits/month

name

Derivative

3500 Credits/month

ath

Derivative

3500 Credits/month

ath_date

Derivative

3500 Credits/month

ath_diff

Derivative

3500 Credits/month

ath_volume

Derivative

3500 Credits/month

ath_volume_base

Derivative

3500 Credits/month

avg

Derivative

3500 Credits/month

btc_dominance

Derivative

3500 Credits/month

currency_count

Derivative

3500 Credits/month

exchange_rank

Derivative

3500 Credits/month

exchange_twitter

Derivative

3500 Credits/month

exchange_volume

Derivative

3500 Credits/month

exchange_volume_usd

Derivative

3500 Credits/month

exchange_website

Derivative

3500 Credits/month

fiat_count

Derivative

3500 Credits/month

fiats

Derivative

3500 Credits/month

market_count

Derivative

3500 Credits/month

marketcap

Derivative

3500 Credits/month

marketcap_usd

Derivative

3500 Credits/month

rank

Derivative

3500 Credits/month

roi

Derivative

3500 Credits/month

sparkline

Derivative

3500 Credits/month

sparkline_price

Derivative

3500 Credits/month

sparkline_volume

Derivative

3500 Credits/month

total_marketcap

Derivative

3500 Credits/month

liquidity

Derivative

3500 Credits/month

change_1h

Derivative

3500 Credits/month

change_7d

Derivative

3500 Credits/month

vwap

Cryptofinance Migrating to Cryptowatch

Since 2017, Cryptofinance has been reliably providing users with live and historical market data from over 46 exchanges. We are happy to announce that as of 2021, we are joining the Cryptowatch family.

Cryptowatch is a cryptocurrency trading platform that offers market data, charting, trading, alerts, and portfolio management all in one place.

We are excited about the move and think it will ultimately provide our users a better experience as more resources will help us improve the breadth of supported data endpoints, the number of exchanges covered, as well as general reliability.