|
Introduction
Basic Technical Requirements
Using the Model
Economic Cycles and Sector Fund Investing
Sector Rotation Timing Diagram
How to Profit From Sector Rotation Investing
-Period 1: Market Bottom
-Period 2: Market Recovery / New Bull Market
-Period 3: Market Top
-Period 4: Bear Market / Recession
Why the Classic Sector Rotation Model is Insufficient
How the Excel Sector Fund System is Superior: 4 Technical Tools
-Tool 1: 48-Week Relative Strength %
-Tool 2: Moving Average Crossovers
-Tool 3: Moving Average % Change
-Tool 4: Top 3 Funds
Building the Model
-Directory and File Structure
-Spreadsheet Structure
-\Calculations/ Sheet
-Visual Basic Macro Code. SeeExcel Training Index if not familiar with macros
-\Signals/ Sheet
-\Data/ Sheet
Obtaining Historical Weekly Fund Price Data
Running the Model on a Weekly Basis
- When to Run the Model
- Combining the Signals with Other Market Information
- Money and Risk Management
Common Macro Errors
FAQs
Backtesting the model
Building an Automated Sector Fund System in MS Excel $89.95 Secure Payment Options 30 Day Money Back Guarantee!
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALLpurchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
More Learn To Build |
Build an Automated Stock Trading System |
Build an Automated Sector Fund System |
Technical Indicators Library |
Build an Automated Spread Trading System |
See Also:Excel Add-ins Index & Excel Training Index & Excel Templates Index & Neural Network Software IndexTrading Software Index & Charting Software Index Or,All Software
Instant Download and Money Back Guarantee on Most Software
Excel Trader PackageTechnical Analysis in Excel With $139.00 of FREE software!
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft