Home > Forum Home > Excel Portfolio Optimization Template > New Portfolio Optimization Template Version > Rolling Backtest Question Share

Rolling Backtest Question

Excel Help for Rolling Backtest Question in Excel Portfolio Optimization Template


Forum TopicLogin

Rolling Backtest Question

Rate this:
(3.2/5 from 4 votes)
Confused In the rolling backtest, is there any overlap between an optimization interval and the subsequent interval during which the optimized weights are used to calculate performance?  I'm a bit concerned, because total returns are just TOO good for re-optimization done every data interval.  It almost seems that the optimization process uses the next period's data.  I can furnish an example showing almost 60% annualized return over the past 7 years using an ETF portfolio containing only SPY, EFA, IEF, TLT, DBC and VNQ with weekly optimization.  I know trading costs are not included, but is the ideal result too good to be true?
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Rolling Backtest Question in the