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)




"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"I have to tell you though that using the IQFeed API is about the easiest and cleanest I have seen for some time." - Comment from Jim
"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
"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
"Thank you so much - awesome feed, awesome service!" - Comment from Greg via Email
"There is no doubt that IQFeed is the best data provider. I am very satisfied with your services. And IQFeed is the only one that I would recommend to my friends. Now, most of them are using your product in China." - Comment from Zhezhe
"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"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 »On the historical data, The Close Price are almost ALWAYS different from the next Open price
Author Topic: On the historical data, The Close Price are almost ALWAYS different from the next Open price (3 messages, Page 1 of 1)

ant1
-Interested User-
Posts: 2
Joined: Nov 5, 2019


Posted: Nov 5, 2019 09:55 AM          Msg. 1 of 3
I was under the assumption that Always, the close price equals the next opening price durg the opening trading day - with the expection of stock exchange closing vs stock exchange opening the next day.

For example, when I query any NASDAQ stock minute granularity historical data, I get improper values.

Statistically, 90% of the time, the close price is different from the next opening price.

I can also see that inconsistency in the Charts App from the IQFEed API Connection Manager, to reproduce, just open the Charts APP, take ABC Symbol, for example, load the minutes, display OHLC and click on each minute - and you will see the inconsistency by yourself.

Same Happens when doing a
HIT,Symbol,60,date from,date to,,,,1,Requestid
request to the API.

How can I get consistent open/close historical data with IQFeed?

DTN_Gary_Stephen
-Interested User-
Posts: 43
Joined: Jul 3, 2019


Posted: Nov 5, 2019 11:06 AM          Msg. 2 of 3
The short answer is: that's an incorrect assumption.

The Close of a minute is not necessarily the Open of the next minute, even within the same day. Minute data is built from individual trade data within that minute. For example, the last transaction of the 10:00 minute can have a price $5.00, and the first transaction of the 10:01 minute can have a price of $5.01. That would give you a 10:00 Close of $5.00 and a 10:01 Open of $5.01. This is common.

In other words, IQFeed doesn't publish an Open based on the Close of the previous interval. An Open only occurs when a new transaction happens, and that new transaction may be at a different price level than the previous.

Sometimes the Open of a minute (or any interval) will match the Close of the previous one, but this is by circumstance only.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

ant1
-Interested User-
Posts: 2
Joined: Nov 5, 2019


Posted: Nov 5, 2019 05:44 PM          Msg. 3 of 3
Thanks Gary for the quick answer and pointing out that this asumption is wrong.

I am quite not sure to understand how, and I would greatly appreciate to get the long answer.

So what you are saying is that - purelly timely speaking - is that for example - if we have the following two minutes for Ask:

10:00 : Open $4.95, Close $5.00
10:01: Open $5.02, Close $5.05

The open time for the 10:01 is not exactly 10:01:00.000000 but between 10:01:00.0000 and 10:01:59.9999999, the first time the order book has changed during this time span, modifying the Ask price.

Or is it that the close price of $5.00 doesn't really happens at 10:00.59.99999 - it is the last change in value recorded between 10:00:00.00000 & 10:00:59.999999 - and that it happens that the price changes at exactly 10:01:00.000000 - giving a different Open value than the close value?

Or is it a bit of the both?
 

 

Time: Fri November 22, 2019 1:19 AM CFBB v1.2.0 32 ms.
© AderSoftware 2002-2003