Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 30th May 2009, 04:20 PM
Benny Benny is offline
Banned
 
Join Date: Jan 1970
Posts: 689
Question Basic Excel Formula

This is the formula that i use to stake on my ratings top 3.

(0+60)/a1
(0+60)/a2
(0+60)/a3

where a1 a2 a3 are the odds. All loses are added to the target.

I'm trying to make a profit of $50. Someone might be able to improve the formula. Any suggestions.
Reply With Quote
  #2  
Old 30th May 2009, 06:12 PM
goty0405 goty0405 is offline
Member
 
Join Date: Mar 2009
Posts: 47
Default

What is that formula doing?! Why do you do 0 + 60? Why not just start with 60?

Anyway what you want to do is this...

50/(odds-1)

Where you want to make $50 profit (i.e not including your stake). So if it was a 1.50 horse you'd stake $100 (50/0.5). A $10 horse and you'd only need to stake $5.56.
Reply With Quote
  #3  
Old 30th May 2009, 06:45 PM
Benny Benny is offline
Banned
 
Join Date: Jan 1970
Posts: 689
Thumbs up Thanks

Can I use it for the top 3 horses and make $50 proit no matter which one wins.
Reply With Quote
  #4  
Old 31st May 2009, 03:07 PM
goty0405 goty0405 is offline
Member
 
Join Date: Mar 2009
Posts: 47
Default

Aaaah ok you want to dutch your top 3 to make $50 profit if any of them win. Right well thats a little more complex and requires several forumals...

It's a multi-step process.

1) Find the probability of each runner. This is just 100/odds. Eg a 2.0 runner = 50% probability.
2) Sum the probablity for each of the runners (it should/must be less than 100).
3) Calculate the "advantage" in your favour(100 - total probabilty from step 2)

Then for each runner you can plug in this formula...

(100/Odds)*(50/advantage)
Reply With Quote
  #5  
Old 2nd June 2009, 11:58 AM
Benny Benny is offline
Banned
 
Join Date: Jan 1970
Posts: 689
Thumbs up Thanks

Let's take this formula one step further and use it for sports betting, especially 2 team multi bets to see if there is an advantage.

No advantage - no bet.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 06:22 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655