Hi Gang, The other issue in backtesting is being sure your cash reserve isn't being blown away. Five or ten dollars ain't no big deal but more, eow! So, here is how you can put a warning on the top of the page.
Use =SMALL(F23:F505,1)
Change the column "F" to whatever column your cash is listed in. Change the blue numbers to the first row with cash listed and the last possible cell in that column that you have in your spreadsheet.
Then right click on the cell that you have designated for the report and go to "Format Cells..." and select Currency and the display for a negative number that is red and looks like (1234.56), that way you can tell in an instant if the parameters you are using are out of line.
If you like I can send you a copy of my version of the AIM Spreadsheet. Just drop me a note at: 60e20f21@opayq.com
