question

Upvotes
Accepted
haykaz.aramyan avatar image
39 ●1 ●0 ●4

Expired option RIC request via Datastream and Eikon APIs

I am using this code to get price data on expired option NDXb1921A5075.U^B21:

df5 = ds.get_data(tickers="<NDXb1921A5075.U^B21>", fields=['MP'], start = '2021-01-01', end = '2021-09-18', freq= 'D' )

According to the RIC rules this option should have been expired on February 19, 2021, however the code above returns price data for up to today (see attached)

price request for expired option.png

And a similar request in Eikon API returns "no data available for the requested period".

Eikon request for same option.png

Could you please kindly consult on this ?


Best regards,

Haykaz


datastream-apidsws-apiderivatives
price-request-for-expired-option.png (19.9 KiB)
eikon-request-for-same-option.png (20.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.

2 Answers

Upvotes
Accepted
Jirapongse avatar image
38.1k ●69 ●35 ●53

@haykaz.aramyan

According to the Datastream Navigator, <NDXb1921A5075.U^B21> represents "NASDAQ 100 Index 16-July-2021 15075 Call" in datastream.

As this forum is more for programming-type queries, rather than content queries - I would recommend you raise a 'I need help understanding content within the product' ticket to the DataStream or Eikon support team via MyRefinitiv. That way a Content specialist can work closely with you and verify the problem.


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.

Upvotes
haykaz.aramyan avatar image
39 ●1 ●0 ●4

Thank you for your answer, will raise a ticket to the support team

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.

Click below to post an Idea Post Idea