This Guide shows you step-by-step how to build a
sophisticated automated stock trading 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
trading tool. 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. After
building the model, you simply import the data you need, run
the model automatically with a click of a button, and make your
trading decisions. The model incorporates both trend-trading
and swing-trading features. The swing-trading feature can be
turned on or off, depending upon your investing style. The
system operates with your choice of FREE ASCII .TXT files
available on the internet, or a subscription data service (with
our without a DDE link). The model can be used alone or in
conjunction with your existing fundamental and market analysis
to improve investment timing and avoid unprofitable situations.
A complete PDF Guide is provided along with a step-by-step
Online Course so you can choose how to learn in the most
comfortable way. A separate pre-built Backtesting Model is also
included for historical analysis and testing various stocks and
time periods.
What You Get: A TREMENDOUS 3-IN-1 VALUE!
- A complete PDF Guide showing you how to build and use the
model
- A complete Online Course including everything in the PDF
Guide PLUS VBA Code and FAQs sections
- A complete pre-built Backtesting Model in MS Excel with
graphs and trade statistics for your historical analysis
- 30 days of online access to download the materials and learn
how to build and use your new Stock Trading Model
5 Year Backtesting Results
The following charts show historical backtesting results from
February 23, 1998 to April 1, 2004 on 10 different U.S. mid-cap
and large-cap stocks. Simply click on an image to view the
complete results.
International Business Machines (IBM)
Microsoft (MSFT)
Lehman Brothers (LEH)
Starbucks (SBUX)
Southwest Airlines (LUV)
Reebok (RBK)
Diamond Offshore (DO)
Oracle (ORCL)
Wind River Systems (WIND)
Amgen (AMGN)
Frequently Asked
Questions
What will I learn in this course? Is it something I can
learn somewhere else?
This course teaches you how to build the components, code,
formulas, and data handling architecture for a functioning
stock trading model. 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. The Course provides
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 Course focuses
directly on building trading models without the unnecessary or
over-generalized content found in most Excel and Visual Basic
books. The knowledge is transferable to any type of trading,
investment, statistical, or economic models.
Does the model have graphs or visual indicators?
Yes, the models contain graphs to show historical performance
and trade signals versus price. The automated trading model you
build is calculation-based, rather than a graphical charting
tool. The greatest strength of the model is its ability to
calculate trading signals on hundreds of stocks rapidly.
Can the model backtest using different scenarios and
indicators?
Yes. In addition to the course materials, a separate
backtesting model is provided for download so you can test
various stocks.
Do I have to build the model from scratch or does the
course come with a finished model?
The purpose of the Stock System course 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, the 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. The course discusses the trading logic in significant
depth. The model is not a "black box". You are taught how the
system logic works so its strengths and weaknesses are clearly
evident.
Does the course come with technical support?
Yes. Two methods of support are available: 1) An online
Frequently Asked Questions section is included within the
course, and 2) If the FAQs section does not answer your
question, email support is available at no charge. The FAQs
section is updated on a regular basis to ensure it addresses
all issues related to building and operating the model.
Benefits
- Instantaneous access to the PDF Guide, Online Course, and
Backtesting Model with your own login and password provided at
time of purchase
- 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 hundreds of stocks within
seconds
Technical Requirements
- Microsoft Excel for Windows
- Adobe Acrobat Reader
- 5 megabytes disk space
- Daily Open-High-Low-Close-Volume stock price data
- (OPTIONAL) DDE data import link for Excel
Order
Goto Developer Web Site for more information
| Additional Information: Building an Automated Stock Trading System in MS Excel | |
| Requires Excel for Windows |
Buy Online $75.00 |