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)




"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
"This is an excellent value, the system is generous (allowing for 500 stocks) and stable (and really is tick-by-tick), and the support is fantastic." - Comment from Shirin via Email
"You are either overstaffed or people just don't have problems with your feed because customer support always answers the phone quickly." - Comment from Jay via Email
"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken
"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
"Thank you so much - awesome feed, awesome service!" - Comment from Greg via Email
"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post
"I've been using Neoticker RT with IQFeed for two months, and I'm very happy with both of the products (I've had IQFeed for two years with very few complaints). The service from both companies is exceptional." - Comment from Public Forum
"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan
"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy 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 »Detecting Reverse Splits In Minute Aggregated Stream
Author Topic: Detecting Reverse Splits In Minute Aggregated Stream (5 messages, Page 1 of 1)

jabowery
-Interested User-
Posts: 5
Joined: Sep 5, 2019


Posted: Nov 24, 2019 11:31 AM          Msg. 1 of 5
How can one detect when a symbol's price increase is due to a reverse split?

I've recently been bit by a backtest of an algorithmic trade with a ridiculously high yield that, when I tracked it down, was due to a reverse split causing an apparent increase in the stock's price.

DTN_Stephen
-DTN Guru-
Posts: 453
Joined: Aug 22, 2014


Posted: Nov 25, 2019 06:47 AM          Msg. 2 of 5
We send the last 2 split dates and rates through our Fundamental data fields.

Stephen Shockey
Senior Customer Support Representative and Product Support Specialist

DTN
800-779-7299
stephen.shockey@dtn.com

jabowery
-Interested User-
Posts: 5
Joined: Sep 5, 2019


Posted: Nov 25, 2019 02:10 PM          Msg. 3 of 5
Is it then true, as seems to be the implication, that minute aggregated pricing cannot with certitude be relied upon for backtesting prior to the first of the 2 split dates provided in the Fundamental data fields?
Edited by jabowery on Nov 25, 2019 at 02:18 PM

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


Posted: Nov 26, 2019 01:49 PM          Msg. 4 of 5
Yes, that is a correct statement. If you like, I can put in a request to add more historical split dates to the data the API can return.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

jabowery
-Interested User-
Posts: 5
Joined: Sep 5, 2019


Posted: Nov 26, 2019 04:21 PM          Msg. 5 of 5
Let me explain the use case so you can properly prioritize this data feature (which is available in its entirety at https://www.splithistory.com/):

While backtesting an AlgoTerminal trading strategy, a market buy order is accompanied with a limit order. At the session close (end of day/EOD), the limit order is not reached and no bar update comes in at the end of day to permit the algorithm to sell the position at market. An overnight reverse X:1 split occurs but this is currently undetected by AlgoTerminal so it doesn't adjust the position (#shares/X and limit price*X). Upon resumption of trading the next day, the price is X*closing price > limit price. The limit condition met, AlgoTerminal sells #shares at price*X. Backtesting incorrectly reports a highly successful trading strategy.

If the backtesting stream included split multiples as well as prices, AlgoTerminal could do the adjustments necessary to produce valid backtesting reports.
Edited by jabowery on Nov 26, 2019 at 04:22 PM
 

 

Time: Sun May 26, 2024 2:59 AM CFBB v1.2.0 7 ms.
© AderSoftware 2002-2003