Example: on Feb 1, EXCM202305000.U changed to EXC1M202305000.U. On Feb 2, when I load "UNDERLYING" field for EXCM202305000.U, it is null so I know the RIC has changed but is there a way, using the API, to determine the new RIC? FYI I am using C# with EikonDataAPI v0.4.7.
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
191
●4 ●7 ●15
How to get new equity option RIC after corp action using EikonDataAPI
hi @DDALY
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
399
●4 ●5 ●9
Hi @DDALY ,
Adjusted options stubs are the results of a corporate event resulting in a change in the underlying, lot size, strike prices, etc. As far as I know there is no direct way to determine a RIC change. One thing I would suggest is to construct and loop over potential RICs (this is straightforward and you can easily construct potential RICs) and try to validate those. Such an implementation is done here for options with different generations. Although these are in Python, you can use the same workflow to re-create functions for C# as well. The functions take ISIN/RIC, maturity date and strike and return a valid RIC along with the prices.
Another thing which I believe might be useful for you is getting the adjustment factor for stock split events as it will impact the strike price. However, if you have the exact strike this shouldn't be a challenge for you. Just in case sharing this article here where you may find a workflow for finding stock split corporate events and adjustment factors.
Please have a look at those and feel free to let me know should you have any further questions.
Hi
@haykaz.aramyan, Apologies for delayed response. Yes I had already implemented the RULES7 formulae using C# but I will be doing some additional work in Python so that code will be very useful. Also thank you for the stock split code - that's one case covered and I may try to expand it to cover other cases if possible.
