Arbitrage and Arbing Software          Be the Bookie          Bet high Lay low for guaranteed profits          Bookie Lay strategies          Lay the bookies favourite bets          Break the bank staking plan

Formulas and Maths Of Arbitrage

This betformulas.co.uk website will be ceased in early May 2024.

All Excel spreadsheets are now available on my updated betandlay.co.uk website.

Visit betandlay.co.uk
Staking solutions for Exchanges :- Football, Horses, Staking Plans, Multiples, and Free on-line Calculators.

Arbitrage.
An Arbitrage or Arb, is a transaction that takes advantage of price differences offered by different bookies and betting exchanges for the same event.
The event may be a horse race, football match, tennis game, or even a television talent show, but whatever the event, we only need prices offered by bookies to differ slightly in order to place a profitable Arb.

No-matter what the subject of the Arb,  we need to find prices offered which allow us to Dutch the market of an under-round book, in order to make a guaranteed profit.

The Basics.  Odds as a percentage.
To recognize an Arb, we need to understand odds expressed as a percentage.

To calculate the percentage of your odds, divide the decimal "Betfair" odds into 100.
For example, we know that even money is a 50 - 50 chance, so evens should equal 50%.
Decimal "Betfair" odds for even money is 2.0.
100 divided by 2 = 50%

To calculate the percentage of fractional odds, add 1 to your odds and divide into 100.
For example, evens (1/1) + 1 = 2.0
100 divided by 2 = 50%

Another example, 3/1 + 1 = 4.
100 divided by 4 = 25%

Over-round and under-round of a book.
An Arb situation exists when the odds available from a selection of bookies allow us to place bets covering all outcomes of an event, and the odds obtained for our bets give us an under-round book.

Over-round or under-round is calculated by expressing all the odds of an event as a percentage, and adding them together.
If the total is more than 100%, the book is over-round, if less than 100%, the book is under-round.

The simplest Arb is an event with just 2 possible outcomes, such as a tennis match, where a draw is virtually an impossibility - either one player or the other will be declared the winner.
Other Arbs may involve 3 outcomes such as a boxing or football match which involve 2 wins and a draw, or an event with many outcomes such as a television talent show.

Making a book.
For example, a horse race has runners priced at evens, 3/1, 4/1 and 9/1.
1/1 is 2.0 in decimal odds, so 100 / 2 = 50%
3/1 is 4.0 in decimal odds, so 100 / 4 = 25%
4/1 is 5.0 in decimal odds, so 100 / 5 = 20%
9/1 is 10.0 decimal odds, so 100 / 10 = 10%
Adding all those percentages together gives 105%.  Our book is 5% over-round.
If we only had evens, 3/1, and 4/1, our book would be 95%, so would be 5% under-round.

Arb example.
Suppose we were interested in a tennis match.
We could look at a selection of bookmakers and compare the odds on offer :-

Bookmakers

Player A

Player B

Book %

 

Lads

Evens (2.0)

4/5 (1.8)

50 + 55.56 = 105.56%

Over-round

Hills

Evens (2.0)

4/5 (1.8)

50 + 55.56 = 105.56%

Over-round

Tote

Evens (2.0)

4/5 (1.8)

50 + 55.56 = 105.56%

Over-round

Coral

6/4      (2.5)

8/13 (1.61)

40 + 62.11 = 106.56%

Over-round

In this fictitious event, Coral take a slightly different view of the outcome.
Although each bookie has an over-round book of 105% or 106%, we can bet UNDER-round by betting with different bookies and obtaining odds of 6/4 (2.5) and 4/5 (1.8).
Those odds give a percentage of 40 + 55.56 = 95.56 which is under-round by 4.44%.

We can eliminate gambling and make a guaranteed profit on this match by Dutching both outcomes for an equal profit, no-matter what the outcome.
Whether Player A wins or Player B wins in irrelevant.
Get this right, and you cannot lose.
This is the equivalent of an "All Green Screen" on Betfair.

There is no need to learn any complicated math's in order to Dutch or Arb.
An Excel spreadsheet can easily work out stakes as fast as you can type, and will also eliminate mathematical errors.

Note that this spreadsheet limits your Total Stakes to a set £ amount.
In order to keep the Total Stake at a set amount input by the user, this spreadsheet does not use the percentage calculations described above.

Excel spreadsheets are a quick and reliable way of doing calculations.
You can build a spreadsheet using the percentage formulas above, or purchase an excellent spreadsheet here for only a fiver.
Be A Bookie spreadsheet.
You will need Excel 2000 or a later version to view this spreadsheet.

 Watch an on-line demo of the Be_A_Bookie spreadsheet

This Be A Bookie spreadsheet calculates the lay stakes required to Lay up to 25 selections to an equal liability.
You could of course use this spreadsheet for any event other than horse racing.
A 2nd spreadsheet within this Excel file
calculates the bet stakes required to bet up to 25 selections to an equal profit.

Input the amount of your Total Payout, and as you input the odds of your selections, the spreadsheet shows :-

  • Total payout on any winner remaining constant at your original input.

  • The Lay stake or bet stake required for each runner.

  • Equal liabilities or profit against each runner.

  • Liability on each runner reducing as more runners are Layed.

  • Profit on each runner that you have Bet.

  • Percentage of your book at all stages.

  • Total of Lay stakes at all stages - - - the "Skinner" amount.

  • OR, total of bet stakes if you are betting.

The more runners you Lay, the less your liabilities become.
The more runners you Lay, the bigger the payout on a "Skinner" - a horse you haven't layed.
The Betting spreadsheet can be used for Arbitrage of any event.
Bet all runners for a book percentage that is less than 100% and you have guaranteed winnings with zero risk.
These zero risk trades are available daily.

Note that this spreadsheet is also available on the Dutching and Laying web pages.

Be A Bookie spreadsheet price = £5.
Please use this
Contact me link to arrange payment within PayPal.
Delivery will be by e-mail

Please include the name of this spreadsheet when you Contact me to arrange payment and delivery

 

Hedge a bookie bet.
The name "Arbing" is also often applied to the strategy of betting with a bookie and laying the same selection on a betting exchange.
This is in fact a Hedge strategy.
This is a very well known method of trading to guaranteed winnings no-matter what the result of a horse race, football match or any other event.
When making these trades, and "Arber" will compare the bet odds offered by a bookie with the lay odds available on a betting exchange such as Betfair.
If the bookie bet odds are bigger than the Betfair lay odds, guaranteed winnings are there to be traded, but commission on the lay side of the trade needs to be taken into consideration.
To make guaranteed winnings from these trades, usually more than one tick difference between bet and lay odds will be required.

An alternative strategy to trading in this way for an equal win or lose profit is to bias the staking to favour a win outcome.
The theory here is that in making these trades, we are continually betting at good value odds with the bookie, so in the long term the profit from hitting winners should outweigh the profit from hitting losers.. . . . That's the basic theory.
To make that pay, the lay stake is adjusted for zero profit or loss on a loser, which gives a bigger profit if we hit a winner.
We then trade a load of races (these trades are usually done in volatile horse race markets), and make a profit from every winner whilst breaking even on all the losers.

The spreadsheet below can be used to make these trades.
A second spreadsheet in this Excel file shows the lay stake required to break even if we hit a loser.
Input the size of your bet stake with the bookie, plus the bet and lay odds and the spreadsheet shows a range of lay odds and stakes for trading to zero loss on losers after commission deductions, and a profit if we hit a winner.
Remember that with commission built into these calculations, to make a profit, you will probably need 2 or 3 ticks or more difference between the bookie bet odds and the Betfair lay odds when you make these trades.

Excel spreadsheets are a quick and reliable way of doing calculations.
You can build a spreadsheet to trade the strategy described above, or purchase an excellent spreadsheet here for only a fiver.
Hedge Your Bookie Bets spreadsheet.
You will need Excel 2000 or a later version to view this spreadsheet.

Input the amount of your Bet Stake with the bookie.
Input the bookie bet odds and the Betfair lay odds and the spreadsheet shows :-

  • A range of lay odds and lay stakes

  • Equal profit or loss if we then lay at any of those odds using the lay stake shown..

  • The liability of your lay.

  • An alternative spreadsheet allows us to bias the staking to favour a win outcome and break even on all losers.

  • Commission is built into the lay side of the calculations.
    If we hit a loser, we would pay commission on our successful lay stake.
    If we hit a winner, we have bet winnings with the bookie, but lay liabilities with Betfair, so there would be zero Betfair commission to pay.

Hedge Your Bookie Bets spreadsheet price = £5.

Please use this Contact me link to arrange payment within PayPal.
Delivery will be by e-mail

Please include the name of this spreadsheet when you Contact me to arrange payment and delivery

 

Bet Each Way with a bookie and lay win and place in Betfair.
When a bookie accepts your each way bet, the odds of the Place part of your bet are fixed by the bookie's Win odds.
The most common place terms are a fifth of the win odds or a quarter the win odds if our horse or other selection is placed.

In Betfair, the Place market odds are totally detached from the Win market odds, so it is very unlikely that the place odds in Betfair will be a fifth or a quarter of the odds in Betfair's Win market.
If we can find Lay odds in Betfair that are smaller than bookie Win and Place bet odds, we can trade for guaranteed winnings whatever the result of our horse race or other event.

An advantage of an Each Way Arb, is that it is not essential to make a profit from both the win and place parts of the trade.
For example, the win part of our trade might only break even or maybe make a small loss, whilst the place part of the trade makes a profit that puts the whole trade into profit.

There are of course 3 possible outcomes for an Each Way bet :-
Our runner wins, is placed, or is unplaced.
Whatever the bet and lay odds, we can bet with a bookie and lay both Win and Place markets in Betfair and equalize our trade for an equal profit or loss on all 3 possible results - Win, Place or Unplaced.
If we can bet with a bookie and lay with suitable odds in Betfair, we can stake to equalize our whole Each Way trade for guaranteed winnings - - - -  a zero risk profit whatever happens to our runner.
Such trading opportunities will not be numerous, but they are there every day in horse races if you are prepared to look for them.

The spreadsheet below can be used to make these trades.

Trade like a Pro.
An alternative to equalizing our Each Way trade across all 3 possible outcomes, is to bias the staking a little to favour  the Win and Placed outcomes over the Unplaced outcome.
A second spreadsheet in this Excel file shows the lay stake required to break even if our runner is unplaced, but show an increased profit if it wins or is placed.
Pro traders will use this technique to increase profit in the long term from their Each Way trades.

Input the size of your Each Way bet stake with the bookie, plus the bookie bet odds and Betfair lay odds from the win market and the place market.
The spreadsheet shows a range of lay odds and stakes for both Win and Place markets in Betfair, which enable us to trade to zero loss on an unplaced runner.
Commission deductions are built into the calculations.

Apologies for the poor quality of the sound recording in this video.
For a bigger view
of the video below, click the icon with 4 small arrows near the bottom right hand corner of the YouTube screen

 

This spreadsheet can be used to trade the Each Way Arbing strategy described above.

 Each Way Arbing spreadsheet    £10.
You will need Excel 2007 or a later version to view this spreadsheet.
The spreadsheet should also work using Open Office.

Input the amount of your Each Way Bet Stake with the bookie.
Input the bookie bet odds and the Betfair lay odds from the Win and Place markets and the spreadsheet shows :-

  • A range of lay odds and lay stakes for both win and place markets

  • Equal profit or loss if we lay at any of those odds using the lay stakes shown..

  • The liability of both of your lays.

  • An alternative spreadsheet allows us to bias the staking to favour a win or place outcome, and break even on an unplaced runner.

  • Commission is built into the lay side of the calculations.
    If our runner is unplaced, we would pay commission on our 2 successful lay stakes.
    If our runner is placed, we have commission to pay on our successful lay in the Betfair Win market.
    If we hit a winner, we have bet winnings with the bookie, but lay liabilities in both Betfair markets.

 Each Way Arbing spreadsheet price = £10.

Please use this Contact me link to arrange payment within PayPal.
Delivery will be by e-mail

Please include the name of this spreadsheet when you Contact me to arrange payment and delivery

Contact me
Copyright © H. Hutchinson 2019 All rights reserved
Copying text or any other kind of content from a web site is a criminal offence.

How copyright protects your creative work

 

Intellectual property