How do you find the percentage of increase or decrease in stock market trends?
12
Jan
Posted by: admin in: Investing
Em asked: 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?
start an online business
2 Responses
Serge M
13|Jan|2010 1game system reviews
It’s a very simple calculation. You find the difference between the latest price and the base price. The base price is the price at the beginning of your trend. Then you divide the difference by the base price.
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.
Franco
13|Jan|2010 2imprinted pens
(Last price - Previous price) / Previous price.x100
If the answer is positive it is a rise, and if the answer is negative, it is a fall
Eg, (60- 50) / 50 x 100 = 20% rise
Leave a reply