Find primary exchange / RIC for an ISIN

Question

Question by Sascha K · Jan 11, 2019 at 09:21 AM · eikon eikon-com-api rics

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.

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-01-11T10:03:13Z

Best Answer

Answer by Zhenya Kovalyov · Jan 11, 2019 at 10:03 AM

@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")

1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2019-01-14T02:10:48Z

Answer by Sascha K · Jan 14, 2019 at 02:10 AM

Thanks @Zhenya Kovalyov, that was helpful.

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.