excel dutching calculator

[osknows]

Thanks for that.

Got a question as you seam to be good with formulas.

If i was down $80 and my next runner was $4 what formula could i use to back and lay to create a zero loss/win situation, basically to to get back losses with out making a profit, or maybe even making a small profit.

I'm not sure I understand the question? I don't know what method or number of selections you are using?

The proper answer though is losses happen, deal with it. A good system will always have losses and the bigger your edge the less frequently this will happen. If you have a system where you need to recover losses to stay in profit then you are likely to lose your bankroll at some point.

[Shaun]

I think they call it a Position Squarer this was the formula i was interested in

[osknows]

If you want to make a profit on a movement of odds on 1 selection...

Sb = Back Stake (unknown)
Sl = Lay Stake (unknown)
Ob = Back odds
Ol = Lay odds
T = Target Profit

Then if the selection wins
1. Sb(Ob-1) - Sl(Ol-1) = T or
1. SbOb-Sb-SlOl+Sl = T

if the selection loses then
2. Sl - Sb = T

rearrange 2. to give
3. Sl = T+Sb

substitute 3. into 1. gives
4. SbOb-Sb-TOl-SbOl+T+Sb = T or
4. Sb(Ob-1-Ol+1)-TOl+T = T or
4. Sb = TOl / (Ob-Ol)

Once you know 4. Sb you can then solve equation 3. to get Sl

Eg What stakes do you need to create a profit for
Back odds = 7
Lay odds = 4
Target Profit = £100

4. Sb = (100 * 4) / (7-4) = 133.33
3. Sl = 100 + 133.33 = 233.33

Is that what you were after?

[Shaun]

thanks for that.

[Norwegian Would]

Thanks to the honourable osknows got a bit further with the functions

=MMULT(MINVERSE(L5:M6);W5:W6). One massive learning curve here!

BUT can any good peeps tell me where I am going wrong - see att files. I know I am close . .. so close to cracking this dutching "thingumybob" but after a stiff vodka and late night coding I just can't see where I am failing.

The pic from BetAnGLE ; I apolgise for Mr Fixador BUT this is central to the solution. Smite me if thou will!

http://www.filedropper.com/dutchbetsolution

http://www.filedropper.com/dutchtounequalamounts

Just like to say thanks in advance for any pointers

Cheers

[osknows]

Hello again,

You're almost there! In your tables where you have the odds and -1's. It should be (odds-1)

Eg
in cell L5 change =H1Odds to =H1Odds-1
in cell M6 change =H2Odds to =H2Odds-1

and repeat for the remainder of the tables

Os

[Norwegian Would]

Osknows; sometimes it's so easy to look for the difficult and complicated.... your solution looks like what I was missing.. piece of cake .. but you found it straight away. Thanks - I appreciate it!

I will post up your solution tomorrow so others may share - and hopefully make a bob or two in this gambolling lark.


Thanks again

Derek

[osknows]

Hi Derek,

I've been doing some unrelated work and stumbled upon something which may help with this.

Where you have several array sizes depending on the number of runners selected - scrap that and just use the largest array

If you don't intend to use a selection, i.e target profit = 0 then set up the array so the -1's change to 0. Just make sure the target profit is 0 and not blank. This also works for non-contiguous ranges so you don't have to re-order

This should really simplify your worksheet and in theory you could set up for 50+ runners using just 1 array which will work for any number of selections.

If you need me to explain more or send through an example let me know
Os

[osknows]

I just wanted to check it worked as expected, here is an example

http://www.mediafire.com/?32wnz1z5kyq

[Norwegian Would]

Some interesting stuff there Os ! Reminds me off the Ready Reckoner I used in my school days. I will look into it further.

Thanks a MILION for you help with the dutching equations - I learned loads.

Here is the link for the Dutch to unequal amounts. I have placed it in a random BET/LAy WorkBook I found on this site - just to pick up the Market / horse names.

http://www.filedropper.com/dutch-tounequalamounts

[doris_day]

Sadly I don't think some of your calculations are correct as the stake*odds generally don't work out as equal to the return its calculated.
Perhaps I'm missing something but I've tried it a couple of times and things are just not adding up correctly.

[osknows]

doris_day is right the returns formula should be stake*odds-stake and not stake*odds+stake as you have

[Norwegian Would]

Thanks for picking up on that one ! The Workbook was originaly for "Bookies-odds" not Decimal odds. I DO appreciate your help.

[Norwegian Would]

Let's try again.....

http://www.filedropper.com/dutch-tounequalamountsrev1

[osknows]

Hope you don't mind me adding a little bit

http://www.mediafire.com/?yyljy0y43cz