Hi all,
Could anyone help please as i am trying to make a dutching Excel sheet/Bot and i am getting stuck
with calcs etc......
I want to pick with manual button / and see total book % after picking selections etc,
would be good if i could make auto at some point like picking most traded- tic move etc
Any help please or can pay for a sheet so i can learn more how to do it.
Thanks
Julian
Excel Dutching Workbook Help
-
spreadbetting
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Which parts are you stuck with? The calculations are simple just divide 100 by the decimal odds to get the % probability. Add all those up to see what percent of the book they're taking or is left, if you want to convert that back to decimal odds just divide 100 but the combined percentage. You can simply use excel's tickboxes to select a runner/row. When clicked a tick box simply puts True in the column instead of False so that can be picked up by an if statement.
-
teambulldog
- Posts: 116
- Joined: Wed Jan 04, 2012 9:09 pm
wow thanks for the reply and info thats a big help,,,
I am a bit stuck on how to skake as say i pick 4 horses and the book% total is 72% what would be the formula for each bet ???? and how to dutch for say a £5 proffit across the 4 ?????
thanks
Julian
I am a bit stuck on how to skake as say i pick 4 horses and the book% total is 72% what would be the formula for each bet ???? and how to dutch for say a £5 proffit across the 4 ?????
thanks
Julian
-
spreadbetting
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
When you do pretty much anything with betting we always try to look at thing as book percentages as it makes life easier. So assume we're always betting into a 100% book
So in you example say the runners are odds of 10,6,5 & 4 which is close to your 72% (71.67%)
If we were backing that to a £100 book we'd simply divide £100 by the odds to get our back stakes
100/10=£10
100/6 = £16.67
100/5 = £20
100/4 = £25
Whichever of those won would return us approx £28 profit ( we're backing 72% into a 100% book so our return will be 28% (100-72) if we win), but you don't want £28 you want £5 so we'd simply scale stakes down by multiplying them by 5/28.
So 10*5/28 @10's
16.67*5/28 @6's
etc
We simply take our target win amount and multple by 1/(100 -book total) i.e. 1/(100-72) = 1/28
So in you example say the runners are odds of 10,6,5 & 4 which is close to your 72% (71.67%)
If we were backing that to a £100 book we'd simply divide £100 by the odds to get our back stakes
100/10=£10
100/6 = £16.67
100/5 = £20
100/4 = £25
Whichever of those won would return us approx £28 profit ( we're backing 72% into a 100% book so our return will be 28% (100-72) if we win), but you don't want £28 you want £5 so we'd simply scale stakes down by multiplying them by 5/28.
So 10*5/28 @10's
16.67*5/28 @6's
etc
We simply take our target win amount and multple by 1/(100 -book total) i.e. 1/(100-72) = 1/28
-
teambulldog
- Posts: 116
- Joined: Wed Jan 04, 2012 9:09 pm
Thanks for setting it out like that, it makes a lot more sence when its in front of you like that,,
Will now have another go and tidy things up,
thanks
Julian
Will now have another go and tidy things up,
thanks
Julian
-
spreadbetting
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Here's a little spreadsheet to help you visualise it better
