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

Find more posts tagged with

derivatives

datastream-api

dsws-api

Accepted answers

Jirapongse

@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.

All comments

Jirapongse

@haykaz.aramyan

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

haykaz.aramyan

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

Maciej.Jasinski

<NDXb1921A5075.U^B21> is a valid code for an NDX Feb 19 2021 expired 15075 call option. The syntax is correct. This is not a DS ticker.

Maciej.Jasinski

<NDXb1921A5075.U^B21> is a valid code for an NDX Feb 19 2021 expired 15075 call option. The syntax is correct. This is not a DS ticker.

Maciej.Jasinski

Here is a proof that the option Eikon RIC is correct and the data fills until the expiry of Feb. 19th. It was never traded though so there is no Trade or Theoretical Price in the DB. There is only BID, ASK and Implied Volatiltiy.

EXPLORE OUR SITES