Sorry folks, I couldn’t help myself and have spent the past couple of days tweaking the spreadsheet. In part to fix some errors but mainly just to try and improve its usability.

Download it Here:

Here’s what I’ve changed:

1.) v2.0 was set so that you manually had to press F9 in order to get the cells to re-calculate. I reset this feature to Automatic
2.) I have tweaked a number of the cells in order to reduce the time it takes to perform the numerous calculations.
3.) I added Auto-Format features to all of the cells in the ‘Daily Results’ & ‘One Row Stats’ pages. I’m a very visual person and this helps me identify at a quick glance the areas of my trading that most urgently need attention (just look for Red & Yell0w)
4.) I added a G-B-OK Average column on the ‘Daily Results’ worksheet, I had inadvertently left it off.
5.) I added Auto-Sort buttons underneath the headers of all of the ‘Trade-Data’ & ‘One Row Stats’ worksheets. Now if you want to look at only the results of your Long trades or trades labeled “Bad”, you can do so with 1 click.
6.) Added input cells to account for the equity & futures commissions that your brokerage charges

Below are some screenshots, hope the changes help!

Jason
 
 

Click to enlarge

Click to enlarge

Click to enlarge

Click to enlarge

Click to enlarge

For all those who are interested, here’s Version 2.0! You can Download it Here or click the banner below.

In addition to the Help Files, there are 3 main worksheets to the spreadsheet:

Trade-Data: Where trades and relevant data are entered.
Daily Results: Where all relevant statistics are automatically calculated and displayed for quick viewing
One Row Stats: Same stats as in the Daily Results except they are all in one row. This makes daily, weekly, monthly comparisons possible and much easier than before.

See below for screenshots of entire workbook.

Click to enlarge

Click to enlarge

Click to enlarge

Click to enlarge

Click to enlarge

Don’t have much time this evening as I’ve been very busy working on an update to the my ScalpRate.xls spreadsheet since speaking to my sister (who’s a business consultant with Morgan Stanley). She gave me a number of great ideas that will drastically increase the functionality and utility of the spreadsheet and really make it possible to quantify and track any and all pertinent data to the utmost degree.

My results were so-so today. I started off down a few R-Units but got it all back with a Trend Short play at 1:00 PM EST. I finished the day at exactly $0.00. Now that doesn’t happen too often. But I have spent the past couple of days focusing my efforts on getting this spreadsheet updated. I’m eagerly awaiting the finished product myself as I’ll now be able to really hone in and see where my biggest mistakes are (By day, time of day, error, entry criteria, exit criteria, etc).

I’ll post more once I’m finished should be either tomorrow or Wednesday. Sorry such a short post today… but I’m late, gotta run!