|
| Title and Version |
|
Build an Automated Spread Trading System vv1
|
| Author |
|
Financial-edu.com / Venus United Capital
|
| Release Date |
|
01 December 2004
|
| Operating Systems |
|
Win 3.1x,Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003
|
| Short Description |
|
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.
|
| PAD File URL |
|
http://www.financial-edu.com/PAD/pad_spread_course_v1.xml |
|
| Application Web Page |
|
http://www.financial-edu.com/SpreadCourse.htm
|
| Author Web Page |
|
http://www.financial-edu.com
|
| Keywords |
|
spread trading system building automated excel spreadsheet vba macro dde active-x quote.com price index stock future option LEAP
|
| Full Description |
|
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. 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!
- Online course showing you how to build and operate the model PLUS VBA Code and FAQs sections
- Detailed instructions on importing prices into Excel using eSignal QLink and Yahoo!Finance
- 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
- 5Mb disk space
- Date-Time-Close price data on your chosen time interval
- (OPTIONAL) DDE data import link for Excel |
|
|
|
