BackTesting ETF Rotation

To research my Truth About ETF Rotation book, I found I needed to write a portfolio simulator to backtest the strategies. This wasn’t my first choice – I tried to use commercially available backtesting tools, but they didn’t quite do everything I needed.

After writing the book, enough investors asked about various tweaks to an ETF rotation strategy that I decided to make my backtesting tools available. If you are interested in exploring different rotation strategies and portfolios, this is for you!

My portfolio rotation simulator allows you to specific a list of tickers – whether they are ETFs, mutual funds, or stocks is up to you.  It will buy equal amounts of the top N tickers, where you decide what number is N.  The top tickers are chosen by calculating the Rate of Change (RoC) over a period you specify.  The simulator sticks with its holdings until one drops into the bottom half of the rankings, at which time it is sold and replaced with the topmost ticker not already owned.

All along, the simulator keeps track of hypothetical account equity and it reports comprehensive statistics at the end of the run.

Control Panel of Portfolio Rotation Simulator

Control Panel of Portfolio Rotation Simulator

Key Limitations

This simulator requires Microsoft® Excel® 365, 2019, 2016, 2010, or 2007 running under Windows.  It has not been tested on anything else. Customers report that it does NOT run on Mac or Open Office — sorry!

Excel not included.  Historical price data not included. Source code not included.

Portfolio simulation performed by the product is a form of backtesting.  Backtesting is not reality, and significant differences may exist between this simulator and live trading.  For example, liquidity and slippage are not considered.  The simulator assumes all trades are executed at the next day’s end-of-day price.

Furthermore, past performance is no guarantee of future results.  You may test out a system that looks good here and find out that it results in big losses going forward.

This product is offered for educational purposes only.  It is not a recommendation to invest or trade.  You need to decide for yourself what is best for you.

More Information

Browse the full User’s Guide
Examine Sample Output

Order Now – $47

All BackTesting Report products are protected by an unconditional 100% money-back guarantee. If you’re not completely satisfied, just email to get a full refund within 30 days of the original purchase.

Official PayPal Seal

Order Anytime – 24/7 Worldwide
Download Product Immediately – Even If Its 3AM

Immediate Electronic Download

Once you purchase you will be directed to a web page for immediate download. No physical copy will be shipped to your address – saving time, expense and our planet’s resources. Be sure to add jackiep [at]** to your address book to receive your product in your InBox without delay.

** Replace [at]** with @ to form an email address like this The [at] notation protects us from web-crawling email-harvesting robots.

Questions / Problems?

Email support [at]** anytime
Call 1-650-752-4921 between 8am – 8pm Pacific Time