I'm trying to perform a EndOfDayPricingExtractionRequest for the Cusip: 132061805 (SOVB is the sy...

vikas.khurana

...mbol). No data is returned.

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",
    "ContentFieldNames": [
      "Close Price",
      "Close Price Timestamp",
      "Trade Date",
      "CUSIP",
      "ISIN"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [
      { "Identifier": "132061805", "IdentifierType": "Cusip" }
      ]
    },
    "Condition": null
  }
}

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionResult",
    "Contents": [
        {
            "IdentifierType": "Cusip",
            "Identifier": "132061805",
            "Close Price": null,
            "Close Price Timestamp": null,
            "Trade Date": "2019-03-04",
            "CUSIP": null,
            "ISIN": null
        }
    ],
    "Notes": [
        "Extraction Services Version 12.3.40277 (47a46edd9411), Built Feb 11 2019 15:28:41\r\nHoliday Rollover of Universal Close Price waived.\r\nProcessing started at 03/05/2019 23:43:40.\r\nUser ID: 9019504\r\nExtraction ID: 350371829\r\nSchedule: _OnD_0x068c346316c05c2d (ID = 0x068c346318705c2d)\r\nInput List (1 items): _OnD_0x068c346316c05c2d (ID = 068c346317405c2d) Created: 03/05/2019 23:43:38 Last Modified: 03/05/2019 23:43:39\r\nSchedule Time: 03/05/2019 23:43:39\r\nReport Template (11 fields): _OnD_0x068c346316c05c2d (ID = 0x068c346316e05c2d) Created: 03/05/2019 23:43:38 Last Modified: 03/05/2019 23:43:38\r\nColumn 'CUSIP' suppressed for lack of 'CUSIP & CUSIP based ISINs' permission.\r\nCells suppressed for 1 row(s) for lack of 'CUSIP & CUSIP based ISINs' permission.\r\nProcessing completed successfully at 03/05/2019 23:43:40, taking 0.235 Secs.\r\nExtraction finished at 03/05/2019 23:43:40 UTC, with servers: x07t02, QSHC15 (0.0 secs), QSSHA1 (0.0 secs)\r\nUsage Summary for User 9019504, Client 108635, Template Type EOD Pricing\r\nBase Usage\r\n        Instrument                          Instrument                   Terms          Price\r\n  Count Type                                Subtype                      Source         Source\r\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\r\n      1 Mutual Funds                                                     Lipper         N/A\r\n-------\r\n      1 Total instrument charged.\r\n      0 Instruments with no reported data.\r\n=======\r\n      1 Instrument in the input list.\r\nNo TRPS complex usage to report -- 1 Instrument in the input list had no reported data.\r\nWriting RIC maintenance report.\r\n",
        "Identifier,IdentType,Source,RIC,RecordDate,MaintType,OldValue,NewValue,Factor,FactorType\r\n"
    ]
}

Also, curious if I can just search by the symbol (i.e SOVB). Also wondering why I have permissioning issues like: CUSIP' suppressed for lack of 'CUSIP & CUSIP based ISINs' permission.

Christiaan Meihsl

@vikas.khurana,

As stated by Nityanand, the issue is that your account is not permissioned for CUSIPs. For permissioning issues you need to contact your Refinitiv account manager.

Please note that querying by CUSIP (or ISIN for that matter) is ambiguous, because the exchange is not specified. That is why I'd recommend converting the CUSIP to a RIC first. The primary RIC for CUSIP 132061805 seems to be LP40214959, whereas the RIC on NYSE is SOVB.N. On this topic I suggest you read the article on DSS ISIN to RIC conversion, which also applies to the use of CUSIPs. It also explains some of the search functionalities, which might help answer your queries.