Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stock change
How do I calculate the change in stock price from the previous day.
|
#2
|
|||
|
|||
Stock change
Just subtract the current price from the previous day's price.
E.g., =B2-B1 Or perhaps you had something else in mind. If so, post back with more details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Knowledge001" wrote in message ... How do I calculate the change in stock price from the previous day. |
#3
|
|||
|
|||
Stock change
I have downloaded 1025 days of stock in excel. Here is the question. In a
column next to the original data,calculate the change in stock price from the previous day. This may be negative or positive. From 1023 closing prices you will get 1024 changes in stock price. "Knowledge001" wrote: How do I calculate the change in stock price from the previous day. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find function | Excel Worksheet Functions | |||
Macro to change Chart Range when inserting a column | Charts and Charting in Excel | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Can I change a cell and cause an automatic change in other cells | Excel Worksheet Functions | |||
How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) |