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

Best Answer

  • 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.