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)




"For anyone considering using DTN.IQ for a data feed, my experience with the quality of data and the tech support has been very positive." - Comment from Public Forum
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"I've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.
"Everything is working great ! Very impressive client. The news refreshes better and is more pertinent than the ******* feed I paid $ 100/month for. I Also like the charts a lot." - Comment from Leon
"Previously I was using *******. IQFeed is WAY more economical, and for my charting needs is just as good, if not better." - Comment from Public Forum Post
"You have an excellent feed. Very few spikes for Spot Forex." - Comment from Public Forum Post
"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
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"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.
"DTN feed was the only feed that consistently matched Bloomberg feed for BID/ASK data verification work these past years......DTN feed is a must for my supply & demand based trading using Cumulative Delta" - Comment from Public Forum Post
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 »Splits and backfill data
Author Topic: Splits and backfill data (3 messages, Page 1 of 1)

gwalschl
-Interested User-
Posts: 46
Joined: Oct 25, 2006


Posted: Oct 21, 2007 11:03 AM          Msg. 1 of 3
Recently I tried downloading minute backfill data (via HM command) and wished to cross-check the downloaded data against the OHLC for each day (via the HD command). It appears to me that if a stock splits at some date "D", then all the OHLC prices received in the HD response for days PRIOR to date "D" also get "split adjusted", however the backfill data from the HM responses do NOT get split adjusted.

For example, "AAON" split 3/2 on 8-22-2007 and as a result share prices went from ~$30 per share to ~$20 per share. Now, my backfill prices received via the HM command show prices around $30 per share prior to the split date and prices around $20 per share afterwards. This is what I would expect. However, prices of OHLC data received in HD responses show prices around $20 both before AND after the split. Therefore it appears that the historical end-of-day OHLC prices are split adjusted but the minute data is not.

Is this intended? Is this the "standard/expected" way of handing this data? If so, why is this done?

Thanks!

DTN_Jay_Froscheiser
-VP, Product Operations-
Posts: 1746
Joined: May 3, 2004

DTN IQFeed/DTN.IQ/DTN NxCore


Posted: Oct 22, 2007 08:38 AM          Msg. 2 of 3
This is correct. At this time, we don't split adjust intraday data (we do split adjust daily data). We have some customers that prefer to see the data split adjusted, while others don't. What most people do is look at the fundamental data on the symbol for the past split dates which will allow you to control the split adjustments on the intraday data if you desire.

We are currently evaluating split adjustment of intraday data, but it is a low priority against other things in the hopper.

Jay Froscheiser
DTN - Trading Markets

taa_dtn
-DTN Evangelist-
Posts: 154
Joined: May 7, 2004


Posted: Oct 22, 2007 05:45 PM          Msg. 3 of 3
Quote: We have some customers that prefer to see the data split adjusted, while others don't.

Right -- please count me among the "don't" crowd. When using historical data to back-test, it's important that the data match (as closely as practical) what would have been received as streaming quotes had the symbol been watched during the historical period. Otherwise you can't tell what a trading system running during that period would actually have done.

Allen
 

 

Time: Fri May 24, 2024 4:06 AM CFBB v1.2.0 59 ms.
© AderSoftware 2002-2003