Spreadsheets that use only one Dutching method.

 

 
  Home Spreadsheets Dutch Double Dutch Strategies Videos  

 


Dutching is a method of staking several selections in the same race.
Stakes are calculated so that providing we hit the winner, each selection returns the same profit or loss.

Bet Dutching can be a very effective way of betting on a number of selections in order to show a profit, but whilst increasing the number of selections obviously increases our chance of hitting the winner, every additional selection also reduces our overall odds, and reduces our profit.

If Laying, the opposite applies.
Whilst increasing the number of selections increases our chance of hitting the winner with one of our lays, every additional selection also increases our profit it we don't lay the winner.
If we miss the winner with our lays, all our Lays are successful and we have a very nice profit that is equal to the total of all our lay stakes.
Follow this link for a more detailed description of Dutching.

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.

__________________________________________________________

Be A Bookie.
This spreadsheet allows you to be the bookie.
.
Lay the whole field, or just a few runners.
The spreadsheet shows the stakes required to Lay from one to 25 selections for an equal payout, no-matter what the outcome of the race.


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.

The Excel file also contains a spreadsheet for betting up to 25 runners for an equal profit or loss.

Spreadsheet feature :-
As you add more runners by entering lay odds into the spreadsheet, the stakes on all other runners remain unaltered.
Using this simple Dutching method, you can lay a runner or several runners and then lay one or more later.
As you do that, stakes already placed will not need to be changed.
An equal profit or loss will be maintained against all runners without the need to alter any of the stakes placed earlier.

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

  2. Lay several runners in a horse race, adjusting the stakes for almost an even money situation, even though we don't expect to hit the winner with the horses that we have layed.
    Link to my old startingstalls web site.

  3. Use the Adjust feature to favour one outcome over all the others.
    Dutch Match Odds in a football match to Lay the Draw and then Lay the 2 teams after a goal is scored.

  4. Trade across more than one market.  Lay the Draw in football markets with insurance against a Nil - Nil result.

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

 

__________________________________________________________

Lay the Betfair Horse Racing Place market.
Lay the whole field, or just a few runners.
The spreadsheet shows the stakes required to Lay from one to 25 selections for an equal payout, no-matter what the outcome of the race.


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.

When we think of laying in the Betfair horse racing Place market, a big fear may be that we have up to 4 chances of having to make a payout instead of only one in the win market.
Our fear might be that if horses we lay finish first, 2nd, 3rd (or 4th in handicaps with 16 or more runners), we will have several payouts if more than one of the horses we have layed gets placed.
That need not be true, providing that we lay enough runners.

If we stake correctly, we could lose only if we have layed EVERY placed horse.
If we don't lay just one of the placed horses, we could have profit on everything that we have layed, even horses that we have layed that are placed.
It all depends on the total percentage of all the odds that we lay.

If we lay our book to a high enough percentage, we can still show a profit if 1, 2 or 3 horses are placed that we have layed.

The maths of trading the Place market are no different to the maths of trading in the Win market
As we lay more runners, our liabilities decrease, AND :-

  • If we lay to more than a 100% book, we will win if only one of the horses that we lay is placed.

  • If we lay to more than a 200% book, we will win if 2 of the horses that we lay are placed.

  • If we lay to more than a 300% book in a 16+ runner handicap, we will win if 3 of the horses that we lay are placed.

  • Example.  If we lay several horses to more than a 200% book, we will only lose if we lay ALL 3 placed horses.
    If we hit a winner with only 2 of our lays, we will have profit.
    That is the maths of the Place market when we stake for an equal payout on all our lays..

So, Laying in the Place market, isn't quite as dangerous as it might seem.
Follow this link for a more detailed description of laying in the Place Market.

Spreadsheet features :-
As we bet and lay in the Betfair Place Only market, our Betfair screen only displays the liabilities for individual runners.
Betfair cannot show our overall position if we bet or lay more than one runner.
That is because there are too many possible combinations of different profit and loss amounts if we bet and lay several runners at different odds without balancing our stakes for equal liabilites on each runner whatever the result.
This spreadsheet gets around that problem simply by using balanced staking for an equal profit or loss on all runners.
As we add more runners, stakes on other runners do not alter.

 

__________________________________________________________

Lay to a Liability Target.
Take total control of your lay liabilities
whilst you lay up to 25 runners.
Lay for an equal profit or loss, but with a set liability of your choice if you hit a winner.


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 Lay staking method may be suitable for use with a staking plan.

  • Lay big odds for small liabilities if you choose.

  • Limit the amount you lose if you Lay the winner - in any sport.

  • As you lay more runners, your liability remains at the level of your choice.

  • As you lay more runners, your Total Stakes increase.
    If you don't hit the winner with your lays, all your lays are successful and you clean up with profit equal to the total of all your lay stakes.

Spreadsheet feature :-
A problem with this method of Lay Dutching is that the odds of all your selections need to be put into the spreadsheet before you start to place your lays.
If you alter any of the odds or you add another runner, ALL the stakes on other runners will change in order to maintain your liabilities at your chosen level.

How to Lay several runners at once on Betfair.

  • Click the Lay odds on Betfair and input your stake as usual, but don't hit "Submit".

  • Do the same for all your selections until you have all your lays with stakes on show.

  • Once you are satisfied with your staking, hit "Submit," and "Confirm" your Lays.

  • All your lays will be submitted together in one go.

__________________________________________________________

Lay a Yankee.
Using this spreadsheet, selections will be Layed one at a time, so can be in any market, and can be spread over any time scale.


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.

We lay selections one at a time so that we can see if we hit a winner or a loser with each lay.
As we hit a winner or a loser, we can then place a lay with the correct stake size on runners that follow in our Yankee.
Unlike a bookie, if you Lay a Yankee on Betfair using this spreadsheet, you don't have to Lay the whole 11 bets.
This offers the opportunity to take advantage of 7 successful Lays from one loser.

Suggested strategy.
As you know, a Yankee is 4 selections combined in 11 bets consisting of 6 doubles, 4 trebles and one 4 timer.
If just one of the 4 selections loses, 7 bets fail, leaving just 3 doubles and a treble.
If we are laying, one loser means that we have 7 successful lays.

For example.
You place your first Lay, and the selection loses.
You are 7 points up as that first lay carries 7 stakes.
You could trouser the winnings, and start afresh with a second Yankee.
If your first also Lay loses in that 2nd Yankee, you are 14 points up from just 2 losers.
A bookie cannot do that since he has to see out the whole bet.

3 Doubles and a Treble.
You may be concerned that sooner or later a few consecutive winners will come along and the high liabilities involved may take you beyond your comfort zone.
To avoid this scenario, the Lay Yankee spreadsheet above can be used to Lay 3 Doubles and a Treble, rather than the whole Yankee.
Simply input runner A as a loser, and the spreadsheet then covers only runners B, C, and D leaving you with just 3 Doubles and a Treble to lay.

Strategy for 3 doubles and a treble.
Again, your first runner carries most stakes.
In this case, your first runner starts 2 doubles and a treble.
If your first runner loses, you could pocket 3 stakes and start from scratch again.

__________________________________________________________

Lay a Union Jack.
As with the Yankee above, using this spreadsheet, selections will be Layed one at a time, so can be in any market, and can be spread over any time scale.


We lay selections one at a time so that we can see if we hit a winner or a loser with each lay before placing the next lay in the sequence.
As we hit a winner or a loser, we can then place a lay with the correct stake size on runners that follow in our Union Jack.

The Union Jack is another very popular combination bet, at least with bookmakers.
This comprises 9 selections in 8 trebles.

9 runners, are set out in a 3 by 3 grid.
A, B, C
D, E, F
G, H, I
The trebles covered are 3 horizontally, 3 vertically and 2 diagonally.

With 9 selections, there are a possible 84 treble combinations, but a Union Jack covers only 8 of them, leaving the punter with less than a 1 in 10 chance of hitting a winning treble combination.
As a layer we can take advantage of this by laying those 8 trebles from 9 selections, just as bookies do.
It is possible to hit 6 winners with no payout.
An example of 6 winners with no payout is shown in bold above.
There will be other combinations.

These are the combination bets for your 9 selections A, B, C, D, E, F, G, H, and I that comprise a Union Jack :- 
ABC, DEF, GHI, ADG, BEH, FCI, AEI, CEG.

Some selections appear in trebles more often than others.
For instance, the first runner A appears at the start of 3 trebles so carries 3 initial stakes, whilst E appears in 4 separate trebles.
If runners E loses, half of all the bets fail, so when you Lay a Union Jack, be sure to make runner E a banker Lay.

 

-----------------------------------------------------------