The Stock Trading System for Excel is a step-by-step course on 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 Stock Trading System for Excel 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 Stock Trading System for Excel, you simply import the data you need, run the model automatically with a click of a button, and make your trading decisions. The Stock Trading System for Excel incorporates both trend-trading and swing-trading features. The swing-trading feature can be turned on or off, depending upon your investing style. The system operates with your choice of free ASCII text files available on the internet, or a subscription data service (with our without a DDE link).
The Stock Trading System for Excel 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 Back testing Model is also included for historical analysis and testing various stocks and time periods.
Key Features on the Stock Trading System for Excel course include:
A complete PDF Guide showing you how to build and use the model.
A complete Online Course including everything in the PDF Guide plus VBA Code and FAQs sections.
A complete pre-built Back testing model in MS Excel with graphs and trade statistics for your historical analysis.
30 days of online access to download the materials and learn how to build and use your new Stock Trading Model.
Instantaneous access to the PDF Guide, Online Course, and Back testing Model with your own login and password provided at time of purchase.
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 and upgrade costs.
Calculate trading signals on hundreds of stocks within seconds.
Stock Trading System for Excel 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
