[AusRace] Excel Formula For Price Movement

[Robert Aldridge]

Hi Nick,

2.5 to 2.0 I get 10% price movement.

2.5 = 40%

2.0 = 50%

hence a 10% gap whether firming or  drifting in price.

Rob 

 

From: Racing [mailto:racing-bounces at ausrace.com] On Behalf Of Nick at Twonix
Sent: Monday, 7 August 2017 6:21 AM
To: 'AusRace Racing Discussion List'
Subject: Re: [AusRace] Excel Formula For Price Movement

 

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/e30093e7/attachment.html>