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 19th August 2006, 06:05 PM
Benny Benny is offline
Banned
 
Join Date: Jan 1970
Posts: 689
Default Excel Help

I have written the following formula to help in calulating my bets based on 2% of my bank.

Headings

race no., tab no., opening bank, next bet, return, Profit/loss, running balance

=a3*2%

I'm trying. Can someone please help?

benny
Reply With Quote
  #2  
Old 19th August 2006, 09:01 PM
bluetown bluetown is offline
Member
 
Join Date: May 2005
Posts: 68
Default

Do you have Email ?
Reply With Quote
  #3  
Old 20th August 2006, 03:35 PM
Benny Benny is offline
Banned
 
Join Date: Jan 1970
Posts: 689
Default

Reply With Quote
  #4  
Old 27th August 2006, 11:28 AM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default fixed odds to place div

Need a formula
How do I get exel to show the place odds from a fixed price e.g $3.70
I now the odds are 1/4 (0.93) but how do I display that figure in $$ terms

cheers
Reply With Quote
  #5  
Old 27th August 2006, 11:44 AM
jfc jfc is offline
Member
 
Join Date: Jan 1970
Location: Sydney
Posts: 402
Default

Quote:
Originally Posted by Crackone
Need a formula
How do I get exel to show the place odds from a fixed price e.g $3.70
I now the odds are 1/4 (0.93) but how do I display that figure in $$ terms

cheers


=DOLLAR(A1/4,2)

If that's not what you want then restate your question.
Reply With Quote
  #6  
Old 27th August 2006, 12:03 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

Quote:
Originally Posted by jfc
=DOLLAR(A1/4,2)

If that's not what you want then restate your question.
Thanks for your reply jfc

What I am looking for is the place price that it will pay for a place eg $1.34 with this formula and all the ones I came up with return $0.93

cheers
Reply With Quote
  #7  
Old 27th August 2006, 12:21 PM
jfc jfc is offline
Member
 
Join Date: Jan 1970
Location: Sydney
Posts: 402
Default

Quote:
Originally Posted by Crackone
Thanks for your reply jfc

What I am looking for is the place price that it will pay for a place eg $1.34 with this formula and all the ones I came up with return $0.93

cheers


=(A1-1)/4+1

with this 5.00 decimal odds in A1 gives 2.00 Place which is correct.

3.70 => 1.675 suggesting your $1.34 is wrong for 1/4 odds
Reply With Quote
  #8  
Old 27th August 2006, 12:47 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

Quote:
Originally Posted by jfc
=(A1-1)/4+1

with this 5.00 decimal odds in A1 gives 2.00 Place which is correct.

3.70 => 1.675 suggesting your $1.34 is wrong for 1/4 odds
Where getting close I would like to put $4 in A1 not the decimal 5.00
Reply With Quote
  #9  
Old 27th August 2006, 12:59 PM
jfc jfc is offline
Member
 
Join Date: Jan 1970
Location: Sydney
Posts: 402
Default

Quote:
Originally Posted by Crackone
Where getting close I would like to put $4 in A1 not the decimal 5.00



=DOLLAR((VALUE(A1)-1)/4+1,2)
Reply With Quote
  #10  
Old 27th August 2006, 01:35 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

Quote:
Originally Posted by jfc
=DOLLAR((VALUE(A1)-1)/4+1,2)
the result is eg $4 in A1 =$1.75 if you put $5 in result is $2
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 08:47 AM.


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