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 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 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
80.1k 257 52 75

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