In this tutorial we will show you how to pull historical data from the Coinmetrics API into Excel.
Coinmetrics Historical
Description: Blockchain data of a given asset over a specified time range
Data returned:
txcount
txvolume(usd)
adjustedtxvolume(usd)
paymentcount
activeaddresses
fees
medianfee
generatedcoins
averagedifficulty
mediantxvalue(usd)
blocksize
blockcount
price(usd)
marketcap(usd)
exchangevolume(usd)
Example: Return metrics for Bitcoin from August 1st, 2018 to August 21st, 2018.
How to pull
In the Cryptosheets ribbon, click Dashboard
Login to the service through Google, or sign-up option
Click the orange + button
Click Coin Metrics Historical
Choose Start Time (GMT) and End Time (GMT)
Click the Table Headers toggle
Click into A1 of the “Data” tab, click Highlight Range, and Place Data
Verify that data has updated
You also have the option to choose a timed refresh interval.