API to get RIC of a particular exchange

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.

Find more posts tagged with

api

eikon-data-api

Accepted answers

Jirapongse

@angelalock

In Eikon Excel, you can use the RSearch function.

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

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

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

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

All comments

Jirapongse

@angelalock

In Eikon Excel, you can use the RSearch function.

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

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

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

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

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?

EXPLORE OUR SITES