Trying to retrieve Expired S&P500 Index option chain

hmmmcho

Hello.

I am trying to retrieve the RICs of expired options.

In the case of non-expired options, I can get the RICs of options as follows:

df, e = ek.get_data(['0#SPX*.U'],
                    ['PUTCALLIND', 'STRIKE_PRC', 'EXPIR_DATE', 'CF_CLOSE', 'IMP_VOL']
                    )

However, to get the expired RICs of options, I guess the following should work, but it does not.

df2, e = ek.get_data(['0#SPX*.U^A21'],
                    ['PUTCALLIND', 'STRIKE_PRC', 'EXPIR_DATE', 'CF_CLOSE', 'IMP_VOL']
                    )

I think 0#SPX*.U^A21 should work, because it has following valid information as follows:

ts = ek.get_timeseries(['SPXa152138000.U^A21',], start_date='2020-01-01')

Could you please help me, how to get the all the RICs by using command like 0#SPX*.U^A21.

Thank you very much.

haykaz.aramyan

Hi @hmmmcho ,

In addition to what @raksina.samasiri already mentioned above and probably you have already learned from the content team:

Unfortunately it is currently not possible to extract expired option RICs through a single API call. The only way you can currently get them is to reconstruct expired RICs following the logic of Refinitiv RIC rules and the ones from exchange (e.g. CBOE in case of SPX) and check the validity via an API call. The article below is walking through that process and you can use the codes in GitHub folder to get RICs for SPX yourself. Please have a look and let us know should you have any further questions:

https://developers.refinitiv.com/en/article-catalog/article/finding-expired-options-and-backtesting-a-short-iron-condor-stra