Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board > Thoroughbred Horse Racing Discussion > General Handicapping Discussion


Reply
 
Thread Tools Rate Thread
Old 05-23-2022, 10:17 AM   #1
Robert Fischer
clean money
 
Robert Fischer's Avatar
 
Join Date: Sep 2006
Location: Maryland
Posts: 23,512
Excel formula for 'Dutching' bet??

What's the Excel formula for 'Dutching' a bet?

Thanks
__________________
Preparation. Discipline. Patience. Decisiveness.
Robert Fischer is offline   Reply With Quote Reply
Old 05-23-2022, 03:48 PM   #2
CheckMark
 
CheckMark's Avatar
 
Join Date: Aug 2016
Location: Fergus,ON
Posts: 3,686
A few links (hope this helps!)

https://excelrepo.com/how-to-create-...%20as%20profit.

https://mindtheduck.com/excel-dutching-calculator/

http://betformulas.co.uk/dutching.htm
__________________
Handicapping the world year round'
-Conley
CheckMark is offline   Reply With Quote Reply
Old 05-23-2022, 03:56 PM   #3
Tom
The Voice of Reason!
 
Tom's Avatar
 
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,470
https://www.timeform.com/betting/dutching-calculator

Here's an online calculator.

https://www.aceodds.com/bet-calculator/dutching.html
__________________
Who does the Racing Form Detective like in this one?

Last edited by Tom; 05-23-2022 at 04:06 PM.
Tom is offline   Reply With Quote Reply
Old 05-23-2022, 07:06 PM   #4
Robert Fischer
clean money
 
Robert Fischer's Avatar
 
Join Date: Sep 2006
Location: Maryland
Posts: 23,512
Thanks guys.


Lost some of my Excel stuff on the old PC.

I'll check all the links
__________________
Preparation. Discipline. Patience. Decisiveness.
Robert Fischer is offline   Reply With Quote Reply
Old 06-01-2022, 01:15 PM   #5
harry
Registered User
 
Join Date: Oct 2021
Posts: 5
Dutch Bet Formula_Dutch Bet

Hello
Hedge and Dutch Bet Formula:
Re: Hedge and or
Dutchformula
= (funds / ((funds/odds1)+ (funds/odds2)+
(funds/odds3))) * (funds/odds1) = bet 1 = (funds / ((funds/odds1)+ (funds/odds2)+
(funds/odds3))) * (funds/odds2) = bet 2 = (funds / ((funds/odds1)+ (funds/odds2)+
(funds/odds3))) * (funds/odds2) = bet 3


Cheers
harry is offline   Reply With Quote Reply
Old 06-01-2022, 01:58 PM   #6
harry
Registered User
 
Join Date: Oct 2021
Posts: 5
Excel _Dutch Betting

Hello
I can supply you the formula if you really want it.
Go to this website and you can download a copy
free of charge.
www.excelrepro.com


Excel Formula for Dutch Betting




Re: Hedge and or
Dutchformula
= (funds / ((funds/odds1)+ (funds/odds2)+ (funds/odds3))) *
=(funds / ((funds/odds1)+(funds/odds2)+(funds/odds3))) * (funds/odds1) = bet 1
=(funds / ((funds/odds1)+(funds/odds2)+(funds/odds3))) * (funds/odds2) = bet 2
=(funds / ((funds/odds1)+(funds/odds2)+(funds/odds3))) *
(funds/odds2) = bet 3


Cheers
harry is offline   Reply With Quote Reply
Old 06-02-2022, 02:07 PM   #7
Robert Fischer
clean money
 
Robert Fischer's Avatar
 
Join Date: Sep 2006
Location: Maryland
Posts: 23,512
Quote:
Originally Posted by harry View Post
Hello
I can supply you the formula if you really want it.
Go to this website and you can download a copy
free of charge.
www.excelrepro.com


Excel Formula for Dutch Betting




Re: Hedge and or
Dutchformula
= (funds / ((funds/odds1)+ (funds/odds2)+ (funds/odds3))) *
=(funds / ((funds/odds1)+(funds/odds2)+(funds/odds3))) * (funds/odds1) = bet 1
=(funds / ((funds/odds1)+(funds/odds2)+(funds/odds3))) * (funds/odds2) = bet 2
=(funds / ((funds/odds1)+(funds/odds2)+(funds/odds3))) *
(funds/odds2) = bet 3


Cheers
Thank you Harry. I'll check that out.

I've downloaded one that works OK ( have to substituste dollars for pounds but same math, and can't save an edited version due to the coding ).

However, I like to have and edit a self-coded one.
Over the years we've done stuff like Dutching, hedging, Kelly Criterion, max-consecutive losses, and other formulas, and I didn't do a good job of saving all of that from my old laptop.

Thanks
__________________
Preparation. Discipline. Patience. Decisiveness.
Robert Fischer is offline   Reply With Quote Reply
Old 06-03-2022, 12:38 AM   #8
Ted
Registered User
 
Join Date: Jul 2011
Posts: 26
If you haven't tried this it might be worth a shot. When my laptop died I was able to take the hard drive and put it in an external case. The hard drive was fine and I was able to recover everything on it. Good luck.
Ted is offline   Reply With Quote Reply
Old 06-04-2022, 07:51 PM   #9
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 43,096
Back in the day I compared dutch returns to proportional odds returns. End results, they eventually sum to the same.
__________________
Peace on earth, good will to all
GOD BLESS AMERICA

" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
formula_2002 is offline   Reply With Quote Reply
Old 06-10-2022, 10:31 AM   #10
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 43,096
HERE IS MY EXCE DUTCHING CHART. ONLY TWO INPUTS ARE RQUIRED, ODDS AND VIG.

THE SUCCESSFUL PLAY OCCURS WHEN THE REQUIRED MIN $1 RETURN IS EXCEEDED BY THE POSSIBLE $1 RETURNS..GOOD LUCK WITH THAT.
THE ATTACHED CHART IS FOR TODAYS SA Fairview* Race 4
, ELIMINATING THE FAVORITE #7 ODDS. THE FAVORITE WON!!
Attached Files
File Type: xls JCM DUTCHING CHART FOR PACEADVANTAGE.xls (56.0 KB, 27 views)
__________________
Peace on earth, good will to all
GOD BLESS AMERICA

" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill

Last edited by formula_2002; 06-10-2022 at 10:35 AM.
formula_2002 is offline   Reply With Quote Reply
Reply




Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

» Advertisement
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 03:37 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.