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 just wanted to let u know that your data feed/service is by far the best!!! Your unfiltered tick data is excellent for reading order flow and none of your competitors delivers this quality of data!" - Comment from Peter via Email
"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.
"I was with ******* for 4 years at $230 a month, this is a huge savings for me, GOD BLESS YOU PEOPLE," - Comment from T.S. via Email
"Everything is working great with the API. I love it." - Comment from Calvin
"If someone needs the best quality data and backfill beyond what their broker provides at a rate that is the best in the industry, I highly recommend IQFeed." - Comment from Josh via Public Forum
"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
"Boy, probably spent a thousand hours trying to get ******* API to work right. And now two hours to have something running with IQFeed. Hmmm, guess I was pretty stupid to fight rather than switch all this time. And have gotten more customer service from you guys already than total from them… in five years." - Comment from Jim
"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 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'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
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) »IQFeed Developer Support »Problem with Open price
Author Topic: Problem with Open price (2 messages, Page 1 of 1)

opttrade
-Interested User-
Posts: 25
Joined: Nov 7, 2016


Posted: Feb 8, 2019 12:34 PM          Msg. 1 of 2
I'm having troubles to get the unadjusted hiostorical Open price for stocks.
For backtesting I need unadjusted data. Therefore I take the (unadjusted) 1-minute data and thought that the open price of the 0930 bar (or the first bar after 0930 if this does not exists) will match to the daily open price.
Normally the price IS the open price, but there seems to be some situation where this is not the case.

Example: Feb, 7th 2019:

At 09:30:00 055341 there was a trade at 19.83 which is the open of the 0930 candle
The streaming data for VVV sent an open of 20.43 which seems to be the official open from NYSE_ARCA at 09:32:05 001591

The problem now: How to create valid unadjusted historical daily bars? We have to use intraday data, because daily data from IQFeed are adjusted, but the open of the first minute bar does not necessarily match the real open. To correct this it would be necessary to look into T&S but this is only available for half a year or so.

Any suggestions how to build unadjusted daily (and minute) data with correct open?

DTN_Steve_S
-DTN Guru-
Posts: 2093
Joined: Nov 21, 2005


Posted: Feb 19, 2019 06:50 AM          Msg. 2 of 2
Unfortunately there isn't a real good way to do this because we include Extended Trades (which are some Form T trades) in our minute data bars.

However, one thing I'll note here is that generally speaking, IQFeed only adjusts daily data for splits. There are a few cases where in the past (and by few, I mean once or twice a year across all stocks on average) we have also manually adjust data for other corporate actions and/or dividends but I believe we stopped doing this several years ago.

Your example VVV has not had any splits registered in our system so the daily data should be un-adjusted.

So as a result, you should be safe (of course you will want to verify this using your own methods) to use the daily data as is for any symbols that haven't split.
 

 

Time: Fri May 3, 2024 2:50 AM CFBB v1.2.0 11 ms.
© AderSoftware 2002-2003