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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
4 4 3 6

how far DataScope goes in terms of Time Series?

Using as an example of AAPL.O I can only get from 2013 onwards

dss-rest-apidatascope-selectdsstime-series
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
38.1k 69 35 53

@psouto

Refer to DSS User Guide, Price History, Timeseries Pricing and Single Price History reports provide historical pricing from as far back as 1980.

I have tested with TimeSeriesExtractionRequest and I can get the data before 2013.

The request is:

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TimeSeriesExtractionRequest",
    "ContentFieldNames": [
      "File Code",
      "RIC",
      "Trade Date",
      "Close Price",
      "Alternate Close Price",
      "Split Factor",
      "High Price",
      "Low Price",
      "Open Price",
      "VWAP Price",
      "Turnover",
      "Volume",
      "Bid Price",
      "Asset Type",
      "Quote ID",
      "Bid Yield",
      "Universal Close Price",
      "Exchange Code",
      "Currency Code"          
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",  
      "InstrumentIdentifiers": [{
        "Identifier": "AAPL.O",
        "IdentifierType": "Ric"
      }]
    },
    "Condition": {
      "LastPriceOnly": false,
      "StartDate": "2010-05-24T00:00:00.000Z",
      "EndDate": "2012-05-31T00:00:00.000Z"
    }
  }
}

The response is:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)",
    "value": [
        {
            "IdentifierType": "Ric",
            "Identifier": "AAPL.O",
            "File Code": "1304",
            "RIC": "AAPL.O",
            "Trade Date": "2012-05-31",
            "Close Price": 577.73,
            "Alternate Close Price": null,
            "Split Factor": null,
            "High Price": 581.5,
            "Low Price": 571.46,
            "Open Price": 580.74,
            "VWAP Price": 577.3188,
            "Turnover": null,
            "Volume": 17568229,
            "Bid Price": 577.5,
            "Asset Type": "EQTY",
            "Quote ID": "0x0003dc004a4e845f",
            "Bid Yield": null,
            "Universal Close Price": 577.73,
            "Exchange Code": "NSQ",
            "Currency Code": "USD"
        },
...

        {
            "IdentifierType": "Ric",
            "Identifier": "AAPL.O",
            "File Code": "1304",
            "RIC": "AAPL.O",
            "Trade Date": "2010-05-24",
            "Close Price": 246.76,
            "Alternate Close Price": null,
            "Split Factor": null,
            "High Price": 250.9,
            "Low Price": 246.26,
            "Open Price": 247.28,
            "VWAP Price": 249.1184,
            "Turnover": null,
            "Volume": 26937337,
            "Bid Price": 246.76,
            "Asset Type": "EQTY",
            "Quote ID": "0x0003dc004a4e845f",
            "Bid Yield": null,
            "Universal Close Price": 246.76,
            "Exchange Code": "NSQ",
            "Currency Code": "USD"
        }
    ]
}

If this doesn't answer your question, please share the request message used to replicate the problem. Therefore, I can use it to request the data and verify the problem.

icon clock
10 |1500

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

Click below to post an Idea Post Idea