|
Introduction
Basic Technical Requirements
Three Profitable Spread Trading Strategies
- Strategy 1: E-Mini S&P500 vs. Nasdaq 100 futures
- Strategy 2: Swiss Franc vs. Japanese Yen futures
- Strategy 3: 5-year vs. 10-year Treasury Note futures
3 Technical Indicators
- Exponential Moving Averages
- Percentage Price Oscillator (PPO)
- Donchian Channels
- Combined Trading Rules
System Architecture
Setting Up the Excel Workbook
- Building the Directory and File Structure
- Building the Spreadsheet Structure
- Building the Indicator and Spread Formulas
Writing the VBA Macro Code.
- Visual Basic Editor window
- Code Module
- Writing the VBA Code
- The VBa code Explained
- Checking the Code for Errors
Building the \Signals/ Sheet
- Labels and Formulas
- Build the Ranges and Enter Tickers
- Add a Control Button and Assign a Macro
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
- Signals and What They Mean
- Entry and Exit Techniques
- Risk Management and Limiting Losses
Macro Errors
Frequently Asked Questions
Backtesting the Model
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 |
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
SPECIALS!
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel
| MSSQL Migration
Toolkit |
Monte Carlo Add-in |
Excel
Costing Templates