Excel Value Calculation

[mtysocks]

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.

[Captain Sensible]

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

[Shaun]

Put this in Z5 and your percentage in AA5 =H5-((H5/100)*AA5)

[mtysocks]

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.

[Shaun]

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%