get RIC code for a given OrgId in python

vijay.singh · May 2021

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

Jirapongse · May 2021

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

get RIC code for a given OrgId in python

Best Answer

Welcome!

Welcome!

Quick Links

Categories