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
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
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
Hello @swapna.dr,
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
-AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
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.
Hi Alex,
How do I retrieve 'OPENINT_1' or 'TR.OPENINTEREST' with EIKON API? I'm using df, e = ek.get_data('IBM.N', ['OPENINT_1'], {'SDate':'2022-01-01','EDate':'2022-04-01'}) and its coming back with NA. Thanks