Program Description

This online course shows you how to build a sophisticated automated stock trading model using MS 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 step-by-step through creating worksheets, files, ranges, indicator formulas, control buttons, DDE/Active-X links, and code modules. Build the model, import the price data, run the model by clicking a button, and make your trading decisions. Uses both trend-trading and swing-trading features. Operates with your choice of FREE ASCII .TXT files available on the internet, or a subscription data service. Can be used alone or in conjunction with your existing fundamental and market analysis to improve investment timing and avoid unprofitable situations. 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! - An Online Course showing you how to build and operate the model PLUS VBA Code and FAQs sections - Detailed instructions on importing prices into Excel using eSignal QLink and Yahoo!Finance - A pre-built Backtesting Model in MS Excel with graphs and trade statistics - 60 days of online access to download the materials and take the course Benefits - Learn to integrate Excel, VBA, formulas, and data sources into a trading tool - Acquire unique knowledge for any Excel modeling project - Save money by eliminating recurring software costs - Calculate trading signals on hundreds of stocks within seconds Technical Requirements - MS Excel for Windows - 5Mb disk space - Daily Open-High-Low-Close stock data - OPTIONAL: DDE price import link for Excel