Excel calculation question for stocks

[danholly34]

Hello all--

I have an Excel question
Here you will find James River Cola historic prices and are
downloadable to your computer and Excel can open it

http://finance.yahoo.com/q/hp?s=JRCC

What is not on the table is the daily percent increase or decrease of
the stock each day. Is there any way of getting Excel to perform this
calculation for each day and going back for some months? I would like
the result to show up in the next valuable cell

So Excel has to subtract the opening price from the closing price (or
vis versa) and then calculate the percentage change


Thanks Denny

 

[Don Guillett]

goto
(e-mail address removed)
and look in the files section. There are several free files.
I have a couple of free files under author donalb36

GetYahooMultipleHistory
will give you data for lots of symbols. It could be modified to do as you
ask.

 

[joeu2004]

What is not on the table is the daily percent increase or decrease of
the stock each day. Is there any way of getting Excel to perform this
calculation for each day and going back for some months?

Yes, it is quite straight-forward.

So Excel has to subtract the opening price from the closing price
(or vis versa) and then calculate the percentage change

That gives you the percentage change from open to closing price. The
usual way to compute daily change is use the closing price of the
current and previous trade day.

If you click on the link "Download to Spreadsheet" the data is put
into columns A through G. In H2, enter the following formula and
format the cell as Percentage.

=E2/E3 - 1

Drag or copy the formula down the column to calculate the daily change
"going back for some months". (Short-cut: double-click on the handle
at the lower-right of the cell.


----- original posting -----

 

[joeu2004]

Drag or copy the formula down the column to calculate the daily change
"going back for some months". (Short-cut: double-click on the handle
at the lower-right of the cell.

If you use the short-cut, be sure to delete the last cell in the
column, which is invalid.

Also, that works fine if there are no stock splits or other stock
dividends (not to be confused with cash dividends).

Ostensibly, you could use the Adj Close column (G) instead of E. I
don't like to do that because Yahoo makes adjustments for cash
dividends as well as stock dividends.


----- original posting -----

 

[danholly34]

      goto
      (e-mail address removed)
      and look in the files section. There are several free files.
      I have a couple of free files under author donalb36

GetYahooMultipleHistory
will give you data for lots of symbols. It could be modified to do as you
ask.

Thanks much Don. I have joined and will give it a try. I have never
used excel much. How hard would you rate this to figure out and do?

Thanks
Den

 

[danholly34]

Sorry to top post but...
I thank you immensely for all that. Believe it or not I have been
using Windows computers for ten years, can assemble and trouble shoot
them but have rarely used excel. Just got some books from library and
will try to do with it your advice

It's amusing that google and Yahoo finance historical data does not
list percentage gain/loss each day. I find it useful. Each stock
session is a new day and somewhat separate for other sessions. JRCC
has often had big jumps and FDG not really. (Both are coal) They
conformed to this behavior today. An 8% day to day gain for JRCC is
not a shock but for FDG it would be

Many Thanks
Den

______
______