This online course shows you how to build an automated spread trading model using MS Excel. The System captures the price difference between security pairs of any type - indexes, stocks, futures, options, LEAPs, currencies. The System uses three proven technical indicators - exponential moving averages, Percentage Price Oscillator (PPO), and Donchian Channels - to capture spread movements when profits are likely to be greatest. Includes three spread strategies for Swiss Franc - Japanese Yen futures, Nasdaq - S&P 500 E-Mini, and 10-Year vs 5-Year U.S. Treasury Notes. The System is optimized for use with daily or hourly data, but can be used on any time interval. You are shown how to build a data "hub" with a DDE link, or run the model with free .csv data files from Yahoo! Finance or another source. A PDF Guide is provided along with the online course so you can choose how to learn in the most comfortable way. Also included is a complete backtesting model -- simply import historical data and see statistical and graphical results for your chosen spread strategy.
What You Get: A TREMENDOUS 3-IN-1 VALUE!
- PDF Guide
- Online course including everything in the PDF Guide PLUS VBA Code and FAQs sections
- Pre-built Backtesting Model in MS Excel with graphs and trade statistics
- Online access to the course materials
Benefits
- Integrate Excel, VBA, formulas, and data sources into a profitable trading tool
- Acquire knowledge applicable to any Excel modeling project
- Save money by eliminating recurring software costs
- Calculate Buy/Sell signals on multiple spread pairs within seconds
Technical Requirements
- MS Excel for Windows
- Adobe Acrobat Reader
- 5Mb disk space
- Date-Time-Close price data on your chosen time interval
- (OPTIONAL) DDE data import link for Excel