Excel problem. Trying to calculate the percent difference for 162 cells from cell to cell.?

Question

In my excel problem, I have to calculate the percent increase/decrease in a closing price for a stock from month to month. For example I have to calculate the percent change in closing price from June 2006-July 2006. I can do the formula, but isn't there a way to easily copy the formula the whole way up the column, insead of having to do each month to month analysis? I'd hate to do that with 120 months.

Answer 1

I will assume you have your monthly closing prices in column A, starting at row 2.

In cell B3, type....

=(A3-A2)/A2 x 100

Copy and paste the cell down column B.

If you choose to format column B using percentage style, you would use the formula...

=(A3-A2)/A2

...instead.

Answer 2

If you have one column with all the percentages in it and the other column with the differences calculated by formula, just copy the formula from one cell and paste it into all 120 cells going down. The cell references will automaticaly change and you should get the right answer.

Answer 3

u have done more than half the work of creating the formula. Just type the formula, and while doing so just check whether u need the ABSOLUTE or RELATIVE cell references. Then create a range where u want and paste the formula, and LO ur %age value of + or - is there.
eg

assuming c10 is 100% the increase should be c10=100%
d10= ?

c10= 500 d10 = 520 e10= ((d10*100)/c10)

just make the block of ((d10*100)/c10) and copy it down the range

Answer 4

After you type the first formula, as per Boots McGraw...

then just use the fill handle and drag it down for all cells. (the fill handle is the small black + in the lower right corner of the active cell.)

Answer 5

check this link its good


http://buyingandsellingshares.blogspot.com/

.