where can I find a mapping between Refinitiv Exchange Codes to Market identifier codes (MIC) & Servi

pratik.p.mehta

Example of one such us NSI -> XNSE? Any links for any xls/csv or anyway to extract this data using Java?

Example:

NEO Exchange NEO-D for NEO-listed securities -----> ???? exchange code

Jirapongse

@pratik.p.mehta

Thanks for reaching out to us.

You can contact the content support team as mentioned by my colleague to check if the mapping file is available.

However, I have used our search API to map RDN_EXCHD2 to MIC. It can map around 300 entries.

You can download it from here. However, it is better to contact the content support team to confirm it.

raksina.samasiri

hi @pratik.p.mehta ,

In my best understanding of the question, it is about content and the members of the developers' community and the moderators of the forum may have some understanding of the content involved. We aim to answer the question if our answer can be of help.

However, the in-depth understanding of specific content requires the knowledge of an expert in that content area. As our customer, you can tap this expertise by opening a case via Content Helpdesk Online or calling your local Refinitiv support number.

To be of help, case number 11605134 was raised on your behalf and you will be contacted by the support team directly to assist on this.

pratik.p.mehta

Thank you - this is exactly what I was looking for. Does this file update whenever a new exchange is added?

Do you have more info on how can we get this programmatically via Java?

Jirapongse

@pratik.p.mehta

No, I will not be updated when a new exchange is added. I need to re-run the code for newly added exchanges.

I used RDP Search API to get those mappings.

The search endpoint is https://api.refinitiv.com/discovery/search/v1/.

The request message is:

{
  "View": "SearchAll",
  "Filter": "(ExchangeCode eq 'LSE' and Mic ne null)",
  "Select": "Mic,MicName, ExchangeCode,ExchangeName",
  "Top": 1
}

The response is:

{
  "Total": 19303,
  "Hits": [
    {
      "Mic": "XLON",
      "MicName": "LONDON STOCK EXCHANGE",
      "ExchangeCode": "LSE",
      "ExchangeName": "London Stock Exchange"
    }
  ]
}

The Java code looks like this:

Unirest.setTimeouts(0, 0);
HttpResponse<String> response = Unirest.post("https://api.refinitiv.com/discovery/search/v1/")
    .header("content-type", "application/json")
    .header("Authorization", "Bearer <token>")
    .body("{\n  \"View\": \"SearchAll\",\n  \"Filter\": \"(ExchangeCode eq 'LSE' and Mic ne null)\",\n  \"Select\": \"Mic,MicName, ExchangeCode,ExchangeName\",\n  \"Top\": 1  \n}")
    .asString();

If you have a Refinitiv Data Platform account, you can test the query through https://api.refinitiv.com.

You can contact your Refinitiv Account Team directly for more information regarding the Refinitiv Data Platform API.

Jirapongse

Another resource is https://my.refinitiv.com/gcodes/mkt_exch_cds.html.

viktor.gorcs

You can use RDP Symbology endpoint.

{

"from": [

{

"identifierTypes": [

"MIC"

],

"values": [

"XETR",

"XNGS"

]

}

],

"to": [

{

"identifierTypes": [

"RDNExchangeCode"

]

}

],

"reference": [

"name",

"status"

],

"filter": {

"status": "active"

},

"type": "auto"

}