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

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

I think that if you subtract the previous day's closing fron the following
day's closing you will get results with the losses indicated by a minus sign
or enclosed in paretheses depending on your formatting. In the difference
column put"

= E2-E3 and copy down the column.

Your first result based on the data you posted would show -0.39

"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