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

• Build an Automated Spread Trading System v1
  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,...

• Build an Automated Sector Fund System v2
  This online course shows you how to build a long term sector fund rotation model using MS Excel

• Build an Automated Stock Trading System v1
  This online course shows you how to build a sophisticated automated stock trading model using MS Excel. Microsoft's Visual Basic (VBA) language is used in conjunction with Excel's user interface, formulas, and calculation capabilities to deliver a...

• Build an Automated Stock Trading System v1
  This online course shows you how to build a sophisticated automated stock trading model using MS Excel

• Build an Automated Sector Fund System v1
  This online course shows you how to build a long term sector fund rotation model using MS Excel. Microsoft's Visual Basic (VBA) language is used with Excel's user interface, formulas, and calculation capabilities to deliver a powerful and flexible investment tool. Uses the classic market economist's Sector Rotation Model, with several improvements...

• Spheresoft Highlighter for Microsoft Excel 2009.09
  Real-time highlighting is now available for users of Microsoft Excel

• Investment Portfolio Management 4.1.14
  Are your trading accounts accurate? Can you bring up your profit & loss reports in a matter of minutes, should the tax people come calling? Would you be able to show detailed records of your trades in under five minutes? OTrader 4.1 is a...

• Genesis 8.2
  Genesis is a stock charting and technical analysis trading system providing a complete set of models and charting features, with support for any type of instrument in all market cycles, Internet connectivity, spreadsheet-like capabilities, built-in database query builder, fully customisable charts, simultaneous analysis of multiple instruments, save/restore facilities and price line attachment overlays such as candlesticks, barcharts, high-lows, trends and channels