Assuming we have data in row#2 and on down. In G2 enter:

=D2-D3 and copy on down
--
Gary''s Student - gsnu200783


"RIck" wrote:

Folks,

I need help in obtaining (or creating) a formula or function (or macro ?)
in which I can compute the difference in the closing price of a stock from
day to day. For example the closing price yesterday and the closing price
today. I have the basic information in an Excel spreadsheet that looks like
this:

Col A Col B Col C Col D Col E Col F

Date Open High Low Close Volume
5/2/2008 142.2 142.3 140.6 141.51 1067800
5/1/2008 138.38 141.12 138.27 141.12 187279500
4/30/2008 139.29 140.59 138.26 138.26 208395900
4/29/2008 139.39 139.73 138.61 139.08 125514100
4/28/2008 139.88 140.25 139.38 139.63 105610200
4/25/2008 139.4 139.89 137.91 139.6 190788100
4/24/2008 138.08 139.74 137.04 138.32 229381300

I would like to build a new column that keeps a running difference of the
prices in column E. I'm sure that for you Excel experts it's an easy problem
but I've tried myself and have not had any luck. An Excel guru I am not.

Any help would be appreciated.

Thanks
--
Best Regards

Rick