Search This Blog

Tuesday, December 20, 2011

Build an Automated Sector Fund System in Excel

Build an Automated Sector Fund System in Excel
Software::Business & Finance
price:$89.95
This online course 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. 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. What You Get: A TREMENDOUS 3-IN-1 VALUE!
- A complete course with detailed instructions on building your automated sector fund model PLUS VBA Code and FAQs sections
- A complete pre-built Backtesting Model in MS Excel with graphs and trade statistics for your historical analysis
- Instant access to download the materials and learn how to build and use your new Sector Fund Model

1 comment:

  1. Large list using MS Excel, you can easily create and maintain. It is used to store contacts, to do statistical analysis, perform financial calculations and more. Excel is widely used to store any contact throughout.

    Excel courses sydney

    ReplyDelete