[AusRace] Excel Formula For Price Movement

Nick at Twonix nick.aubrey at twonix.com
Mon Aug 7 06:21:27 AEST 2017


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ausrace.com/pipermail/racing_ausrace.com/attachments/20170807/c0ef065d/attachment.html>


More information about the Racing mailing list