How do you find the percentage of increase or decrease in stock market trends?
（I am doing a school project on the stock market, and one of the requirements is to calculate the percentage of increase or decrease of stock market prices over a few Fridays.
Is there a possible function or formula to use on Excel or something to find this?）
Answer：
For example, the latest price of the stock is $25. The price at the beginning of the period you wish to compare was $20. The difference in the price is $5. Divide $5 by $20 and you get .25. there has been a 25 percent increase in the price over the period.
Suppose the earlier price was $32, the difference is -$7. Dividing -$7 by $32 gives you -.21875 or a 21.875 percent decline.
Another way is to divide the latest price by the earlier price and then deduct 1 from the result:
$25 / $20 = 1.25
1.25 – 1 = .25 or 25 percent
$25 / $32 = .78125
.78125 = 1 = .21875 or 21.875 percent.
Posted: July 27th, 2010 under US Stock Market.
Tags: increase or decrease in stock market trends, stock market trends