Variable dutching calculator

jt42cwrm

New Member
Joined
Aug 16, 2007
Messages
15
Hello,

I am struggling to figure out how to go about this, perhaps someone can point me in the right direction?

I wish to create a variable dutching calculator whereby, instead of all the runners in the field generating the same profit, one can be weighted to more than the rest. For example, Mr Ed's return to be 200% of all the other runners, whilst the overall stake remains constant.

Here is my standard dutching calculator:-


Excel 2010
ABCDEFG
1WinnerPrice% chance% stakeStakeGross earningsNet earnings
2Mr Ed12.58.00%45.37%£ 3.18£ 32.75£ 31.11
3Silver65.01.54%8.72%£ 0.61£ 32.65£ 31.02
4Trigger30.03.33%18.90%£ 1.32£ 32.60£ 30.97
5Quick Draw McGraw21.04.76%27.00%£ 1.89£ 32.69£ 31.06
6
7Total stake£ 7.00
8Commission5%
Sheet1
Cell Formulas
RangeFormula
C2=1/$B2
C3=1/$B3
C4=1/$B4
C5=1/$B5
D2=$C2/SUM($C$2:$C$5)
D3=$C3/SUM($C$2:$C$5)
D4=$C4/SUM($C$2:$C$5)
D5=$C5/SUM($C$2:$C$5)
E2=ROUND($D2*$B$7,2)
E3=ROUND($D3*$B$7,2)
E4=ROUND($D4*$B$7,2)
E5=ROUND($D5*$B$7,2)
F2=($E2*$B2)-SUM($E$2:$E$5)
F3=($E3*$B3)-SUM($E$2:$E$5)
F4=($E4*$B4)-SUM($E$2:$E$5)
F5=($E5*$B5)-SUM($E$2:$E$5)
G2=ROUND($F2-($F2*$B$8),2)
G3=ROUND($F3-($F3*$B$8),2)
G4=ROUND($F4-($F4*$B$8),2)
G5=ROUND($F5-($F5*$B$8),2)


Can anyone give me any suggestions?
 
Last edited:

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Can't you just enter the horse twice?
 
Upvote 0
That would increase my total stake, which I want to remain the same. Plus I might want to set the variable return on that one "horse" to anything, ranging from 0% to 500% the return on the other runners.
 
Upvote 0
See https://www.box.com/s/5pt3sgepeuoj8q42lp36

I differs from what you asked for in that you choose a base amount to win, and the weights multiply that, rather than specifying your stake.

For example,

Code:
       -------B------- -C- ---D---- ----E----- ---F----
   2                       To Win W  $50.00            
   3                                                   
   4   Mud in Your Eye Wgt Dec Odds    Bets      Pays  
   5   Mud in Your Eye   1      10     $ 11.99 $ 119.86
   6   Hooves of Steel   2       8     $ 21.23 $ 169.86
   7   Speeding Bullet   3       6     $ 36.64 $ 219.86
   8   Rein Me In                                      
   9   Go Bob Go                                       
  10                          0.392 Total Bets   Net   
  11                                   $ 69.86  $ 50.00


Code:
       -------B------- -C- ---D---- ----E----- ---F----
   2                       To Win W  $50.00            
   3                                                   
   4   Hooves of Steel Wgt Dec Odds    Bets      Pays  
   5   Mud in Your Eye   1      10     $ 11.99 $ 119.86
   6   Hooves of Steel   2       8     $ 21.23 $ 169.86
   7   Speeding Bullet   3       6     $ 36.64 $ 219.86
   8   Rein Me In                                      
   9   Go Bob Go                                       
  10                          0.392 Total Bets   Net   
  11                                   $ 69.86 $ 100.00


Code:
       -------B------- -C- ---D---- ----E----- ---F----
   2                       To Win W  $50.00            
   3                                                   
   4   Speeding Bullet Wgt Dec Odds    Bets      Pays  
   5   Mud in Your Eye   1      10     $ 11.99 $ 119.86
   6   Hooves of Steel   2       8     $ 21.23 $ 169.86
   7   Speeding Bullet   3       6     $ 36.64 $ 219.86
   8   Rein Me In                                      
   9   Go Bob Go                                       
  10                          0.392 Total Bets   Net   
  11                                   $ 69.86 $ 150.00
 
Upvote 0
Wow shg, thanks!
I haven't seen or used any mathematical equations like those for over 20 years so my head hurt just looking at them.

It does the trick perfectly, cheers.
 
Upvote 0
Really like what you've achieved with the Variable Dutch Book. Is it possible to go a step further and provide for a "saver" bet, i.e., bet an amount to break even on the "saver" bet and enable an increase in the amounts bet on remaining selections?
Also, do you have any views on how to convert a Dutching spreadsheet to a stand alone program?
 
Upvote 0
Hi shg love the tool you've created

However, I have the same problem where I want to create a variable dutching calculator whereby, instead of all the runners in the field generating the same profit, one can be weighted to more than the rest.

I have not been able to access the link Box

I have the old thread Variable dutching calculator

If anyone else knows how I can create this variable dutching calculator please let me know

Thank you,

brerus72
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top