gruss-software.co.uk Forum Index The Ultimate Betting Exchange Software
gruss-software.co.uk
FAQ  FAQ   Search  Search   Memberlist  Memberlist   Usergroups  Usergroups
Register  ::  Log in Log in to check your private messages

gruss-software.co.uk Forum Index » Discussion » Formula for specific profit

Post new topic  Reply to topic
 Formula for specific profit « View previous topic :: View next topic » 
Author Message
Manic
PostPosted: Sat Aug 18, 2012 10:21 am    Post subject: Formula for specific profit Reply with quote



Joined: 06 Nov 2010
Posts: 11
Hi all,

Could anyone help me with an excel formula?

I simply want to automate the amount to bet to reach a specific profit, and the stake factor is messing me around.

So for instance, if odds were 4.0 and I wanted to make $10, what would the formula be to tell excel what the correct stake would be.

Thanks for any help Smile
Back to top
View user's profile Send private message
Captain Sensible
PostPosted: Sat Aug 18, 2012 1:55 pm    Post subject: Reply with quote



Joined: 19 Nov 2005
Posts: 1106
Remember decimal odds always include the stake so 4.0 is also 3 to 1 (3/1)

If you wanted to win $10 the formula for the stake would be 10 divided by 3/1 = 3.33

If our target stake is in A1 ($10) and our current decimal odds in A2 (4.0) the excel formula would be

stake = A1/(A2-1)
Back to top
View user's profile Send private message
Manic
PostPosted: Sat Aug 18, 2012 3:48 pm    Post subject: Reply with quote



Joined: 06 Nov 2010
Posts: 11
Captain Sensible wrote:
Remember decimal odds always include the stake so 4.0 is also 3 to 1 (3/1)


Yeah that's the bit that I couldn't formulate.

Ahh the brackets and -1 needed to be added.

You're a legend Sir, thank you.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

gruss-software.co.uk Forum Index » Discussion » Formula for specific profit
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


DAJ Glass (1.0.8) template by Dustin Baccetti
EQ graphic based off of a design from www.freeclipart.nu
Powered by phpBB © 2001, 2005 phpBB Group