How do I get all the RICS for a given Security? Lets say I have AAPL.O and I am interesting in re...

psouto
psouto Newcomer
How do I get all the RICS for a given Security? Lets say I have AAPL.O and I am interesting in retriving AAPL.OQ and so on...

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    Hello @psouto,

    To search up company RICs visually use Resources -> RIC Search Tool on this portal.

    ---

    In Datascope, all the RICs for a company are related by Organization ID (OrgId).

    To take advantage of this I would first pull the Orgid for RIC:

    {{protocol}}{{host}}{{api}}Search/InstrumentSearch

    {
    "SearchRequest": {
    "InstrumentTypeGroups": [
    "CollatetizedMortgageObligations",
    "Commodities",
    "Equities",
    "FuturesAndOptions",
    "GovCorp",
    "MortgageBackedSecurities",
    "Money",
    "Municipals",
    "Funds"
    ],
    "IdentifierType": "Ric",
    "Identifier": "AAPL.O",
    "PreferredIdentifierType": "OrgId"
    }
    }

    Resulting in OrgId identifier:

    {
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Content.ValidatedInstrument)",
    "value": [
    {
    "Identifier": "19775",
    "IdentifierType": "NONE",
    "Source": "NSQ",
    "Key": "VjF8MHgwMDAzZGQwMDEzN2U2NGQ3fDB4MDAwM2RjMDA0YTRlODQ1ZnxOU1F8RVFRVXxFUVRZfE9EU0h8RXx8QUFQTC5PfDEzMDQ",
    "Description": "APPLE ORD",
    "InstrumentType": "EquityQuote",
    "Status": "Valid"
    }
    ]
    }

    And then search for all Rics per OrgId:

    {{protocol}}{{host}}{{api}}Search/InstrumentSearch

    {
    "SearchRequest": {
    "InstrumentTypeGroups": [
    "CollatetizedMortgageObligations",
    "Commodities",
    "Equities",
    "FuturesAndOptions",
    "GovCorp",
    "MortgageBackedSecurities",
    "Money",
    "Municipals",
    "Funds"
    ],
    "IdentifierType": "OrgId",
    "Identifier": "19775",
    "PreferredIdentifierType": "Ric"
    }
    }

    Resulting in

    {
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Content.ValidatedInstrument)",
    "value": [
    {
    "Identifier": "AAPL.OQ",
    "IdentifierType": "Ric",
    "Source": "NSM",
    "Key": "VjF8MHgwMDAzZGQwMDEzN2U2NGQ3fDB4MDAwM2RjMDAzOGQ2OTZhN3xOU018RVFRVXxFUVRZfE9EU0h8RXx8QUFQTC5PUXwxMzAz",
    "Description": "APPLE ORD",
    "InstrumentType": "EquityQuote",
    "Status": "Valid"
    },
    ...