Retrieve the Parent equity RIC with bond ISIN: Incomplete lists

Hi all,

I am trying to retrieve the parent euqity RIC using the bond ISIN. Following the previous tasks and questions proposed like Retrieval of Parent equity close prices via Bond RIC - Forum | Refinitiv Developer Community and Retrieval of Equity Instrument Data via Bond Instrument Identifier - Forum | Refinitiv Developer Community I use the following codes:

df = pd.read_excel(' ')
print(df[:3]

parent = df['Parent Immed Org ID'].astype(str).tolist()
df2, e = ek.get_data(parent, ['TR.RIC','TR.PrimaryQuote','TR.OrganizationID']

Most of the equities RIC are obtained, however, some of the RIC are missing. For example, the bond ISIN is 'AT0000A2JSN2'( with Isser Name is 'EVN AG', whose Parent Immed Org ID is '105701684'), whose equity RIC can not be found.

Is there any other way that I can get these RICs?

Many thanks.

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @jiayin.meng.20

    Thank you for reaching out to us. There are a lot of IDs.

    df, err = ek.get_data(['AT0000A2JSN2'],['TR.UltimateParentId', 
                                         'TR.FiParentOrgID', 
                                         'TR.FiIssuerOrganization',
                                         'TR.FiParentImmedOrgID','TR.RIC'])
    df

    1707725549204.png

    Then, I used those IDs to get TR.RIC.

    df, err = ek.get_data(["5000003197","109442","10024","105701684"],
                          ["TR.RIC","TR.CommonName","TR.IsPublic"])
    df

    1707725663611.png

    As far as I know, RICs are available for public organizaions.

Answers