Results 1 to 10 of 10
Thread: percent formula question

20150120, 07:17 #1
 Join Date
 Nov 2011
 Location
 Australia
 Posts
 221
 Thanks
 80
 Thanked 3 Times in 2 Posts
percent formula question
IF
a money transaction web page was literally showing
1.75 to 1.55 = 27%
The closest I can come to is (Cell A1) 1/75 to (Cell B1)1/55
using formula in Cell D1 =(B1A1)/ABS(A1)
When I type in 1/75 and 1/55, I get 27395 and 20090 and arrive to 26.67%
Which obviously rounds up to 27% as it appears.
So what's happening when the web page is showing 1.75 to 1.55 = 27%
How do they do this calculation and in what format in Excel ?
Thanks

20150120, 08:36 #2
 Join Date
 Dec 2000
 Location
 Burwash, East Sussex, United Kingdom
 Posts
 6,286
 Thanks
 3
 Thanked 194 Times in 180 Posts
What's the page? My best guess would be that the first part is a range, not a subtraction.
Regards,
Rory
Microsoft MVP  Excel

20150120, 10:37 #3
 Join Date
 Nov 2011
 Location
 Australia
 Posts
 221
 Thanks
 80
 Thanked 3 Times in 2 Posts
Link
http://www.propun.com.au/racing_foru...achmentid=3606
Thanks rory,
it's actually an attachment of someone else's post, (unrelated topic).
What I noticed on the near top left corner, or just below top left is
"market mover 1.75 to 1.55 = 27%"
How can I do this exact same calculation in Excel ?
Thanks

20150120, 10:49 #4
 Join Date
 Jan 2004
 Location
 Praha
 Posts
 1,009
 Thanks
 59
 Thanked 109 Times in 94 Posts
To answer your question we need to know what the $1.75 and $1.55 represent.

20150120, 10:55 #5
 Join Date
 Nov 2011
 Location
 Australia
 Posts
 221
 Thanks
 80
 Thanked 3 Times in 2 Posts
MartinM
To answer your question we need to know what the $1.75 and $1.55 represent.
It represents a change or fluctuation in the price of xyz stock, buy/sell, in this case Odds
Hope this is correct
Thank you.

20150120, 11:37 #6
 Join Date
 Dec 2000
 Location
 Burwash, East Sussex, United Kingdom
 Posts
 6,286
 Thanks
 3
 Thanked 194 Times in 180 Posts
Those are the returns for a $1 stake (i.e. they include the original stake), so in terms of profit (or odds) change, it's actually (0.750.55)/0.75
Last edited by rory; 20150120 at 11:51.
Regards,
Rory
Microsoft MVP  Excel

The Following User Says Thank You to rory For This Useful Post:
XPDiHard (20150120)

20150120, 11:39 #7
 Join Date
 Jan 2004
 Location
 Praha
 Posts
 1,009
 Thanks
 59
 Thanked 109 Times in 94 Posts
Looks to me more like the return for a given stake (maybe $1 ?) in a horse race. Any taxes or other deductions could cause a complex relationship between the percentage shown and the two $ amounts.
Or the two $ amounts might be illustrating the best and worst returns across the range of betting companies and the percentage figure a representation of the size of that range.
You can see that I'm just guessing . . . that's all I can do.
UPDATE: You can see that my post crossed with Rory's. He and I are headed in the same general direction though.

The Following User Says Thank You to MartinM For This Useful Post:
XPDiHard (20150120)

20150120, 12:56 #8
 Join Date
 Nov 2011
 Location
 Australia
 Posts
 221
 Thanks
 80
 Thanked 3 Times in 2 Posts
Thanks,
Are they correct when posting 1.75 to 1.55 = 27%
So if I may reiterate my original question
When I type in 1/75 and 1/55, I get 27395 and 20090 and arrive to 26.67%
Which obviously rounds up to 27% as it appears.
had to play around with formatting the cells to get it to work.
Are these the correct formula ?

20150120, 15:59 #9
 Join Date
 Jan 2004
 Location
 Praha
 Posts
 1,009
 Thanks
 59
 Thanked 109 Times in 94 Posts
Rory's explanation is the correct one.
In one case you bet $1.00 and win 75c and get your stake back: a total of $1.75
In the other case you bet $1.00 and win 55c and get your stake back: a total of $1.55
So your winnings have gone from 75c to 55c which is a reduction of 27% (strictly 26.666... %)
So the formula for the percentage shown on the webpage is ((1.751)(1.55  1))/(1.75 1).
I have put this formula into the yellow cell in your example Workbook v2, attached.
Of course you can simplify the formula to (1.75  1.55)/(1.75  1) if you like  I was just showing the full calculation for clarity.

The Following User Says Thank You to MartinM For This Useful Post:
XPDiHard (20150120)

20150120, 18:51 #10
 Join Date
 Nov 2011
 Location
 Australia
 Posts
 221
 Thanks
 80
 Thanked 3 Times in 2 Posts
ah ha ! the penny drops yet again, forgot about the 1 within the formula, it makes sense now
Thanks