Support Board
Date/Time: Mon, 10 Feb 2025 15:55:15 +0000
Historical data not being returned for earlier start/end dates
View Count: 666
[2020-08-22 19:55:53] |
CBR600RR - Posts: 37 |
If I make a request for historical data for Thursday using start/end date (today is saturday), the data is returned fine. If I make a request for wednesday, no data is returned - records served is 0. The only change is the start and end dates of a day. eg: Working request log: HD Server | HD Request #2 | Socket: 4 | Symbol: AAPL | ServiceCode: | RecordInterval: 5 | MaximumDaysRequested: 0 | Start date-time: 2020-08-20 13:30:00 | ClientRequestID: 2 | Username: x. | Thread:7492 | 2020-08-22 15:51:59.572 HD Server | Using ending date-time: 2020-08-20 20:00:00 | ClientRequestID: 2 | Username: x. | Thread:7492 | 2020-08-22 15:51:59.573 HD Server | HD Request #2 | Socket: 4 | Symbol: AAPL | ServiceCode: | RecordInterval: 5 | Records Served: 4663 | ClientRequestID: 2 | Username: x. | Thread:7492 | 2020-08-22 15:51:59.637 Failed request log: HD Server | HD Request #2 | Socket: 2 | Symbol: AAPL | ServiceCode: | RecordInterval: 5 | MaximumDaysRequested: 0 | Start date-time: 2020-08-19 13:30:00 | ClientRequestID: 2 | Username: x. | Thread:5712 | 2020-08-22 15:48:34.202 HD Server | Using ending date-time: 2020-08-19 20:00:00 | ClientRequestID: 2 | Username: x. | Thread:5712 | 2020-08-22 15:48:34.202 HD Server | HD Request #2 | Socket: 2 | Symbol: AAPL | ServiceCode: | RecordInterval: 5 | Records Served: 0 | ClientRequestID: 2 | Username: x. | Thread:5712 | 2020-08-22 15:48:34.202 what am I missing? |
[2020-08-24 12:16:57] |
CBR600RR - Posts: 37 |
This is still an issue with build 2158.
|
[2020-08-24 23:00:31] |
CBR600RR - Posts: 37 |
StartDateTime doesn't seem to be respected at all. If I omit EndDateTime and MaxDaysToReturn and set StartDateTime to 8/20 at 9:30 am (the unix value I am using is 1597930200), I get data for today only (8/24). The log in sierra charts shows that it appears to be receiving the start time correctly: HD Server | HD Request #1 | Socket: 2 | Symbol: TSLA | ServiceCode: | RecordInterval: 5 | MaximumDaysRequested: 0 | Start date-time: 2020-08-20 13:30:00 | ClientRequestID: 1 | Username: x. | Thread:6836 | 2020-08-24 19:05:43.245 Date Time Of Last Edit: 2020-08-24 23:15:00
|
[2020-08-25 04:45:59] |
|
Try re-downloading the Intraday data for the symbol in the source installation of Sierra Chart which the data is being served from. Re-download all the data in the chart by going to the chart and selecting "Edit >> Delete All Data and Download". You just need to do this once per symbol and not for each chart. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2020-08-25 04:46:15
|
[2020-08-25 11:37:24] |
CBR600RR - Posts: 37 |
That worked, thanks. IS there anyway to do this all at once for every symbol (I'm working with 50 symbols)?
|
[2020-08-25 11:44:09] |
CBR600RR - Posts: 37 |
Never mind looks like you can just delete the files manually in the data directory. Cheers.
|
[2020-08-26 00:18:54] |
|
Still we are not sure why there is an issue. It must have something to do with the new Date-Time integer format but the historical data server can read the data in either a double or integer format. So at this point we are not sure of the exact reason for the problem. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2020-08-26 00:19:06
|
[2020-08-26 14:25:50] |
CBR600RR - Posts: 37 |
I think the issue was I had intraday storage time unit set to 1 tick and max historical days to download set to 10 for non tick data and 2 for 1 tick data, so when I requested 5 second data I was thinking it was going to use the max of 10 days because I was downloading 5 second data, but it used the max of 2 days because intraday data storage time unit was 1 tick.
|
[2020-08-27 06:39:21] |
|
Ok yes that is a good explanation.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: