For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
20 2 1 1

How to fetch historical "Market Open Interest" using eikon R API?

Hi,

I need to know how one can fetch the Market Open Interest using eikon R API. I have no idea about its fields name. I know how to collect Open Interest using eikon R API. Below is an example

get_data(list("LCOc1"),fields = list('TR.OPENINTEREST.Date', 'TR.OPENINTEREST', '2000-01-01', '2020-05-25'))

but I want to know how one can fetch Historical Market Open Interest. Below graph shows the difference between Open Interest and Market Open Interest.

The above subplot is of OI while below subplot is Market OI. Kindly help.

Thank you

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonreikon-data-api-rr-studio
2020-10-05.png (53.7 KiB)
icon clock
10 |1500

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

1 Answer

Upvote
Accepted
6.7k 8 6 7

Hi @niket.chauhan Thanks for your question - I believe market open interest is the sum of all open interest for all contracts in the futures chain - unfortunately this is not a field available via the Eikon Data API and will need to be computed.

For today you can get this using:

ek.get_data(list('0#1S:'), fields = list('OPINT_1'))

and then summing the OPINT_1 field.

To do this historically is a two-step process. First you need to get the futures in the chain using:

Python:

df, err = ek.get_data('0#1S:', fields = 'CF_NAME')

R:

ek.get_data(list('0#1S:'), fields = list('CF_NAME'))

Then you need to get the open interest value for each contract for each day of history you want with a second API call.

Python:

df1, err = ek.get_data(df['Instrument'].astype(str).values.tolist(), ['TR.OPENINTEREST.date','TR.OPENINTEREST'],{'SDate':'0D','EDate':'-10D'}) 
df1

R: sorry you can probably convert this better than me!

Python:

df1.groupby('Date')['Open Interest'].sum()

R: ditto

I hope this can help.


1602070003868.png (71.8 KiB)
1602071633043.png (55.4 KiB)
icon clock
10 |1500

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

Thank you for the Answer @jason.ramchandani . Really Helpful

Click below to post an Idea Post Idea