API to get RIC of a particular exchange

angelalock
angelalock
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 admin
    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

  • angelalock
    angelalock
    @Jirapongse, thanks for your explanation, very helpful. Just one more thing, how do I manipulate the RSearch function in excel to query from a list of securities and exchanges?
  • Jirapongse
    Jirapongse admin

    @angelalock

    I am not sure if the RSearch function supports multiple queries. Please contact the Eikon Excel support team directly via MyRefinitiv to verify it.



Categories