get RIC code for a given OrgId in python

Question

question

vijay.singh

43 ●2 ●1 ●7

get RIC code for a given OrgId in python

We have list of OrgId of companies recieved from Organisation Hierarcy data API.

requestUrl='https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw'

"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.LegalEntityHierarchyExtractionRequest"

Now for all the companies recieved from Organisation Hierarcy data, we require corresponding RIC codes.

Could you point us to the API which can provide the relevant data.

Also if you can provide the code snippet(as mentioned below) for API call, it will be very helpful.

  
  
                
                 requestUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw'
                  
                 requestHeaders = {
    
    
                     "Prefer": "respond-async",
                     "Content-Type": "application/json",
                     "Authorization": "token " + token
                 }
                  
                 requestBody = {
    
    
                     "ExtractionRequest": {
    
    
                         "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.LegalEntityHierarchyExtractionRequest",
                         "ContentFieldNames": [
                             "ID",
                             "Legal Entity OrgID",
                             "Official Name",
                             "Related OrgID",
                             "Immediate Parent OrgID",
                             "Ultimate Parent OrgID"
                         ],
                         "IdentifierList": {
    
    
                             "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.EntityIdentifierList",
                             "EntityIdentifiers": [
                                 {"Identifier": "100421204", "IdentifierType": "OrgId" }
                             ]
                         },
                         "Condition": {
    
    
                             "DeltaDays": "5"
                         }
                     }
                 }
                  
                 r2 = requests.post(requestUrl, json=requestBody, headers=requestHeaders)
                 status_code = r2.status_code

dss-rest-api datascope-select dss symbology ric

May 19, 2021 at 11:42 AM

10 |1500

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

Answer 1 · 2021-05-20T05:03:44Z

Jirapongse

38.1k ●71 ●35 ●53

@vijay.singh

From my finding, I can use the returned "Legal Entity OrgID" fields with the Search/EquitySearch endpoint to get RIC codes.

{
    "SearchRequest": {
        "AssetStatus": "Active",
        "AssetCategoryCodes": null,
        "SubTypeCodes": null,
        "CurrencyCodes": null,
        "CompanyName": null,
        "Description": null,
        "DomicileCodes": null,
        "ExchangeCodes":null,
        "FairValueIndicator": null,
        "FileCodes": null,
        "GicsCodes": null,
        "OrgId": "116916829,100421204,101908452,95420",
        "Ticker": null,
        "Identifier": null,
        "IdentifierType": null,
        "PreferredIdentifierType": null
    }
}

The response looks like this:

    "value": [
        {
            "Identifier": "NNND.F",
            "IdentifierType": "Ric",
            "Source": "FRA",
            "Key": "VjF8MHgwMDAzZGQwMDEzNjY5NjNkfDB4MDAwM2RjMDAzZGM1ODBhN3xGUkF8RVFRVXxFUVRZfE9EU0h8RXx8Tk5ORC5GfDAxODY",
            "Description": "TENCENT ORD",
            "InstrumentType": "EquityQuote",
            "Status": "Valid",
            "DomicileCode": "CN",
            "CurrencyCodes": "EUR",
            "SubTypeCode": "ODSH",
            "AssetStatus": "Active",
            "IssuerName": "TENCENT HOLDINGS",
            "IssuerOrgId": "100421204",
            "Exchange": "FRA",
            "FileCode": "186"
        },
        {
            "Identifier": "UBSFF.PK",
            "IdentifierType": "Ric",
            "Source": "PNK",
            "Key": "VjF8MHgwMDAzZGQwMDE0ZDE3ZjY0fDB4MDAwM2RjMDA0MjAxMGI5N3xQTkt8RVFRVXxFUVRZfE9EU0h8RXx8VUJTRkYuUEt8MTA2MA",
            "Description": "UBISOFT ENTERTAINMENT ORD",
            "InstrumentType": "EquityQuote",
            "Status": "Valid",
            "DomicileCode": "FR",
            "CurrencyCodes": "USD",
            "SubTypeCode": "ODSH",
            "AssetStatus": "Active",
            "IssuerName": "UBISOFT ENT",
            "IssuerOrgId": "95420",
            "Exchange": "PNK",
            "FileCode": "1060"
        },

However, please directly contact the Refinitiv DataScope Select support team via MyRefinitiv to verify it.

May 20, 2021 at 05:03 AM

10 |1500

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

Q&A Forum

question

get RIC code for a given OrgId in python

1 Answer

question

get RIC code for a given OrgId in python

1 Answer

Related Questions