Getting RIC from ISIN and MIC

neil.gallagher
neil.gallagher Newcomer
in DSS

Hello, Am I able to map an ISIN and MIC to a RIC using DSS API . I know there is the Source option but I dont see anywhere I can map MIC to Source. Also the EXchange Code field returned from Terms and Conditions doesnt seem to be conform to the 3 character REuters Exchange code format . Thanks

Tagged:

Best Answer

  • Christiaan Meihsl
    Christiaan Meihsl LSEG
    Answer ✓

    @neil.gallagher,

    Now that I understood your query better, I knew what to search, but it took some time.

    The T&C (Terms and Conditions) request you mentioned can be used in 2 ways:

    • Input an ISIN, and receive the primary RIC, MIC, Exchange code, etc.
    • Input an ISIN and exchange code, and receive the (not necessarily primary) RIC, MIC, etc.


    The issue is that you don't have exchange codes, you have MICs.
    I am guessing that as you have MICs, you could have cases where the MIC could be on an exchange which is not the primary exchange. So we cannot assume we just need to find the primary RIC (which would be easy, as mentioned above and described in this article on converting ISINs to RICs using DSS).


    So the issue is to find a mapping between MIC and exchange code.


    A basic instrument search request using an ISIN as input returns all possible RICs, with their corresponding exchange codes. We get the universe of RICs, but not their MIC.
    Running a T&C request on all the RIC-exchange pairs received from the instrument search will deliver the corresponding MICs, which would allow you to select the correct RIC.
    This is a bit of a roundabout solution, but could work.


    An alternative would be to use a table of correspondence between MIC and exchange code. It took some time, but a colleagues (thank you Patrick !) came up with two similar ones, here they are:

    • An online version, dated 17 Feb 2018, with 364 matching records. This one is maintained by Thomson Reuters.
    • An Excel version, attached. This one is of May 2017 and contains 390 actual matches (there are many blank and "Not Available" records, which might also be of interest) mic-to-exchange-table-may-2017.zip.
      I found a similar Excel version, but of 2013, here.
      These seem practical, but as they were not created by Thomson Reuters, we do not guarantee their content.
    • Added 4 April: I found a more recent version, dated 8 March 2018, with 420 matching records. mifid-basic-venue-20180308.zip

    Hope this helps.

Answers

Categories