Get the issuer(or parent)'s RIC from the Bond

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

I tried to use the ticker field, but looks like the tickers are not the NYSE standard, no I'm stuck there. Some of the fields of the bond are prefixed with 0x (maybe asset_id), but I don't know how to map it to the RIC or permid or any other well know public identifiers.

Best Regards,

Frederic

Find more posts tagged with

python

eikon

rics

bonds

fields

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

m.bunkowski

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

All comments

m.bunkowski

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

Frederic.Li

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?

Augusto.Blanc1

@Augusto.Blanc1

dianne.palmario

Hello @marcin.bunkowski

How come I am getting an error? Please advise. Thank you.

m.bunkowski

@dianne.palmario

The second line of code is missing some part:

df,err = ek.get_data(IDs['Ultimate Parent Id'].astype('str').tolist(),"TR.RIC")

EXPLORE OUR SITES