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 ran your IQFeed DDE vs. my broker vs. a level II window for some slow-moving options. I would see the level II quote change, then your feed update instantaneously. My broker's DDE, however, would take as much as 30 seconds to update. I am not chasing milliseconds, but half a minute is unacceptable." - Comment from Rob
"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
"I am a hedge fund manager here. It’s funny, I have a Bloomberg terminal and a Bridge feed, but I still like having my DTN feed!" - Comment from Feras
"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
"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
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"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
"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
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"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
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: Tue May 7, 2024 1:45 AM CFBB v1.2.0 12 ms.
© AderSoftware 2002-2003