Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
angelalock avatar image
1 ●0 ●1 ●2

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.

eikon-data-apiapi
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raksina.samasiri avatar image   raksina.samasiri

hi @angelalock

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,
AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

1 Answer

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
79.1k ●250 ●52 ●74

@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']

1652154992438.png (11.9 KiB)
1652155141409.png (17.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

angelalock avatar image 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 avatar image Jirapongse angelalock

@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.



Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.