spreadsheet formula for dutching

[berkoboy]

Can anyone help. I know there are dutching calculators out there , but it seems the ones I’ve found are for the same profit on all horses. What I want is a simple formula, for a spreadsheet (to do myself) or a dutching calculator site where I only want 2 horses, but variable profit targets. Say Horse A is the fav 2-1 , and I want him to win £20, but I think the danger is 10-1, but I lump on the fav, but horse B wins but I just want to cover the bet.

Hope this makes sense. I know there are spreadsheet gurus out there!

[% MAN]

Can anyone help. I know there are dutching calculators out there , but it seems the ones I’ve found are for the same profit on all horses. What I want is a simple formula, for a spreadsheet (to do myself) or a dutching calculator site where I only want 2 horses, but variable profit targets. Say Horse A is the fav 2-1 , and I want him to win £20, but I think the danger is 10-1, but I lump on the fav, but horse B wins but I just want to cover the bet.

Hope this makes sense. I know there are spreadsheet gurus out there!

If you just want to cover your bet just dived the price of the 2nd horse into the amount STAKED ON THE 1ST and thats the amount needed TO GET YOUR MONEY BACK

This will give you your money back if the 2nd selection won.

What you have to realise is if your 1st horse wins it would be winnings less what was placed on the 2nd horse

In this case if A WON AT 2/1 X 10 = £20 PROFIT LESS £1 FOR B.

The prob lies with the amout staked and the price of the second and if only 1 pt in it say 1/1 and 2/1 your putting 20 on to win 20 but 10 to get your money back so if your banker wins you only gain 10pts WHICH IN REAITY MAKES IT A 1/2 SHOT.

Like I say its just dividing your main stake by the price of the 2nd to get your money back but realise the amount on the 2nd would have to be taken of profits.

% MAN

[discretedata]

Found one here,http://www.mediafire.com/?yn2ym0jt2g5 by Googling ‘free multibet spreadsheet’.

Seems to work OK but I needed to F9 to perform the calculations.

[berkoboy]

Thanks for input. That’s a nice straightforward spreadsheet discrete, thank you. It is the variable profit which is of use. I probably didn’t make myself clear %MAN. The second horse would probably be a 8/1 shot or above, and maybe make a little profit on that rather than just cover my bet. Thanks for taking the time anyway.

[discretedata]

You may have already worked this out for yourself but to determine the stakes required to simply break even, i.e. your main selection loses but your saver selection wins, you need to enter £0.00 in the ‘Req profit’ cell next to the odds of your saver selection.

Good luck!

[Author]

Posts