Join the 80,000 other DTN customers who enjoy the fastest, most reliable data available. There is no better value than DTN!

(Move your cursor to this area to pause scrolling)




"I "bracket trade" all major news releases and I have not found one lag or glitch with DTN.IQ feed. I am very comfortable with their feed under all typical news conditions (Fed releases, employment numbers, etc)." - Comment from Public Forum
"I've been using Neoticker RT with IQFeed for two months, and I'm very happy with both of the products (I've had IQFeed for two years with very few complaints). The service from both companies is exceptional." - Comment from Public Forum
"Everything is working amazing now. I'm already impressed with the true-tick feed of IQFeed and it's ability to support my 480 symbol layout." - Comment from Tyler via Email
"Thank God for your Data Feed as the only Zippers I see are on my pants (LOL), and no more 200 pip spikes to mess up charts." - Comment from Spiro via Email
"Previously I was using *******. IQFeed is WAY more economical, and for my charting needs is just as good, if not better." - Comment from Public Forum Post
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"I have been using IQFeed now for a few years in MultiCharts and I have zero complaints. Very, very rare to have any data hiccups or anything at all go wrong." - Comment from Public Forum
"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"Just a quick one to say I'm very impressed so far :) The documentation for developers is excellent and I've quickly managed to get an app written to do historical downloads. The system is very robust and pretty quick considering the extent of data that's available. The support guys have been very helpful too, in combination with the forums it's been plain sailing so far!" - Comment from Adam
Home  Search  Register  Login  Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTNMarkets on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »IQFeed Developer »IQFeed Developer Support »Historical tick data timezone?/adjustment issue
Author Topic: Historical tick data timezone?/adjustment issue (6 messages, Page 1 of 1)

lgwaustralia
-Interested User-
Posts: 16
Joined: Apr 11, 2016

Trade on


Posted: Jun 19, 2019 06:44 AM          Msg. 1 of 6
Hi. We are fetching historical data for FDAX. Latest test fetching using HTT,XG#,20190606 000000,20190611 170500,,,,0,,.

The fetched ticks timestamp seems to have been moved back 5 hours from the usual 1am/2am that it usually starts.

So end part of raw data looks ok, ends around 15XX/16XX (we fetch it with closest datetime being retrieved first)

2019-06-11 16:03:24.215000,12154.00,73,105233,12154.00,12154.00,2743249,C,68,01, <== end
2019-06-11 15:59:59.674000,12145.50,2,105160,12145.00,12145.50,2743053,C,68,01,
2019-06-11 15:59:56.711000,12145.00,2,105158,12144.00,12145.00,2743036,C,68,01,
2019-06-11 15:59:55.466000,12144.00,1,105156,12144.00,12145.00,2743032,C,68,01,

Then we get to here where it should had stopped at 1am/2am but goes back passed 0a and back further to previous day

2019-06-11 00:03:16.804000,12114.50,1,1036,12112.00,12114.50,1043420,C,68,01,
2019-06-11 00:01:27.540000,12115.00,1,1035,12112.50,12115.00,1043277,C,68,01,
2019-06-11 00:01:24.790000,12112.50,1,1034,12112.50,12115.00,1043249,C,68,01,
2019-06-11 00:01:07.922000,12112.50,1,1033,12112.50,12115.00,1043221,C,68,01,
2019-06-11 00:00:08.134000,12114.50,1,1032,12112.50,12114.50,1043178,C,68,01, <== new day
2019-06-10 23:59:58.424000,12114.50,1,1031,12112.50,12114.50,1043175,C,68,01,
2019-06-10 23:58:29.982000,12114.00,2,1030,12112.00,12114.00,1043094,C,68,01,
2019-06-10 23:57:50.899000,12113.50,1,1028,12111.50,12113.50,1043073,C,68,01,

This continues until here

2019-06-10 20:15:27.993000,12079.50,1,42,12077.50,12079.50,988692,C,68,01,
2019-06-10 20:15:27.134000,12079.00,1,41,12076.50,12079.00,988677,C,68,01,
2019-06-10 20:15:24.822000,12074.50,1,40,12074.50,12079.00,988646,C,68,01,
2019-06-10 20:15:23.338000,12073.00,39,39,12073.00,12073.00,988556,C,68,01, <== new session start??
2019-06-10 16:03:35.737000,12096.50,37,48420,12096.50,12096.50,988017,C,68,01, <== previous day session end
2019-06-10 15:59:57.689000,12087.00,1,48383,12087.00,12090.50,987387,C,68,01,
2019-06-10 15:59:57.688000,12087.00,1,48382,12087.00,12090.50,987384,C,68,01,
2019-06-10 15:59:55.916000,12087.00,1,48381,12087.00,12091.00,987268,C,68,01,

Same thing happens on the other days:

2019-06-10 00:01:37.788000,12107.00,1,955,12104.50,12107.00,71532,C,68,01,
2019-06-10 00:01:05.796000,12105.50,1,954,12104.50,12105.50,71497,C,68,01,
2019-06-10 00:00:46.297000,12104.50,1,953,12104.50,12106.50,71471,C,68,01,
2019-06-10 00:00:39.994000,12104.50,1,952,12104.50,12106.50,71466,C,68,01, <== new day
2019-06-09 23:59:27.013000,12104.50,1,951,12104.50,12106.50,71426,C,68,01,
2019-06-09 23:59:12.510000,12104.50,1,950,12104.50,12106.50,71423,C,68,01,
2019-06-09 23:58:56.789000,12104.50,1,949,12104.50,12106.50,71421,C,68,01,
...
...
2019-06-09 20:15:24.558000,12101.00,1,49,12100.50,12101.00,687,C,68,01,
2019-06-09 20:15:24.556000,12100.50,1,48,12100.50,12101.00,683,C,68,01,
2019-06-09 20:15:24.556000,12101.00,2,47,12100.50,12101.00,681,C,68,01,
2019-06-09 20:15:24.556000,12100.50,45,45,12100.50,12100.50,649,C,68,01, <== ??
2019-06-07 16:03:39.563000,12055.00,37,105100,12055.00,12055.00,12426297,C,68,01, <== session end
2019-06-07 15:59:59.411000,12050.00,1,105063,12048.00,12050.00,12425814,C,68,01,
2019-06-07 15:59:59.401000,12050.00,6,105062,12048.00,12050.00,12425812,C,68,01,
2019-06-07 15:59:59.390000,12050.00,6,105056,12048.00,12050.00,12425806,C,68,01,

Issue appears to have started from 12/10/2018 based on a table we use to keep start / end timestamps for each day's session.

2018-12-04 02:00:00.000000
2018-12-05 02:00:00.000000
2018-12-06 02:00:00.000000
2018-12-07 02:00:00.000000
2018-12-09 19:30:00.000000
2018-12-10 00:00:00.000000 <==
2018-12-11 00:00:00.000000
2018-12-12 00:00:00.000000
2018-12-13 00:00:00.000000
2018-12-14 00:00:00.000000
...
...
(part where its DST)
2019-03-07 00:00:00.000000
2019-03-08 00:00:00.000000
2019-03-10 19:30:00.000000
2019-03-10 23:00:00.000000
2019-03-11 23:00:00.000000
2019-03-12 23:00:00.000000
2019-03-13 23:00:00.000000
2019-03-14 23:00:00.000000
2019-03-17 19:30:00.000000
2019-03-17 23:00:00.000000
2019-03-18 23:00:00.000000
...

Any idea why this happened? a way to fix it?

Lance

lgwaustralia
-Interested User-
Posts: 16
Joined: Apr 11, 2016

Trade on


Posted: Jun 19, 2019 07:19 AM          Msg. 2 of 6
After checking with a ninjatrader chart, timestamp that goes back to 20:00 is actually an additional 5 hours of tick data prefixed to the start of the expected historical tick data. Not sure what they are.


Lance
Edited by lgwaustralia on Jun 19, 2019 at 10:19 PM

lgwaustralia
-Interested User-
Posts: 16
Joined: Apr 11, 2016

Trade on


Posted: Jun 23, 2019 09:33 PM          Msg. 3 of 6
Is there any way to exclude those additional historical tick data? Was it because of the command string that we sent?

Would like for you to test on your end and see if we get the same result.

Lance

LonnieS
-King of IQ Development-
Posts: 114
Joined: Jun 2, 2004


Posted: Jun 24, 2019 08:19 AM          Msg. 4 of 6
In December of 2018 the DAX increased it's trading hours to start a few hours after the Close on the previous day. The additional data you are seeing represents those additional market trades, it is not erroneous data. You could filter the data you receive but then you would be throwing away a significant portion of the actual DAX trading.

Lonnie Shumate
Development Manager, IQ Systems
DTN

lgwaustralia
-Interested User-
Posts: 16
Joined: Apr 11, 2016

Trade on


Posted: Jun 25, 2019 03:53 AM          Msg. 5 of 6
Thanks for the reply.

Lance

lgwaustralia
-Interested User-
Posts: 16
Joined: Apr 11, 2016

Trade on


Posted: Jun 25, 2019 10:20 PM          Msg. 6 of 6
Just had to change Trading hours to the Extended one and can now see the additional market data in NT.

Lance
 

 

Time: Wed April 1, 2020 1:51 PM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003