get_data() throws an exception when specifying certain dates

The scripting API method call: get_date() provides the ability to retrieve historical data using a date range as an optional parameter specification. The following request will return valid rows of data.
df,err = tr.get_data('.SPX', ['TR.PriceClose'], parameters={'SDate':'1970-01-01','EDate':'1970-01-04'})
When going back further in time, it appears for the above requested instrument, the data is available only until Jan 1, 1970. This can be further observed when requesting for the same data years earlier.
The above request doesn't have any historical data for the date range specified. Although it returns one row with a NaN as the value, I'm assuming this implies no data. However, I would expect such a result to occur if I continue to go back in time. Instead, if I continue to go back in years, I can reach a point where my specified date results in an exception being thrown.
I would expect no data to be returned, or something similar to the above request. Not an exception.
Best Answer
-
OK, I reproduce the issue and confirm that the back-end reject request referring to data before 1950. I'm going to escalate the issue.
You can retrieve Close with the get_timeseries function (values are available since 1928):
Take care to the limit of maximum of 3000 rows, and adjust the date range so as not to reach it (otherwise, result is aligned with end_date):
0
Answers
-
Hi @pierre.faurel,
Yes, the above request will return valid rows of data. I did indicate this in my question: "The following request will return valid rows of data".
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 556 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 652 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- 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
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛