Hi, I have some simple backtesting to do on a system with simple rules and would like to do it in Excel... I was wondering if you have used/came across (and is willing to share) the spreadsheet. Thanks a lot.
If you don't get a posted spreadsheet here in this forum, make sure to check out the Yahoo Groups area for xltraders. http://tech.groups.yahoo.com/group/xltraders/ There are many downloads in the files area that members have posted, one in February of this year called Excel Trader.xls (Spreadsheet Program to Test Trading Ideas) that might solve your problem or at least give you a good starting point and an example to work from.
http://www.financial-edu.com/build-an-automated-stock-trading-system-in-excel.php 90 bucks, not bad if the framework is close to what you need.