Build an Automated Stock Trading System in 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. 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. 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 (from Yahoo!Finance or other provider), or your 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 With Each Course: A Tremendous 3-in-1 Value! -A complete Online Course PLUS VBA Code and FAQs sections -A complete PDF Guide showing you how to build and use the model (includes most course content for your choice of learning material) -A complete pre-built Backtesting Model in MS Excel with graphs and trade statistics for your historical analysis -60 days of online access to access the course materials and learn how to build and use your new Trading Model Features & Benefits -Access to the course materials with your own login and password -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 a large number of stocks, funds, or spreads within seconds (limited only by Excel's data capacity) Technical Requirements -Microsoft Excel -Adobe Acrobat Reader -5 megabytes disk space (for stock data storage) -Intraday, daily, or weekly Open-High-Low-Close-Volume price data -Internet access (high speed DSL or cable modem suggested, but not necessary) -OPTIONAL: DDE data import link for Excel through your data provider (advised for more than 5-10 securities, otherwise free price data from Yahoo!Finance or other source works fine) Table of Contents Introduction Basic Technical Requirements The 5 Technical Indicators Step 1: Average Directional Movement Index (ADX) Step 2: Trending or Oscillating? Step 2A: Trending = Moving Average Crossovers Step 2B: Oscillating = Stochastic Oscillator Step 3: Timing the Buy/Sell Signals with Bollinger Bands Step 4: Enhancing Percentage Trade Success with the DMI System Architecture Setting Up Building the Directory and File Structure Building the Spreadsheet Structure Building the Indicator Formulas Market Data ADX Indicator Moving Averages Stochastic Bollinger Bands DMI Building the Macro Code Step 1: Opening the Visual Basic Editor window Step 2: Writing the Macro Code Step 3: Checking the Code for Errors What the Code Does Building the Signals/ Sheet Step 1: Signals/ Sheet Labels and Formulas Step 2: Build the Ranges Step 3: Adding a Control Button and Assigning a Macro Step 4: Formatting the worksheet Building the Data Source File Loading Data from Other Sources Loading .CSV or .TXT Files Getting FREE Historical Data from Yahoo! Finance Running the Model on a Daily Basis When to Run the Model Combining the Signals with Other Market Information Money and Risk Management Common Macro Errors FAQs Backtesting the model Login Delivery You will receive an email at the address you provided during the payment process to access the online materials. We generally email usernames and passwords within 48 hours of purchase (usually much sooner). In some cases (due to holidays, weekends, or technical difficulties) it may take longer than 48 hours.
Platforms supported:
Windows 95, Windows NT, Windows 2000, Windows XP, Windows 98, Windows Server 2003, .NET Windows, .NET Cross-Platform, XP Tablet PC, Windows XP x64, Windows Server 2003 x64, .NET 2.0 Windows, Windows Vista