Australia Sports Betting offers a free betting tracker excel worksheet, which is available for download.
The worksheet tracks your bets for multiple agencies and provides performance data as well as a summary graph. There are seven worksheets as described below:
- Introduction – provides an introduction to the spreadsheet, along with some instructions
- Settings – contains the worksheet settings for betting agencies and sports categories
- Deposits – input sheet for deposit and withdrawal activity
- Bets – input sheet for your betting activity
- Available Funds – lists your credit levels for each betting agency
- Performance Summary – interactive worksheet that summarises your betting performance
- Performance Graph – plots your betting performance over time
Terms of Use
Use of the Betting Tracker Worksheet is conditional upon you reading and accepting the Terms of Use for Australia Sports Betting. Basically, it is a condition of use that you do not rely upon the information and resources provided by this website when placing bets. Please verify everything for yourself. Click here to read the terms of use for this website.
Download – Excel 2007 and Onwards (.xlsx)
Download – Excel 1997-2003 (.xls)
Version History
| v2.01 |
|
1 Feb 2012 |
|
New version with the following updates
- Ability to filter betting data by tipster/capper. Punters who subscribe to tipping services can now track performance for each service separately.
- Changes to the Settings worksheet instructions.
|
| v2.0 |
|
25 Jan 2012 |
|
New version with the following updates
- .xlsx file format instead of the previously used .xls format. This is only supported by Excel 2007 and onwards.
- Basic support added for Betfair lay betting.
- Performance Summary worksheet is now interactive. Statistics can be filtered by sport, bet type and bet date.
- Removal of profit graphs for individual bookmakers
- Additional colour coding to distinguish between optional fields, mandatory fields, and fields that should not be edited.
- The workbook now supports 200 bookmakers as opposed to 60 previously.
- Betting data rows increased from 1,000 to 10,000
|
| v1.10 |
|
20 Jun 2011 |
|
New version with the following updates
- Asian Handicap betting is now supported, with half win (HW), half lose (HL) and push (PU) included as possible bet outcomes in the Bets sheet.
- A Commissions column has been added to the bets sheet. Users of Betfair will now be able to input agency commissions for simple bets.
- In the Performance Summary sheet, ‘Overall Performance’ now shows ‘Concluded Bets’, which do not include pending bets.
- The Performance Summary sheet now features a “High Points and Low Points” summary table, which outlines your best and worst profit positions to date.
- The algorithm for calculating profits has been simplified and (arguably) corrected. This change may affect the overall profit calculations by a few cents for those who import data from previous versions.
- The Free Bet column in the bets sheet now accepts a blank value as being the same as ‘N’. The wager is assumed to not be a free bet if the field is left blank.
- The Settings sheet now features a rounding input, which enables you to change the payout and profit rounding if your currency supports more or less than two decimal places.
- Additional instructions have been added to the Intro sheet.
|
| v1.07 |
|
10 Mar 2011 |
|
New version with the following updates
- The spreadsheet now accommodates 200 sporting event categories
- The spreadsheet now supports performance tracking by bet type (Head to Head, Line Bet, etc.)
- The Page Setups for each sheet have been updated
- Pending bet rows are now highlighted in the Bets worksheet (thanks to Chad J.)
- The performance summary sheet features the ability to filter bet type performance by sporting category (thanks to Chad J.)
|
| v1.06 |
|
10 Feb 2011 |
|
New version with the following updates
- The spreadsheet now accommodates decimal, fractional, US, Hong Kong, Indonesian and Malay odds. You can change this setting in the ‘Settings’ sheet.
- The Settings sheet now accommodates 60 betting agencies.
- The Bets sheet contains less rows to reduce the file size. Additional rows can be added using the instructions in the ‘Intro’ worksheet.
- A bug that involved some accidentally locked cells in the ‘Bets’ worksheet has been fixed.
- Additional instructions have been added to the ‘Settings’ sheet.
|
| v1.05 |
|
7 Jan 2011 |
|
New version with the following updates
- The Settings sheet now accommodates more betting agencies and sporting event categories.
- The Bets sheet contains more rows.
- The Bets sheet now features an optional ‘In-Play’ column to track performance for in-play versus pre-game betting.
- The Performance Summary sheet now provides separate in-play and pre-game betting statistics.
|
| v1.04 |
|
12 Mar 2010 |
|
New version with the following updates
- The performance summary sheet now includes betting odds statistics
- The worksheets are now colour coded. The blue sheets are used to input data and the yellow sheets output statistics and information.
- Additional instructions have been placed within selected worksheets
- Additional rows have been added to the Bets worksheet
|
| v1.03 |
|
28 Apr 2009 |
|
New version with the following updates
- Performance summary sheet now incorporates bonus credit
- Other miscellaneous touch ups
|
| v1.02 |
|
21 Feb 2009 |
|
New version with the following updates
- ‘Half payout’ added as an additional option for the bet result column in the ‘Bets’ worksheet
- Bonus deposits table added to the ‘Deposits’ worksheet
|
| v1.01 |
|
29 Jan 2009 |
|
New version with the following updates
- Tidied up introduction sheet
- Pending bets displayed in the ‘Available Funds’ sheet
- Sample data included
- Page setups for A4 printing
|
| v1.00 |
|
26 Jan 2009 |
|
First version |
Support
Support can be found at the betting tracker thread in the sports betting forum. Questions can comments can be submitted through the Contact Form. Updates and new regarding the spreadsheet are posted on our Facebook page.
![[Excel icon]](http://www.aussportsbetting.com/images/excel.gif)
