INDEX DATA IS HERE

September’s release brings with it our #1 user request: index data. You can now get SPX, VIX, NDX, DJI, plus all your other favorites. Thousands of indices are now available. Best yet, index data is available both for both real-time and historical use.

If you’re using our Google Sheets Add-On there is a new formula available INDEXDATA that works the same way as STOCKDATA, with all the same parameters. There should be no learning curve for users who are already working with our formulas. And for API users, the endpoints for indices work the same as stocks and accept all the same parameters that you are used to using, so only minimal changes to your code will be necessary.

Unlike other data providers that require special leading or trailing characters to identify the index (e.g. $DJI, ^DJI, .DJI, DJI.X etc.), in our implementation, none of that is necessary. Just use the standard symbol for the index (DJI) in your Sheets formulas or our index API endpoints without any leading or trailing index identifier.

Learn in 3 minutes!

Google Sheets with =INDEXDATA("SPX","all","9/1/2022","9/2/2022","1") in cell A1, filling a table of one-minute SPX candles from 9:30 on 9/1/2022 with date, open, high, low and close columns

If you’re a Sheets user, you can get started with INDEXDATA in just a few minutes. It works the same way as the rest of our formulas!

We also finished this month:

  • Sheets: Status feedback during the refresh process.
  • Sheets: Ability to refresh the current sheet instead of all sheets.
  • API: Bug fixes for real-time stock data endpoint.