-------------------------------------------------------------------------------------------

*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: 

https://intercom.help/cryptosheets/en/articles/3432991-cryptocompare-in-cryptosheets

-------------------------------------------------------------------------------------------

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

Did this answer your question?