Building an Automated Stock Trading System in Excel

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 complete PDF Guide is provided 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 PDF Guide showing you how to build and use the model - An Online Course including everything in the PDF Guide PLUS VBA Code and FAQs sections - 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 - Adobe Acrobat Reader - 5Mb disk space - Daily Open-High-Low-Close stock data - OPTIONAL: DDE price import link for Excel