Total Open Interest for RBOB

davide.costanzo

If I want to get the total open interest of 'LCO' (Brent) I do:

import eikon as ek

ric='LCOTOT'

s , e = ek.get_data( ric , ['TR.OPENINTEREST.Date' , 'TR.OPENINTEREST']

However, if I want to do the same for 'RB' (Rbob) :

import eikon as ek

ric='RB-TOT'

s , e = ek.get_data( ric , ['TR.OPENINTEREST.Date' , 'TR.OPENINTEREST']

It wont work. Do you know why?

Moody

ek.get_timeseries(['RB-TOT'],

start_date=datetime.timedelta(-100),

end_date=datetime.timedelta(0),

fields= ['VALUE','TIMESTAMP'],

interval='daily')

jonathan.legrand

Hi @davide.costanzo ,

Please use the DIB to find the relevant field that may change depending on the instrument type:

davide.costanzo

Thanks, I have done that but I think the field is simply missing. There is the field 'opint_1' but it contains only ONE number, and there is no history for it.

For all the other rics there is 'TR.OPENINTEREST' which contains the full history. While for this one there is not.

jonathan.legrand

Hi @davide.costanzo ,

An alternative RIC will need to be used, because the fields shown in the DIB are the only ones reachable via the Eikon Data API used here. To find the RIC you are after, you can contact the content team directly. You can contact them via the my.refinitiv.com website.

davide.costanzo

i can obtain the information i want on a chart, but cannot obtain it in with the eikon API.

Can you help on this?

jonathan.legrand

Hi @davide.costanzo, I believe that you're using Datastream charts here. I looked into Datastream and found the following:

https://product.datastream.com/browse/search.aspx?dsid=ZRQW955&AppGroup=DSAddin&q=RBOB&prev=99_RBOB+Gasoline+Total+Volume+Composite+Energy+Statistics+Contract&nav_category=12

Is this what you are after? If so, you will need to use the Datastream API. For Datastream credentials, if you don't already have any, please contact your representative on my.refinitiv.com. For documentation on Datastream and its APIs, please see here. I also created a Tutorial on Datastream's API if needed.

davide.costanzo

thanks Jonathan,

no, I am actually just using the charts app in Eikon.

I would like to pull that data using the eikon python api.

I tried with ek.get_data() but I could not do it.

thanks

Davide

jonathan.legrand

Hi @davide.costanzo, In that case, this is a content question. Please reach out to my.refinitiv.com where they can answer such questions.

davide.costanzo

I was actually told to ask in the developer portal as the question is about the eikon API.