How to retrieve the RICs using the bond ISINs?

Janice
Janice LSEG
edited May 14 in Refinitiv Data Platform Libraries

Hello Team,

I hope all is well.

I'm seeking for your help, (for example) Apple, Microsoft and Tesla have bonds going 10 years and each of these bonds have a specific ISIN, unfortunately the ISIN doesn’t map directly to the company’s RIC but to the bond’s RIC. My goal is to sort of input an ISIN of a bond and return a company’s RIC.

So let’s say I input an ISIN of an Apple bond “USThisIsAnExample2025” => it returns “AAPL.OQ” or “AAPL.O”

Also could you provide the Python code instead of the Excel formula? Thank you a lot in advance!

 

Tagged:

Answers

  • Janice
    Janice LSEG

    The only data item we have for ISINs or Bond RICs for that matter is TR.FiIssuerOrganization, which produces numerical value, but we're having problems in constructing codes. As per specialist team, we need to get the data of TR.FiIssuerOrganization first before we can retrieve the RICs. Could you please check and advise the accurate codes? Thank you in advance

  • raksina.samasiri
    raksina.samasiri admin

    Hi @Janice ,

    You can achieve this with two consecutive calls (one: get an OrgID for each instrument, two: get a RIC for each OrgID) then merge the results.

    df = ld.get_data(['US037833CN89', 'US02079KAC18', 'USU02320AH94'],['TR.FiParentImmedOrgID'])
    
df2  = ld.get_data(df['Parent Immed Org ID'].astype(str).tolist(), ['TR.RIC'])


    
df.set_index('Parent Immed Org ID', inplace=True)
    
df2.set_index('Instrument', inplace=True)
    
df.join(df2)

    The output is like below

    image.png

Categories