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
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"
}
]
}
}
}
Awesome! Thank you so much, where is this search on website? Sorry for stupid question, but I really cannot find it.
"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?
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"
}
]
}
}
}
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
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.
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