Learn to Build an Automated Trading System in Excel for Stocks, Forex and ETFs

This course walks you step-by-step through building an end of day trading system in Excel that creates buy/sell signals for up to 100 stocks, ETFs or Forex pairs. Excel?s VBA language is used in conjunction with spreadsheets, links and formulas to deliver a powerful and flexible trading tool. The model includes 5 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. The model incorporates both trend-trading and swing-trading features. The swing-trading feature can be turned on or off, depending on your trading style. The system can be used to generate trading signals for up to 100 stocks, ETFs or Forex pairs at a time. It works with just about any watch list you can create -- just provide the model with price data and it runs great. After building the model, you simply import your end of day price data, run the model with the click of a button, and make your trading decisions. ? 2018 ExcelTradingModels and Alpha Squared Management The course shows you how to use free price data from the Internet, and how to import prices into Excel using a DDE/Active-X link. A pre-built back testing model is included that allows you to test the system versus buy-and-hold over 5 years of price history. The back test model displays detailed performance and risk statistics to help you select a watch list with a greater probability of generating large profits. Benefits to You: ? Learn how to integrate Excel, VBA, formulas and data sources into a profitable trading system ? Calculate buy/sell signals on a watch list of up to 100 stocks, ETFs or Forex pairs in seconds ? Save significant money by eliminating recurring data and software costs ? Get instant access to the course materials in a zip file emailed directly to you ? Apply the knowledge you gain to any Excel modeling or analysis project