I want to back 3 or 4 horses in a race and make a profit of $10 no matter which one wins. Is there an excel formula that I can use.

Try this

Attached Files

Saver-Dutch calculator.xlsx (24.0 KB, 855 views)

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

HI Shaun have the qld tab changed there format for downloads to v4.5 and
consensus ratings 2012 v2.

thanks Rick

Yeah i noticed a change, i have seen this before it may just be today, if it is the same tomorrow i will have to make a change.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

thanks for the reply Shaun, if you have to make a change could you please do it to both programs v4.5 and
consensus ratings 2012 v2.

cheers Rick

Depends on what i have to do.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

Hi Benny,

I found this at Ozracetools:

Dutch Book

Put your odds in and at the bottom of the sheet, click on the 'profit' button and enter the amount you want to win, click 'calculate'.

__________________
The Schmile

"I buy when other people are selling.”
― J. Paul Getty

thanks Shaun

Rick

Hi Benny,
I find Dutching to Return a fixed amount is the stronger way to go.
This is done by dividing the Horses price into a Fixed return amount of say $50

It controls the outlays more when there is varying numbers of horses being targeted race to race.
It also protects from overloading a race to show a profit, one tends to lose a lot less if it falls over on the shorter priced Dutchings.

Example.
Price
3.00 into 50.00 O/L 17.00 Ret 51.00 Prof 13.00
4.00 into 50.00 O/L 13.00 Ret 52.00 Prof 14.00
6.00 into 50.00 O/L 8.00 Ret 48.00 Prof 10.00
Total O/L 38.00

See Ozracetools for Dutching to Return, alternative to Dutching to Profit per race.

__________________
Cheers.