permID API: mapping ticker and MIC to Primary RIC Code

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

Find more posts tagged with

permid-api

intelligent-tagging-api

open-permid-api

Accepted answers

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=&lt;token&gt;&amp;q=ticker:AAL and mic:XLON&amp;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"
        }
      ]
    }
  }
}

All comments

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=&lt;token&gt;&amp;q=ticker:AAL and mic:XLON&amp;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=&lt;token&gt;&amp;q=ticker:AAPL and mic:xxxx&amp;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

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

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

EXPLORE OUR SITES