Missing Close Prices of active Option chain

Dear Refinitiv community and help desk,
thank you very much for taking the time to help me.
Missing close prices:
For many of the active RICs for options, there are also no close prices but Bid & Ask prices (see attachment). Especially for many options of the 0#OEX*.U chain. Where can I get historical close prices for these options? The close prices of the options on the S&P 100 Index are extremely important for me.
At the moment I extract all active RICs of the S&P100 and then get TR.Closeprice for each which does not work if there is no data for that command.
I would be very delighted if you could help me.
Best regards,
Nick
Best Answer
-
This is the sample code:
#get all the underlying rics
df,e = ek.get_data('0#OEX*.U','LONGLINK1')
rics = df['Instrument'].tolist()
#rics is list of 25xx instruments.
#get TR.ClosePrice for all the instruments
df,e = ek.get_data(rics,'TR.ClosePrice')
#drop rows with NaN value
df1 = df.dropna()
df1.head(10)It seems that around 78 instruments from 2551 instruments that have TR.ClosePrice data.
I would not be able to answer why the TR.ClosePrice is not available to those instruments.
You can contact Refinitiv Content Helpdesk to clarify about the content question at https://my.refinitiv.com/
0
Answers
-
Hello @nick.kirchner
I sent you an email regarding this through the case you raised with us. Feel free to reply to the email I sent you just now.
To get the historical price of the Chain RIC 0#OEX*.U.
1. Once you cell reference the RIC in the instrument field -> Click the Time Series Icon (looks like a graph icon beside the name interval)
2. You can go to Bid then select the data items needed.
3. You can cell reference the date then once done, you can hit insert.I sent you the template I created to the email registered to the case.
Best Regards,
Rizalie
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 613 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
- 248 ETA
- 552 WebSocket API
- 37 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
- 275 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
- 630 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
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 86 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛