permID API: mapping ticker and MIC to Primary RIC Code

Johann Lourens

I can't seem to find this in documentation and just want to check if anyone has been able to map from ticker and MIC to primary RIC code? e.g. AAL and XLON to AAL.L

Jirapongse

@Johann Lourens

You can use GET /permid/search with quote entity type to get the PermID and RIC from ticker (AAL) and MIC (XLON).

https://api.thomsonreuters.com/permid/search?access-token=<token>&q=ticker:AAL and mic:XLON&entityType=quote

If RIC is available, the result will contain hasRIC field with RIC value.

{
  "result": {
    "quotes": {
      "entityType": "quotes",
      "total": 1,
      "start": 1,
      "num": 1,
      "entities": [
        {
          "@id": "https://permid.org/1-55836044588",
          "hasName": "ANGLO AMERICAN ORD",
          "assetClass": "Ordinary Shares",
          "isQuoteOfInstrumentName": "Anglo American Ord Shs",
          "hasRIC": "AAL.L",
          "hasMic": "XLON",
          "hasExchangeTicker": "AAL",
          "isQuoteOf": "https://permid.org/1-8590920808"
        }
      ]
    }
  }
}

Johann Lourens

Awesome! Thank you so much, where is this search on website? Sorry for stupid question, but I really cannot find it.

Johann Lourens

"hasRIC:" is that the primary quote RIC or primary RIC code? As an example for AAPL and XNGS, primary quote would be AAPL.OQ and primary RIC would be AAPL.O

It looks to me like its the primary quote ric. Is there anyway to get back primary ric code?

Jirapongse

If I set MIC to "xxxx", it returns AAPL.O.

https://api.thomsonreuters.com/permid/search?access-token=<token>&q=ticker:AAPL and mic:xxxx&entityType=quote

{
  "result": {
    "quotes": {
      "entityType": "quotes",
      "total": 1,
      "start": 1,
      "num": 1,
      "entities": [
        {
          "@id": "https://permid.org/1-55838974642",
          "hasName": "APPLE ORD",
          "assetClass": "Ordinary Shares",
          "isQuoteOfInstrumentName": "Apple Ord Shs",
          "hasRIC": "AAPL.O",
          "hasMic": "XXXX",
          "hasExchangeTicker": "AAPL",
          "isQuoteOf": "https://permid.org/1-8590932301"
        }
      ]
    }
  }
}

Johann Lourens

https://community.developers.refinitiv.com/discussion/comment/45180#Comment_45180

That works for AAPL, as there happens to be only one potential primary RIC for that ticker. However, try DSY, then you get atleast 2 as there the relationship between ticker and primary RIC is not one-to-one

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/45193#Comment_45193

@Johann Lourens

It looks the entity search can't be used to retrieve primary RIC code from ticker and mic. I think that it is designed to get the OpenPerm ID from the RIC or ticker and search results are ranked in descending order of the string match results.

However, I will contact the OpenPerm ID support team to verify this use case.

Jirapongse

I got a response from the development team.

Tickers are not unique – they are unique when referenced
with their respective exchanges only.

In the example used, DASTy.DEU and DSY.CCP are
consolidated RICs, and by market convention of being consolidated in nature, is
assigned MIC:XXXX. Therefore I don’t think, can be generalized to conclude
there is one-to-many mapping.The product is working as expected