Using TokenAnalyst data in Cryptosheets

This article demonstrates two examples of how to pull TokenAnalyst data into your spreadsheet using the side panel console and custom functions.

You can currently pull 56 endpoints from TokenAnalyst into Cryptosheets including: 

ETH On-chain Volume, BTC On-chain Volume, BTC On-chain Transaction Count, BTC Active addresses, BTC Supply, BTC NVT, BTC Fees, BTC UTXO Age, BTC Miner Hashrate, BTC Miner Rewards, BTC Spent Outputs Profit Ratio, BTC UTXO Average Age, BTC UTXO Average Value, BTC UTXO Count, BTC UTXO Median Age, BTC UTXO Total Value, BTC UTXO Weighted Average Age, BTC UTXO Supply Percentage, ETH On-chain Volume, ETH On-chain Transaction Count, ETH Active addresses, ETH Supply, ETH NVT, ETH Fees, ETH Miner Hashrate, ETH Miner Rewards, ERC20 On-chain Volume, ERC20 On-chain Transaction Count, ERC20 Active addresses, Tether (Omni) On-chain Volume, Tether (Omni) On-chain Transaction Count, Tether (Omni) Active Addresses, Tether (Omni) Supply, Tether (ERC20) Supply, Tether (Omni) NVT, Tether (Omni) Fees, Stablecoin On-chain Volume, Stablecoin On-chain Transaction Count, Stablecoin Active addresses, BTC Full Historical Inflow to Exchanges, BTC Full Historical Outflows from Exchanges, BTC Full Historical Top 10 Inflow Large Value Transactions, BTC Full Historical Top 10 Outflow Large Value Transactions, ETH Full Historical Flows Into Exchanges, ETH Full Historical Flows Out Of Exchanges, ETH Full Historical Top 10 Inflow Large Value Transactions, ETH Full Historical Top 10 Outflow Large Value Transactions, Stablecoins Full Historical Inflow from Exchanges [Beta], Stablecoins Full Historical Outflow from Exchanges [Beta], Tether (Omni) Full Historical Top 10 Inflow Large Value Transactions, Tether (Omni) Full Historical Top 10 Outflow Large Value Transactions, ERC20 Full Historical Flows Into Exchanges [Beta], ERC20 Full Historical Flows Out Of Exchanges [Beta], Miner Full Historical Inflow, Miner Full Historical Outflow, Miners to Exchanges Full Historical Flows, BTC Full Historical Balance

Explore more TokenAnalyst endpoints here


Although TokenAnalyst has 56 available endpoints, we will use BTC On-chain Volume as our example.

Description:

This endpoint returns the full historical on-chain volume of Bitcoin since it's genesis in 2009. The volume is separated into 'real' volume and 'change' volume.

Example data returned:

  • date 
  • volume_change 
  • volume_change_usd
  • volume_real
  • volume_real_usd
  • volume_gross 

________________________________________________________________

Setup

  1. Install the Cryptosheets add-in from Microsoft AppSource Store
  2. Make sure you are logged into your Cryptosheets account

 
________________________________________________________________

Using the console

  1. From the Cryptosheets ribbon click data
  2. Type in type in "TokenAnalyst..." then click on BTC On-chain Volume
  3. Scroll through the console parameters and input your values
  4. Select the cell you want to place the data into
  5. Click make request

________________________________________________________________

Using custom functions

  1. In any cell type the following:
=CS.QUERY("TokenAnalyst","BTC On-chain Volume",{"token","btc";"window","1d";"from_date","2017-03-12";"to_date","2018-06-12";"limit","50";"key","API_KEY";"format","json"})


 2. In any console, after selecting the parameters to configure the query string as desired, simply click the radio button to toggle the the function/formula builder, then click the clipboard icon to copy the full formula string and paste it into any cell.
*Quick help: see detailed examples and tutorial 

HINT: If you need help remembering the exact parameters for any function, you can always just type in any cell:
=CS.PARAMETERS("TokenAnalyst","BTC On-chain Volume")

*Note: you must have a certain minimum version of Microsoft Office or Excel for custom functions to work - but they now work in full on Excel for Mac/OSX and for the web in Excel online! 

Signing up for Cryptosheets is free  

Get crypto data in 30 seconds or less

________________________________________________________________

Helpful Resources:

  • Visit the API documentation for TokenAnalyst here

Troubleshooting

  • Find tips & tricks on our troubleshooting page
  • Please reference the following troubleshooting code: QUE-1593-676

Learn more here
________________________________________________________________
Tags: tokendata.io, analytics, on-chain, volume, excel, googlesheets, cryptodata, spreadsheet

Did this answer your question?