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.