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 your subscription data service. The learning materials include a step-by-step Online Course and a separate pre-built Backtesting Model for historical analysis and testing. -What You Get With Each Course: A Tremendous Value! -A complete Online Course PLUS VBA Code and FAQs sections -Detailed instructions on importing price data into Excel using eSignal QLink or Yahoo!Finance -A complete pre-built Backtesting Model in MS Excel with graphs and trade statistics for your historical analysis -Instant online access the course materials -Works with Excel 2007, 2003 or 1997 and any version of Windows (Vista too)
Platform Windows 95/98/ME
Operating Systems Windows 95/98/ME,Windows NT/2000,Windows XP,Windows NT/2000/2003/SBS2003,Windows Vista
Date added 31 Jan 2011
Last Updated 29 Aug 2011
Tags excel, spreadsheets, trading, VBA, eSignal, Yahoo, finance, stocks, day trading, swing trading, model, analysis