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 am keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don
"Everything is working great with the API. I love it." - Comment from Calvin
"With HUGE volume on AAPL and RIMM for 2 days, everyone in a trading room was whining about freezes, crashes and lag with *******, RealTick, TS and Cyber. InvestorRT with IQFeed was rock solid. I mean SOLID!" - Comment from Public IRC Chat
"You are much better than lawyers or the phone company because you answer the phone when I call! I just love your customer service." - Comment from Isreal
"My broker in Davenport suggested I give you a try as he uses your service and says its the best." - Comment from Bill via RT Chat
"I've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.
"You are either overstaffed or people just don't have problems with your feed because customer support always answers the phone quickly." - Comment from Jay via Email
"Very impressed with the quality of your feed - ******* is a real donkey in comparison." - Comment from A.C. via Email
"Interactive Brokers tick data was inconsistent, so I have switched to using DTN exclusively. It is great to no longer have to worry about my datafeed all day long." - Comment from Philippe
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
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 »No milliseconds included in DateTime on Tick Data Requests
Author Topic: No milliseconds included in DateTime on Tick Data Requests (18 messages, Page 1 of 1)

bbmat
-Interested User-
Posts: 30
Joined: Mar 31, 2014


Posted: Mar 31, 2014 03:17 AM          Msg. 1 of 18
I use protocol 5.1 (also tried 5.0) when I subscribe to the Lookup socket. When I request tick data (fx data, such as EURUSD.COMP the tick data that is returned includes the Date and Time BUT not any milliseconds. Milliseconds is always "000". Why is that the case and how can this be solved?

Thanks
Matt

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Mar 31, 2014 03:42 AM          Msg. 2 of 18
I don't believe Forex publishes the millisecond activity, but I will confirm with our market data team when they come in.

Tim

bbmat
-Interested User-
Posts: 30
Joined: Mar 31, 2014


Posted: Mar 31, 2014 03:46 AM          Msg. 3 of 18
Well, I would be very surprised if they do not because several ticks per second are received for each symbol. That should definitely be on the to-do list for the next release (if it is not) because it makes using tick based data pretty impossible for low-latency sensitive use.

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Mar 31, 2014 03:56 AM          Msg. 4 of 18
I am sure it is something they would like to add, but I have no ETA on seeing it. I will see if there is anything on the horizon I haven't heard of and let you know.

Tim

bbmat
-Interested User-
Posts: 30
Joined: Mar 31, 2014


Posted: Mar 31, 2014 04:18 AM          Msg. 5 of 18
I see the same lacking on Level1 quote subscriptions for fx. Can you confirm that milliseconds are also not reported on Level1 quotes? I do not understand why your servers would not time stamp everything that comes in, regardless of asset class? (unless of course it is already exchange time stamped)

By the way could you please let me know the field descriptor to specify in "Select Update Fields" in order to have a full time stamp (with date) returned. I do not see dates returned right now for Level1 quote subscriptions. I currently use "Bid TimeMS", "Ask TimeMS", and Last TimeMS", so how can I get the full date & time returned? Thanks


Edited by bbmat on Mar 31, 2014 at 04:19 AM
Edited by bbmat on Mar 31, 2014 at 04:21 AM

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Mar 31, 2014 04:21 AM          Msg. 6 of 18
That is correct, we do not have millisecond on level one as well. We do not timestamp any of the data, the milliseconds displayed with other exchanges is exchange sent, not DTN created. I believe this is a feed limitation, but as I mentioned I do have an email out to confirm this and I will report back once I know for sure.

Tim

bbmat
-Interested User-
Posts: 30
Joined: Mar 31, 2014


Posted: Mar 31, 2014 04:23 AM          Msg. 7 of 18
got it, regarding my last line in the previous post,

"By the way could you please let me know the field descriptor to specify in "Select Update Fields" in order to have a full time stamp (with date) returned. I do not see dates returned right now for Level1 quote subscriptions. I currently use "Bid TimeMS", "Ask TimeMS", and Last TimeMS", so how can I get the full date & time returned?"

Could you please point me to the right field?

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Mar 31, 2014 04:37 AM          Msg. 8 of 18
I do not believe there are date fields available for bid and ask since we do not have historical bids and asks, but I will confirm that as well.

bbmat
-Interested User-
Posts: 30
Joined: Mar 31, 2014


Posted: Mar 31, 2014 04:39 AM          Msg. 9 of 18
so how would you deal with the fact that the stream continues throughout a date switch? Anyone who does not deal with EST as local time needs to convert to UTC or local time which makes it very error prone if no date can be retrieved.

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Mar 31, 2014 04:54 AM          Msg. 10 of 18
I am not sure I understand the question, wouldn't the reset of the time to 00:00:00 be the identifier you would need to know the date switched?

Tim

bbmat
-Interested User-
Posts: 30
Joined: Mar 31, 2014


Posted: Mar 31, 2014 05:00 AM          Msg. 11 of 18
no I would not because the EST time 00:00:00 would show on my machine as 12:00:00 noon (12 hours ahead) and no date switch would be made. My problem is that I want to convert all time stamps to UTC datetime and right now the date portion is missing on streaming data.

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Mar 31, 2014 05:04 AM          Msg. 12 of 18
I don't think I have a way to help that one unfortunately, about the best you could do is watch the timestamp messages that we send each second to level one and populate a date field that way and prepend that date to the timestamp.

Tim

bbmat
-Interested User-
Posts: 30
Joined: Mar 31, 2014


Posted: Mar 31, 2014 05:17 AM          Msg. 13 of 18
got it, thanks.

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Mar 31, 2014 08:17 AM          Msg. 14 of 18
I confirmed that Forex does not place a millisecond timestamp on their quotes, so there is nowhere to get an accurate millisecond timestamp from.

Tim

bbmat
-Interested User-
Posts: 30
Joined: Mar 31, 2014


Posted: Mar 31, 2014 08:30 AM          Msg. 15 of 18
Thanks for checking.

Not wanting to open another topic, could you please let me know what the cutoff time is for fx data when requesting historical DAILY data? What is the time at which the Daily Close of a compressed data point is taken? Is it midnight EST?

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Mar 31, 2014 08:38 AM          Msg. 16 of 18
We close them at 5:00 pm EST.

Tim

bbmat
-Interested User-
Posts: 30
Joined: Mar 31, 2014


Posted: Mar 31, 2014 08:39 AM          Msg. 17 of 18
Thanks

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Mar 31, 2014 08:41 AM          Msg. 18 of 18
No problem. Let me know if anything else comes up.
 

 

Time: Thu April 2, 2020 11:48 PM CFBB v1.2.0 0 ms.
© AderSoftware 2002-2003