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)




"Excellent datafeed !!!" - Comment from Arely
"I "bracket trade" all major news releases and I have not found one lag or glitch with DTN.IQ feed. I am very comfortable with their feed under all typical news conditions (Fed releases, employment numbers, etc)." - Comment from Public Forum
"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 have to tell you though that using the IQFeed API is about the easiest and cleanest I have seen for some time." - Comment from Jim
"I am keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"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
"If you want customer service that answers the phone, your best bet is IQFeed. I cannot stop praising them or their technical support. They are always there for you, and they are quick. I have used ****** too but the best value is IQFeed." - Comment from Public Forum
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"Interactive Brokers tick data was inconsistent, so I have switched to using DTN exclusively. It is great to no longer have to worry about my datafeed all day long." - Comment from Philippe
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 (4 messages, Page 1 of 1)

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


Posted: Apr 9, 2024 11:11 AM          Msg. 1 of 4
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 37 times)

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


Posted: Apr 11, 2024 10:21 AM          Msg. 2 of 4
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: 394
Joined: Jul 3, 2019


Posted: Apr 15, 2024 10:29 AM          Msg. 3 of 4
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: 52
Joined: Mar 26, 2008


Posted: Yesterday @ 12:53 PM          Msg. 4 of 4
Great. I'll wait for the good news!
 

 

Time: Thu April 18, 2024 6:56 AM CFBB v1.2.0 13 ms.
© AderSoftware 2002-2003