FORUMS BROKERS SOFTWARE
Home
 
    Forums > Technically Speaking > Strategy (System) Design > Stock splits vs backtesting


Reply
 
Thread Tools
Old Jun 4th, 2012, 12:07 PM   #19
Rationalize
Registered User
 
Join Date: Jan 2010
Posts: 841
In some markets, stocks under a buck make up significant index weight.
    Quote
Old Jun 8th, 2012, 01:46 PM   #20
Gyles
 
 
Join Date: Aug 2007
Posts: 407
Regarding the stock splits handling, please have a look at the following post:
Real World Equity Trading

Please let us have your opinion.
    Quote
Old Jul 10th, 2012, 11:53 AM   #21
jupiter12
 
 
Join Date: May 2012
Posts: 9
Quote:
Quote from braincell:

I'm sure some of you have encountered this problem when testing daily bars.

For example MSFT goes down to a value of around 0.01 per share by 1986 if you account all of the splits. Then the backtester gets confused since it's max tick value is 0.01, so it can only place orders at 0.00 or 0.02 for example. In reality, the price was around $20, and there would be no problems placing orders at 0.01 intervals (or 1/8ths) in reality. This means that the backtester can (in the case of MSFT in 1986) only place orders at +/- 100% of the stock price. That won't work.

The only realistic option I see is having the backtester detect stock splits via a separate database and know how to respond to it.

If we keep increasing future values (and not past like now) from the splits (ie MSFT would be around $8000 per share now), we get a different problem as the spread and everything else would have to be artificially inflated or something. It's not workable.

Questions:

What are your experiences when working with daily data that goes that far back?
Does anyone maybe convert the stock price to real dollar purchasing power or commodity index to smooth it out? What tricks could I use, short of forcing the backtester to detect the splits and react as it would in reality (which may be a lot of work)?

Note: I have coded my own backtester.
Why don't you use data adjusted for dividends and splits?
    Quote
 
Reply
Thread Tools

Forum Jump



   Conduct Rules   Privacy Policy   Sitemap Copyright © 2014, Elite Trader. All rights reserved.   

WHILE YOU'RE HERE, TAKE A MINUTE TO VISIT SOME OF OUR SPONSORS:
Advantage Futures
Futures Trading & Clearing
AMP Global Clearing
Futures and FX Trading
Collective2
Automated Trading Services
CTS
Futures Trading Software
dom993trading.com
NinjaTrader Consulting
eSignal
Trading Software Provider
FXCM
Forex Trading Services
Global Futures
Futures, Options & FX Trading
Interactive Brokers
Pro Gateway to World Markets
JC Trading Group
Direct Access Trading
MB Trading
Direct Access Trading
NinjaTrader
Trading Software Provider
optionshouse
Option Trading & Education
Rithmic
Futures Trade Execution Platform
SpeedTrader
Direct Access Trading
SpreadProfessor
Spread Trading Instruction
thenut-trader.com
FX, Gold, & Stock Signals
TradersStudio
System Building & Backtesting
Tradier
Equity and Options Trading
Trading Technologies
Trading Software Provider