Build an Automated Spread Trading System in Excel In category - Business Finance Business Finance   This online course shows you step-by-step how to build and utilize an automated spread trading model using Microsoft Excel. The System captures the price difference between security pairs of any type -- indexes, stocks, futures, options, LEAPs, etc. Spread returns are typically non-correlated with other investment and trading strategies, making the model an excellent addition to an overall asset management strategy. The System uses three proven technical indicators--exponential moving averages, Percentage Price Oscillator (PPO), and Donchian Channels, to filter and capture situations where spread movement (and hence risk-adjusted profits) are likely to be greatest. Also presented are three real-world spread strategies, including Swiss Franc - Japanese Yen futures spreads, Nasdaq Composite - S&P 500 E-Mini spreads, and 10-Year vs. 5-Year U.S. Treasury Note spreads. The System is optimized for use with daily or hourly data, but can be used on virtually any time interval. Data can be imported into the model with a DDE data link available from most market data providers. You are shown how to build a data "hub" with a DDE link, or run the model with free .csv data files available from Yahoo! Finance or another source. 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 With Each Course: A Tremendous 3-in-1 Value! -A complete Online Course PLUS VBA Code and FAQs sections -Detailed instructions on importing prices using eSignal QLink and Yahoo!Finance -A complete pre-built Backtesting Model in MS Excel with graphs and trade statistics for your historical analysis -60 days of online access to access the course materials and learn how to build and use your new Trading Model Visit Product's WebSite      Buy Now

More from this Author

Pivot-Stochastic Futures Trading Model
Pivot-Stochastic Futures Trading Model is an efficient, time-saving tool for intraday traders using pivot points to trade futures price reversals. This pre-buil....

Excel with Yahoo! Finance - Building a Cash Flow Valuation Model
This detailed course shows you how build a Cash Flow Valuation Model using Excel and Yahoo! Finance data. You are taught in detail how to build a Discounted Cas....

Residential Real Estate Excel Model
This is the single most important tool you will ever use in your real estate investing! A professional pre-built Excel spreadsheet that calculates and details t....

Consulting Expense Excel Template
The Consulting Expense Excel Template is an easy to use expense claim spreadsheet and tracking tool. Completely pre-built and ready to use, this template allow....

Build an Automated Spread Trading System in Excel
This online course shows you step-by-step how to build and utilize an automated spread trading model using Microsoft Excel. The System captures the price differ....

Build an Automated Stock Trading System in Excel
This online course shows you step-by-step how to build a sophisticated automated stock trading model using Microsoft Excel. Microsoft`s Visual Basic (VBA) langu....

50 Ways to Survive a Recession
Let`s face it -- an economic recession can hit you, your family, your job or your business hard! Have you... -Suffered financial difficulties due to the....

Spread Trading Contract Calculator
This Calculator is a must have for spread traders! When spread trading two different futures contracts, it is important to equalize the value of each side o....

Build an Automated Sector Fund System in Excel
This online course walks you step-by-step through building a long term sector fund rotation model using Microsoft Excel. Microsoft`s Visual Basic (VBA) language....

Cash Flow Valuation Model for Excel
The Cash Flow Valuation Model for Excel is the perfect tool for comparative company or project valuations. Cash flow analysis is the basis for most sound in....