Good day experts,
I'm having a bunch of bonds that need to dig out the issuer's RICs (or the parent and nearest ancestor of the issuer that has the RIC), e.g.,
XS1732152589
XS1861178322
XS2051121387
XS2099768207
Best Regards,
Frederic
Good day experts,
I'm having a bunch of bonds that need to dig out the issuer's RICs (or the parent and nearest ancestor of the issuer that has the RIC), e.g.,
XS1732152589
XS1861178322
XS2051121387
XS2099768207
Best Regards,
Frederic
Hi @Frederic.Li
You can with retrieving the Ultimate Parent ID and from there equity RIC. Please check if it meets your requirements.
IDs, err = ek.get_data(['XS1732152589','XS1861178322','XS2051121387','XS2099768207'],'TR.UltimateParentId') df,err = ek.get_data(IDs['Ultimate Parent Id'].astype('str').to df
Thank you @marcin.bunkowski
That's works!
But why I cannot see the 'TR.UltimateParentId' field either in the Eikon Data Item Browser or the Eikon Excel's build formula tool? Is there any other places to get the dictionary of the full field list?
Hi @Frederic.Li
I'm glad that it was helpful. I'm also able to find this field in DIB
The second line of code is missing some part:
df,err = ek.get_data(IDs['Ultimate Parent Id'].astype('str').tolist(),"TR.RIC")