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/

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.

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

Best Regards,

Rizalie