question

Upvotes
Accepted
1 2 1 0

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

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apidatahistoricalderivatives
reuters.png (53.8 KiB)
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.

Upvotes
Accepted
18.2k 21 13 21

Hi @nick.kirchner


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/


ahs1.jpg (92.4 KiB)
ahs2.jpg (83.1 KiB)
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.

Upvotes
1 0 1 0

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.

User-added image


I sent you the template I created to the email registered to the case.


Best Regards,

Rizalie

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.

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.