Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Open PermID /
avatar image
Question by Johann Lourens · Jul 02, 2019 at 10:55 AM · permid

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

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

5 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jirapongse.phuriphanvichai · Jul 03, 2019 at 02:58 AM

@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)
Comment
Johann Lourens

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by Johann Lourens · Jul 03, 2019 at 04:06 AM

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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by Johann Lourens · Jul 03, 2019 at 04:10 AM

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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by jirapongse.phuriphanvichai · Jul 03, 2019 at 05:53 AM

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"
        }
      ]
    }
  }
}
Comment

People who like this

0 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Johann Lourens · Jul 03, 2019 at 07:24 AM 0
Share

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

avatar image
REFINITIV
jirapongse.phuriphanvichai ♦♦ Johann Lourens · Jul 03, 2019 at 11:22 PM 0
Share

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

avatar image
REFINITIV
Answer by jirapongse.phuriphanvichai · Jul 09, 2019 at 11:21 PM

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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
6 People are following this question.

Related Questions

Hi, I want to match my database containing permID identifier with data providedby thomson and from APPstudio. How can I do?the only common variable should be permID

Can PermID.org search for person?

orgSubtype field available in entity search, but not in lookup

How to read TTL/n-triple dumps?

How can we find the PermIDs match using LEI information?

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges