I have a work sheet with stock data entered every day. I need like
on B15 with the title on A15 Last 7 days volume. The data starts on
A38 with the date, open is on b38, high is on c38, low is on d38,
close is on e38 and volume is on f38. Currenlty i have about 75 days
but would like to set data end at 500 cells. Please help me with
this fomula..

One more request. I would like to have also the last date with
closing price. The cell I would like to place this is A36. So I
need the computer to find the last data of entry from a38:a500 and
then go to that cell - in e38 for the close.

Thanks JBE

The trick here will be to first determine the dates to pull. After that, you
can simply use the VLOOKUP function (see XL help for full detail) to pull in
the other info.

For the dates, to pull the last seven days, assuming you are entereing dates
as true dates/numbers.

Latest date:
=LARGE(A$38:A$500,ROW(A1))
Copy this down 6 more rows to give you the next 6 most recent dates.

Again, now that you have the dates, you can use that as a lookup value in
the VLOOKUP function.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Buckeye Epstein" wrote:

I have a work sheet with stock data entered every day. I need like
on B15 with the title on A15 Last 7 days volume. The data starts on
A38 with the date, open is on b38, high is on c38, low is on d38,
close is on e38 and volume is on f38. Currenlty i have about 75 days
but would like to set data end at 500 cells. Please help me with
this fomula..

One more request. I would like to have also the last date with
closing price. The cell I would like to place this is A36. So I
need the computer to find the last data of entry from a38:a500 and
then go to that cell - in e38 for the close.

Thanks JBE

On Sep 18, 12:00*pm, Luke M wrote:
The trick here will be to first determine the dates to pull. After that, you
can simply use the VLOOKUP function (see XL help for full detail) to pull in
the other info.

For the dates, to pull the last seven days, assuming you are entereing dates
as true dates/numbers.

Latest date:
=LARGE(A$38:A$500,ROW(A1))
Copy this down 6 more rows to give you the next 6 most recent dates.

Again, now that you have the dates, you can use that as a lookup value in
the VLOOKUP function.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*



"Buckeye Epstein" wrote:
I have a work sheet with stock data entered every day. * I need like
on B15 with the title on A15 Last 7 days volume. * The data starts on
A38 with the date, open is on b38, high is on c38, low is on d38,
close is on e38 and volume is on f38. *Currenlty i have about 75 days
but would like to set data end at 500 cells. * Please help me with
this fomula..

One more request. *I would like to have also the last date with
closing price. * The cell I would like to place this is A36. *So I
need the computer to find the last data of entry from a38:a500 and
then go to that cell - in e38 for the close.

Thanks *JBE- Hide quoted text -

- Show quoted text -

Do not understand. I want this to be automatic.

date - open - high - low - close - volume
August 28, 2009 0.013 0.013 0.009 0.01 412,980
September 1, 2009 0.01 0.01 0.0088 0.0088 100,999
September 2, 2009 0.0089 0.009 0.0084 0.0084 181,200
September 3, 2009 0.0082 0.0082 0.008 0.0082 159,100
September 4, 2009 0.0082 0.0082 0.0082 0.0082 54,618
September 8, 2009 0.0096 0.0096 0.0082 0.0089 22,533
September 9, 2009 0.0082 0.0082 0.0055 0.0055 358,528
September 10, 2009 0.0065 0.0065 0.0055 0.0055 246,939
I will just add every day the next date..then i want the computer on
cell lets say x9 to say what was the 7 day average close.