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?
MURRAY
Comments
Do you take donations or is this free like some of the penny stock pick site I know that take donations?
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.
(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
