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 was on the phone with a friend who uses CQG and right after the Fed announcement, CQG was as much as 30 seconds behind DTN.IQ. Some quotes were off by as much as 15-18 cents. Your feed never missed a beat." - Comment from Roger
"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
"It’s so nice to be working with real professionals!" - Comment from Len
"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post
"Thanks for all of your help. Great customer service deserves to be recognized which one the reasons I've been a customer of DTN for over 10 years!" - Comment from Stuart
"I used to have *******, but they are way more money for the same thing. I have had no probs with data from DTN since switching over." - Comment from Public Forum Post
"You have an excellent product !!!!!!" - Comment from Arely
"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
"DTN has never given me problems. It is incredibly stable. In fact I've occasionally lost the data feed from Interactive Brokers, but still been able to trade because I'm getting good data from DTN." - Comment from Leighton
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
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 »Product Support »Data and Content Support »Odd data in Historical 1 sec OHLCV vs tick data
Author Topic: Odd data in Historical 1 sec OHLCV vs tick data (5 messages, Page 1 of 1)

-Interested User-
Posts: 8
Joined: Jan 4, 2019

Posted: Apr 12, 2020 06:22 PM          Msg. 1 of 5
I'm retrieving the historical 1 second OHLCV data for backtesting, however I'm seeing some odd spikes in the data that I don't see when I use the 'IQFeed Time & Sales' application to view tick and/or 1min data. It's causing me to doubt whether I should pull/use the historical 1 sec OHLCV or whether I need to start pulling tick data and compiling this myself. I've attached an image that puts the 1sec vs tick vs 1min side by side and have highlighted the 85.39 1sec OHLCV that I can't reconcile with the tick or 1min data. Please could anyone let me know if I am misinterpreting this?
Thanks in advance for any help
Edited by ChainsawDR on Apr 12, 2020 at 06:22 PM

File Attached: BBY.png (downloaded 145 times)

-Interested User-
Posts: 8
Joined: Jan 4, 2019

Posted: Apr 12, 2020 06:33 PM          Msg. 2 of 5
Adding a clearer version. Attached is the 1 sec OHLCV data for BBY on 02/03/2020. Higlighted in yellow is a drop from $86 close price to $85.65, then back to $86. Neither the tick or 1min data from 'Time & Sales' shows any drop down to $85.65. My system triggered a signal on this 1 sec OHLCV data that wouldn't be triggered with the other iqfeed dataset. Unsure of the reason for the discrepancy, or wondering if I have a bug in my data retrieval of 1 sec OHLCV data.

File Attached: BBY2.png (downloaded 162 times)

DTN Todd
-Interested User-
Posts: 55
Joined: Mar 24, 2010

Posted: Apr 12, 2020 08:24 PM          Msg. 3 of 5

I have reviewed that data on multiple of our platforms and i am not showing that drop to $85.65 If we can be of any additional assistance let us know.


-Interested User-
Posts: 8
Joined: Jan 4, 2019

Posted: Apr 12, 2020 08:44 PM          Msg. 4 of 5
Thanks for looking into it Todd. I'll look into our systems to see if we're doing any unexpected transformations or gaps fills that might be causing this. Thank you

-Interested User-
Posts: 24
Joined: Sep 25, 2014

Posted: Apr 13, 2020 10:09 AM          Msg. 5 of 5
I'm sorry, we need to correct our earlier posting -- IQFeed is indeed showing the various ticks at 85.39 on 2/3/20, albeit as "extended trades," which by default are not displayed in the Time & Sales window. To turn on Extended trades, you will need to go into the T&S Settings, and under the General tab, check the box for "Enable Extended Trades."

Mark Eash, Trading Markets Customer Service DTN
9110 West Dodge Rd, Ste 200, Omaha, Ne 68114
800-397-7000 (DTNIQ & IQFEED) | 402-255-3682 (Fax) | |

File Attached: bbytick.png (downloaded 155 times)


Time: Thu October 1, 2020 2:28 PM CFBB v1.2.0 32 ms.
© AderSoftware 2002-2003