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 will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther
"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
"I just wanted to let you know how fast and easy I found it to integrate IQFeed into our existing Java code using your JNI client. In my experience, such things almost never go so smoothly - great job!" - Comment from Nate
"The people at Nirvana have very nice things to say about your company and I can see why! Price and service is a potent combination." - Comment from Ed
"If you want customer service that answers the phone, your best bet is IQFeed. I cannot stop praising them or their technical support. They are always there for you, and they are quick. I have used ****** too but the best value is IQFeed." - Comment from Public Forum
"I just wanted to say how happy I am with your service. I was able to download the API docs last week and I was able to replicate Interactive Brokers historical bar queries and realtime bar queries over the weekend. That was about one of the fastest integrations that I've ever done and it works perfectly!!!!" - Comment from Jason via Email
"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy via Email
"I've been using IQFeed 4 in a multi-threaded situation for the last week or two on 2600 symbols or so with 100 simultaneous daily charts, and I have had 100% responsiveness." - Comment from Scott
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"I would just like to say that IQFeed version 4 is running very well and I am very happy with its performance. I would also like to extend a big thanks for the fast and efficient help that I always receive. My questions and concerns are always addressed promptly. Way to go!" - Comment from Josh in CO.
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 »Archive (2017 and earlier) »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)

ChainsawDR
-Interested User-
Posts: 29
Joined: Jan 4, 2019


Posted: Apr 12, 2020 06:22 PM          Msg. 1 of 5
Hi,
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 961 times)

ChainsawDR
-Interested User-
Posts: 29
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 1072 times)

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


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

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.

Thanks
Todd

ChainsawDR
-Interested User-
Posts: 29
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

DTN_mark_e
-Interested User-
Posts: 49
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)
www.dtn.com/trading | www.dtniq.com | http://www.iqfeed.net



File Attached: bbytick.png (downloaded 1003 times)
 

 

Time: Fri April 26, 2024 10:30 AM CFBB v1.2.0 10 ms.
© AderSoftware 2002-2003