For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
4 5 6 7

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

dss-rest-apidatascope-selectdsstick-history-rest-apirics
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvote
Accepted
32.2k 40 11 20

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"
        },
...  
icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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