| Author |
Message
|
| mtysocks |
 Posted: Wed Apr 25, 2012 9:25 pm Post subject: Excel Value Calculation |
 |
|
Joined: 14 Sep 2010
Posts: 26
Location: UK
|
Hi All
I would like some help please. How do I calculate bad value? For example, if I make Horse A 50% chance (2.00 odds), and I want to lay it if the odds are 20% worse, how would I work it out? Also, what formula should I put in Excel? All help welcome. |
|
| Back to top |
|
 |
| Captain Sensible |
| Posted: Thu Apr 26, 2012 11:40 am Post subject: |
|
|
Joined: 19 Nov 2005
Posts: 1106
|
If you want to lay at 20% less odds you're effectively looking for a figure 80% (100-20) of your price. Remember decimal odds include stake so we need to remove and add that back on.
So for a 2's chance the odds would be
((2 less 1 (stake) ) x 80/100% ) + 1 (stake) =1.8
say your odds are in A1 your formula breaks down to
(A1-1)*0.8+1
In excel you could just use an if staement in your trigger to check if the current odds are equal to or less than your bad value price |
|
| Back to top |
|
|
| Shaun |
| Posted: Thu Apr 26, 2012 11:51 am Post subject: |
|
|
Joined: 09 May 2008
Posts: 367
Location: Kellerberrin, Western Australia
|
| Put this in Z5 and your percentage in AA5 =H5-((H5/100)*AA5) |
|
| Back to top |
|
|
| mtysocks |
| Posted: Sun Apr 29, 2012 10:18 am Post subject: |
|
|
Joined: 14 Sep 2010
Posts: 26
Location: UK
|
Thank you for showing me that formula. Please can you help me with the following.
I have two prices:
Cell A1: 4.40
Cell B1: 6.20
How do I calculate the percentage difference between the two? Sometimes the figure in Cell A1 might be higher than Cell B1 and vice versa. |
|
| Back to top |
|
|
| Shaun |
| Posted: Sun Apr 29, 2012 12:03 pm Post subject: |
|
|
Joined: 09 May 2008
Posts: 367
Location: Kellerberrin, Western Australia
|
if the prices were in H5 and H6
=1/H5
=1/H6
Then just right click the cell and format as percentage, then you just have to take one cell from another.
=H5-H6 this equals 6.60% |
|
| Back to top |
|
|
|
|
