Version 1a of Results Summary spreadsheet

Update: April'11.  The much improved Results Summary v2 spreadsheet is now available for download! Including results summarised by sports, Betdaq support and much more.  Check out the post about it here http://betfairtradingmindgames.blogspot.com/2011/04/results-summary-v2-spreadsheet-is-here.html

I've made a small improvement the Results Summary spreadsheet. Save it to the same folder as your current version. After opening it and turning macros on, press the new button, "Import records from previous version" next to the "undo current import" button. Then you're up and running!

Firstly, the weekly totals now have the date that each week started on rather than the week number.

This is a bit more meaningful and also has the benefit of sorting correctly - as the weeks numbered 1 to 10 were previously sorting incorrectly with 1 appearing before 19 and 2 before 29 etc (I hadn't noticed as I've only been using this spreadsheet since last May). But you'll be ok until mid-March next year with the old version!

The second little improvement is that the data import macro will now work even if you rename "Results Summary" to something else. The Betfair P&L file must still have the default name of BettingPandL.xls and be in the same folder as Results Summary though. This will be useful if you want to have separate instances of Results Summary for different accounts, or simply to call it something else.

Any questions, let me know! There have now been over 100 downloads of the first version. Hope you are all finding it useful.

The original post about Results Summary can be found by clicking here.

Have a great Xmas & New Year (particularly on Boxing Day and New Year's Day racing!).

More on the Results Summary spreadsheet

It's great to see the spreadsheet being used by a few people, I'm glad its been of use posting it up. A couple of bloggers, that I'm aware of, have posted screenshots of their results using it. You can check them out here: JS' Betfair Trading Journal & Fight The Inner Demons Good reads both of them.

I thought I'd mention a couple of things for the people that have downloaded the spreadsheet (a lot more than 2 - let me know if you are finding it useful!) which may help get more out of it.

The reason that there is no grand total on the table with the daily results is that by selecting any of the columns you can then get total, maximum, minimum, average and count for that data without the grand totals being included and messing it up. To do this put the cursor just above the column header until you get a black downward-pointing arrow, as shown here above the P&L column:


Clicking will then select the whole column and the summary figures I mentioned will be displayed along the bottom of the excel window:


If you don't get all the summary figures shown here, you can choose which ones you want by right-clicking this bottom part of the Excel window.

Another thing is the warning message that you get regarding macros every time you open the spreadsheet. You can get avoid this happening in Excel 2007 without lowering your security for other spreadsheets by digitally signing this spreadsheet as your own.

To do this go to the start menu, select "All programs" find Microsoft Office, then click on the sub-folder called Microsoft Office Tools then select "Digital Certificate for VBA projects". Give the certificate any name you want, e.g. "Fred's supa dupa certificate" & click OK. Then open the Results Summary spreadsheet, right-click on the "Summary" tab at the bottom of the Excel window, select "View code". A new window will open and at the top there are several menus. Select "Tools" then "Digital Signature". Under "Sign as" press the "Choose" button and select the certificate you have just named. Click OK x2 and then close the Microsoft Visual Basic window. At this point, save your spreadsheet. The next time you open it you will not be prompted about macros.

Sorry that got a bit technical, but over the course of months this will save you tens of irritating warning messages!