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

question

Upvotes
Accepted
0 2 4 7

Getting Historical Open Interest & Option Chain with Eikon API

How do I retrieve 'OPENINT_1' or 'TR.OPENINTEREST' with EIKON API? I tried using df, e = ek.get_data('IBM.N', ['OPENINT_1'], {'SDate':'2022-01-01','EDate':'2022-04-01'}) and its coming back with NA. Tried Get_History and no luck. Also, Historical Option chains for SPX. Thank you.

apihistorical
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@vlad.dimanshteyn

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

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

1 Answer

· Write an Answer
Upvotes
Accepted
17.2k 82 39 63

Hi @vlad.dimanshteyn

I would suggest you reach out to the Refinitiv Helpdesk - they can bring in a content specialist to determine if this historical data is available.

If you are interested in retrieving content for an Option Chain, you will have to specify an Option Chain RIC for IBM. For example:

option_chain,err = ek.get_data('0#IBM*.U', ['CF_NAME', 'OPINT_1'])

This will return all constituents within the chain with the Open Interest values for each. However, a content specialist can determine if the historical content is available.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks Nick. I'm getting current option chains & OPTINT_1 for SPX, etc I want to get option chains & open interest historically (closing values) and trying to figure out what I need to do. Can I get it with Eikon or do I need separate historical subscription???? Vlad

@vlad.dimanshteyn

Please reach out to the Refinitiv Helpdesk, as mentioned by my colleague. The HelpDesk team can bring in a content specialist to determine if this historical data is available.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.