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.,
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