Is there a way to get call and put option volume traded on a particular stock on a given date through the API? And similarly Open Interest. If a direct data item is not available, is it possible to get the data to help me aggregate it? Thank you
I don't believe this data is available in Eikon historically. You can retrieve volume and open interest for individual options including expired options. But I cannot think of any way to reconstruct the options chain or the list of options that were active as of a given date.
You may want to verify this information with Refinitiv Helpdesk, which is the best resource for any content search and explanation queries. Ask if this data can be retrieved into Excel. The rule of thumb is if the data is available in Excel, it's available through Eikon APIs.