For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
13 3 3 5

RIC nomenclature for expired Options on Futures

How can I build the RIC for an expired Option on a Future such as 'LCO5500'?

The Q&A below gives an answer for historical Options, but not Options on a Futures:

https://community.developers.refinitiv.com/questions/48814/find-historical-option-price-for-given-ticker-date.html

I'd like to use such RIC for expired Options on Futures in Python in an API call similar to this:

  1. option = ek.get_timeseries(['ECAG201801100.U^G18'],start_date='2018-01-10',end_date='2018-02-10',interval='daily')
eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonsymbologyderivatives
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.

1 Answer

Upvote
Accepted
1.4k 6 2 2

Hi @danieluphromes ,


Looking at 'RULES1' in Eikon, you can select the RIC rules for the security type at hand - here it's Options on Futures, which is 'RULES5'


Once the Option on a future is delivered, its original RIC is removed from Eikon's front end.

E.g.: Once the LCO5500 option expired in October 2020 and was delivered in December 2020, it was removed.

After being removed, they are renamed (in the back end - so that they are discoverable in our APIs) to specify that they're now expired.

E.g.: Once the LCO5500 option was delivered in December 2020, it was discoverable as LCO5500L0^L20 on the API; the two last Ls represent that the delivery month was December, and the 0 & 20 added towards the end indicate that the delivery year was 2020.

So you can find the LCO5500 Option on a Future expired in October 2020 (and delivered on December 2020) in the Python API under 'LCO5500L0^L20':


ek.get_timeseries(['LCO5500L0^L20'], start_date='2020-01-10', end_date='2020-02-10', interval='daily')


You can follow the same logic for other such Options on Futures

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