Description From Publisher
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 SYSTEM CAN OUTPERFORM DIVERSIFIED BUY AND HOLD MUTUAL FUND INVESTING BY A FACTOR OF 2-4 TIMES. 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. A PDF Guide is provided so you can choose how to learn in the most comfortable way. 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!
- PDF Guide showing you how to build and use the model
- Online course
- 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
- Adobe Acrobat Reader
- 5Mb disk space
- Weekly Close Fund price data
- (OPTIONAL) DDE data import link for Excel
Supported OS
Win 3.1x,Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Win
Related Keywords
fund sector trading system building automated excel spreadsheet vba macro dde active-x quote.com weekly rotation relative streng fund sector trading system building automated excel spreadsheet vba macro dde active-x quote.com weekly rotation relative streng
|
|
Latest Investment Tools Realted Tools:
Internet Quotes Assistant 4.22
Internet Quotes Assistant automatically keeps track of your portfolio, getting actual and historical financial quotes from any server in the Internet for free (supported exchanges Frankfurt, London, New York, Paris, Bovespa, etc.) |
World Stock Charts 2.0.6
World Stock Charts is a complete solution for Charting and Tracking Stocks, Funds and Indices with over 50 Forms of Technical Analysis built into it. |
ESQuotes - Real time stock quotes 2.1
Powerful Excel workbook for stocks & mutual funds. Quotes directly from Internet with no downloads or conversions. Manage stocks & mutual funds your way. Stealth quote interface uses simple & familiar =functions(). Works with all proxy servers. |
EZ-Files Technical Indicator Library v1
The EZ-Files Library contains 26 technical indicators pre-built in Excel Spreadsheet Format. These Excel files are tremendously useful for constructing securities trading, technical analysis, or statistical models in Excel. |
Option Profit Calculator 1.0.0
Compare stock or option transactions. Input transaction data. Calculates profit from transactions, potential loss, annualized profit (in dollars and as percentage), and annualized potential loss. Factors in commission fees. Stores results. |
MetaTrader 4.00
The trading terminal for Forex, Futures & CFD. At your service: an advanced charting, a flexible control system of trading activity, an extensive set of technical indicators, own programming language and an opportunity of automatic trading. |
MetaTrader CE 1.52
The trading terminal for Forex, Futures & CFD on PDA. At your service: an advanced charting, a flexible control system of trading activity, a set of major technical indicators and an access to over 30 brokerage companies. |
MetaTrader 4 Mobile 4.00
Online terminal for mobile trading at Forex, Futures & CFD using PDAs. At your service are: advanced charting, great flexibility in trading activities, a set of 30 technical indicators, and free access to many brokerage companies. |
Market System Analyzer 2.0
Market Trading Software. Apply advanced money management strategies to increase trading returns and limit risk. Position sizing methods, dependency rules, equity crossover trading, significance testing, and more. |
investX 1.4
Personal investment software package that incorporates all of the tools an end-of-day trader requires to make informed trading decisions. investX includes portfolio management, technical analysis and market-filtering tools. |
iFlash Market Alert Software 1.10.1007
Thanks to InvestorFlash.com, you can now be kept up to the minute with the new iFlash alert software. FREE Stock Market Forecasts, Technical Analysis delivered instantly. Daily reports and access to 100s of archived articles. Download NOW! |
Fund Manager - Professional 8.7
Fund Manager is a full featured portfolio management application. Fund Manager is designed to help investors monitor and analyze their stocks, mutual funds, and other investments with a wide variety of easy to use graphs and reports. |
EZQuote 1.06.000
EZQuote allows you to download historical end-of-day quotes for virtually any stock, index, ETF or mutual fund publicly traded in USA and other world markets. The data can be stored in Metastock or ASCII format. |
|
