
Staking
Plans Settings 















The settings below
determine the suggested stakes that are displayed on the Bets worksheet. 




Click here to learn more about these staking plans. 




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: 













Odds Adjustment Options 

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/bettingstrategies/stakingplans/simultaneousbets/ 













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. 














































































































