Step 1: Enter the stock ticker for the fund you would like to be invested in when it is above the moving average. Step 2: Enter the cash ticker for the fund you would like to be inveted in when the stock ticker is below the moving average. Step 3: Enter the dates for when you would like the backtest to start and to end. Step 4: Select the moving average filter length and type, when the stock ticker is below this moving average the backtester will invest in the cash filter, when the stock ticker is above this moving average the backtester will invest in the stock ticker input. Step 5: Select whether you would like to use 2 Moving Averages or not. If you use 2 moving averages then the logic will wait for the moving averages to cross. If you use 1 moving average (default) the logic will wait for the price of the 'stock' fund to cross the moving average only. Step 6: Select how often you would like to check if the stock ticker is above or below the moving average (Frequency of Updates).

Results show the equity curve and statistics for the Moving Average Filter applied to the stock ticker compared against the S&P 500 Index.

Data Source for Backtesting

Select Stock Exchange To Lookup Symbols

Select exchange here, then enter tickers normally. Ex. VCN should be entered for Vangaurd FTSE Canada All Cap fund.

This data is provided partially by St. Louis Fed Web Services [FRED], read their terms of service before using: https://research.stlouisfed.org/docs/api/terms_of_use.html This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Click Button to Load Fund into 'Stock' Ticker:

Enter the stock ticker you would like to use:

Stock Ticker

Minimum % of Stock Fund to Hold:

Note: cash filter is applied to funds total value including dividend/split adjustments.

Click Button to Load Fund into 'Cash Ticker' Entry:

Enter the cash ticker you would like to use:

Cash Ticker

Use Ratio of Funds for Signal

The ratio of two funds indicates their relative performance. When ratio rises the stock fund is doing well, when the ratio falls the stock fund is doing poorly compared to the cash fund.

Start Backtest

End Backtest

Frequency of Updates

Number of Weeks for Update

Number of Days for Update

How often the backtester checks the moving average condition.

Filter Method

MACD Calculation - Moving Average Convergence Divergence

MACD Fast Moving Average:

MACD Slow Moving Average:

MACD Signal Line:

Main Moving Average Filter Length

Use Second Moving Average (Short MA)

If a second Moving Average (the short moving average) is used the logic will wait for the 2 moving averages to cross.

Short Moving Average Length

Limit Drawdown using cash filter fund

Selecting this input will limit drawdown to the input percent by investing in the cash filter fund if the strategy equity ever goes below the set drawdown limit. Keep in mind this condition is only checked at each period end, so drawdown may be larger than this limit.

Drawdown Limit %

Below is the next periods update as of the end simulation date:

Note: Please save all settings before exiting or reloading this page. You may use the download settings button at the bottom of the page, settings are also recorded in the downloadable report.

If you would like to save your settings copy the below URL, and bookmark it. When you would like to resume, visit this bookmark and settings will be filled in automatically.

Show Log Plot

Monte Carlo Simulation

Runs a Monte Carlo Simulation based on backtest results. Backtest Results give a value for expected return % (CAGR), and volatility %. Using these two numbers the Monte Carlo calculates future expected returns. Since the values used to calculate are based on backtest results the model is only accurate if the backtest is an accurate representation of the future.

Select Monte Carlo Style: Savings or Withdraw

These values are used in the simulation to determine expected future performance, thus the Monte Carlo is only as accurate as these numbers are accurate.

Annual Inflation (%):

Annual Inflation Volatility (%):

Duration of Monte Carlo Simulation (yrs)

Investment Advisor Annual Fees (%)

Monthly Deposits into Account ($):

Current Account Size ($):

Time in Trade vs. Return %

Performance Summary

% Per Symbol

Annual Performance For Market Filter

All Trades - Market Filter

Downloads

The spreadsheet below is a list of all trades taken by the Market Moving Average Strategy, it can be edited in Excel Download Trades in Spreadsheet

The spreadsheet below can be downloaded and imported into the Combined Portfolio App or Portfolio Rotation or Portfolio Moving Average Tools or edited in Excel Download Daily Equity Report in Spreadsheet

All settings and symbols can be downloaded below for later reference. Download Settings

A HTML Report can be downloaded below with settings and equity curve information, please save file to drive before opening. This file may be shared with others or saved to your computer for future reference. Download HTML Report

Notice: Your use of this site (RotationInvest.com or RotationInvest) is considered equivalent to your signature as evidence of your acceptance of RotationInvest.com's Terms of Use, and Privacy Policy. RotationInvest.com is not a registered investment advisor and does not provide professional financial or investment advice. RotationInvest.com is a tool that produces trade signals and backtesting results according to the set of funds and rules provided for analysis. Any strategies shown including but not limited to the prebuilt strategies are only used to highlight what is possible using these tools. Results from any of RotationInvest.com or PortfolioBuilderInvest.com tool or website may not be accurate, and cannot be guaranteed to be accurate or correct. Please contact us if you are unsure about where to read or Terms and Conditions and Privacy Policy.