Build an Automated Stock Trading System in Excel

Build an Automated Stock Trading System in Excel

Build an Automated Stock Trading System in Excel is a step-by-step how to guide on building 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. <br /><br />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. <br /><br />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. <br /><br />A separate pre-built Backtesting Model is included by email for historical analysis and testing various stocks and time periods. <br /><br />What You Get: A Tremendous 3-in-1 Value!<br /><br />- A complete e-book guide PLUS VBA Code and FAQs sections.<br />- Detailed instructions on importing price data into Excel using a DDE link or Yahoo Finance.<br />- Pre-built Backtesting Model in Excel with graphs and trade statistics for your historical analysis.<br /> <br />Features & Benefits:<br /><br />- Learn to integrate Excel, VBA, formulas, and data sources into a profitable trading tool.<br />- Acquire unique knowledge applicable to any Excel modeling or analysis project.<br />- Save money by eliminating recurring software costs.<br />- Calculate trading signals on a large number of stocks within seconds.<br />- Instantaneous access to the e-book after purchase.<br /><br />Technical Requirements:<br /><br />- Microsoft Excel<br />- 2 megabytes disk space (for files and stock data storage)<br />- Intraday, daily, or weekly Open-High-Low-Close-Volume price data <br />- Internet access