Excel

[Benny]

Does anyone know how I can use excel to calculate my bet sizes.?

Benny

[system]

what do you mean? bet %of bank or dutch or according to price of selection etc

[Benny]

According to the price of the selection.

Benny

[Shaun]

What we need to know is do you want to win say $100 no mater what the price of the horse

[Benny]

Or near to it ($100)

Benny

[system]

here benny this will do a few things for you.
with this sheet you can bet overs or dutch and a set % of your bank to bet and you can see how much you need to bet to get desired return.if you need any help let me know and i think shaun would have spread sheet if this 1 no good.

[Shaun]

Well...just to give you an option...i think i am going excel mad...everytime i see a program i just have to write an excel version.....

[discipline pays]

benny if you go to practical punting daily .com.au ( i think ) you can download a free punters calculator to calculate all your bets... hope this helps

[Shaun]

I have that one but it really only works in larger bet sizes...it is a bit out of whack

[system]

benny did those s/sheets sort out your problem?

[zorro]

Attached is the Excel workbook I use for multiple Bet calculations. As well as the normal Dutch booking calcs there are alternate tabs for dutching with 1 or 2 horses as savers. The "Good Bet/Bad Bet" cells can be modified to suit the user's ideas on minimum returns.
Also there is a sheet to calculate Market percentages based on input prices as well as re-calculating the market to 100% or whatever % you like.

[MEH999]

Shaun, just seen your dutching calculator.
I'm writting my own small version, I can work most of it out, but I now want to calculate the amount to bet from the profit. ie I want to input the Profit amount - say £20 and calculate back. Can you help me with this?
Regards,
Mark.

[Shaun]

I have uploaded an unprotected sheet so you can see the formulas....let me know if you need any more help

[Shaun]

I just wanted to say that for as many times i have bagged this site for censorship and some of the members that use this forum.

It is still by far the best forum on the internet for just about any punting information that you need.

I had a computer crash a few years back and lost all information including all excel sheets i had created or tested, but thanks to the search section on here i have found a lot of lost info such as this dutching sheet i wrote up a few years ago with formulas intact.