question

Upvotes
Accepted
7 3 2 4

Find primary exchange / RIC for an ISIN

We are using RSearch

e.g. RSearch("FUND";"Search:KYG4648K1085";"NBROWS:30";"TRANSPOSE:YES";B1)

to get a list of RICs for an ISIN. Now we are wondering if it is possible to identify the primary RIC / Exchange using the Excel EIKON Com Add-In.

Thanks in advance for any feedback.

eikoneikon-com-apirics
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.

Upvote
Accepted
4.6k 26 7 22

@skobus instead of trying to search for it, you can convert an ISIN to a RIC with a DEX2 RData call or with the TR function such as this:

=TR("KYG4648K1085","TR.RIC")
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.

Upvotes
7 3 2 4

Thanks @Zhenya Kovalyov, that was helpful.

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.