Bet £20, Get £40 in Free Bets info icon
close icon
close icon

If you’ve ever looked at the odds for a bet you’re thinking of placing and thought “those can’t be right,” you may need the Kelly Criterion calculator.

In this guide, you’ll find our exclusive Kelly calculator along with all the info you need on how to use it.

By the time we’re done here, you will know if your bets are good value and how much you should stake, or whether you’re being taken for a ride by the bookies.

KELLY CRITERION CALCULATOR
Odds format:
Decimal
Fractional
American
Current betting balance
Bookmaker odds
Your estimate (%)
Fractional Kelly Betting (FKB)
Bookmaker Estimate (%)
00.00%
Recommended Stake (%)
Recommended Stake - FKB adjusted (%)
00.00%
Recommended Stake - FKB adjusted
00.00
Return on wagered funds
00.00%
Expected value for bet
00.00
Overall potential profit
00.00
RESET

Instructions on How to Use the Kelly Criterion Calculator

Insert Current BalanceInsert the amount of money you have in your betting account or are willing to use to bet.
Add Bookmaker OddsAdd the odds of the market you are backing
Your EstimateInput your estimate of how likely your bet is to be correct
Fractional Kelly Betting (FKB)Choose between 0.1 and 1.0. This is the fraction of your total balance you feel comfortable betting
Recommended Stake (%)This will give you the recommended percentage to bet of your full balance
Recommended Stake (%) – FKB AdjustedThe recommended percentage to bet, after adjusting for your Fractional Kelly betting amount.
Recommended Stake – FKB AdjustedThis will give you the actual recommended stake, after taking all adjustments into account.
Return on Wagered Funds (%)The return percentage of your wager, depending on how much you have staked.
Expected ValueThe amount of added value you will receive for this bet, depending on your probability estimate.
Overall Potential ProfitThe net profit you will receive if the bet wins.
Info box icon

Info

Should you wish to use the Kelly Criterion Calculator for a new calculation, simply tap the RESET button in green.

Breaking Down the Kelly Criterion Calculator

There are four numbers you need to input into the Kelly betting calculator, and seven more data points which will be calculated and presented to you. Understanding all these metrics is key to using the betting calculator effectively. Let’s go through them all.

This is the total amount you have in your betting account. The Kelly stake calculator will determine how much of it you should place on a particular bet. If you plan on betting more, make sure to make your deposit first, so you can calculate the full amount.

Add the odds you would like to bet on. Once you've found a market worth betting on, add it here. The Kelly Criterion calculator gives you the choice of adding the odds in decimal, fractional or American, so you won’t need an odds converter.

Here’s where your sports prediction skills come into play. You need to estimate how likely your bet is to win, as a percentage. For example, if you’re betting on Liverpool to beat Man United and you think there’s a 70% chance of this happening, add 70 to the Kelly Criterion betting calculator.

This number determines how much of your bankroll you should be willing to part with when placing your bets. Depending on the percentage you give on the previous data, you may opt for a full send, or play it safe by using just 50% to reduce the risk of a major loss. This means that you don’t have to wager the full recommended amount.

This section needs to be written as a decimal from 0.1 to 1, meaning between 10% and 100%.

This is the bookmaker’s odds converted into a percentage, indicating how likely they think an event is to occur. When put against your own calculation, you can spot potential value straight away. It’s a crucial part for any Kelly staking calculator.

This is the recommended percentage of your total betting balance that you should stake on a single wager. For example, if you have £1,000 in your betting balance and a recommended stake of 70%, you will wager £700.

This section does not factor in fractional Kelly betting and assumes that you’re placing your entire bankroll on the line. If you’ve added a number to the FKB Kelly calculator section, which isn’t 1, you should ignore this number.

This section will give you the recommended percentage of your balance which you should be using to bet, based on the number (between 0.1 and 1) which you added in the Fractional Kelly Betting.

So, if you have £1000, and the recommended stake without adjustment is 70%, or £700; a 0.8 FKB will recommend using 56% of your total sum, which would be £560.

This is mainly relevant if you plan on using less than the full Kelly strategy.

This shows you the actual amount you should use as your stake, determined by the fractional Kelly betting number you placed. If you didn't add a fraction, this will still show you how much you need to stake from your bankroll.

This tells you the potential profit, relative to the amount risked, as a percentage.

For example, at 2 / 1 odds you make £2 profit for every £1 you risk, so your return on wagered funds is 200%.

This is the expected value you’re potentially achieving. The higher the number, the better value you’re getting for this bet. This number is mainly calculated depending on the difference between the bookmaker’s estimate and your estimate of how likely an event is to occur.

This figure shows you what you stand to win if your bet lands, minus your stake. This is pure winnings in real money terms. In this case, betting £600 on odds of 2/1 will give you £1200 overall profit.

Kelly Criterion Calculator Excel

In addition to our automated calculator above, you can also download our Kelly Criterion excel version below. Take your pick!

Download Kelly Criterion Calculator

Download our free and easy-to-use Kelly Criterion Calculator on excel by downloading this file! All you need to do is choose which column you want to use (depending on whether you want to input your odds in fractions, decimal or American format) and follow the instructions provided!

How to create your own Kelly Criterion Calculator in Excel

Creating your own Kelly Criterion Calculator in Excel is very easy. Just follow these simple steps.

  • List Icon

    Step 1 – Open a new Excel spreadsheet and create these headers:

Bankroll (How much is your total Bankroll?)
Kelly Staking Fraction (Which percentage of a Full Kelly do you want?)
Outcome 1 (Name the outcome)
Outcome 2 (Name the outcome)
Odds of 1 (The odds offered by bookies)
Odds of 2 (The odds offered by bookies)
Probability of 1 (How likely do you estimate Outcome 1?)
Probability of 2 (How likely do you estimate Outcome 2?)
Stake on 1 (How much should you bet on Outcome 1?)
Stake on 2 (How much should you bet on Outcome 2?)

Kelly Criterion Calculator in Excel Step 2
  • List Icon

    Step 2 – Enter your bankroll and staking fraction (How much of a full Kelly do you want to bet?)

Kelly Criterion Calculator in Excel Step 3
  • List Icon

    Step 3 – Enter the two possible outcomes for the market in 1 outcome and 2. Also, place the market odds in Odds of 1 and Odds of 2. For this example, we will use the odds from our earlier hypothetical matchup between Real Madrid and Manchester United for the Champions League final. (In this case, there is no draw)

Calculator in Excel Step 4
  • List Icon

    Step 4 – Fill in your own estimated probabilities for each outcome

  • List Icon

    Step 5 – Add formulas to Stake on 1 and Stake on 2

Paste this Kelly Criterion excel formula in H2

=((((E2G2)-1)/(E2-1))A2)*B2

Paste this Kelly Criterion formula for excel in I2

=((((F2H2)-1)/(F2-1))A2)*B2
Calculator in Excel Step 5

As you can see, our 50% Half Kelly is exactly half of our earlier calculation for the Full Kelly.

Calculator in Excel Step 6
  • List Icon

    Step 6 – Let’s see how it works for our Horse Racing example.

As you can see, you only need to put odds in for one side of the outcome. Drag the cross cursor down in I2 to get the same formula for I3.

If you want more great calculators, check out our bet calculators page.

ThePuntersPage Final Say

The Kelly Criterion Calculator is a great tool to help you evaluate risk and value in betting. It’s a complicated sum, but our calculator and guide should give you the assist you need to score some great punts, without needing a maths degree.

Kelly criterion calculator faqs

Simply fill in your current betting balance, bookmaker odds, you’re estimate as a percentage, and your fractional Kelly betting as a decimal, and the Kelly betting calculator will give you the ideal amount you should be betting.

Absolutely! You can use the Kelly Criterion betting calculator on any sport and market, if you have enough knowledge in the sport or event to be able to give an accurate probability estimate.

Yes. All you need is the Kelly Criterion formula for excel and a plan. We have a step-by-step guide on how to create it, or you can simply download our readymade excel sheet.

No. The Kelly Criterion calculator is just a staking strategy. As long as you’re not manipulating offers or using loopholes to effect odds, how you choose your stake is of no concern to the bookie.

Yes. The calculation is very versatile and can be used on any sport, event, or market. You just need to make sure that the odds don’t shift while you’re calculating the stake. In that case, you’ll need to start over.

Further reading

ThePuntersPage.com © 2006-2026 ThePuntersPage.com