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)




"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
"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
"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
"Everything is working amazing now. I'm already impressed with the true-tick feed of IQFeed and it's ability to support my 480 symbol layout." - Comment from Tyler via Email
"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
"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
"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 started a trial a few weeks back before the market went wild. DTN.IQ didn’t miss anything and beat my other provider. I decided to stay with you because of the great service through all the volatility." - Comment from Mike
"I noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah
"It’s so nice to be working with real professionals!" - Comment from Len
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: Sun May 5, 2024 6:39 AM CFBB v1.2.0 13 ms.
© AderSoftware 2002-2003