How to pull historical prices of Bitwise Indices into Excel

In this tutorial, we show you how to pull the historical pricing history of various Bitwise Indices.

Bitwise Index Historical

Description: Full historical data for all of Bitwise’s indices.

Data returned:

• Index

• Index Price (USD)

• Date UTC

Example: Return historical data for the Bitwise 10 index from August 20, 2018 till August 26th, 2018.

How to pull

1. In the Cryptosheets ribbon, click Dashboard

2. Login to the service through Google, or sign-up option

3. Click the orange + button

4. Click Bitwise Index Historical

5. In the Index dropdown, choose Bitwise 10 Index

6. Choose Start Time (GMT) and End Time (GMT)

7. Click the Table Headers toggle

8. Click into A1 of the current tab, click Highlight Range, and Place Data

9. Verify that data has updated

10. You also have the option to choose a timed refresh interval.