Excel for Betting / Trading

A collection of simple Excel spreadsheets for basic betting and trading calculations.

  • Asian Handicap

    This spreadsheet allows you to quickly calculate outcome of your Asian Handicap bet, for all full goal, half-goal and quarter-goal lines for both Home/Away and Total Goals (Over/Under) markets.

    Just select your handicap line, enter odds and stakes, and there you are!

    Excel 2007 file, 20 kB

  • Calculator of Double Chance and DNB Odds (Asian Handicap (0) odds)

    These calculators allow 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 1X2 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%.

    Calculation of AH(0) odds; based upon Punters Lounge thread Asian handicap formulas.

    Excel 2003 file, 15 kB.

  • Bet history records

    Spreadsheets for tracking your bets

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

    Download

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

    Download

    Bets record and staking plan with each-way option.

    Download

    Bets record for lay bets, with fixed liability untill initial bank is recovered.

    Download

    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.

    Tired of keeping record of your bets in Excel, and coping with its functions?

    Then try free online services such as Bet Magnet or MyBetLog, that will let you easily keep record of all the bets you make.

  • Time of first goal

    Spreadsheet that extracts statistics of time of first goal from raw data available at CGMBet.com, and occurence of second goal based on time of first goal.

    Detailed instructions on how to use the spreadsheet can be found within respective thread at Geeks Toy forum.

  • Using Poisson Calculator to predict outcome of football matches

    One of the ways (though, not necessarilly the best one) to turn goal expectations into odds is Poisson distribution.

    Poisson calulator spreadsheet allows for two calculations, "Total Goals" and "Correct Score". Just enter goal expectations of both teams into yellow cells, and it will return probabilities and odds of 1X2 and Over/Under outcomes.

    Though, you need to be aware that Poisson distribution, when applied to predict football matches, has certain flaws and limitations; there are numerous sources on that topic, and you can read, for example, ones from Pinnacle and Shots On Target before using the calculator, to understand the pitfalls!

  • Bet Calculator

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

    I'd like to thank to Garreth, who discovered and reported an error on this spreadsheet: returns for single bets on sheets above 4-folds were inaccurate (while profits themselves were accurate, though). The error has been corrected and new spreadsheet uploaded on 24. September 2014; if you downloaded this spreadsheet before, please download the new one!

    Excel 2003 file, 500 kB

  • Correct Score market

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

    Excel 2003 file, 26 kB

  • Odds conversion

    Converting between decimal and fractional odds.

    Excel 2003 file, 18 kB

  • Yankee

    Calculation of profit / loss on Yankee bet, and comparison with singles / accumulator.

    Based on Punters Lounge thread Yankee Bet?.

    Excel 2003 file, 26 kB

  • 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 file, 19 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.

    Based upon Punters Lounge thread Need help for a 24 selection bet calculation.

    Excel 2003 file, 25 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 Punters Lounge thread What do I need to know to use Poisson? Spreadsheet contains example for beginning of the season in Championship 2010/2011, but it didn't prove to be successfull.

    Excel 2003 file, 5 MB

  • The Perfect Martingale System

    Spreadsheet created upon Punters 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 file, 35 kB

  • Upcoming fixtures from BetExplorer

    Excel file that "scrapes" upcoming fixtures from BetExplorer.com, reading the text file rather than a web query, created by longstanding PuntersLounge's member Accu-JD.

    Fixtures: options (today, tomorrow + no. of days (0 - +7 days)
    Sports: Soccer and hockey
    Preferred leagues: - you can choose only certain leagues to be downloaded.
    Markets: 1X2, Over/Under, Asian Handicap

    Excel 2007 file, with macro, 65 kB