Tutorials

Beginner Tutorial

Get started using Cryptosheets in 30 seconds

C

Written by Chris Ware
Updated over a week ago

How to convert between UNIX timestamp to readable date

This tutorial covers the conversion between Unix timestamp and date in Excel.

Written by John Young
Updated over a week ago

Pulling your first data source into Excel using Cryptosheets & Nomics

Step-by-step guide on pulling data into Excel using Nomics

Written by John Young
Updated over a week ago

history

Bitwise - Returns a list of historical daily index values for an index. Each element in the response array contains a ISO8601 date of the...

Written by John Young
Updated over a week ago

How to pull historical prices of Bitwise Indices into Excel

Find out the historical performance of all the top Bitwise Indices with the click of a button

Written by John Young
Updated over a week ago

How to pull metadata and constituent data for Bitwise Indices into Excel

This pull also includes index performance and a break down of the index's weight constituents.

Written by John Young
Updated over a week ago

How to pull Coinmetrics Historical data directly into Excel

We show you how to get Coinmetrics Historical data to use in Excel modeling with the click of a button.

Written by John Young
Updated over a week ago

How to pull social data for 2,000+ cryptocurrencies from Coindar into Excel

Get website, block explorer, Github, Bitcointalk, Twitter, Reddit, Telegram, Facebook, Youtube, and more

Written by John Young
Updated over a week ago

How to pull events and calendar data for cryptocurrencies into Excel

Find out what events move the price of a cryptocurrency the most

Written by John Young
Updated over a week ago

How to add your Cointracking.info API key in Cryptosheets

Update your Cryptosheets settings with your Cointracking.info API key to instantly access all of your accounts

C

Written by Chris Ware
Updated over a week ago

Cointracking.info data in Excel & Googlesheets using Cryptosheets

How to pull Cointracking.info data into Excel including balance, trades, gains and more

C

Written by Chris Ware
Updated over a week ago

Cryptocompare data in Excel & Googlesheets using Cryptosheets

How to pull Cryptocompare historical OHLCV data into Excel

C

Written by Chris Ware
Updated over a week ago

How to pull OHLCV for thousands of cryptocurrencies directly into Excel

We show you how to get Cryptocompare OHLCV data to use in Excel modeling with the click of a button.

Written by John Young
Updated over a week ago

How to pull instant mining profitability metrics from CryptUnit directly into Excel

CryptUnit is a web-based Cryptonote mining profitability calculator.

Written by John Young
Updated over a week ago

Etherscan data in Excel & Googlesheets using Cryptosheets

How to pull Etherscan data into Excel to analyze a Bitfinex ETH exchange wallet

C

Written by Chris Ware
Updated over a week ago

Shrimpy data in Excel & Googlesheets using Cryptosheets

How to pull Shrimpy data into Excel

C

Written by Chris Ware
Updated over a week ago

Stablecoins Historical Exchange Balances

TokenAnalyst - Returns daily and hourly stablecoin balances of exchanges

Written by John Young
Updated over a week ago

Data Catalog

TokenAnalyst - Returns an array of supported possible values for a given parameter of a defined datasets in the data catalog

Written by John Young
Updated over a week ago

ETH Total Rewards

TokenAnalyst - Returns the daily coinbase rewards. The block_reward (incl. uncle rewards) is denominated ETH.

Written by John Young
Updated over a week ago

ETH Total Hashrate

TokenAnalyst - Returns the daily hashrate and blocks mined for a given day. The hashrate is denominated in TH/s and block_count is the to...

Written by John Young
Updated over a week ago

BTC Full Historical Balance

TokenAnalyst - This endpoint returns the full historical on-chain balance of Bitcoin exchanges.

Written by John Young
Updated over a week ago

Miners to Exchanges Full Historical Flows

TokenAnalyst - This endpoint returns the full historical flows from miners to exchanges that we have labelled.

Written by John Young
Updated over a week ago

Miner Full Historical Outflow

TokenAnalyst - This endpoint returns the outflow of a given token out of miner controlled wallets during the time period specified. Miner...

Written by John Young
Updated over a week ago

Miner Full Historical Inflow

TokenAnalyst - This endpoint returns the inflow of a given token into miner controlled wallets during the time period specified. Miner wa...

Written by John Young
Updated over a week ago

ERC20 Full Historical Flows Out Of Exchanges [Beta]

TokenAnalyst - This endpoint returns the outflow of ETH from exchange wallets. The avg_txn_value, outflow, and number_of_txns are calcula...

Written by John Young
Updated over a week ago

ERC20 Full Historical Flows Into Exchanges [Beta]

TokenAnalyst - This endpoint returns the inflow of ERC20 tokens into exchange wallets. The avg_txn_value, inflow, and number_of_txns are ...

Written by John Young
Updated over a week ago

Tether (Omni) Full Historical Top 10 Outflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total USDT sent) flowing out of exchange wallets for every day ...

Written by John Young
Updated over a week ago

Tether (Omni) Full Historical Top 10 Inflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total USDT sent) flowing into exchange wallets for every day th...

Written by John Young
Updated over a week ago

Stablecoins Full Historical Outflow from Exchanges [Beta]

TokenAnalyst - This endpoint returns the inflow of stablecoins into exchange wallets. The avg_txn_value, inflow, and number_of_txns are c...

Written by John Young
Updated over a week ago

Stablecoins Full Historical Inflow from Exchanges [Beta]

TokenAnalyst - This endpoint returns the inflow of stablecoins into exchange wallets. The avg_txn_value, inflow, and number_of_txns are c...

Written by John Young
Updated over a week ago

ETH Full Historical Top 10 Outflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total ETH sent) flowing out of exchange wallets for every day t...

Written by John Young
Updated over a week ago

ETH Full Historical Top 10 Inflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total ETH sent) flowing into exchange wallets for every day tha...

Written by John Young
Updated over a week ago

ETH Full Historical Flows Out Of Exchanges

TokenAnalyst - This endpoint returns the outflow of ETH from exchange wallets. The avg_txn_value, outflow, and number_of_txns are calcula...

Written by John Young
Updated over a week ago

ETH Full Historical Flows Into Exchanges

TokenAnalyst - This endpoint returns the inflow of ETH into exchange wallets. The avg_txn_value, inflow, and number_of_txns are calculate...

Written by John Young
Updated over a week ago

BTC Full Historical Top 10 Outflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total BTC sent) flowing out of exchange wallets for every day t...

Written by John Young
Updated over a week ago

BTC Full Historical Top 10 Inflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total BTC sent) flowing into exchange wallets for every day tha...

Written by John Young
Updated over a week ago

BTC Full Historical Outflows from Exchanges

TokenAnalyst - This endpoint returns the outflow of BTC from exchange wallets for as far back as we track. The average outflow is the ave...

Written by John Young
Updated over a week ago

BTC Full Historical Inflow to Exchanges

TokenAnalyst - This endpoint returns the inflow of BTC into exchange wallets for as far back as we track. The average inflow is the avera...

Written by John Young
Updated over a week ago

Stablecoin Active addresses

TokenAnalyst - This endpoint returns the active addresses of stabelecoin tokens for every day of their existence. An address is defined a...

Written by John Young
Updated over a week ago

Stablecoin On Chain Transaction Count

TokenAnalyst - This endpoint returns the number of token transfers on the Ethereum blockchain for the given stablecoin you select for eve...

Written by John Young
Updated over a week ago

Stablecoin On Chain Volume

TokenAnalyst - This endpoint returns the full historical on-chain volume of any of the stablecoins that we support.

Written by John Young
Updated over a week ago

Tether (Omni) Fees

TokenAnalyst - This endpoint returns the historical supply of Tether (usdt_omni) on the OMNI blockchain for every day of it's existence 2...

Written by John Young
Updated over a week ago

Tether (Omni) NVT

TokenAnalyst - This endpoint returns the NVT Ratio (Network Value to Transactions Ratio) for Tether (usdt_omni). This is the ratio of the...

Written by John Young
Updated over a week ago

Tether (ERC20) Supply

TokenAnalyst - This endpoint returns the historical supply of the Tether ERC20 token (usdt_erc20) on the Ethereum blockchain for every da...

Written by John Young
Updated over a week ago

Tether (Omni) Supply

TokenAnalyst - This endpoint returns the historical supply of Tether (usdt_omni) on the OMNI blockchain for every day of it's existence.

Written by John Young
Updated over a week ago

Tether (Omni) Active Addresses

TokenAnalyst - This endpoint returns the active addresses of Tether (usdt_omni) tokens for every day of it's existence since 2014-10-06. ...

Written by John Young
Updated over a week ago

Tether (Omni) On Chain Transaction Count

TokenAnalyst - This endpoint returns the daily number of Tether (usdt_omni) transactions on the full Omni blockchain for every day of it'...

Written by John Young
Updated over a week ago

Tether (Omni) On Chain Volume

TokenAnalyst - This endpoint returns the full historical on-chain volume of Tether on the OMNI blockchain since it went live on 2014-10-0...

Written by John Young
Updated over a week ago

ERC20 Active addresses

TokenAnalyst - This endpoint returns the active addresses of ERC20 tokens for every day of their existence. An address is defined as 'act...

Written by John Young
Updated over a week ago

ERC20 On Chain Transaction Count

TokenAnalyst - This endpoint returns the number of token transfers on the blockchain for the given token for every day since its existence.

Written by John Young
Updated over a week ago

ERC20 On Chain Volume

TokenAnalyst - This endpoint returns the full historical on-chain volume of any of the major ERC20 tokens that we support.

Written by John Young
Updated over a week ago

ETH Miner Rewards

TokenAnalyst - This endpoint returns the daily block rewards and uncle rewards by miner. The miner_daily_block_reward and miner_daily_unc...

Written by John Young
Updated over a week ago

ETH Miner Hashrate

TokenAnalyst - This endpoint returns the total and miner specifc hashrate and uncle rates. The total_daily_hashrate and the miner_daily_h...

Written by John Young
Updated over a week ago

ETH Fees

TokenAnalyst - This endpoint returns the total and average fees spent on the Ethereum network for every day of it's existence. The total_...

Written by John Young
Updated over a week ago

ETH NVT

TokenAnalyst - This endpoint returns the NVT Ratio (Network Value to Transactions Ratio) for ETH. This is the ratio of the Market Cap div...

Written by John Young
Updated over a week ago

ETH Supply

TokenAnalyst - This endpoint returns the historical supply of ETH on the Ethereum blockchain for every day of its existence.

Written by John Young
Updated over a week ago

ETH Active addresses

TokenAnalyst - This endpoint returns the active addresses on the Ethereum blockchain for every day of its existence. An address is define...

Written by John Young
Updated over a week ago

ETH On Chain Transaction Count

TokenAnalyst - This endpoint returns the number of transactions, where ETH value transferred was > 0, on the full historical Ethereum blo...

Written by John Young
Updated over a week ago

ETH On Chain Volume

TokenAnalyst - This endpoint returns the full historical on-chain volume of Ethereum since it went live in 2015. The volume is separated ...

Written by John Young
Updated over a week ago

BTC UTXO Supply Percentage

TokenAnalyst - This endpoint returns the proportion of the bitcoin supply on the specified date, held in unspent transaction outputs stra...

Written by John Young
Updated over a week ago

BTC UTXO Weighted Average Age

TokenAnalyst - For instance outputs in the category 12-18m are unspent outputs (UTXOs) from transactions that occurred 12-18m ago. Time i...

Written by John Young
Updated over a week ago

BTC UTXO Total Value

TokenAnalyst - This endpoint returns the total BTC value of the bitcoin supply at the specified date, held in unspent transaction outputs...

Written by John Young
Updated over a week ago

BTC UTXO Median Age

TokenAnalyst - This endpoint returns the median age of the bitcoin supply at the specified date, held in unspent transaction outputs stra...

Written by John Young
Updated over a week ago

BTC UTXO Count

TokenAnalyst - This endpoint returns the count of unspent transaction outputs (UTXOs) at the specified date, stratified by their age. For...

Written by John Young
Updated over a week ago

BTC UTXO Average Value

TokenAnalyst - This endpoint returns the average value of unspent transaction outputs (UTXOs) at the specified date, stratified by their ...

Written by John Young
Updated over a week ago

BTC UTXO Average Age

TokenAnalyst - This endpoint returns the average age of the bitcoin supply at the specified date, held in unspent transaction outputs str...

Written by John Young
Updated over a week ago

BTC Spent Outputs Profit Ratio

TokenAnalyst - This endpoint returns the historical spent outputs profit ratio (SOPR) as defined by Renato Shirakashi. The data starts fr...

Written by John Young
Updated over a week ago

BTC Miner Rewards

TokenAnalyst - This endpoint returns the daily coinbase rewards by miner (incl. txn fees). The miner_daily_block_reward is denomiated BTC.

Written by John Young
Updated over a week ago

BTC Miner Hashrate

TokenAnalyst - This endpoint returns the daily and miner specifc hashrates. The total_daily_hashrate and the miner_daily_hashrate are den...

Written by John Young
Updated over a week ago

BTC UTXO Age

TokenAnalyst - This endpoint returns the proportion of the current bitcoin supply held in unspent transaction outputs stratified by their...

Written by John Young
Updated over a week ago

BTC Fees

TokenAnalyst - This endpoint returns the total and average fees spent on the Bitcoin network for every day of it's existence. The total_f...

Written by John Young
Updated over a week ago

BTC NVT

TokenAnalyst - This endpoint returns the NVT Ratio (Network Value to Transactions Ratio) for BTC. This is the ratio of the Market Cap div...

Written by John Young
Updated over a week ago

BTC Supply

TokenAnalyst - This endpoint returns the historical supply of BTC on the Bitcoin blockchain for each day of its existence. This is the su...

Written by John Young
Updated over a week ago

BTC Active addresses

TokenAnalyst - This endpoint returns the daily number of active addresses on the Bitcoin blockchain for each day of its existence. An add...

Written by John Young
Updated over a week ago

BTC On Chain Transaction Count

TokenAnalyst - This endpoint returns the daily number of transactions on the full historical Bitcoin blockchain for every day since it's ...

Written by John Young
Updated over a week ago

BTC On Chain Volume

TokenAnalyst - This endpoint returns the full historical on-chain volume of Bitcoin since it's genesis in 2009. The volume is separated i...

Written by John Young
Updated over a week ago

TokenAnalyst data in Excel & Googlesheets using Cryptosheets

How to pull TokenAnalyst data into Excel

C

Written by Chris Ware
Updated over a week ago