Min/Max multiple rows into another sheet

D

Dan

I have the following stock data. I would like to summarize 3 days (rows) into
one row on another sheet. I would like to take the date and opening from day
1 and then take the Max of the next 3 rows (high) , the Min of the next 3
rows (low) and the close of the 3rd row and put this into 1 line on another
sheet. This 3 day aggregation I would like to do for the entire sheet. so
1/2, 1/3 and 1/4 would be one row and 1/4, 1/5 1/8 would be next row etc.....

Date Open High Low Close
1/2/1962 578.5 578.5 572 572
1/3/1962 572 577 572 577
1/4/1962 577 577 571 571.25
1/5/1962 570.5 570.5 559 560
1/8/1962 559.5 559.5 545 549.5
1/9/1962 552 563 552 556
1/10/1962 557 559.5 557 557
1/11/1962 558.5 563 558.5 563
1/12/1962 564 568 564 564

Thanks in advance - Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top