Building an Automated Spread Trading System in Excel

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