Hello,
I'd like to know if there's a way to keep track on ISIN/SEDOL/Any other identifier changes for a given company.
Is there a way to do this with the Eikon API?
Thanks for your time!
Hi,
To check the historical changes you can try with:
ek.get_data('MTBC.F',["TR.ISIN","TR.ISIN.date"],{'SDate':0,'EDate':-20,'FRQ':'Y',})
the same should work with TR.RIC or TR.SEDOL.
@22ca8780-99e4-42fa-9ca2-b27abad3c0c4_deprecated_52290d28-5651-43dc-98eb-52c06ef37810
Thanks
Thanks a lot for your help!
I tried this using dates as inputs and didn't succeed. Why would that be?
ek.set_app_id('8A7A8AE30B105E8CDB41')freq='D'sDate='01/15/2007'eDate='01/31/2007'data = dict() #creating and updating dictionarydata.update(Sdate=sDate)data.update(Edate=eDate)data.update(Frq=freq)df = ek.get_data(rics, 'TR.ISIN', data)
Hi @22ca8780-99e4-42fa-9ca2-b27abad3c0c4_deprecated_52290d28-5651-43dc-98eb-52c06ef37810 ,
In your syntax you are missing TR.ISIN.date
df = ek.get_data(rics, ['TR.ISIN','TR.ISIN.date'], data)
Your example with broader time window gives more non empty results.
Please also make sure that the RIC was active on that date as few examples from your list contains instruments that were listed quite recently. Try to set up eDate to today's value to check that all the fields are non empty.
One question about this, specifically speaking of RICs: I thought RIC was an ID we could use to map all other ID's, despite it being changed from time to time, "delisted" RICs still could be used to map new stuff (even newer RICs).Is there an ID that serves for this purpose?
