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.

Follow this link for a List of all available spreadsheets.

After payment for a spreadsheet 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.

If you have problems downloading your spreadsheet,
e-mail me and I will send your spreadsheet by e-mail the next time I look at my in-box - usually every day.

2 spreadsheets designed for combining Correct Score with other markets

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.
Our betting exchange will only show our market position in the 2 individual markets.
Betfair cannot show losses or gains in 2 markets combined.

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.

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.

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.

Interested in how
pro - traders operate ?
Learn how to profit from your gambling..

Join Bet Club now.