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)




"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"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
"Excellent datafeed !!!" - Comment from Arely
"I just wanted to let you know how fast and easy I found it to integrate IQFeed into our existing Java code using your JNI client. In my experience, such things almost never go so smoothly - great job!" - Comment from Nate
"I just wanted to tell you what a fine job you have been doing. While *******, from what I hear, has been down and out, off and on, IQ feed has held like a champ this week." - Comment from Shirin
"I noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"It’s so nice to be working with real professionals!" - Comment from Len
"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
"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
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 »NEW IQFEED FORUMS »Data Questions »Spinoff Adjustments
Author Topic: Spinoff Adjustments (6 messages, Page 1 of 1)

Roberts
-Interested User-
Posts: 53
Joined: Mar 26, 2008


Posted: Apr 9, 2024 11:11 AM          Msg. 1 of 6
We all know that Daily data is split-adjusted but Intraday is not. Following a couple recent large spinoffs (GE > GEV and MMM > SOLV), I noticed that IQFeed had applied a split-type adjustment for these that matched my adjustment that I apply for intraday data. I continued investigating S&P 500 and Nasdaq 100 stock histories and found that adjustments for Spinoffs have been applied in about 30 cases.

I attached a spreadsheet with my spinoff findings. This isn't an exhaustive study but I've been following the S&P 100, 500, and Nasdaq 100 stocks. With a few exceptions that I can't quite reconcile the workbook has 3 spreadsheets:

1. The first are the spinoffs for which IQFeed has already applied the adjustment. Nothing needs to be done here, it's just for reference.
2. The next sheet is a list of about 65 other spinoff that I request to be applied to the Daily data. If its not possible to apply these corrections, then I want to know that, and I'll just do it myself for all of our customers.
3. The last sheet of "Errors" is a short list of spinoff that IQFeed may have applied an adjustment for, but they don't match my calculation. More investigation required.

Mainly, I'm looking for action on #2.



File Attached: IQFeed_Spinoffs.zip (downloaded 97 times)

Roberts
-Interested User-
Posts: 53
Joined: Mar 26, 2008


Posted: Apr 11, 2024 10:21 AM          Msg. 2 of 6
To be clear, I'm only talking about adjustments for Daily data. (Just forget that I even mentioned Intraday.)

It's been a few days. Can someone reply?

DTN_Gary_Stephen
-DTN Guru-
Posts: 396
Joined: Jul 3, 2019


Posted: Apr 15, 2024 10:29 AM          Msg. 3 of 6
I have sent your findings to our data team for review. I should have let you know this sooner, I apologize for that.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

Roberts
-Interested User-
Posts: 53
Joined: Mar 26, 2008


Posted: Apr 17, 2024 12:53 PM          Msg. 4 of 6
Great. I'll wait for the good news!

DTN_Gary_Stephen
-DTN Guru-
Posts: 396
Joined: Jul 3, 2019


Posted: Yesterday @ 12:40 PM          Msg. 5 of 6
This is still being researched by our data team. There was a lot of data so it will take some time to fully investigate. I will post here when there is an update.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

Roberts
-Interested User-
Posts: 53
Joined: Mar 26, 2008


Posted: Yesterday @ 02:04 PM          Msg. 6 of 6
Roger that.
 

 

Time: Wed May 1, 2024 5:41 PM CFBB v1.2.0 12 ms.
© AderSoftware 2002-2003