ExcelBanter - How do I calculate the change in stock price in excel.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I calculate the change in stock price in excel. (https://www.excelbanter.com/excel-discussion-misc-queries/51090-how-do-i-calculate-change-stock-price-excel.html)

Knowledge001

How do I calculate the change in stock price in excel.

How do I calculate the change in stock price from the previous day.

Gary''s Student

How do I calculate the change in stock price in excel.

Put yesterday's price in cell A1 and today's price in cell A2. In cell A3
put the formula:

=A2-A1
--
Gary's Student

"Knowledge001" wrote:

How do I calculate the change in stock price from the previous day.

All times are GMT +1. The time now is 08:55 PM.