Theta Data in Excel!

Theta Data is proud to announce an Excel Add-In! The Add-In allows you to access Theta Data’s data right in Excel. Easily create charts and compute statistics all while using the Excel formulas you know and love.

Stocks, Options, and Indices

Currently the Excel Add-In supports fetching data for Stocks, Options, and Indices. While not all of the endpoints in the REST API are provided in Excel, most of the data is available. You can see more about each type of data in the documentation.

You must use the proper namespace in your formula to access Theta Data: =THETADATA. Then select the function you wish to call. You can leverage the help pop-up, or reference the documentation to access the data you need.

Data is provided as if you opened the CSV output in Excel. Once the data has been fetched, you can manipulate it any way you want using all the built-in Excel functions.

Requirements

There are a few requirements before you can use the Excel Add-In. First, you must have a PRO subscription for at least one of the data types. Second, you must ensure the HTTP_ACCESS_ORIGIN=* property (usually found at the bottom of your properties file) is set to (*) to allow connections from Excel. Finally, you must be running terminal version 1.8.1a or newer to access data in Excel.