Spreadsheets that use more than one Dutching method.

 

Home Spreadsheets Dutch Double Dutch Strategies Videos

 

Spreadsheets for trading football.
Trade Correct Score bets or lays with other Betfair markets

Link down to Copy what a bookie might do
Link down to video demonstrations for football trading

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 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.

__________________________________________

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.

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.
Down to video demonstrations of these spreadsheets.

___________________________________

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 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 the spreadsheets work 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.

 

________________________________________________

Lay combining 2 Dutching methods
Copy what a bookie mighty do.  Target runners to lose.

Copy what a bookie might do.  Target runners to lose.

These Double Dutch spreadsheets combine 2 different methods of Dutching in their calculations.
To use these spreadsheets, you will need your own selection method for finding suitable runners to lay.

2 Basic strategies.

  • Lay one or more targeted runners to lose.

  • Lay other runners to reduce the liabilities of those targeted runners.
    If we hit the winner with one of these extra lays, we break even on the whole trade.

  • Alternatively, we can stake so that we show a profit if we hit the winner with one of these extra lays.
    If we lay non-target runners for a profit, we only need to lay 2 or more of these extra runners to show a profit if we hit the winner with one of them.
    These profitable extra lays also reduce the liabilities of our targeted runners.

As these Non-Target lays will either break even with zero loss if we hit a winner with one of them, or will show a profit, we may not be too concerned whether we hit a winner or a loser with one of these non-target Lays.

Copyright notice.  In the 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.

_____________________________________________________
 
Lay to a max liability plus Break Even     10
Lay to a max liability on a target runner.
Break even on non-target lays


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.

This spreadsheet was designed for laying just one or 2 target runners well before race time.
Occasionally, the odds of a target runner would go down dramatically, which could indicate that it might win.
Using the stakes shown in this spreadsheet, we can lay any other runners we like to reduce our liabilities on our target lays.

We have placed our target lays earlier in the day.
In order to maintain those lay stakes as we lay additional runners to break even, the additional non-target, break even lay stake sizes grow rapidly as we enter more odds into the sheet.
Once we feel comfortable with the liabilities shown in the spreadsheet against our target lays, we place the non-target lays in Betfair.

Spreadsheet feature :-
This method uses larger lay stakes on non-targeted runners than the other methods shown here.
These larger lay stakes on non-target runners can make this method very profitable if we don't hit the winner with one of our lays.

This spreadsheet can be used to lay up to 10 target runners and up to 15 non-target runners.
Videos not yet available.

_____________________________________________________

Lay using 2 Dutching methods plus Break Even     10
Lay to set stakes limit on a target runners.
Break even on non-target lays


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.

This spreadsheet was designed for laying just one or 2 target runners to a set stake.
We then lay other runners to break even to reduce the liabilities on those target lays.

Because of how the spreadsheet works, it would be best to either place the non-target lays first followed by the target lays, or place all the lays at the same time.
As we enter odds into the spreadsheet, the stakes for the non-target lays remain unaltered.
The stakes for target lays alter as other odds are entered or removed from the spreadsheet.

Spreadsheet feature :-
The 2 Dutching methods used for these calculations can be used individually if we choose, giving several options for different ways of Dutching our lays.
Watch 3 Linked videos :-

  1. Demonstrates inputs and how the Lay spreadsheet works.

  2. An example of Lay Dutching several runners in Betfair.
    In this 2nd video, the winner of the race started from stall No. 2 but laying in other races at Lingfield using the system shown is not recommended as a winning method.

  3. A betting version of this "Break Even" Dutching spreadsheet.

 

 

 

____________________________________________________

1 or 2 Losers spreadsheet.         10
Lay up to 4 targeted runners to lose.
Lay other runners to profit.

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.

Whilst watching televised horse racing, television presenters often tell us that the bookies are targeting one or 2 runners to lose, but will profit if anything else wins.
The bookies will lay most if not all of the runners, but only lose if the winner is one particular horse or maybe comes from 2 particular horses.
The spreadsheet below shows the staking for doing that.
A bookie may lay every runner, but we don't need to lay many selections to make this work for us.

Spreadsheet feature :-
Using this laying method we can lay a few runners and profit from some of them even if we hit the winner with one of our lays.

Watch 4 Linked videos :-

  1. Video 1 demonstrates inputs and how the spreadsheet works.
    We can Lay lots of runners but only show liabilities against 1 or 2 runners, with a profit shown against all our other lays

  2. .Lay several runners in a horse race, adjusting the stakes to balance your trade

  3. .Target 2, 3, or 4 runners to reduce liabilities on targeted runners.
    The football match described near the end of this 3rd video ended with a score of 3-2.

  4. How to Lay or Bet below the 2 minimum.