The biggest problem I've run into with pairs trading models is data. To accuratly test the models, you need more data than most places make available to you. Assuming you have the historical data to test the model, and a good datafeed to run real-time, you should be fine in excel.