Stocks & Commodities V. 30:4 (78-82): Pair Trading With Spreadsheets by Ron McEwan

Stocks & Commodities V. 30:4 (78-82): Pair Trading With Spreadsheets by Ron McEwan
Item# V30C04_297MCEWPDF
Availability: In Stock

Product Description


Pair Trading With Spreadsheets by Ron McEwan

Build a spreadsheet to aid in revealing profitable opportunities in pair trades.

Pair trading is classified as a market neutral strategy where you are not concerned with market direction, whether up or down. Instead, the idea is to exploit temporary price discrepancies in two (or more) securities by simultaneously going long the outperforming security and going short the underperforming one.

An important concept in pair trading is in selecting securities that have a spread with a “mean reverting” (comovement) characteristic. Correlation of the two securities was often used as a measure to find similarity in the movement of two or more securities. Correlation is not always indicative of mean reversion. Cointegration is a more accepted method for detecting mean reversion — that is, comovement — of the spread in securities.

Other than knowing that cointegration is a way to measure comovement or mean reversion, it is not necessary to go into detail about it here. There are commercial software packages and web services that will perform cointegration analysis on a pair of stocks. In addition, there are free scripts for Matlab and “R,” the free language and environment for statistical computing and graphics, that will perform the cointegration calculations.

For this article I have constructed an Excel spreadsheet to aid in identifying the spread in a pair of stocks that have a mean reversion characteristic that can be traded profitably.

*Note: $2.95-$5.95 Articles are in PDF format only. No hard copy of the article(s) will be delivered. During checkout, click the "Download Now" button to immediately receive your article(s) purchase. STOCKS & COMMODITIES magazine is delivered via mail. After paying for your subscription at users can view the S&C Digital Edition in the subscriber's section on

Take Control of Your Trading.
Professional Traders' Starter Kit
All these items shown below only $299.99!
  • 5-year subscription to Technical Analysis of STOCKS & COMMODITIES, The Traders' magazine. (Shipping outside the US is extra. Washington state addresses require sales tax based on your locale.)
  • 5 year access to S&C Archive
  • 5 year access to S&C Digital Edition
  • 5-year subscription to Advantage.
  • 5-year subscription to Working Money.
  • Free book selection.
  • Click Here to Order