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
1 1 2 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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apieikon-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

· Write an Answer
Upvotes
Accepted
39.4k 77 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.

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.