Find primary exchange / RIC for an ISIN

Sascha K
Sascha K Newcomer
in Eikon COM

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.

Tagged:

Best Answer

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG
    Answer ✓

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

Answers

Categories