excel dutching calculator

[mafia12]

hello guys, i have been testing betting assistant since last night and i've just setup an excel spredsheet which should do some bets for me while at work

i've been searching all night for an excel dutching calculator or the math's on how to do dutching with no luck, can anyone point me in the right direction?

[Roger]

Try:
http://home2.btconnect.com/jmandjp/Trading/dutching.htm

[mafia12]

is there an easier explanation? i have foun that website before, but its not the easiest, i don't even need the excel formula just a clear guide on the math's calculations

thanks

[throwmeadisc]

OK.

Fixed Stake:

Say you want to dutch these 3 selections with the decimal odds of:

A - 3.25
B - 4.6
C - 10

So there theoretical chance of winner is (1 divided by odds)

A - 1/3.25 = 0.31 or 31%
B - 1/4.6 = 0.22 or 22%
C - 1/10 = 0.10 or 10%

And total chance of one of these winning is 0.63 or 63%

So now you need to work out how much of the fixed stake to put on each selection. Our fixed stake will be £50

So you need to work the percentage change of a selection winning out of the three. Which is selection chance of winning divide by overall chance of winning.

A - 31% / 63 % = 49% or 0.49
B - 22% / 63 % = 35% or 0.35
C - 10% / 63 % = 16% or 0.16

And now you can work out your stake for each selection.

A = £50 * 0.49 = £24.50
B = £50 * 0.35 = £17.50
C = £50 * 0.16 = £8.00

That's it. Hope it's clear enough.

Also I made this dutching calculator if you want to use it. The sheet is unprotected so you can see the formula. There is also target profit in there too if you want it.

http://www.gruss-software.co.uk/Excel/Dutching.xls

Original post: http://gruss-software.co.uk/forum/viewt ... ght=#11106


Al

[mafia12]

cheers al your a star!

[Captain Sensible]

Just treat everything the same way as if you were laying or backing a book %

say three runners odds you want to dutch are 3,3,4.5

book %'s are 100/3=33.3%,100/3=33.3% & 100/4.5=22.2% total percent of your runners add up to 33.3+33.3+22.2 =88.8% which means you're effectively backing at aggregate odds of 100/88.8 i.e 1.126. Obviously you need that overall odds for any other calcs and limits you might want to trigger at.

Say you want to back the runners to dutch a £10 profit. Odds of 1.126 mean for a total stake of £100 you'd get back £112.6 which is £12.6 profit before commission. To win £10 you'd need to stake £79.37

simple calc stake = Amount to win /( digital odds less 1 (returned stake))

stake = £10/(1.126-1) =£79.36

That stake is then just spread in proportion to the runners odds. So for the 3's proportion of stake would be

total stake multiplied by runner percentage divided by total runners percentage

3's would be staking £79.36 times 33.3%/88.8% = £29.76
3's would be staking £79.36 times 33.3%/88.8% = £29.76
4.5's would be staking £79.36 times 22.2%/88.8% = £19.84

total stake £29.76 + £29.76 + £19.84 =£79.36

Hopefully I haven't overcomplicated things but once you start treating things in terms of a book % everything should just fall into place and the actual formulas are very simple to stick into a spreadsheet for as many or as little runners as you want

[Captain Sensible]

lol me and my bloody slow typing

[mafia12]

is it a different formula for dutching inwhen laying bets?

[thunderfoot]

Free EXCEL calculator at ....

http://www.thunderfoot.f2s.com/betting/

[throwmeadisc]

Sorry I haven't worked out the laying formula yet, does anyone else know?

[Fixador]

Sorry guys missed this thread earlier .... my three penny worth

It is possible to :-

(1) Back Dutch to a target profit ( as throwmeadisc has shown above )

(2) Back Dutch to a target liability

(3) Lay Dutch to a target profit

(4) Lay Dutch to target Liability ( same formula as throwmeadisc has shown above )

and there are also the simpler versions - which i cant rember

if anyone wants (2) , (3) formulae - just yell ( except VH ! ha ha ) ....... but its not as easy as throwmeadisc's formulae....... stress, stress, stress - it just isnt gambling anymore !

Never being able to work out Lay dutch to zero liability though !

[throwmeadisc]

Sorry guys missed this thread earlier .... my three penny worth

It is possible to :-

(1) Back Dutch to a target profit ( as throwmeadisc has shown above )

(2) Back Dutch to a target liability

(3) Lay Dutch to a target profit

(4) Lay Dutch to target Liability ( same formula as throwmeadisc has shown above )

and there are also the simpler versions - which i cant rember

if anyone wants (2) , (3) formulae - just yell ( except VH ! ha ha ) ....... but its not as easy as throwmeadisc's formulae....... stress, stress, stress - it just isnt gambling anymore !

Never being able to work out Lay dutch to zero liability though !

I'd like to see the for formula for (3). Can you post it here? Or I can PM you my email...?

Thanks,

Al

[Fixador]

Hi Al , cant post it here - as too large ! - nor can i put it into a pm - too large

Have sent you a link in a pm - there is a word doc there - that contains my drivel


if you cant get that - then please pm your email address

Paul

[mak]

Fixador hi
I would like to see the for formula for (3)
Is it possible?

thanx

[Norwegian Would]

STUMPED ! I have used all the weekend trying to get my head around "this dutching lark" !

Can any of you good peeps point my nose in the right direction please? I would appreciate it.


What I am mainly interested in is how to bring the fav into the equation - ie overiding the target profit on the favourite.

See image.

http://www.filedropper.com/dutchhedgingthefav

http://www.filefactory.com/file/b0gb551 ... Thefav.png

(I am not quite sure which gives the best screen resolution)

PS - What happened to Fixadrious... extinct?

I appreciate any help.