[AusRace] Excel Formula For Price Movement

[Linda Nicholas]

Please delete me from your list

Sent from my iPhone

> On Aug 6, 2017, at 3:21 PM, Nick at Twonix <nick.aubrey at twonix.com> wrote:
> 
> When they talk about the stock market going up or down on opening prices the formula is :
> (Closing Price divided by Opening Price ) minus 1
> Eg1. Opening Price 2.5 Closing Price 2.0 Price movement -20%
> Eg2. Opening Price 2.5 Closing Price 3.0 Price movement +20%
> Cheers,
> AN
>  
> From: Racing [mailto:racing-bounces at ausrace.com] On Behalf Of Robert Aldridge
> Sent: Saturday, 5 August 2017 3:57 PM
> To: Ausrace <racing at ausrace.com>
> Subject: [AusRace] Excel Formula For Price Movement
>  
> Does anyone on this list know the formula to enter into excel to the find the correct price movement percentage?.
> I need a formula so if the price shortens one would enter the longest price first, and the reverse if the lengthens.
>  
> So what I need is a formula that I can enter into excel so I just have to enter the two prices to get the price
> movement as a percentage.
>  
> Regards,
> Robert
> _______________________________________________
> Racing mailing list
> Racing at ausrace.com
> http://ausrace.com/mailman/listinfo/racing_ausrace.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ausrace.com/pipermail/racing_ausrace.com/attachments/20170806/7699924f/attachment.html>