A list of all my spreadsheets
lives here :-
betandlay.co.uk/strategies
Strategies for horse racing and football trading

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.

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.

After payment via
PayPal, select the "Return to merchant" option on the PayPal
screen.
PayPal should then route you to a download web page where you can obtain
the Excel spreadsheet file.

Be A Bookie
spreadsheet price = £5.
Payment is by PayPal, but you don't need a PayPal account to use the
payment button below.

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.

After payment via
PayPal, select the "Return to merchant" option on the PayPal
screen.
PayPal should then route you to a download web page where you can obtain
the Excel spreadsheet file.

Hedge Your Bookie Bets
spreadsheet price = £5.
Payment is by PayPal, but you don't need a PayPal account to use the
payment button below.

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.

After payment via
PayPal, select the "Return to merchant" option on the PayPal
screen.
PayPal should then route you to a download web page where you can obtain
the Excel spreadsheet file.

Each Way Arbing spreadsheet price =
£10.
Payment is by PayPal, but you don't need a PayPal account to use the
payment button below.