|
Introduction
Basic Technical Requirements
A Primer: The Five 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. If not familiar with VBA see
Excel Training
- 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
Building an Automated Stock Trading System in MS Excel $89.95 Secure Payment Options 30 Day Money Back Guarantee!
Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
More Learn To Build |
Build an Automated Stock Trading System |
Build an Automated Sector Fund System |
Technical Indicators Library |
Build an Automated Spread Trading System |
See Also: Excel Add-ins Index & Excel Training Index & Excel Templates Index & Neural Network Software Index Trading Software Index & Charting Software Index Or, All Software
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS