Personal Finance & Money Asked by Eugene S on April 4, 2021
In an attempt run few backtesting tasks, I have obtained some historical data. I noticed that there are two closing prices available, regular close and adjusted close.
After doing some reading, I have learned that the adjusted close value is being affected by the following parameters and in fact NOT the real close value on that day.
I’m still confused which one of the close values should I use though, the real one or the adjusted?
It seems that the adjusted close gives more accurate data about the stock but it is not the real price.
You would have to compare your backtesting to what you will be doing in real trading, and try to have the backtesting as close to your real trading as possible. Note: you may never get the backtesting to match your real trading exactly but you need to get as close as possible.
The whole purpose of backtesting is to check if your trading strategies - your signals, entries and exits, and your stops - are profitable over various market conditions. As you would be using actual closes to do your real trading you should be using this to also do your backtesting.
Rather than using adjusted data to get an idea of your total return from your backtesting, you can always add the value of the dividends and other corporate actions to the results from using the actual data. You may even find a way to add any dividends and other corporate action to your results automatically, i.e. any dividend amount added to your total return if the stock is held during the ex-dividend date.
If you are using adjusted data in your backtesting this may affect any stops you have placed, i.e. it may cause your stop to be triggered earlier or later than in real trading. So you will need to determine how you will treat your stops in real trading.
Will you adjust them when there is corporate action such as dividends?
Or will you leave them constant until actual prices have gone up?
If you will be leaving your stops constant then you should definitely be using actual data in your backtesting to better match your real trading.
Correct answer by Victor on April 4, 2021
A one year period of study -
Stock A trades at $100, and doesn't increase in value, but has $10 in dividends over the period.
Stock B starts at $100, no dividend, and ends at $105.
However you account for this, it would be incorrect to ignore stock A's 10% return over the period.
To flip to a real example, MoneyChimp shows the S&P return from Jan 1980 to Dec 2012 as +3264% yet, the index only rose from 107.94 to 1426.19 or +1221%.
The error expands with greater time and larger dividends involved, a good analysis won't ignore any dividends or splits.
Answered by JTP - Apologise to Monica on April 4, 2021
If you want to monitor how well you did in choosing your investments you will want to use stock prices that account for the dividends and splits and other changes (not just the closing price).
The adjusted close will include these changes where the straight close will not include them. Using the adjusted close you will get your true percentage change.
For example I have a stock called PETS that paid an $0.18 dividend in July 2015. The adjusted closes before that day in July are all $0.18 lower per share.
Say the closing price had been unchanged at $20.00. The close prices would say I made no profit, but the adjusted closing price would say I made $0.18 per share on this investment because the adjusted close would read $19.82 in June 2015 but would read $20.00 in August 2015 (just like the closing price).
The adjusted close allows me to know my true profit per share.
Answered by user32630 on April 4, 2021
Instead of a "it depends" answer, I tend to side with @user32630 and @Bob Baerker that we SHOULD indeed use adjusted OHLC (and also adjusted volume) for backtesting - specifically, price adjusted by both splits and dividends. Otherwise, you will find a lot of artificial jumps in your historical data (check out this post that shows a sudden 50% drop due to a 2-to-1 split). Jumps due to dividend payout may be less dramatic, but still artificial by nature. Those bungee jumps will likely generate false triggers for trade order entry/exit.
TL;DR: try to use adjusted OHLCV values to get the real underlying stock prices and volumes. Just my two cents based on years of growing my own 401(k) portfolio.
Answered by minerCode on April 4, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP