Formula for price movement percentage - Aussie Stock Forums

Thread: Formula for price movement percentage

1. Formula for price movement percentage

Hi,

Hope someone can help me with this, i can never seem to get percentages right!

What would be the formula to get a percentage of price movement.
for instance if the open price was 31.03 and the closing price was 34.34 how would you work out what would be the percentage moved.

What would be + percentage and alternatively if the price closed lower than the open what would be - percentage.

Hope this makes sense!

2. Re: Formula for price movement percentage

Percentage = (Current Price - Last Price)/Last Price

3. Re: Formula for price movement percentage

I want to use open price and close price but using the formula you showed I cant get it to give me what I need.

4. Re: Formula for price movement percentage

If you are using my formula, then current price=close and last price=open

Most sites will quote the &#37;age return as the current price today compared to YESTERDAYS closing price...

5. Re: Formula for price movement percentage

Thanks, that does work fine, from my example price i get 11%

much appreciated!

6. Re: Formula for price movement percentage

Originally Posted by stoxclimber
Percentage = (Current Price - Last Price)/Last Price
Strictly speaking, you need to multiply the result by 100 to give a percentage.

Or, rearrange to give:

Percentage = ( CurrentPrice / PriorPrice - 1) * 100

This is often easier in practice, since you only need to divide one number into the other - no need to calculate the difference first, prior to dividing by the PriorPrice. In your original example,

CurrentPrice / PriorPrice = 34.34 / 31.03 = 1.1067

So, subracting one and multiplying by 100 gives 10.67%.

7. Re: Formula for price movement percentage

Yeah that would be right snagglepuss

at open 31.03 and close of 34.34

mypercentage: Format(([close]-[open])/[open],"#.0000")*100

this gives me 10.67%

Cool

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
Aussie Stock Forums