Staking Plans Settings

The settings below determine the suggested stakes that are displayed on the Bets worksheet.
Input instructions for the odds and bet ratings adjustments can be found at the bottom of the sheet.

Plans Displayed on the Bets Worksheet   Staking Plans
1 Level Stakes
Staking Plan #1: Use the dropdown menus to the left to select which two staking plans to display recommended stakes for on the Bets worksheet. 2 Percentage Stakes
Staking Plan #2: 3 Only two are displayed on the Bets worksheet to save space. 3 Square Root Stakes
4 Kelly Criterion
Staking Plan Settings:
Global Settings:  \$                      0.01 Enter a minimum stake amount.  This is designed to avoid recommended stakes that are below the minimum stake accepted by your bookmaker. 1 None
Ignore withdrawals when calculating stakes? 2 Div Odds
3 Div Sqrt Odds
Level Stakes :  \$                     10.00 Enter the fixed currency amount to wager for every bet.
\$                     50.00 Enter a maximum currency amount to have at risk.  Input an arbitrarily large number (e.g. 9999999) if you don't wish to impose any limit.
Odds adjustment (see the instructions below to learn what each term means)
3 Bet rating adjustment (see the instructions below to learn what each term means)   Bet Rating Adjustment Options
1 None
Percentage Stakes: 5.0% Enter a set percentage of your balance to wager for every bet. 2 Rating/10
20.0% Enter a maximum percentage of your balance to have at risk per day.  Input 0.0 if you don't wish to impose any limit. 3 Sqrt (Rating/10)
Odds adjustment (see the instructions below to learn what each term means)
3 Bet rating adjustment (see the instructions below to learn what each term means)
Ignore withdrawals
Square Root Stakes: 5.0% Enter a set percentage of your balance to wager for every bet. 1 Yes
20.0% Enter a maximum percentage of your balance to have at risk per day.  Input 0.0 if you don't wish to impose any limit. 2 No
Odds adjustment (see the instructions below to learn what each term means)
3 Bet rating adjustment (see the instructions below to learn what each term means)

Odds and Bet Ratings Adjustments:

You can opt to adjust the staking plans for odds and bet ratings.  Note that the square root option is less sensitive to the odds and ratings than the simple adjustment option.

For the odds adjustment, your options are:
None - no adjustment.  The stake will be irrespective of the odds.
Div Odds - the stake will be divided by the decimal odds.  E.g. if the base stake is \$10.00 and the decimal odds are 1.25, the stake will be \$8.00.
Div Sqrt Odds - the stake will be divided by the square root of the decimal odds.  E.g. if the base stake is \$10.00 and the decimal odds are 1.25, the stake will be \$8.94.

You can opt to use a ratings system where you rate each of your bets between 1 and 10 to denote your confidence or perceived value of the odds.
With this system 1 is the lowest score and 10 is the highest.  Note that you can input decimal values such as 5.5.

For the ratings adjustments your options are:
None - no adjustment.  The stake will be irrespective of any bet rating.
Multiply Rating - the stake will be multiplied by the ratio of your bet rating to the maximum possible rating. E.g. if the base stake is \$10.00 and the rating is 8, the stake will be \$8.00.
Multiply Sqrt Rating - the stake will be multiplied by the square root of the ratio of your bet rating to the maximum possible rating. E.g. if the base stake is \$10.00 and the rating is 8, the stake will be \$8.94.

Simultaneous Bets

The spreadsheet takes a crude approach to simultaneous wagers.  The worksheet treats any wagers with the same date as being simultaneous.  If you want to separate some bets as having concluded before you submitted wagers for others, you can input a bet time into column B of the Bets worksheet. The spreadsheet will then use the time to  determine which bets are simultaneous.

For simultaneous wagers the spreadsheet uses the approach outlined here:
http://www.aussportsbetting.com/guide/betting-strategies/staking-plans/simultaneous-bets/

For example, suppose you are using fixed stakes with \$10 per stake and \$50 as a maximum amount to have at risk.  If you have 8 simultaneous bets the spreadsheet will calculate each recommended level stake as \$50/8 = \$6.25.  If you are adjusting the stakes for odds and/or bet ratings these adjustments will then be applied independently to each of the 8 bets.  Note that if you are using the bet rating adjustment the maximum \$50 at risk would only ever be achieved if every bet had a maximum rating of 10/10.  If you are using the odds adjustment then the \$50 maximum amount at risk will never be reached.