-------------------------------------------------------------------------------------------
*IMPORTANT: THIS TUTORIAL IS FOR THE CRYPTOSHEETS 1.0 ADD-IN WHICH HAS BEEN DEPRECATED - PLEASE SEE THE UPDATED TUTORIAL FOR CRYPTOSHEETS 2.0 HERE:
-------------------------------------------------------------------------------------------
In this tutorial we will show you how to pull OHLCV data from the Cryptocompare API into Excel.
Importing Cryptocompare data into Excel
Required Parameters
Asset - Choose from Cryptocompare's thousands of asset choices. ex. "Bitcoin (BTC)"
Currency - Choose a conversion currency. ex. "USD" for US Dollar
Days Selected - Choose how many days you want data for. ex. 1 Month (Last 30 Days)
Refresh - Choose refresh frequency. Default is daily.
For a list of all base and convert symbols, click here:
Optional Parameters
Label - Allows the user to name a dataset pull.
How to pull
After logging in:
Click the "View Dashboard" button in the ribbon"
Click the orange "+" symbol at the bottom right of Home
Click "Cryptocompare OHLCV"
Choose Asset, Currency, Days Selected, and Refresh
In this example, we will use "Bitcoin (BTC)", "USD", "1 Month (Last 30 Days)", and "Daily". This will give us a daily refresh of the Bitcoin to US Dollar pairing for the last 30 days.
Make sure your cursor is in cell A1, and click the "Highlight Range" button
Confirm that the highlighted range will not overwrite any data, then click "Place Data".
Data will be pasted into cell A1 of your worksheet
Note - many API providers use "UNIX timestamp" instead of date. If you need help converting UNIX timestamp, see the following article: https://intercom.help/cryptosheets/tutorials/how-to-convert-between-unix-timestamp-to-readable-date
Resources
Cryptocompare website
Cryptocompare API