Building an Automated Stock Trading System in MS Excel

This online course 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 system operates with your choice of FREE ASCII .TXT files available on the internet, or a subscription data service. The learning materials include a step-by-step Online Course, a PDF Guide, and a separate pre-built Backtesting Model for historical analysis and testing.