A collection of simple Excel spreadsheets
for basic betting / trading calculations

Match Odds market

Simulation of profit/loss at Betfair’s Match odds market.
File created after Geeks Toy Forum thread A Query based on Market Sports Trader Blog

Excel 2003 file, 25 kB

Correct Score market

Simulation of profit/loss at Betfair’s Correct score market.

Excel 2003 file, 26 kB

Bet Calculator

Comparison of profits for Full Cover Bets with or without singles, Singles and Accumulators, in a single screen, up to 8 selections.
Excel 2003 file, 500 kB

Poisson Calculator
Probability / Odds of expected number of goals using Poisson distribution

If you have some expectation of number of goals in a match, one of the best ways to turn them into odds is Poisson distribution; it will give you probability of certain number of goals to be scored, and dividing 100 with probability gives you odds.

This spreadsheet has two sheets, “Total Goals” and “Correct Score”.

  • If you have expected number of goals for both teams altogether (i.e., for entire match), use sheet “Total Goals”: enter your expected number of goals into yellow cell, and it will return probabilities / odds for goal lines.
  • If you have expected number of goals for each team separately, use sheet “Correct Score”: enter your expected number of goals into yellow cells for both teams, and it will return probabilities / odds for correct scores.

Excel 2003 file, 30 kB.

Leaning Towards Average

Strategy to evaluate expected match outcome and expected number of goals on the basis of recent team performance in comparison to “average” team performance, assuming that as the season goes by, average number of goals scored and conceded by each team is more accurately defined, thus allowing comparison of team performance against average performance; therefore I named this strategy Leaning Towards Average.
This strategy has been inspired by article at Understanding Uncertainty blog, and later on discussed in Punter’s Lounge thread What do I need to know to use Poisson?.
Spreadsheet contains example for beginning of the season in Championship 2010/2011.
Excel 2003 file, 5 MB

Hedging Calculator

Calculation of back / lay stakes when trading (“greening up” and “Redding up”); calculation for equal profit / loss, or calculation of profit / loss for desired stakes.
Excel 2003, 19 kB.

Calculator of Double Chance and DNB Odds

This calculator allows calculation of Double Chance and DNB (Draw No Bet, Asian Handicap (0)) Odds based on 1X2 Odds.
Excel 2003 file, 25 kB

A reply to wasai’s comment, 28. December 2011: Overround of DNB odds is not given in advance, it cannot be set before calculation. DNB odds are calculated on the basis of 1×2 odds/probabilities.
So, in this example, overround is 114.22%, and odds were taken from real bookmaker’s offer. If bookmaker offered higher odds, for example, 2.40 on Home Win, 3.20 on Draw and 3.05 on Away Win, overround of DNB would be 108.30%.

Bet history records

Spreadsheets for recording bets history

Simple bets record, with two sheets (betting at bookmaker, and back-lay at exchange) and profit/loss charts.
Excel 2003, 218 kB.

Bets record all-in type (entire bank in), with constant or variable odds.
Excel 2003, 106 kB.

Bets record and staking plan with each-way option; based upon Punters Lounge thread Excel formula help (staking plan related).
Excel 2003, 40 kB.

Bets record for lay bets, with fixed liability untill initial bank is recovered; based upon polishMagic’s thread at Punters Lounge forum.
Excel 2003, 60 kB.

So, you want to know why keeping records of your bets is essential for long-term profit?!
Read careful analysis of Top 3 Benefits of good record keeping of your bets out there at Sports Trading Life.
Link:
sportstradinglife.com/2012/03/record-keeping-the-top-3-benefits

Tired of keeping record of your bets in Excel, and coping with its functions?
Then try Bet Magnet, free service that will let you easily keep record of all the bets you make. You can enter what you are betting on, at which sportsbook, in which currency, for which odds and from which source. After you settle your bets you can see all your results combined or split by almost any criteria you can imagine.
Link:
www.betmagnet.com

Yankee

Calculation of profit / loss on Yankee bet, and comparison with singles / accumulator.
Based on Punter’s Lounge thread Yankee Bet?

Excel 2003, 30 kB

Asian Handycap (0) odds

Calculation of AH(0) odds; based upon Punter’s Lounge thread Asian handicap formulas.
Excel 2003, 15 kB.

The Perfect Martingale System

Spreadsheet created upon Punter’s Lounge thread The Perfect Martingale System:

The rules are simple. I will lay Under 1.5 Goals for a £10 stake. After one goal I will then lay Under 2.5 Goals for my £10 stake + the liability for the first bet. If another goal is scored I will lay Under 3.5 Goals for my £10 stake + all the previous liability. I will keep going until the the 87th minute. To protect me against a goal in injury time I will then lay the current correct score to cover all my liability on the Under markets.

Excel 2003, 35 kB.

Odds conversion

Converting between decimal and fractional odds.
Excel 2003, 18 kB.

Extracting 1X2 odds from AH odds

A try to extract empirical relationship between 1X2 odds and AH odds; based on PuntersLounge thread Extracting true odds need a bit of help with theory.

Excel 2003 file, 65 kB.

Assigning probabilities to ratings

Spreadsheet for solution to Punter’s Lounge query
Assigning probabilities to ratings – Excel help.

Excel 2003 file, 150 kB.

Calculating number of combinations and profit/loss on different folds

Calculation of number of folds from specific number of selections, and potential profit assuming the same odds for all selections.
Created after Punter’s Lounge thread Need help for a 24 selection bet calculation.
Excel 2003 file, 25 kB.

See also Betting Calculator, online tool for system bet calculation.

All spreadsheets above have been created out of hobby; they are protected, in order to avoid unintentional changes, but not password protected, so if you need to alter anything, just unprotect them from menu Tools – Protection – Unprotect Sheet (Excel 2003), or Review – Unprotect (Excel 2007).

You are free to use and alter spreadsheets in any way you want, without any charge, as long as you don’t hold me responsible for any losses you may incur after using them! :mrgreen:

So, you want more free Excel spreadsheets, eh?!

Premier League Predictions at Betfair Banter forum

Each week I am trying to beat the Betfair Premier League Football odds by comparing my estimations of the probability of each outcome with the Betfair odds and betting on the one that differs the most.

The spread sheet does the maths for you, even if you want to use Kelly staking rather than level stakes, all you have to do is input your % estimations and the Betfair odds and the sheet will tell you who to bet on.

It’s pretty good fun so why not have a go yourself!

http://www.betfairbanter.com/forum/viewtopic.php?f=7&t=6

Keeping records, by Betfair Banter forum

We all know how important it is to keep record of your betting and I’ve decided to up my game in this area of my betting too.

I’ve created a spreadsheet that allows me to keep track of all my bets in different sports and tell me how well I’m doing in each. It also tells me how well my bets fair with level stakes so I can see whether I’m winning or losing due to poor staking or upping my stakes too early.

http://www.betfairbanter.com/forum/viewtopic.php?f=20&t=13

Michael Wray’s Free Football Spreadsheets

  • European Champions League
    • Fixtures and tables using precise UEFA methodology, including non-iterative head-to-head logic
    • Summary of each competition since inaugural 1955/56 season
    • Individual team stats for every club to have ever played in the tournament since inaugural 1955/56 season
    • National stats for each country in UEFA
    • Head-to-head stats for each country in UEFA
    • Head-to-head results for every club to have ever played in the tournament
    • National opposition stats for every club to have ever played in the tournament
    • Full tournament results for every past year of the tournament, available by both season and club
  • 2011/12 season Leagues
    • Fixtures and tables using precise methodology relevant to each league, including non-iterative head-to-head logic
    • Playoffs, where relevant
    • Colour-coded results and fixture grids
    • Chart of points accumulation during season
    • Chart of league positions during season
    • Club statistics on season results
    • Division statistics on season results
    • Strength of opposition table for both remaining games and played games
    • Points deductions
    • Prediction engine, dynamically calculated from current form and past meetings between clubs
    • The ability to enter your own predictions and see resulting table
    • Recent head-to-head league results for the last five seasons (Germany & Conference)
    • Head-to-head league results for all-time (English & Australian/NZ Leagues)
    • Historic league positions pedigree (English & Australian/NZ divisions only)
    • Historic league statistics (English divisions only)

Link:
www.michaelwray.co.nz

You might enjoy Punter’s Lounge thread Return to Oz and the Michael Wray Experiment, that has been based upon these sheets, and is one of the longest lived PL threads, with more than twenty hundreds of posts over the course of almost five years!

Link:
forum.punterslounge.com/f21/return-oz-michael-wray-experiment-31767