 |
|
|
|
|
|
This Guide walks you step-by-step through 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 System 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-4 TIMES.
Description
The automated model 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. 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.
A complete Online Course PLUS VBA Code and FAQs sections
Detailed instructions on importing price data into Excel using eSignal QLink and Yahoo!Finance
A complete pre-built Backtesting Model in MS Excel with graphs and trade statistics for your historical analysis
60 days of online access to access the course materials and learn how to build and use your new Trading Model
Instantaneous access to the course materials with your own login and password provided at time of purchase (if purchasing through CCBill, otherwise course password is emailed to you)
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 trading signals on a large number of stocks, funds, or spreads within seconds (limited only by Excel's data capacity)
Microsoft Excel
5 megabytes disk space (for data storage)
Weekly close fund price data (available free from Yahoo!Finance)
Internet access (high speed DSL or cable modem suggested, but not necessary)
OPTIONAL: DDE data import link for Excel through your data provider (advised for more than 5-10 securities, otherwise free price data from Yahoo!Finance or other source works fine)
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. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 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 Index Trading Software Index & Charting Software Index Or, All Software
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical 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