Home > Excel Business Solutions > Excel Productivity > Training and Tutorials > Stock Trading System Share

Stock Trading System

Excel stock trading system for training and tutorials

Excel Stock Trading System

Rate this solution:
(4/5 from 5 votes)
Stock Trading System screenshot
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
  • Money and Risk Management
  • Common Macro Errors
  • FAQs
  • Back testing the model

Get It

(Pricing is available on the next page)
(Updated on 2023-10-01)

Related Excel Solutions for Stock Trading System

Trading Data AnalysisTechnical Analysis  Complete Trading SystemTechnical Analysis  Spread Trading SystemTraining and Tutorials

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.