You cannot use more than 10 funds at a time in the backtest model. The backtest model only has sufficient room in columns B through K of the Calculations sheet for 10 funds. You CAN backtest fewer than 10 funds. You will need to make sure the weekly closing price data...
There are 3 possible solutions: 1) Make sure you have closing prices for each fund filled in all the way down to row 576 in the backtesting model Calculations worksheet columns B thru K. 2) Check for any NULL, blanks, or zeros (0) in the price data. Scroll down...
Use the Adjusted Price instead of Close price with Yahoo Finance data. Adjusted Price includes splits and dividends in the historical prices so you don’t get jumps in the data.
Yes, you can modify the moving average lengths or any other parameter. Just modify the formulas in the Calculations worksheet and make sure the backtest worksheet parameters are set exactly the same. Of course, the model is likely to behave differently. Backtesting...
You may end up with several funds at the top of the relative strength list and no BUY signals at all. This is a signal to put your money in the safest spot you can (cash). With no BUY signals and no upside opportunity, it’s time to sit and wait for the next...
