Stock change

C

Chip Pearson

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



message
news:[email protected]...
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top