Home > Excel Business Solutions > Excel Productivity > Training and Tutorials > Fund Management System Share

Fund Management System

Excel fund management system for training and tutorials


Excel Fund Management System

Rate this solution:
(3.5/5 from 2 votes)
Fund Management System screenshot
The Fund Management System for Excel is a step-by-step course for building a long term sector fund rotation model using Microsoft Excel. Microsoft's Visual Basic (VBA) language is used in conjunction with Excel's user interface, formulas, and calculation capabilities to deliver a powerful and flexible investment tool.

The Fund Management System for Excel is based on the classic market economist's Sector Rotation Model, providing several crucial improvements that eliminate the guesswork in timing fund switches. Over long periods, the system can outperform diversified buy and hold mutual fund investing by a factor of 2 to 4 times.

The automated Fund Management System for Excel incorporates three proven technical indicators - long term relative strength, moving average crossovers, and moving average slope, to identify the sector funds most likely to provide long term profits. The system can be used with any mutual fund, index fund, SPDR, ETF, future, or other index security to allocate capital to the most profitable sectors of the market.

It operates with weekly CSV data files available for free over the Internet from Yahoo Finance, or an automated DDE data link if desired. Simply run the system on a weekly basis and make your investment decisions.

A complete PDF Guide is provided along with a step-by-step Online Course so you can choose how to learn in the most comfortable way. Also included is a pre-built Excel back test model that allows you to test up to 10 different funds versus buy and hold over a 10 year period.

Key Features on the Fund Management System for Excel include:
  • A complete PDF Guide showing you how to build and use the model.
  • A complete Online Course including everything in the PDF Guide PLUS VBA Code and FAQs sections.
  • A complete pre-built Back testing Model in MS Excel with graphs and trade statistics for your historical analysis.
  • 30 days of online access to download the materials and learn how to build and use your new Sector Fund Model.
  • Instantaneous access to the PDF Guide, Online Course, and Back testing Model with your own login and password provided at time of purchase.
  • Learn to integrate Excel, VBA, formulas, and data sources into a profitable trading tool.
  • Acquire unique knowledge applicable to any Excel modeling or analysis project.
  • Save money by eliminating recurring software costs.
  • Calculate Buy/Sell signals on hundreds of funds within seconds.

Fund Management System for Excel Table of Contents:
  • Introduction
  • Basic Technical Requirements
  • Using the Model
  • Economic Cycles and Sector Fund Investing
  • Sector Rotation Timing Diagram
  • How to Profit from Sector Fund 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
  • 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
  • Back testing the model

Get It

Price: USD 89.95
(Updated on 2014-09-08)

Related Excel Solutions for Fund Management System

Portfolio Performance MonitoringPortfolio Management  Portfolio OptimizationPortfolio Management  Stock Trading SystemTraining and Tutorials  Spread Trading SystemTraining and Tutorials  Building A Cash Flow ModelTraining and Tutorials

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum or proposed as a project to the Excel freelance community.