DTN IQFeed, DTN.IQ, DTN ProphetX Support Forums

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

"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken

"Very impressed with the quality of your feed - ******* is a real donkey in comparison." - Comment from A.C. 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

"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

"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

"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

"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip

"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

"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - Comment from Public Forum

Home

Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather

DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter

»Forums Index »Archive (2017 and earlier) »Data and Content Support »Close higher than high, Close lower than low

Author	Topic: Close higher than high, Close lower than low (6 messages, Page 1 of 1)
datatest -Interested User- Posts: 23 Joined: Feb 29, 2012	Posted: Mar 15, 2012 03:12 AM Msg. 1 of 6 Hello I have analyzed historical corn contracts (EOD Data) and have seen that quite often the close is higher than the high, or lower then the low. Why is in these cases the high/low not equal to the close? thanks
DTN_Steve_S -DTN Guru- Posts: 2093 Joined: Nov 21, 2005	Posted: Mar 15, 2012 10:12 AM Msg. 2 of 6 Can you post some examples? The close value in EOD data (for futures) is the settlement price. Its possible that they are cases where the contract settled outside the High/Low for the day but we will need to investigate it to be sure.
datatest -Interested User- Posts: 23 Joined: Feb 29, 2012	Posted: Mar 15, 2012 10:34 AM Msg. 3 of 6 yes, I put them in an XLS File, these are 2665 examples of wrong records... one question I don't understand: you have all this data in your database. why can you not simply run a check and compare where close/open is lower than low or close/open is higher than high? I am spending hours and hours in data validation, data which should be in principle be checked with some minimal quality checks. And if there is an explanation for this specific "pattern", e.g. due to the settlement price, so it should be in your FAQ. I have the feeling I am the first one looking at these data and asking these questions...
datatest -Interested User- Posts: 23 Joined: Feb 29, 2012	Posted: Mar 15, 2012 10:36 AM Msg. 4 of 6 seems I cannot upload excel, so I send you enclosed a screenshot File Attached: Corn High Low Errors.pdf (downloaded 1421 times)
DTN_Steve_S -DTN Guru- Posts: 2093 Joined: Nov 21, 2005	Posted: Mar 15, 2012 01:29 PM Msg. 5 of 6 Hello, I have confirmed that these are cases where the settlement was outside the High/Low. IQFeed does not stretch the High/Low to include the settlement in this scenario. We don't stretch the High/Low because that allows the 3rd party or end user to decide if they want to do this on thier end (if we did it automatically, they would have no indication that it is the case). As far as your more general concerns: I can assure you that you are not the first person to look at this data. Our history servers process several million requests for data per day. You are looking at a very small subset of the data that our servers provide. They contain trade/minute/daily/weekly/monthly history for millions of symbols (both current and expired). I don't mention this to make excuses but rather simply to illustrate that it is not as simple as running an SQL query where Low > High or and spitting out a report. With that said, we do have processes in place that check the data and we have a team of market data specialists to investigate and correct errors. Additionally, as in this case, we also investigate all issues reported by customers as well. What you found today wasn't an error. The high/low is left "unstretched" so that the end user (3rd party developer) can decide how they want the data.
datatest -Interested User- Posts: 23 Joined: Feb 29, 2012	Posted: Mar 16, 2012 01:21 AM Msg. 6 of 6 Hello Thanks for the investigation. I was assuming that the reason is the settlement price, this is why I wrote above that I am surprised that this answer is not coming immediately or written somewhere, because obviously it happens not so seldom. I was searching in the internet, but could not find an explanation: Why exactly can the settlement price be outside of low/high boundaries?