I need to retrieve information regarding delistings of RIC codes (im my case only stock symbols) in an automated fashion using Eikon's Python API.
Anyone managing a portfolio fed with TR data must have a need for something like this. For instance: RIC ‘COH.N’, Coach Inc., recently changed into ‘TPR.N’, Tapestry. I need to process this information on the day it becomes effective and before downlading pricing data. Thereafter the machine can make buy/sell decisions. If the change is processed too late we will obviously run into an error since no pricing data came in for one of the positions. So, actually, I am looking for a Eikon API statement in PYTHON like:
EXAMPLE
df, err = eikon.get_data(‘COH.N’,[‘TR.EventStartDate','TR.EventType','TR.EventTitle'],{'EventType’:’DELISTING’, 'SDate':'20140101', 'EDate':'20180101’})
One can already do this for ‘SSP’ (=Stock Splits), ‘EXDIV’ (Ex dividend). And perhaps others. So where it says :’DELISTING’ in my example I could use a code for delistings. Than I can run a daily script to determine if any stock in my portfolio has been delisted, of changed of RIC code or/and changed of name.
It seems that once a RIC code is deprecated its name is changed to include the ^ character (circumflex accent). Where/how is this (future) change retrieved using the Eikon Python API?
So in short: How do I automatically retrieve information regarding delistings, RIC code changes and name changes using the Eikon Python API? (If someone know how to retrieve this in Excel, that will bring me a step further as well.)
