Learn to Build an Automated Sector Fund Investing System in Excel

Everything you need to build a investing system in Excel for your 401(k) or IRA

Build an Automated Sector Fund Investing System in Excel Course

What You Get

How To Course

How To Course

Step-by-step course covers strategy, data, formulas, VBA and FAQs.

Price Data Import

Price Data Import

Detailed instructions on importing price data into Excel.

Back Test Model

Back Test Model

Includes a complete back testing model with detailed stats.

Watch List

Your Watch List

Build a profitable investing tool for your watch list of funds or ETFs.

Detailed Overview

This course walks you step-by-step through building an automated long term sector fund rotation investing model using Excel. Excel’s VBA language is used in conjunction with spreadsheets, links and formulas to deliver a powerful and flexible investing tool.

This is an ideal system to grow your 401(k) or IRA by investing in sector funds using an effective economic rotation strategy.

The model is based on the classic market economist’s Sector Rotation Model which identifies the most likely sectors to profit during any given economic market cycle phase. Crucial improvements have been added that eliminate the guesswork in timing sector fund changes. Over long periods the strategy can significantly outperform diversified buy and hold investing by focusing capital on economic sectors most likely to outperform the overall market.

You are shown how to identify the funds or ETFs most likely to generate profits using three proven indicators: relative strength, moving average crossovers and moving average slope. The system allocates capital to market sectors most likely to generate superior returns, with confirmation from actual price movements. It can be used with any mutual fund, sector fund, index fund, ETF or ETN.

The course teaches you how to import free weekly price data from the Internet. It also shows you how to import prices into Excel using a DDE link from your broker or data provider if you have one available.

A pre-built back testing model is included that lets you test up to 10 different funds or ETFs versus buy and hold over 10 years of price history. The back testing model calculates and displays detailed performance and risk statistics to help you construct a profitable portfolio.

Screenshots

Watch List & Signals Sheet

Watch List & Signals

Back Testing Model

Back test model

Calculations Sheet

Calculations sheet

Strategy Guide

Strategy guide

Benefits

Calculate buy/sell signals on a large number of funds or ETFs in seconds

Integrate Excel, VBA, formulas and data sources into a profitable investing system

Apply the knowledge you learn to any Excel modeling or research project

Save significant money by eliminating recurring software and data costs

Get instant access to the materials in a zip file emailed directly to you

**CFTC RULE 4.41 – HYPOTHETICAL OR SIMULATED PERFORMANCE RESULTS HAVE CERTAIN LIMITATIONS. UNLIKE AN ACTUAL PERFORMANCE RECORD, SIMULATED RESULTS DO NOT REPRESENT ACTUAL TRADING. ALSO, SINCE THE TRADES HAVE NOT BEEN EXECUTED, THE RESULTS MAY HAVE UNDER-OR-OVER COMPENSATED FOR THE IMPACT, IF ANY, OF CERTAIN MARKET FACTORS, SUCH AS LACK OF LIQUIDITY. SIMULATED TRADING PROGRAMS IN GENERAL ARE ALSO SUBJECT TO THE FACT THAT THEY ARE DESIGNED WITH THE BENEFIT OF HINDSIGHT. NO REPRESENTATION IS BEING MADE THAT ANY ACCOUNT WILL OR IS LIKELY TO ACHIEVE PROFIT OR LOSSES SIMILAR TO THOSE SHOWN.

GET YOUR 5 FREE TECHNICAL INDICATORS

Enter your email address and we will send them instantly!

Success! Your indicators are on their way!

Free 10 Steps to Create a Trading System in Excel

FREE GETTING STARTED GUIDE

Enter your email address and we will send it to you instantly!

Success! Your guide is on its way!

FREE Spread Trading Contract Calculator in Excel

GET YOUR FREE SPREAD TRADING CALCULATOR

Enter your email address and we will send it to you instantly!

Success! Your calculators are on their way!

FREE Yahoo Finance Stock Split Adjuster

GET YOUR FREE YAHOO FINANCE STOCK SPLIT ADJUSTER FOR EXCEL

Enter your email address and we will send it to you instantly!

Success! Your stock split adjuster is on its way!

Free Trading Model

GET YOUR FREE
EXCEL TRADING MODEL

Enter your email address and we will send it instantly!

Success! Your free trading model is on it's way!