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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythoneikon-com-apiricsexcelvba
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
39.2k 75 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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea