Total Open Interest for RBOB

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?
Best Answer
-
ek.get_timeseries(['RB-TOT'],
start_date=datetime.timedelta(-100),
end_date=datetime.timedelta(0),
fields= ['VALUE','TIMESTAMP'],
interval='daily')
0
Answers
-
Hi @davide.costanzo ,
Please use the DIB to find the relevant field that may change depending on the instrument type:
0 -
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.
0 -
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.
0 -
i can obtain the information i want on a chart, but cannot obtain it in with the eikon API.
Can you help on this?
0 -
Hi @davide.costanzo, I believe that you're using Datastream charts here. I looked into Datastream and found the following:
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.
0 -
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
0 -
Hi @davide.costanzo, In that case, this is a content question. Please reach out to my.refinitiv.com where they can answer such questions.
0 -
I was actually told to ask in the developer portal as the question is about the eikon API.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 687 Datastream
- 1.4K DSS
- 622 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 254 ETA
- 557 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 276 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 671 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛