This online course shows you how to build a long term sector fund rotation model using MS Excel. Microsoft's Visual Basic (VBA) language is used with Excel's user interface, formulas, and calculation capabilities to deliver a powerful and flexible investment tool. Uses the classic market economist's Sector Rotation Model, with several improvements that eliminate the guesswork in timing fund switches. The model incorporates three proven technical indicators--relative strength, moving average crossovers, and moving average slope, to identify the sector funds most likely to provide long term profits. Can be used with any mutual fund, index fund, SPDR, ETF, future, or other index security to allocate capital to the most profitable sectors. Uses weekly .csv data files available for FREE from Yahoo! Finance, or an automated DDE data link if desired. Simply run the system on a weekly basis and make your investment decisions. Also included is a pre-built Excel backtest model that allows you to test up to 10 different funds versus buy and hold over a 10 year period.



What You Get: A TREMENDOUS 4-IN-1 VALUE!

- Online course showing you how to build and operate the model
- Detailed instructions on importing prices into Excel from eSignal QLink and Yahoo!Finance

- Pre-built Backtesting Model in MS Excel with graphs and trade statistics

- Direct online access to the course materials



Benefits

- Integrate Excel, VBA, formulas, and data sources into a profitable trading tool

- Get knowledge applicable to any Excel modeling project

- Eliminate recurring software costs

- Calculate Buy/Sell signals on hundreds of funds within seconds



Technical Requirements

- MS Excel for Windows

- 1Mb disk space

- Weekly Close Fund price data

- (OPTIONAL) DDE data import link for Excel

• Build an Automated Sector Fund System v1
  This online course shows you how to build a long term sector fund rotation model using MS Excel. Microsoft's Visual Basic (VBA) language is used with Excel's user interface,...

• TraderXL Pro Package 6.1.15
  Technical Analysis in Microsoft Excel

• Analyzer XL Pack 2011.1105
  Technical Analysis in Microsoft Excel. 146 indicators and experts. Free download real and historical stock quotes from USA, Europe, and Canada into Excel spreadsheets. Mutual funds, corporate bonds, Major USA Market Indices, Major World Indices are...

• Offshore Private Plan 2.3
  About OffshorePrivatePlan OffshorePrivatePlan

• Excel Funding and Equity Plan 3.3
  Funding Plan PRO for Excel provides the perfect financial planner for any 10 year projection. No accounting knowledge is required. You can use Funding Plan PRO to create financial models of your company. Variables can be adjusted anyway you want and as you know Excel will translate any input change instantly into the appropriate outcome....

• Excel Funding Plan 3.3
  Funding Plan PRO for Excel provides the perfect financial planner for any 10 year projection

• Stock Quotes Express 2.
  Stock Quotes Express is a shareware program which allows you freely download intraday, daily, weekly and monthly historical stock quotes, mutual funds, options, indices and commodity futures. Free historical prices are provided by Yahoo Finance,...