Build an Automated Trading System in Excel - Three Course Series
Price: $89.95 each
Overview
Financial-edu's three expert courses guide you step-by-step through building sophisticated trading models
using Microsoft Excel. Microsoft's Visual Basic (VBA) language is used in conjunction with Excel's user interface,
formulas, and calculation capabilities to deliver powerful and flexible trading tools.
Build an Automated Stock Trading System in Excel
This Online Course shows you how to build an automated stock trading model using Microsoft Excel.
The Model includes five proven technical indicators (ADX, moving average crossovers, stochastics, Bollinger bands, and DMI).
You are guided in a detailed fashion through creating worksheets, files, ranges, indicator formulas, control buttons, DDE/Active-X links, and code modules.
Learn MoreBuy Now
Build an Automated Sector Fund System in Excel
This Online Course walks you through building a long term sector fund rotation model using Microsoft Excel.
The System is based on the classic market economist's Sector Rotation Model.
It 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. The System can be used with any mutual fund, index fund, SPDR, ETF, future, or other index security.
Learn MoreBuy Now
Build an Automated Spread Trading System in Excel
This Online Course shows you how to build and use an automated spread trading model in Microsoft Excel. The System captures the price difference between security pairs of any type -- indexes, stocks, futures, options, LEAPs, etc.
Spread returns are typically non-correlated with other strategies, making the model an excellent addition to your trading program. The System uses three proven technical indicators--exponential moving averages, Percentage Price Oscillator (PPO),
and Donchian Channels.
Learn MoreBuy Now
What You Get With Each Course: A Tremendous 3-in-1 Value!
A complete Online Course PLUS VBA Code and FAQs sections
A complete PDF Guide showing you how to build and use the model (includes most course content for your choice of learning material)
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
Features & Benefits
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)
Technical Requirements
Microsoft Excel
Adobe Acrobat Reader
5 megabytes disk space (for stock data storage)
Intraday, daily, or weekly Open-High-Low-Close-Volume price data
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)
Frequently Asked Questions
What will I learn in this course? Is it something I can learn somewhere else?
Our courses teach you how to build the components, code, formulas, and data handling architecture for functioning trading models.
While it is possible to learn each part individually, no book shows you how to integrate all of these skills into a functioning trading model.
Our courses provide tremendous savings in time and money by alleviating the need to discover and implement the knowledge it takes to build institutional-level trading models in Excel.
The courses focus directly on building trading models without the unnecessary or over-generalized content found in most Excel and Visual Basic books.
Furthermore, the knowledge is transferable to any type of trading, investment, statistical, or economic models, providing long term value far beyond the courses themselves.
Do the models have graphs or visual indicators?
Yes, the models contain graphs to show historical performance and trade signals versus price. The automated trading models you build are calculation-based, rather than a
graphical charting tools. The greatest strength of the models are their ability to calculate trading signals on hundreds of stocks, funds, or spreads rapidly.
Can the models backtest using different scenarios and indicators?
Yes. In addition to the course materials, separate backtesting models are provided for download so you can test various stocks, funds, and spreads.
Do I have to build the models from scratch or do the courses come with finished models?
The purpose of these online courses is to teach the skills and techniques of building trading models in Excel. You are required to build the model as part of the course.
For convenience, each course includes a complete pre-built backtesting model incorporating the same indicators and logic. There is no substitute for building a model from the
ground up in terms of knowing how it works in actual trading conditions. This is especially important for investment professionals, who must know all the details and nuances
of their tools in order to meet risk and disclosure requirements.
Are the trading rules and logic provided?
Yes. Each course discusses trading logic and rules in significant depth. The models are not "black boxes". You are taught how the system logic works so its strengths and weaknesses are clearly evident.
Do the courses come with technical support?
Yes. Two methods of support are available: 1) An online Frequently Asked Questions section is included within each course, and 2) If the FAQs section does not answer your question, email
support is available at no charge.
