Re: Getting historical options data

raksina.samasiri

<AHS>

The Chart for expired RIC <AXJO6250U8.AX^I18> would look like this:

Currently, the RIC syntax for expired options cannot be searched in the instruments section using the Formula Builder. However, you can reference the expired RIC and still create the formula to retrieve the historical data.

Here's a sample formula where cell A2 contains the expired RIC (e.g., AXJO6250U8.AX^I18):
=RHistory(A2,".Timestamp;.Close","NBROWS:60000 INTERVAL:1D",,"TSREPEAT:NO CH:Fd")

You can check <RULES1> and <RULES2> in a Quote without the brackets for additional details.

I hope that this addressed you concern. I would like to take the opportunity to ask for permission to close the case. Once agreed, you will be receiving a recap email right after this email to confirm the resolution provided. Rest assured that even though the case is closed, I will still have access to the email thread and can re-open the case any time should you have any clarification regarding the query.

From: Getting historical options data