question

Upvotes
Accepted
7 3 2 4

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

intelligent-tagging-apipermid-apiopen-permid-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
Accepted
47.5k 113 44 60

@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%3AAAL%20and%20mic%3AXLON&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"
        }
      ]
    }
  }
}

permid.png (33.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
7 3 2 4

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
7 3 2 4

"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?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
47.5k 113 44 60

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

https://api.thomsonreuters.com/permid/search?access-token=<token>&q=ticker%3AAAPL%20and%20mic%3Axxxx&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"
        }
      ]
    }
  }
}
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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

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

Upvotes
47.5k 113 44 60

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.