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

THE FORMULAS AND MATHS OF HEDGING
TO AN "ALL GREEN" SCREEN

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.

On this web page :-
GET THIS RIGHT AND YOU CANNOT LOSE

Bet high and Lay low is the golden rule of hedging for a guaranteed win/win situation.
One of the basic strategies of trading on Betfair is to bet and lay (Hedge) a market move.
A Hedge can be successful on any movement of the odds, up or down.
Odds increasing or odds decreasing dictate the order of Hedge transactions.

Bet first, or lay first ?
In a rising market (odds increasing) Lay first -  Bet 2nd

In a falling market (odds decreasing) Bet first -  Lay 2nd
A Hedge can secure a guaranteed profit, no-matter what the outcome of the race/event.

Hedge formulas and a Hedge Your Bets spreadsheet
Hedge one bet on one selection

Trade a Mathematical Certainty
Hedge Bookie sign-up deposits, and associated Free Bets and Refunds

Hedge Several Bets on 1 selection
Hedge several bets on the same selection

Hedge 3 bets (Football)
Hedge several bets on up to 3 selections

Hedge to a Profit Target

Hedge Formulas.
There are 2 ways of calculating Hedge stakes.
The "Green Up" method uses 3 or more stakes but the best way to Hedge uses only 2 stakes.

  • The advantage of the Green Up method is that calculations are very straightforward.

  • The disadvantages are that it only favours large stakes

  • If you use the Green Up method and want to Hedge using small stakes, you will have to mess about in order to place Bets or Lays at less than the minimum £2 on Betfair

  • This will involve several more Bets or Lays, which of course take more time, and can also lead to mistakes

The Green Up method.
Bet and Lay the same selection to equal amounts, making sure the Bet odds are bigger than the Lay odds.
Divide the profit by the available Lay odds for an
All Green screen.

  • Place a Bet in a falling market, or a Lay in a rising market.

  • When the odds move in your favour, Lay the same amount in the falling market, or a Bet the same amount in the rising market.

  • You now have the equivalent of  a "free" Bet - a win or break even situation.

  • Divide that free Bet profit by the current Lay odds to "Green up" for a win/win situation.

Example.
Suppose we bet £10 on a horse at 10.0  (9/1) in a falling market.
The odds then shorten to 9.0  (8/1), so we Lay the same horse for £10 at odds of 9.0.
Win.   If our selection wins, we win £10 x 9.0 = £90 less Lay liabilities of £10 x 8 = £80 = a profit of £10.
Lose.  If our selection loses, we lose £10 on the bet, but have a successful £10 Lay = Break even, profit = Zero.
To green up, we need to divide the "free" Bet profit of £10 by the current Lay odds, and place a second Lay :-
Lay stake to equalize or green up =  £10 / 9.0 = £1.11.

After equalizing (greening up) :-
If our selection wins, we win £10 x 9.0 = £90 less Lay liabilities of (£10 x 8 = £80) + ( £1.11 x 8  = £8.88) = 88.88 a guaranteed profit of £1.12.
If our selection loses, we lose £10 on the bet, but have successful Lays of £10 + £1.11 = £11.11 profit = £1.11.

That is a simple Hedging method, but the big drawback for a small stakes trader is that in order to place your Lay of £1.11, you would then have to mess about Laying less than the minimum £2 on Betfair.

A rising market with a £10 Lay at odds of 9.0 and a Bet of £10 at odds of 10.0 would again produce a Bet profit of £10 for a win and a break even for a lose.
Suppose the Lay odds rise to 10.0.
Divide the £10 win profit by the current Lay odds (10.0), and Lay £1 at odds of 10.0 to equalize your trade for an All Green Screen profit of £1.00 no-matter what the outcome of the event.
In this £10 example, you would need to Lay at less than the £2 minimum.

A better way to Hedge is to use The 2 Transactions Method to complete your Hedge.
This method works with any size stakes, any size odds. and eliminates the need to place Bets or Lays at less than the £2 minimum.
This Hedging method is ideally suited to the smaller stakes trader.

  • Place a Bet or Lay.

  • When the odds change, place an opposing Bet or Lay, staking to trade out.

Two simple but extremely effective formulas give the stakes required for either a falling or rising market move.
If we Bet first, and the odds shorten, we calculate the stake for our Lay at lower odds.
If we Lay first, and the odds lengthen, we calculate the stake for our Bet at Higher odds.

Example.  Odds shortening.  Bet first, Lay 2nd.
Suppose we bet £10 on a horse at 10.0  (9/1)
The odds then shorten to 9.0  (8/1).
We can Lay £11.11 for a successful Hedge and a guaranteed profit of £1.11 no-matter what the outcome of the race.
Bet = £10 at odds of 10.0
Lay = £11.11 at odds of 9.0
Horse Wins   + £90 less £88.88 lay liability = + £1.12
Horse Loses  + £11.11 successful Lay less £10 losing bet = + £1.11

Odds lengthening.  Lay first, Bet 2nd.
Suppose we Lay £10 on a horse at 9.0  (8/1)
The Bet odds then lengthen to 10.0  (9/1).
We can Bet £9 for a successful Hedge and a guaranteed profit of £1.00 no-matter what the outcome of the race.
Lay = £10 at odds of 9.0
Bet = £9 at odds of 10.0
Horse Wins   + £81 less £80 lay liability = + £1
Horse Loses  + £10 successful Lay less £9 losing bet = + £1

Commission is only payable on profits, so there would be no commission to pay on losing Bets or Lays.
A benefit of this is that a Hedge can be profitable on very small changes in the odds.

If the market moves against you and you have Lay odds higher than Bet odds, the formula to equalize losses is exactly the same, but you will have an all red screen, instead of all green.
In both cases, profit or loss is equalized.

Hedge Your Bets spreadsheet     £5
You will need Excel 2000 or a later version to view this spreadsheet.

Trade using just 2 transactions, a Bet and a Lay, or a Lay and a Bet.
This Hedge Your Bets spreadsheet calculates the bet or lay stake required to make a profit no-matter what the outcome of any event, provided your bet odds are higher than the lay odds.
Input your initial stake and the Bet and Lay odds for instant calculations.
The spreadsheet can be used for trading - you can bet and lay the market for a particular runner, golfer, football team, cricket team, tennis player, etc.
Bet first, or lay first, it makes no difference, providing the bet odds are greater than the lay odds, this spreadsheet covers both eventualities - bet first or lay first.

An additional feature of this Excel spreadsheet is an input that allows you to favour one outcome over the other.
In a football match for instance, a goal may be scored, and you may take the view that one team will probably win the match.
This spreadsheet shows the stake required to trade out to an equal profit win or lose, but a further input allows you to bias your stake in favour of your Bet or your Lay.
In this way, you have the option of boosting your hedge profit for a win or a lose whilst still having insurance cover of a smaller gain if events turn against you.

Note that.
These spreadsheets show the stakes required for a range of 16 different odds, thus eliminating the need to re-input the odds if there is a market move whilst you are trading.

Hedge your Bets and Lays to an All Green Screen.
Make an equal profit no-matter what the outcome, or bias your hedge one way or the other, giving a big or small gain to either side of your trade.
Hedge correctly whilst the odds move in your favour, and you cannot lose.
.

Hedge Your 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
 

Trade Bookies Free Bets for guaranteed winnings.  This is a Hedge strategy.
Trade a Bookie Deposit and Free Bet correctly, and you can guarantee excellent profits on EVERY trade.
It doesn't matter if you hit all winners, all losers, or something in between.
Also, it doesn't matter if your Bet odds are bigger or smaller than your Lay odds
Stake correctly, and you will win EVERY time.

The spreadsheet package offered here is the one I have used very extensively and covers different types
of bookie offers :-

  • Free money such as the Betfair offer.

  • Bet a deposit, free bet stake IS returned with winnings.

  • Bet a deposit, free bet stake is NOT returned with winnings.

  • Bet a deposit, get a percentage added to your winnings, for example treble your winnings.

  • Bet a deposit, get your bet stake refunded if you hit a loser - - a "Lose Only" refund.

This free bets strategy is the only mathematical certainty that I know of in the gambling world.

What profit to expect.
Ask any Betfair trader, and he would be very, very satisfied with a net percentage profit on a normal trade
of  5% to 10%, and if he is honest, he would expect to have losing trades.
When you Trade bookies free bets, you should aim for an 80% profit on your initial deposit from the whole trade, deposit and free bet combined..
Some trades will pay less than 80% of your deposit, but a few may pay more.

Example.  JenningsBet July 2008.  Bet £30, get £30 free.  My Free bet stake was not returned with winnings.

  • Trade £30 deposit.
    JenningsBet.  Bet £30 at Bet odds 2.87,  Lay £30.64 at Betfair odds 2.86 for a small net loss -£0.89

  • Trade Free Bet
    JenningsBet Free Bet £30 at odds 15.0,  Lay £27.18 at Betfair odds 15.5.  Net profit = £25.82

  • Both deposit and free bet selections lost.
    Net profit = Successful Lay of Net £25.82, Less -£0.89 = + £24.93 Net Profit.

That is 83.1% net profit on the initial £30 deposit from the 2 trades combined - the equivalent of a winner at odds of almost 5/6, with no risk.
Note that
if both selections had won, or if there had been one winner and one loser, the net profit would have been almost the same..
The spreadsheet shows the stakes required to equalize your trades whether your selections win or lose - including commission on the Lay side of your trades.
Note also that in the 2nd part of this trade, the Bet odds of 15.0 were lower than the Lay odds of 15.5.

Compared to any normal trade, over 60% net profit ON EVERY TRADE is an absolutely fantastic return.

Here are the maths of my JenningsBet example above showing how my trades were equalized.
Do not be put off by the large liabilities shown below.
I have regularly layed to very large chunks of my Betfair bank, knowing that my overall trade would show a good profit.
It made very little difference whether my JenningsBet selections won or lost :-

Trade £30 deposit Bet + or - Lay Liability Net
Win £30 x odds 2.87 £56.10 Lay £30.64 x odds 2.86 -£56.99 -£0.89
Lose   -£30 £30.64 less 5% +£29.11 -£0.89
Trade £30 Free Bet Bet + or - Lay Liability Net
Win £30 x odds 15.0 £420 £27.18 at odds 15.5. -£394.11 £25.89
Lose Free bet

Zero

£27.18 less 5%   £25.82

Mostly, bookies offer to match your initial deposit with a free bet of the same value.
Usually, the free bet stake is not included with winnings.
Do not look on that as a negative.
It is perfectly normal for a bookie not to return the free bet stake with winnings.
It will not adversely affect your profits.

Stake correctly, and you should NEVER HAVE A LOSING TRADE that involves a bookie deposit and free bet.
You can easily achieve what is described here.

Copyright notice.  In the 5 videos below, Betfair content shown is for demonstration purposes only, and is presented with the kind permission of The Sporting Exchange Limited.  © The Sporting Exchange Limited.

  1. Video 1 demonstrates inputs and how the spreadsheet works.

  2. An example of a Free Bet trade, betting with the bookie and laying on Betfair.

  3. How to save a bit of commission on these trades.

  4. Lay liabilities and exit strategies.

For a bigger view of the videos below, click the icon with 4 small arrows near the bottom right hand corner, just below the " T " in the word "Tube"

 

If you have no bookie accounts at present, you should be able to make £1000 or more clear net profit on just the initial deposits of these offers, if you take advantage of the maximum free bets available.
If you can't do that, I'll eat my spreadsheet.
If you have just a few bookie accounts at present, this is an excellent way of boosting your betting bank.
Don't forget, these trades carry virtually NO RISK.

Free Bets spreadsheet      £10

You will need Excel 2000 or a later version to view this spreadsheet.

This Free Bets spreadsheet calculates the stakes required to trade your bookie deposit and free bets to profit.
Input the size of your deposit or free bet, plus the odds of your selection.
The spreadsheet shows the stakes required to trade to a good profit on the 2 trades --- deposit and free bet.
Also included :-

  • A list of 30 major on-line bookies and exchanges that regularly offer free bets.
    This list also includes information for obtaining extra Free £'s in addition to some of the free bet offers.

  • A banking spreadsheet to record your transactions and track your growing profit.

  • Some bookies offer to match the stake of your first bet, double your winnings, or add a percentage to your winnings.
    An extra spreadsheet covers these offers.

Stake correctly, and the risk is ZERO.  You will win on EVERY trade, deposit + free bet.

Free Bets spreadsheet plus instructions 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
 

Hedge Several Bets on one selection
Suppose you intend placing a series of Bets and Lays to trade to a profit on one selection.
After placing your first Bet or Lay, you can equalize your trade with a single Bet or Lay using the Hedge Your Bets spreadsheet described above, but after a series of Bets and Lays, you would need to know the average odds of your trades in order to trade out with one additional stake.

You can of course set Betfair to consolidate your odds for you, and also set Betfair to show "What if" scenarios.
Then you could juggle your greening up stake to trade out.
Juggling your stakes takes time, and if you are not an experienced trader, it is easy to make a mistake.
Whilst you juggle your stake, the odds may change, so more juggling would be needed.

The spreadsheet below eliminates the need to juggle stakes.
The only inputs required are that you duplicate your Matched Bets and Lays from Betfair onto the spreadsheet, and input odds close to the current odds available on Betfair.
This spreadsheet will then display a range of 16 odds increments and the stakes required at those odds to equalize your trade.
The spreadsheet decides for you whether you need to Bet or Lay, and shows the effect that a range of 16 different stakes at different odds will have on your current position.

If a Bet is required, only Bet odds are shown, with stakes highlighted in Blue.
If a Lay is required, only Lay odds are shown, with stakes highlighted in Pink.
If the odds change, you can decide the size of stake required very quickly, without the need for further input.

Example.  This example uses small stakes, but any size stakes could be used.
A market has Bet odds 2.7, Lay odds 2.68.  You enter those odds on the spreadsheet.
You judge that the odds will shorten, so you offer a £10 Bet at 2.72.
The market moves against your expectations.
Your offer of £10 Bet at 2.72 gets matched.
You enter Bet Odds 2.72 stake £10 on the spreadsheet.

The spreadsheet shows immediately that a Lay is required, and displays a range of odds 2.54 to 2.84, and the Lay stakes required to equalize your trade at any of that range of odds.
The spreadsheet shows a profit of £0.71 for a £10.71 Lay at odds of 2.54 through all increments to a loss of £-0.42 for a Lay of £9.58 at odds of 2.84. 
You decide that the odds may continue to lengthen, so you Lay £20 at odds of 2.74.
Your Lay gets matched so you enter those details on the spreadsheet.
The spreadsheet now indicates that a Bet would be required to equalize.
The spreadsheet shows the Bet stakes required to equalize your trade through a range of odds 2.56 to 2.86.

The spreadsheet shows a loss of £-0.78 for a Bet of £10.78 at odds of 2.56 through all increments to a profit of £0.35 for a Bet of £9.65 at odds of 2.86.  The break even Bet is £10 at odds of 2.76.

You may continue to Bet and Lay.
As you enter your Matched Bets and Lays on the spreadsheet to mirror what is happening on Betfair, the spreadsheet decides for you whether you need to Bet or Lay to equalize your trades, and shows a range of odds and stakes.
The effect that each of those stakes would have on your current market position is shown.

This spreadsheet does not interact with the betting exchange, but is a very good alternative to renting an interactive interface.


Hedge Several Bets spreadsheet     £10
You will need Excel 2000 or a later version to view this spreadsheet.

This Hedge Several Bets spreadsheet is ideal for trading several transactions on a single runner, team, etc.
This spreadsheet calculates instantly the bet or lay stake required to equalize your trade.
Input the odds of your Bets and Lays to mirror your Matched Bets and Lays on Betfair and the spreadsheet :-

  • Shows your current position in the market.

  • Decides for you whether you need to bet or Lay in order to equalize your trade.

  • Shows 16 odds increments, with associated stakes for equalization.

  • Shows the effect that equalizing at each of those 16 odds would have on your present position.

  • Allows 20 Bet and 20 Lay matched inputs.

The spreadsheet can be used for trading - you can bet and lay a market for a particular runner, golfer, football team, cricket team, tennis player, etc.
Bet first, or lay first, it makes no difference, this spreadsheet will decide for you what you need to do next to equalize your trade, and will display a range of stakes required.

Use this spreadsheet to place a single Bet and Lay, or a series of Bets and Lays to an All Green Screen.
Stake and Hedge correctly, and you cannot lose.

Customer feedback.
I find your spreadsheet very easy to use.
I always have it open now when trading football matches.
When a goal goes in I can quickly calculate what I need to do to "green up".
I no longer have to worry about making a mistake in the heat of the moment!  .........John

Hedge Several Bets 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
 

Hedge 3 bets.
This Hedge 3 Bets spreadsheet was built specifically for trading the 3 outcomes of the Match Odds market in football matches, but you can use this spreadsheet to Bet and Lay 1, 2, or 3 selections in any market.
The only inputs required are your matched bets, to mirror your matched bets on Betfair, and the current odds.

Hedge (Bet and Lay) up to 3 selections in any event - football, cricket, tennis, darts, horses, etc.
This Hedge 3 Bets spreadsheet will enable you to keep track of exactly what you are doing whilst placing a series of Bets and Lays.

  • Your position in the market is shown at all times for each individual selection.

  • Your overall position is shown for all 3 selections combined.

  • You can see exactly where you stand in the market at all times.

  • The spreadsheet shows what you need to do next Bet or Lay, to equalize each trade.

  • Equalizing stakes are shown over a range of 9 odds increments, 4 either side of your current odds.
    As the odds change within those 9 increments, there is no need to update the odds on the spreadsheet.

  •  Plan your next move.
    The spreadsheet shows the effect that equalizing at each of those 9 odds would have on your present position
  • You can input Bets or Lays on the spreadsheet to see "What If" situations, whilst the game progresses, without messing about on Betfair.

Copyright notice.  In the 3 videos below, Betfair content shown is for demonstration purposes only, and is presented with the kind permission of The Sporting Exchange Limited.  © The Sporting Exchange Limited.

These videos demonstrate the Hedge 3 Bets spreadsheet - how it works and what it can do.
For a bigger view of the videos below, click the icon with 4 small arrows near the bottom right hand corner, just below the " T " in the word "Tube".

 


Hedge 3 Bets spreadsheet     £10
You will need Excel 2000 or a later version to view this spreadsheet.

This Hedge 3 Bets spreadsheet is ideal for trading several transactions on up to 3 selections.
The spreadsheet calculates instantly the Bet or Lay stake required to equalize your trades.
Input the odds of your Bets and Lays to mirror your Matched Bets and Lays on Betfair, plus the current odds, and the spreadsheet :-

  • Shows your current position in the market for each individual selection..

  • Shows your current position in the market for all 3 combined selections.

  • Decides for you whether you need to bet or Lay in order to equalize your trade.

  • Shows 9 odds increments, with associated stakes for equalization.

  • Shows the effect that equalizing at each of those 9 odds would have on your present position.

  • Allows 10 Bet and 10 Lay matched inputs for all 3 selections (60 in total).

The spreadsheet can be used for trading - you can bet and lay a market for a single runner, golfer, football team, cricket team, tennis player, etc., or up to 3 selections.
Bet first, or lay first, it makes no difference, this spreadsheet will decide for you what you need to do next to equalize your trade, and will display a range of stakes required.

Use this spreadsheet to place a single Bet and Lay, or a series of Bets and Lays aiming for an an All Green Screen.

Hedge 3 Bets 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
 

Hedge to a Profit Target.
As with most other forms of betting, it is possible to win a specific profit from Hedging.
It isn't easy to forecast a market move, and most of us can't even predict which way the market will turn, but if you have your own views, you can trade to a specific profit using a Profit Target Hedging spreadsheet.
The Hedge to a Profit Target spreadsheet available below may be used to work to a staking plan, or to recover lost stakes etc..

Example.
Bet odds stand at 3.1.  You anticipate Lay odds of 3.0.
You would like to make a 2 Tick Hedge profit (3.0, 3.05, 3.1) of £1.
The stakes required are Bet £30 at odds of 3.1, Lay £31 at odds of 3.0.
Win.   £30 x 2.1 = £63, less Lay liabilities of £31 x 2 = £62.  Profit = £1.
Lose.  £31 successful Lay, less losing Bet of £30 = £1 profit.

Bet odds stand at 3.2.  You anticipate Lay odds 3.0.
You would like to make a 4 Tick Hedge profit (3.0, 3.05, 3.1, 3.15, 3.2) of £1.
The stakes required are Bet £15 at odds of 3.2, Lay £16 at odds of 3.0.
Win.   £15 x 2.2 = £33, less Lay liabilities of £16 x 2 = £32.  Profit = £1.
Lose.  £16 successful Lay, less losing Bet of £15 = £1 profit.

I would guess that at the time of writing, January 2008, this calculation is not available elsewhere.
The only inputs required to Hedge to make a specific profit using this spreadsheet are the Bet and Lay odds, and and the amount £ you would like to win.
The number of wagers is 2, a Bet and a Lay.


Hedge to a Profit Target spreadsheet     £5
You will need Excel 2000 or a later version to view this spreadsheet.

This Hedge to a Profit Target spreadsheet calculates  the bet or lay stakes required to make a specific profit no-matter what the outcome of any event, provided the bet odds are higher than the lay odds.
Input your required winnings and the Bet and Lay odds for instant calculations.
The spreadsheet can be used for trading - you can bet and lay the market for a particular runner, golfer, football team, cricket team, tennis player, etc.
Bet first, or lay first, it makes no difference, providing the bet odds are greater than the lay odds, this spreadsheet covers both eventualities - bet first or lay first.

Note that.
These spreadsheets show the stakes required for a range of 16 different odds, thus eliminating the need to re-input the odds if there is a market move whilst you are trading.

An additional feature of this Excel spreadsheet is an input that allows you to favour one outcome over the other.
You may take the view that your selection will win, or lose.
This spreadsheet shows the stakes required to trade out to an equal profit win or lose, but a further Adjust input allows you to bias your stake in favour of your Bet or your Lay.
In this way, you have the option of boosting your hedge profit for a win or a lose whilst still having insurance cover of a smaller gain if events turn against you.

Hedge your Bet and Lay to an All Green Profit Target making an equal profit no-matter what the outcome.
Alternatively, bias your hedge one way or the other, giving a big or small gain to either side of your trade.
Hedge correctly whilst the odds move in your favour, and you cannot lose.

"It's a nice spreadsheet - just what I was looking for !"   Cheers, John.

Hedge to a Profit Target 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
 

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