Staking Plan Calculator and Betting Tracker Excel Spreadsheet

Spreadsheet screenshot

Australia Sports Betting has developed a free staking plan Excel spreadsheet which doubles as a betting tracker. This project is a fork (offshoot) of the standard version (v2.16) of our free Excel betting tracker.

The worksheet tracks your bets and provides in-depth performance data as well as a profit graph. Unlike our standard Excel betting tracker, this worksheet calculates recommended stakes using four different staking plans: level stakes, percentage stakes, square root stakes and the Kelly criterion. The spreadsheet compares your betting performance to the hypothetical results had you strictly followed the four staking plans. The level, percentage and square root plans have adjustable settings that include the ability to adjust your stake for the wager odds and bet rating.

The staking plan Excel calculator contains the following worksheets as described below:

  • Introduction – provides an introduction to the spreadsheet, along with some instructions
  • General Settings – contains the worksheet settings for bookmakers, sports categories, bet types, tippers, etc.
  • Staking Plan Settings – contains the worksheet settings for the staking plans along with some instructions
  • Deposits – data entry sheet for deposits and withdrawals
  • Bets – data entry sheet for your betting activity. Recommended stakes are displayed on this sheet.
  • Available Funds – lists your credit levels for each betting agency
  • Performance Summary – interactive worksheet that summarises your betting performance
  • Staking Plans Comparison Graph – compares your betting performance to hypothetical results had to strictly adhered to certain staking plans

 

Terms of Use

Use of this 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. It is also a condition of use that you do not make this spreadsheet, or any variant of it, available elsewhere on the Internet. If you wish to tell others about this spreadsheet, please share the following URL:
http://www.aussportsbetting.com/tools/staking-plan-calculator-excel-spreadsheet/.

 

Download – requires Excel 2007 and Onwards (.xlsx)

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

Note that this is a resource intensive spreadsheet. It will be slow to use on some computers.

[Excel icon]     Staking Plan Calculator and Betting Tracker v1.00 (~6.1 MB)

 

How does this compare to the standard and advanced betting trackers?

Both the staking plan calculator and advanced betting tracker contain all of the features included in the standard betting tracker. The advanced betting tracker includes closing odds and lines analysis while the staking plan calculator provides stake recommendations.

 

Version History

v1.00     27 Oct 2014     Initial version released based on version 2.16 of the standard betting tracker.

  • UPDATE: performance summary bug fixed (3 Nov 2014)

 

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 this:
Share