question

Upvotes
Accepted
Sascha K avatar image
7 ●1 ●0 ●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 5.0 MiB each and 10.0 MiB total.

2 Answers

Upvote
Accepted
Zhenya Kovalyov avatar image
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 5.0 MiB each and 10.0 MiB total.

Upvotes
Sascha K avatar image
7 ●1 ●0 ●4

Thanks @Zhenya Kovalyov, that was helpful.

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