How the odds perform in football matchesDutch football matches on BetfairHedge football matches on BetfairLay football matches on Betfair  

Dutch and Hedge a Football Match on Betfair or other exchange.
Bet or lay several selections in 1 or 2 markets, using a spreadsheet
to show your overall position across both markets, including commission deductions.

List of all available spreadsheets.

Spreadsheets designed for combining Correct Score with other markets

Dutch and Hedge in 2or 3 Betfair football markets using an Excel spreadsheet to show the effect of commission across the 2 or 3 markets combined.

If we bet and lay in 2 or 3 related football markets, Betfair is unable to show our whole market position across more than one market.
Betfair cannot show losses or gains in 2 or 3 markets combined, so will only show our market position in each individual market.

The football "Dutch and Hedge" spreadsheets below overcome that problem by showing our total market position across 2 or 3 markets, including commission deductions.
The Dutch and Hedge spreadsheets below were designed for use in football markets but may also be suitable for trading across 2 o 3 related markets in other sports if you find suitable markets.

Also on this web page

Trade Correct Score & one other market.
Place any number of bets.
See your overall position across both Betfair markets

Dutch and hedge 2 markets

Other web sites with spreadsheets

betformulas.co.uk
Formulas and maths of trading

betandlay.co.uk/strategies
Strategies for trading Horses and Football

Place ANY NUMBER OF BETS in your Correct Score trades, and use an Excel spreadsheet to see your overall position
across 2 or 3 markets including commission deductions.

The   New  3 Markets spreadsheet available here shows :-

  • The staking required to Dutch and hedge 3 markets using the balanced staking of Dutching,
  • Alternatively, use it to Bet and Lay your trade using any stake sizes of your choice . . . . Do It Yourself . . . . . "Ad-lib" your staking
  • or use the sheet to combine both . . . . . . . Dutching stakes  and your "Ad-lib" stakes.

The spreadsheet below shows the effect of commission deductions across 3 Betfair markets, to show the overall position of your trade.
Any number of bets can be entered into the spreadsheet for any selection.
After entering bets, enter lay odds, and the spreadsheet shows the lay stake required to Hedge any particular bets for an equal profit or loss - - - - - a "Green Up" facility.

This sheet can accommodate any number of bets.
Input odds and stakes info for your bets, and the sheet combines those to show combined bet odds.
We can now see what odds we need to lay at for a successful bet and lay Hedge of any score, or anything else we have bet such as
Under / Over Goals, etc. in another market.
If you have seen my other spreadsheets further down this web page for single Dutched stakes and laying to equalize, you will see that this new sheet uses the same layout.

The spreadsheet is set up to cover the Correct Score market, and up to 4 selections in a 2nd market, and up to 4 selections in a 3rd market..
It could be used for "Paper trade" practice purposes, or to help with staking of live trades.

This "3 Markets" spreadsheet is an expanded version of the 2 Markets spreadsheet described in video just below.

Bet first, lay 2nd - - - -  Dutch and Hedge 3 Betfair markets placing SEVERAL BETS per selection if required      20
Use this spreadsheet to bet in 3 different markets.
Any number of bets can be placed on any selection or selections.
At any time, enter lay odds to see the lay stake required to equalize any selection for an equal profit or loss on that part of the trade.
The spreadsheet shows our whole market position after commission deductions, across both markets combined.

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.

20

__________________________________________

The   New 2 Markets  spreadsheet available here shows :-

  • The staking required to Dutch and hedge 2 markets using the balanced staking of Dutching,
  • Alternatively, use it to Bet and Lay your trade using any stake sizes of your choice . . . . Do It Yourself . . . . . "Ad-lib" your staking
  • or use the sheet to combine both . . . . . . . Dutching stakes  and your "Ad-lib" stakes.

The spreadsheet below shows the effect of commission deductions across 2 Betfair markets, to show the overall position of your trade.
Any number of bets can be entered into the spreadsheet for any selection.
After entering bets, enter lay odds, and the spreadsheet shows the lay stake required to Hedge any particular bets for an equal profit or loss - - - - - a "Green Up" facility.

This sheet can accommodate any number of bets.
Input odds and stakes info for your bets, and the sheet combines those to show combined bet odds.
We can now see what odds we need to lay at for a successful bet and lay Hedge of any score, or anything else we have bet such as
Under / Over Goals, etc. in another market.
If you have seen my other spreadsheets further down this web page for single Dutched stakes and laying to equalize, you will see that this new sheet uses the same layout.

The spreadsheet is set up to cover the Correct Score market, and up to 8 selections in a 2nd market.
It could be used for "Paper trade" practice purposes, or to help with staking of live trades.

This "Several Bets" spreadsheet is an expanded version of the Bet First, Lay 2nd spreadsheet described in videos further down this web page.
This video describes a 2 markets spreadsheet, with the facility for several bets using Dutched stakes, your own size stakes, or both.
The 3 Markets spreadsheet described above this one works in the same way as the one shown in the video.

 

Bet first, lay 2nd - - - -  Dutch and Hedge 2 Betfair markets placing SEVERAL BETS per selection if required      15
Use this spreadsheet to bet in 2 different markets.
Any number of bets can be placed on any selection or selections.
At any time, enter lay odds to see the lay stake required to equalize any selection for an equal profit or loss on that part of the trade.
The spreadsheet shows our whole market position after commission deductions, across both markets combined.

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.

15

______________________________________________________________________________________________

Dutch and Hedge in 2 Betfair markets using balanced staking.
Lay first or bet first spreadsheets for trading football.

If we bet and lay in 2 related markets, Betfair is unable to show our whole market position across both markets.
Betfair cannot show losses or gains in 2 markets combined, so will only show our market position in the 2 individual markets.

The 2 football "Dutch and Hedge" spreadsheets below overcome that problem by showing our total market position across 2 markets, including commission deductions.
The Dutch and Hedge spreadsheets below were designed for use in football markets but can be used for trading across 2 related markets in any sport.

Trading related markets in Betfair.

  • Losses may not be deducted before commission.
    When we trade across 2 or more markets in Betfair, we may think that we see a profit from our total trade, but commission deductions can put our whole trade into the red.
    That may not be obvious whilst we are trading.
    As you know,  losses in one market are not deducted before commission is deducted in a 2nd winning market, so trading across 2 markets rather than in one can be expensive

  • Don't trade the same thing twice.
    If you trade across 2 or more related markets, it is very important that you don't trade the same thing twice.
    Example.
    The Scores 0-0, 1-0, 0-1 are the same as Under 1.5 Goals.
    It would be a mistake to lay those scores and also lay Under 1.5 Goals.
    If you make a mistake and Lay the same thing but in different markets, you could have payout on the same result twice instead of once.
    If you bet on the same thing and don't hit a winner, you will have more losing bets than expected.
    It is very important that you are sure of the relationships between Betfair markets.
    Betfair provides a wide range of markets for the same event, especially for football matches.
    Many of these markets may be related in that you could bet in one market and lay the same thing in another, or bet in both, or lay in both.
    Watch an  Equivalent markets video

  • There's only one winner.
    As a shortcut, these related markets can save us time whilst trading and help to keep things simple.
    Unfortunately, these "Betfair shortcut markets" are of most benefit to Betfair.
    If we trade in a single market, losses are deducted from winnings before commission is paid.
    If we trade 2 related markets, losses in one market are not deducted from winnings in a 2nd market, so commission will be paid on total winnings in one market rather than total profit of the whole trade.
    Also, if we have a big loss in one market but smaller winnings in a 2nd market for an overall loss, we will still pay commission on the total of the winnings profit that we have in our 2nd market.
    If the whole trade was all in the same market, there would be zero commission to pay on a losing trade.

You are probably already aware of those points above.
The extra commission payments and losses not being deducted before commission don't do us any favours, but will be big winners for Betfair when they collect their commission.
We all trade across 2 related markets at some point, but it can be expensive.
Keeping track of our whole trade across 2 markets and getting the staking right is not easy.

__________________________________________

The spreadsheets below were designed specifically to trade Betfair's Correct Score market with other related markets such as Match Odds, Under/Over Goals, etc.
Dutching your trade with balanced staking, may be far easier to work with than simply guessing the size of stakes "In Play" during the heat of battle when the pressure is on.

Video demonstrations of these sheets are at the bottom of this web page.

Spreadsheet feature :-
These spreadsheets are split into 2 sections.
These individual sections can be used to Dutch and Hedge a single market or 2 markets combined.
Dutching stakes are balanced and across both markets for an equal profit or loss before commission deductions.
Hedge an individual selection and the spreadsheet shows the stake required to trade that single selection for an equal profit or loss.
Note that due to Excel calculations working to several decimal places, returns may differ very slightly from what is shown on your Betfair screen.
Depending on stake sizes, there should normally only be a few pence difference between the spreadsheet and Betfair.

 

Bet first, lay 2nd - - - -  Dutch and Hedge 2 Betfair markets       10
Use this spreadsheet to bet several selections in 2 different markets.
Also, after placing bets, lay any individual bet to equalize that part of the trade.
The spreadsheet shows our whole market position after commission deductions, across both markets combined.

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.


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.

Use this spreadsheet to show the stakes required to bet several selections for an equal profit or loss in one or 2 Betfair markets.
Then, if you choose, as the odds change, lay to equalize individual selections for an equal profit or loss on those selections.
After betting, enter lay odds into the sheet for any of those individual bets and the sheet shows the lay stake required to equalize that individual selection for an equal profit or loss.

Our position is shown in the 2 single markets, and also across the 2 markets combined.
Commission deductions are built into the spreadsheet.

___________________________________

Lay first, bet 2nd - - - -  Dutch and Hedge 2 Betfair markets       10
Use this spreadsheet to lay several selections in 2 different markets.
Also, after placing lays, bet any individual lay to equalize that part of the trade.
The spreadsheet shows our whole market position after commission deductions, across both markets combined.

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.


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.

Use this spreadsheet to show the stakes required to lay several selections for an equal profit or loss in one or 2 Betfair markets.
Then, if you choose, as the odds change, bet to equalize individual selections for an equal profit or loss on those selections.
After laying, enter bet odds into the sheet for any of those individual lays and the sheet shows the bet stake required to equalize that individual selection for an equal profit or loss.

Our position is shown in the 2 single markets, and also across the 2 markets combined.
Commission deductions are built into the spreadsheet.

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

The videos below demonstrate the Dutching part of these 2 spreadsheets.
Follow this link to view these videos individually on YouTube. or watch them here on this web page.

  1. Video 1 demonstrates the spreadsheet inputs and how it works using the Bet First spreadsheet.
  2. Video 2 demonstrates the Lay First spreadsheet.
    Spreadsheet inputs for this sheet are as demonstrated in video No. 1.
    For a BIGGER VIEW of these videos, click the small icon bottom right with 4 square corners.
    To move from one video to the next, click the "Next" arrow, bottom left of the YouTube screen.
  3. Video 3.  Bet in Correct score using an insurance bet to cover a 0-0 result.

  4. Video 4.  Lay in Under 2.5 Goals in Correct Score using insurance against a 0-0 result.

 

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

 
 

My spreadsheet websites.

betformulas.co.uk
Formulas and maths of trading

betandlay.co.uk
Football trading

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

Laying web site
Different ways of laying using a bit of imaginative staking.
Also, videos showing live trades