This spread trading Guide shows you step-by-step how to build and utilize an effective 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.
Description
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.
A complete Online Course PLUS VBA Code and FAQs sections
Detailed instructions for importing price data into Excel from 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
Instantaneous access to the course materials with your own login and password provided at time of purchase (if purchasing through CCBill, otherwise course password is emailed to you)
Learn to integrate Excel, VBA, formulas, and data sources into a profitable trading tool
Acquire unique knowledge applicable to any Excel modeling or analysis project
Save money by eliminating recurring software costs
Calculate trading signals on a large number of stocks, funds, or spreads within seconds (limited only by Excel's data capacity)
Microsoft Excel
5 megabytes disk space (for data storage)
Date-Time-Close price data on your chosen time interval
Internet access (high speed DSL or cable modem suggested, but not necessary)
OPTIONAL: DDE data import link for Excel through your data provider (advised for more than 5-10 securities, otherwise free price data from Yahoo!Finance or other source works fine)
Build an Automated Spread Trading System in 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 special@ozgrid.com 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