Extracting Weekly and Monthly price points from Daily price data.

[Brunks]

Hi all,

I have listed a simple stock price table that shows daily prices. I want to find a filter (or some other way) to just show the WEEKLY prices and the MONTHLY prices. I have tried filtering the date column in the table but there is no option for "show weekly points" or "filter for weekly data". How would I go about doing this?

Thanks for any help you can offer.

Date	Open	High	Low	Close	Volume
4-Sep-07	68.1	71.27	67.97	70.6	7150000
5-Sep-07	70.12	71.22	70.06	70.98	6435900
6-Sep-07	70.98	72.3	69.6	70.39	8968766
7-Sep-07	69.7	69.93	68.28	69.36	8229878
10-Sep-07	69.19	69.28	66.9	68.03	6889300
11-Sep-07	68.03	68.31	66.51	67.9	8427350
12-Sep-07	67.8	68.31	66.38	66.75	13278700
13-Sep-07	66.97	69.45	66.97	68.72	9377165
14-Sep-07	68.72	69.77	68.21	69.29	4874910
17-Sep-07	69.12	69.21	67.41	68.58	5959900
18-Sep-07	68.71	70.5	68.04	70.2	6642610
19-Sep-07	70.64	71.55	68.91	69.57	8513831
20-Sep-07	69.78	70.55	69.15	70.09	4929600
21-Sep-07	70.74	71.39	70.09	71.05	6780900
24-Sep-07	71.23	71.57	70.58	70.87	7074972
25-Sep-07	70.02	70.17	68.61	68.85	8313346
26-Sep-07	69.7	69.75	67.16	68.26	9753975
27-Sep-07	69.08	69.08	67.32	67.56	5991700
28-Sep-07	68	68.49	66.92	67.18	6360726
1-Oct-07	66.92	67.57	66.39	67.44	6598826
2-Oct-07	67.09	68.2	66.6	67.9	7199500
3-Oct-07	67.36	68	66.5	67.09	6946900
4-Oct-07	66.65	68.04	65.97	67.86	5399100
5-Oct-07	68.2	68.87	67.13	68.35	6283300
8-Oct-07	68.85	71.28	68.81	70.77	12027134
9-Oct-07	71.25	72.49	70.56	72.19	10616425
10-Oct-07	70.06	75.22	69.95	74.25	18330800
11-Oct-07	74.45	75.66	71.83	73.25	11596450
12-Oct-07	72.75	74.05	72.42	73.49	6198639

<colgroup><col><col span="4"><col><col></colgroup><tbody>
</tbody>

 

[Brunks]

bump

 

[ExcelTactics]

Let's say you're looking to capture every Friday... (The first Friday is on Sept. 7th) Make column G =A5, column H =B5, etc. Make your selection include row 5 (where Sept. 7 is) and the next 4 rows (just prior to the next Friday). It should look like this:

When you drag down to extend the selection (using the little mark in the lower right), it will pick up only every 5th entry (every Friday).

When you're done, you can sort Columns G:L by date, and you should have your weekly list. Monthly might be more tricky...

 

[Oeldere]

To get the month.

f2 = Month(a2) and drag down.

then you can filter on column F.