All Collections
Tutorials
Bitwise
How to pull historical prices of Bitwise Indices into Excel
How to pull historical prices of Bitwise Indices into Excel

Find out the historical performance of all the top Bitwise Indices with the click of a button

J
Written by John Young
Updated over a week ago

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.

Did this answer your question?