Follow AuSportsBetting on Twitter  
Share

Betting Tracker Excel Worksheet

Australia Sports Betting offers an Excel betting tracker spreadsheet that is free to download. Two versions of the spreadsheet are available: standard and advanced. Both versions are free. Users of OpenOffice should use the OpenOffice Calc version of the spreadsheet.

The worksheet tracks your bets for multiple agencies and provides performance data as well as a summary graph. Depending on the version you download there are seven to nine 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
  • Closing Odds Analysis – provides closing odds statistics (advanced version only)
  • Closing Line Analysis – provides closing line/spread statistics (advanced version only)
  • 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)

The primary difference between the ‘Advanced’ and ‘Standard’ versions is the Advanced version supports the recording of closing odds and lines/spreads. This feature is designed for punters who wish to track whether they are beating the closing odds/line.

NOTE: We recommend you save the file to your computer first, then open it with Excel.

[Excel icon]     Betting Tracker Standard v2.14 (1.9 MB)
Betting Tracker Standard v2.14 (Euro version) (1.9 MB)
Betting Tracker Standard v2.14 (British Pound version) (1.9 MB)
 
[Excel icon]     Betting Tracker Advanced v2.14 (2.7 MB)
Betting Tracker Advanced v2.14 (Euro version) (2.7 MB)
Betting Tracker Advanced v2.14 (British Pound version) (2.7 MB)

 

Note that versions 2.0 and beyond require Excel 2007 or later. For those using an older version of Excel the most recent supported version is v1.10.

Download – Excel 1997-2003 (.xls)

[Excel icon]     Betting Tracker Standard v1.10 (4.8 MB)
Betting Tracker Standard v1.10 (Euro version) (4.8 MB)
Betting Tracker Standard v1.10 (British Pound version) (4.8 MB)

 

Version History

v2.14     4 Dec 2013     Updated standard and advanced versions with the following updates:

  • Adjusted the total bets tally and win % columns in the Performance Summary sheet to exclude results other than win and loss
  • Input instructions in the Bets worksheet removed for all but the first 20 rows. Instructions remain in the Win (bet result) column for all rows.
  • Various background tweaks to reduce the number of hidden columns
v2.13     23 Jul 2013     Updated advanced version with the following updates:

  • “Last 24 Hours” stat added to the Recent Summary box in the Bets sheet
  • Win tally, total bets tally and win % columns added to the Performance Summary sheet
  • Tweaked Setup instructions in the Intro sheet
v2.12     8 Jan 2013     Updated advanced version with the following fixes to the Bets worksheet:

  • Beat Close and Beat Close % now account for Lay betting in all rows
  • Beat Close Line/Spread now accounts for Lay betting
  • Bug fix for average odds in the Performance Summary sheet (fix also applied to v2.11 Standard)
v2.11     29 Nov 2012     New standard and advanced versions with the following updates

  • Potential Payout column added to the Bets worksheet
  • 7-day and month-to-date summaries add to the Bets worksheet
  • “P” displayed by default in bet win column, with changes made to the conditional formatting
  • Blank values in setting sheet excluded from drop down menus in Bets and Deposits worksheets
  • Support for American odds in the closing odds analysis (advanced version)
  • Closing odds support for lay wagers (advanced version)
v2.1     3 Se 2012     New ‘advanced’ version with the following updates

  • Closing odds and line/spread columns added to the Bets worksheet
  • New ‘Closing Odds Analysis’ and ‘Closing Line Analysis’ worksheets that provide statistics on beating the closing odds/line.
  • Bookmaker turnover column added to the ‘Available Funds’ worksheet
  • Additional FAQs added to the ‘Intro’ worksheet
v2.02     31 Jul 2012     New version with the following updates

  • Tweaked Sports drop down menu validation in Bets worksheet
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 Excel 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 and Twitter account.

Share
© 2010-14 Australia Sports Betting · Follow on Twitter: Follow AuSportsBetting on Twitter · Follow on Facebook: · Subscribe:PostsComments