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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 1 1 3

Exchange Specific RIC

Given an ISIN or a Primary RIC or both, how can I get an Exchange Specific RIC?

(e.g. NL0011375019 vs. SNHJ.J -> SNHG.DE)

I'm looking for an excel formula (e.g. using TR() , RtGet() or RData(),...) and how to request the same information using the Office COM API Dex2 library (if possible).

Thx

eikoneikon-data-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikoneikon-com-apiricsexcelvba
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.

1 Answer

Upvotes
Accepted
39.3k 76 11 27

In Excel you can use =RSearch("EQUITY","Search:'NL0011375019' ExchangeCode:'GER'")
You can also use the same search expression in RSearch COM library, which mimics the syntax of RSearch worksheet function.

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.