Go to Cryptosheets
All Collections
Tutorials
Tutorials
Follow along with our many cryptocurrency and spreadsheet tutorials.
J
C
78 articles in this collection
Written by
John Young
and
Chris Ware
How to Paginate using CoinGecko API Endpoints in Cryptosheets
Many CoinGecko endpoints have a maximum limit for results per call and per page. You can easily pull the full results by paginating.
C
Written by
Chris Ware
Updated over a week ago
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.
J
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
J
Written by
John Young
Updated over a week ago
Bitwise
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...
J
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
J
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.
J
Written by
John Young
Updated over a week ago
Coinmetrics tutorials
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.
J
Written by
John Young
Updated over a week ago
Coindar tutorials
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
J
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
J
Written by
John Young
Updated over a week ago
Cointracking.info tutorials
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 combined exchange accounts & wallets
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 tutorials
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.
J
Written by
John Young
Updated over a week ago
CryptUnit tutorials
How to pull instant mining profitability metrics from CryptUnit directly into Excel
CryptUnit is a web-based Cryptonote mining profitability calculator.
J
Written by
John Young
Updated over a week ago
Etherscan tutorials
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 tutorials
Shrimpy data in Excel & Googlesheets using Cryptosheets
How to pull Shrimpy data into Excel
C
Written by
Chris Ware
Updated over a week ago
TokenAnalyst
Stablecoins Historical Exchange Balances
TokenAnalyst - Returns daily and hourly stablecoin balances of exchanges
J
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
J
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.
J
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...
J
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.
J
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.
J
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...
J
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...
J
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...
J
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 ...
J
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 ...
J
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...
J
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...
J
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...
J
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...
J
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...
J
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...
J
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...
J
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...
J
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...
J
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...
J
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...
J
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...
J
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...
J
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.
J
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...
J
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...
J
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...
J
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.
J
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. ...
J
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'...
J
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...
J
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...
J
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.
J
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.
J
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...
J
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...
J
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_...
J
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...
J
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.
J
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...
J
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...
J
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 ...
J
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...
J
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...
J
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...
J
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...
J
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...
J
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 ...
J
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...
J
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...
J
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.
J
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...
J
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...
J
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...
J
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...
J
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...
J
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...
J
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 ...
J
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...
J
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