API to get RIC of a particular exchange

angelalock
angelalock Newcomer
in Eikon Data APIs

Hi, is there any API to use to get the RIC of a particular exchange from identifiers (SEDOL, ISIN etc.)? For example, for SEDOL B1FH950 and traded on Frankfurt stock exchange (GF exchange code), the RIC should be USIM_p.F, but just using the SEDOL and this API TR($A$1,"TR.PrimaryRICCode","CODE=MULTI") would not point me to the correct RIC I'm looking for.

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @angelalock

    In Eikon Excel, you can use the RSearch function.

    =RSearch("EQUITY","Search:'B1FH950' ExchangeName:'Frankfurt stock exchange'","NBROWS:1")

    1652154992438.png

    In Eikon Data API (Python), you can use the get_symbology and get_data methods.

    data = ek.get_symbology(["B1FH950"], from_symbol_type="Sedol", to_symbol_type="RIC", best_match=False)
    df, err = ek.get_data(data['RICs'].tolist()[0],['CF_EXCHNG'])
    df

    1652155141409.png

    Then, you can filter the output by the CF_EXCHNG field.

    df[df['CF_EXCHNG'] == 'FRA']

Answers

Categories