Let’s talk the power and heavy lifting capabilities of Excel as compared to R or Python:
Is DotNet CSharp Excel easier more powerful and popular than using open source R or Python for heavy algorithm processing and calculating? – See more at: https://quantlabs.net/blog/2014/03/is-dotnet-csharp-excel-easier-more-powerful-and-popular-than-using-open-source-r-or-python-for-heavy-algorithm-processing-and-calculating/#sthash.41qlE1Hy.dpuf
Power of DotNet C# controlling an Excel workbook or worksheet is impressive to calculations – See more at:Â http://quantlabs.net/academy/forum/technical-forum/power-of-dotnet-c-controlling-an-excel-workbook-or-worksheet-is-impressive-to-calculations/#sthash.ZBJfAQb9.dpuf
Here is a worksheet that you could consider for pairs trading with equity and futures:
Automated Trading Pair Excel worksheet for DotNet CSharp calculating trading signal with Profit and Loss – See more at: https://quantlabs.net/blog/2014/03/automated-trading-pair-excel-worksheet-for-dotnet-csharp-calculating-trading-signal-with-profit-and-loss/#sthash.OZXgFYjN.dpuf
Once I complete this, I will post the complete source code and walkthrough videos  for my Elite Quants!
Bryan
NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!
