Using as an example of AAPL.O I can only get from 2013 onwards
For a deeper look into our DataScope Select REST API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials
Using as an example of AAPL.O I can only get from 2013 onwards
Hello @psouto,
Please let us know how did it go for you with the suggestion from @jirapongse.phuriphanvichai?
Thanks,
-AHS
Hi,
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If yes please click the 'Accept' next to the appropriate reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Regards,
AHS
Hello @psouto,
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
-AHS
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.