I just found this site a few days ago, and have enjoyed reading the post and glad to see that ideas are being exchanged. I have a model that I am working on that I would like to share, and hopefully get some input with...
It starts with a matrix written by Bloomberg (those w/ access to bloomberg can email me for directions on how to get the matrix). The matrix allows you to input a list of stocks (max of 256--# of excel columns), or you can enter an index like SOX or NBI (Nasdaq biotech index), and the days back and it will retrieve the data for you...it does not do intraday. The spreadsheet produces 2 tabs, one with the matrix of each comparison/correlation...the second with a list of the two securies and thier correlation.
This just gives you the stocks and thier correlation...nothing more. I wrote a coniditional format for the matrix to paint stocks >95% correlation BLUE and <-50% RED. The second tab listing the pairs and correlations can be 'filtered' in excel to show the same data. Once the data is listed, you can then fill in a number of columns on current market data (% Change, Open, High, Low, etc) various fundamentals, relative strength, technical info (put/call ratios) etc.
Once you fill in the blanks, you can write conditional formats to show which one is 'better' than the comparison. IE-all you are looking to do is identify the stronger stock and the weaker stock, NOT forcasting direction!! For example....
With Bloomberg, I can pull in 1,2,5-day % change. The both may be up or down randomly over the period, but when I apply the conditional formats, and see that the 1,2,5 day % change is green (three greens in a row) I can see that it is outperforming its counterpart with 3 reds in a row. This is not rocket science, and it is not the ideal entry...but it has lead to fairly decent returns (-5% - my stop loss tollerance to 15% in a few days) ...and I never even looked at a chart or any fancy indicators. Granted, timing can likely be improved by looking at multiple regression analysis, normal distribution curves, Z-Scores, etc.
There are other excel 'add-ins' out there that will calculate the matrix for you. Check out
www.factset.com or
www.portfolioscience.com Esignal and others may have the same info now, I'm not sure. TradeStation or MetaStock may do them as well...if anyone knows, please let me know! The matrix is a quick and easy way to calculate correlations. Many people traded BRCD/QLGC for a long time, because they were very highly correlated, but due to QLGC's recent run-up, it may not behave the same way as BRCD, and their correlations have likely changed.
I have read about a lot here of people loosing a ton of money trading pairs, but the odds dramatically favor pair trading, as opposed to directional trading. Consider the following:
2 stocks, 2 outcomes (up or down/win or loss)
Pair Outcomes:
Stock A - Win
Stock A - Loss
Stock B- Win
Stock B- Loss
(win/loss NOT EQUAL to Long/short or Up/down)
Trade Outcomes:
Stock A- Win & B- Win (winning trade)
Stock A - Win & B - Loss (wash)
Stock A - Loss & B - Win (wash)
Stock A - Loss & B - Loss (loss)
The final results mean there are a 1/4 chance of winning, 1/4 chance of loosing, and 2/4 chances of the trade washing out...compared to the 50/50% chance of winning on a directional trade.
Just because you are 'hedged' through a pair, doesnt mean you can disregard common rules of trading....CUT LOSSES, use proven position sizing/pyrimiding money management techniques, etc.
The point is...I've demonstrated earlier how the risk/reward favors pairs over directional trading...When you're right, the profits can be componded because both long and short can work in your favor at the same time, but they can also work against you.
Good luck....
PearTrader