question

Upvotes
Accepted
1 0 0 3

Hello 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

permid-apihelpdesk
1571419634722.png (450.7 KiB)
icon clock
10 |1500

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

1 Answer

Upvote
Accepted
23k 22 9 14

Hello @quanlan09100,

I can discuss a way to do it.

To verify this information prior to coding, let us use Swagger tool

that is available from PermId API area via Dev Tools -> Swagger or direct link

1. Identify PermId by

GET /permid/search on AAL, the result is several entities, the first is "1-4295896494"

...
"entities": [
        {
          "@id": "https://permid.org/1-4295896494",
          "organizationName": "Anglo American PLC",
          "primaryTicker": "AAL",
          "orgSubtype": "Company",
          "hasHoldingClassification": "publiclyHeld",
          "hasURL": "http://www.angloamerican.com/"
        }, 
...

2. Pull up the top level info on PermId

GET /id on 1-4295896494, the result is detailed and has

"hasOrganizationPrimaryQuote": "https://permid.org/1-55836044588":

...
  "@id": "https://permid.org/1-4295896494",
  "@type": "tr-org:Organization",
  "mdaas:HeadquartersAddress": "Anglo American House\n20 Carlton House Terrace\n\nLONDON\nSW1Y 5AN\nUnited Kingdom\n",
  "mdaas:RegisteredAddress": "Anglo American House\n20 Carlton House Terrace\n\nLONDON\nSW1Y 5AN\nUnited Kingdom\n",
  "tr-common:hasPermId": "4295896494",
  "hasOrganizationPrimaryQuote": "https://permid.org/1-55836044588", 
...

3. Request the primary quote info via

GET /ID 1-55836044588

Results in "tr-fin:hasMic": "XLON" and "tr-fin:hasRic": "AAL.L",

{
  "@id": "https://permid.org/1-55836044588",
  "@type": "tr-fin:Quote",
  "tr-common:hasName": "ANGLO AMERICAN ORD",
  "tr-common:hasPermId": "55836044588",
  "tr-fin:hasExchangeCode": "LSE",
  "tr-fin:hasExchangeTicker": "AAL",
  "tr-fin:hasMic": "XLON",
  "tr-fin:hasRic": "AAL.L",
  "isQuoteOf": "https://permid.org/1-8590920808", 
icon clock
10 |1500

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

Click below to post an Idea Post Idea