What is the best way select the entire history of an instrument in DSS rest API

I am interested in getting the entire history of an instrument.
What is the best way to do that outside of using startDate and EndDate?
Is there a condition clause available to select entire history?
Also is there an easy to view all the relevant search conditions?
requestBody={
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TimeSeriesExtractionRequest",
"ContentFieldNames": [
"File Code",
"RIC",
"Trade Date",
"Close Price",
"High Price",
"Low Price",
"Open Price",
"Volume",
"Bid Price",
],
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [{
"Identifier": "CZ8",
"IdentifierType": "Ric"
}]
},
"Condition": {
"LastPriceOnly": False,
"StartDate": "2017-05-24T00:00:00.000Z",
"EndDate": "2017-05-31T00:00:00.000Z"
}
}
}
Best Answer
-
What is the best way to do that outside of using startDate and EndDate?
There is no other way. But it is easy to hard code a start date of 1 Jan 1996 (the database does not contain data before that date), and programmatically set the end date to today.
Is there a condition clause available to select entire history?
No, there is no such condition.
Also is there an easy to view all the relevant search conditions?
I'm not sure I understand this query. The above request is not a search but a data extraction request. Its conditions (like those of all API requests) are listed in the API Reference tree. Search requests are different, and several are available (instrumentSearch, EquitySearch, etc.). You can find their list, description and search criteria in this section of the API Reference tree.
If this does not answer your query, then please add details so we can deliver a better answer.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 37 Alpha
- 167 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 705 Datastream
- 1.5K DSS
- 633 Eikon COM
- 5.2K Eikon Data APIs
- 14 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 6 Trading API
- 3K Elektron
- 1.5K EMA
- 259 ETA
- 569 WebSocket API
- 40 FX Venues
- 16 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 4 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 284 Open PermID
- 47 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 24 RDMS
- 2.2K Refinitiv Data Platform
- 879 Refinitiv Data Platform Libraries
- 5 LSEG Due Diligence
- 1 LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 123 Open DACS
- 1.1K RFA
- 108 UPA
- 196 TREP Infrastructure
- 232 TRKD
- 919 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 103 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛