C
CEGavinMcGrath
I am trying to make a Weekly data table from a Daily table for some financial
information, along the following lines:
Date Open High Low Close
29/08/2008 558 565 545 550
28/08/2008 527 560 516 558
27/08/2008 525 525 505 519
26/08/2008 515 530 513 522
22/08/2008 522 535 514 530
21/08/2008 540 541 516 516
20/08/2008 560 560 530 540
19/08/2008 576 578 543 546
18/08/2008 610 614 587 587
15/08/2008 608 620 591 610
14/08/2008 581 606 572 602
13/08/2008 602 602 565 571
I want to pull the Open data for the first day in each week in the data
series (ie 602 for 13/08/08, 610 for 18/8/08, 515 for 26/8/08, etc.). Does
anybody know how I might go about doing this?
Kind regards.
information, along the following lines:
Date Open High Low Close
29/08/2008 558 565 545 550
28/08/2008 527 560 516 558
27/08/2008 525 525 505 519
26/08/2008 515 530 513 522
22/08/2008 522 535 514 530
21/08/2008 540 541 516 516
20/08/2008 560 560 530 540
19/08/2008 576 578 543 546
18/08/2008 610 614 587 587
15/08/2008 608 620 591 610
14/08/2008 581 606 572 602
13/08/2008 602 602 565 571
I want to pull the Open data for the first day in each week in the data
series (ie 602 for 13/08/08, 610 for 18/8/08, 515 for 26/8/08, etc.). Does
anybody know how I might go about doing this?
Kind regards.