how far DataScope goes in terms of Time Series?

psouto

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

Jirapongse

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