Build an Automated Sector Fund System

Tags: adobe acrobat reader visual basic vba vba language mutual fund index ms excel yahoo finance spdr etf rotation model csv data files pdf guide dde excel vba moving average sector rotation market economist modeling project flexible investment 5mb disk space sector fund


Build an Automated Sector Fund System

Financial-edu.com / Venus United Capital

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

Software Price: $79.95
Software Version: v1
Release Date
: 12/1/2004

Size: 0.19 MB
Platform: Win 3.1x, Windows 95/98/ME, WinNT 3.x, NT 4.x, Windows 2000, XP, Windows 2003

Download Link: Build an Automated Sector Fund System Download

Keywords: macro automated spreadsheet average rotation strength etf index sector quote.com vba system mutual 401(k) future 401k 403b moving relative weekly fund building dde trading capital slope spdr ira crossover futures active-x excel 403(b)

 

  Search by keyword:      

Copyright © 2003-2012 TverSoft.com