| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 日期 | 收盤價 | 每月存10,000 | 剩餘現金 | 買進張數 | 買進金額 | 累計張數 | 配息 | ||
2 | 2003.07.01 | 38.05 | -10,000 | 10,000 | 0 | 0 | ||||
3 | 2003.08.01 | 41.6 | -10,000 | 20,000 | 0 | 0 | ||||
4 | 2003.09.01 | 45.15 | -10,000 | 30,000 | 0 | 0 | ||||
5 | 2003.10.01 | 44.16 | -10,000 | 40,000 | 0 | 0 | ||||
6 | 2003.11.03 | 48 | -10,000 | 50,000 | 1 | 48,068 | 1 | |||
7 | 2003.12.01 | 46.2 | -10,000 | 11,932 | 0 | 1 | ||||
8 | 2004.01.02 | 47.3 | -10,000 | 21,932 | 0 | 1 | ||||
9 | 2004.02.02 | 48.3 | -10,000 | 31,932 | 0 | 1 | ||||
10 | 2004.03.01 | 51.95 | -10,000 | 41,932 | 0 | 1 | ||||
11 | 2004.04.01 | 48.7 | -10,000 | 51,932 | 1 | 48,769 | 2 | |||
12 | 2004.05.03 | 45.95 | -10,000 | 13,162 | 0 | 2 | ||||
13 | 2004.06.01 | 45.2 | -10,000 | 23,162 | 0 | 2 | ||||
14 | 2004.07.01 | 44.91 | -10,000 | 33,162 | 0 | 2 | ||||
15 | 2004.08.02 | 41.65 | -10,000 | 43,162 | 1 | 41,709 | 3 | |||
16 | 2004.09.01 | 45.8 | -10,000 | 11,453 | 0 | 3 | ||||
17 | 2004.10.01 | 46.3 | -10,000 | 21,453 | 0 | 3 | ||||
18 | 2004.11.01 | 44.29 | -10,000 | 31,453 | 0 | 3 | ||||
19 | 2004.12.01 | 45.63 | -10,000 | 41,453 | 0 | 3 | ||||
20 | 2005.01.03 | 48.3 | -10,000 | 51,453 | 1 | 48,369 | 4 | |||
21 | 2005.02.01 | 47.08 | -10,000 | 13,084 | 0 | 4 | ||||
22 | 2005.03.01 | 48.83 | -10,000 | 23,084 | 0 | 4 | ||||
23 | 2005.04.01 | 46.75 | -10,000 | 33,084 | 0 | 4 | ||||
24 | 2005.05.03 | 45.94 | -10,000 | 43,084 | 0 | 4 | ||||
25 | 2005.05.19 | 45.38 | 43,084 | 0 | 4 | 7,400 | ||||
26 | 2005.06.01 | 45.15 | -10,000 | 60,484 | 1 | 45,214 | 5 | |||
27 | 2005.07.01 | 47.58 | -10,000 | 25,270 | 0 | 5 | ||||
28 | 2005.08.01 | 48.33 | -10,000 | 35,270 | 0 | 5 | ||||
29 | 2005.09.02 | 47.33 | -10,000 | 45,270 | 0 | 5 | ||||
30 | 2005.10.03 | 47.69 | -10,000 | 55,270 | 1 | 47,758 | 6 | |||
31 | 2005.11.01 | 45.52 | -10,000 | 17,512 | 0 | 6 | ||||
32 | 2005.12.01 | 48.7 | -10,000 | 27,512 | 0 | 6 | ||||
33 | 2006.01.02 | 50.55 | -10,000 | 37,512 | 0 | 6 | ||||
34 | 2006.02.03 | 51.6 | -10,000 | 47,512 | 0 | 6 | ||||
35 | 2006.03.01 | 52.85 | -10,000 | 57,512 | 1 | 52,925 | 7 | |||
36 | 2006.04.03 | 53.1 | -10,000 | 14,586 | 0 | 7 | ||||
37 | 2006.05.02 | 56.8 | -10,000 | 24,586 | 0 | 7 | ||||
38 | 2006.06.01 | 53.4 | -10,000 | 34,586 | 0 | 7 | ||||
39 | 2006.07.03 | 53.05 | -10,000 | 44,586 | 0 | 7 | ||||
40 | 2006.08.01 | 51.45 | -10,000 | 54,586 | 1 | 51,523 | 8 | |||
41 | 2006.09.01 | 54.35 | -10,000 | 13,063 | 0 | 8 | ||||
42 | 2006.10.02 | 56.75 | -10,000 | 23,063 | 0 | 8 | ||||
43 | 2006.10.26 | 53.6 | 23,063 | 0 | 8 | 32,000 | ||||
44 | 2006.11.01 | 53.25 | -10,000 | 65,063 | 1 | 53,326 | 9 | |||
45 | 2006.12.01 | 56.6 | -10,000 | 21,737 | 0 | 9 | ||||
46 | 2007.01.02 | 58.45 | -10,000 | 31,737 | 0 | 9 | ||||
47 | 2007.02.01 | 56.75 | -10,000 | 41,737 | 0 | 9 | ||||
48 | 2007.03.01 | 56.05 | -10,000 | 51,737 | 0 | 9 | ||||
49 | 2007.04.02 | 56.7 | -10,000 | 61,737 | 1 | 56,781 | 10 | |||
50 | 2007.05.02 | 57.55 | -10,000 | 14,956 | 0 | 10 | ||||
51 | 2007.06.01 | 60 | -10,000 | 24,956 | 0 | 10 | ||||
52 | 2007.07.02 | 65.6 | -10,000 | 34,956 | 0 | 10 | ||||
53 | 2007.08.01 | 63.3 | -10,000 | 44,956 | 0 | 10 | ||||
54 | 2007.09.03 | 65.8 | -10,000 | 54,956 | 0 | 10 | ||||
55 | 2007.10.01 | 69.35 | -10,000 | 64,956 | 0 | 10 | ||||
56 | 2007.10.24 | 67.7 | 64,956 | 0 | 10 | 25,000 | ||||
57 | 2007.11.01 | 69.45 | -10,000 | 99,956 | 1 | 69,549 | 11 | |||
58 | 2007.12.03 | 61.95 | -10,000 | 40,407 | 0 | 11 | ||||
59 | 2008.01.02 | 60.1 | -10,000 | 50,407 | 0 | 11 | ||||
60 | 2008.02.01 | 56.4 | -10,000 | 60,407 | 1 | 56,480 | 12 | |||
61 | 2008.03.03 | 59.15 | -10,000 | 13,927 | 0 | 12 | ||||
62 | 2008.04.01 | 60.05 | -10,000 | 23,927 | 0 | 12 | ||||
63 | 2008.05.02 | 64.2 | -10,000 | 33,927 | 0 | 12 | ||||
64 | 2008.06.02 | 62.6 | -10,000 | 43,927 | 0 | 12 | ||||
65 | 2008.07.01 | 54.9 | -10,000 | 53,927 | 0 | 12 | ||||
66 | 2008.08.01 | 52.4 | -10,000 | 63,927 | 1 | 52,475 | 13 | |||
67 | 2008.09.01 | 51.45 | -10,000 | 21,452 | 0 | 13 | ||||
68 | 2008.10.01 | 45.6 | -10,000 | 31,452 | 0 | 13 | ||||
69 | 2008.10.24 | 32.34 | 31,452 | 0 | 13 | 26,000 | ||||
70 | 2008.11.03 | 36.69 | -10,000 | 67,452 | 1 | 36,742 | 14 | |||
71 | 2008.12.01 | 32.5 | -10,000 | 40,710 | 1 | 32,546 | 15 | |||
72 | 2009.01.05 | 34.2 | -10,000 | 18,164 | 0 | 15 | ||||
73 | 2009.02.02 | 30.88 | -10,000 | 28,164 | 0 | 15 | ||||
74 | 2009.03.02 | 31.93 | -10,000 | 38,164 | 1 | 31,976 | 16 | |||
75 | 2009.04.01 | 37.29 | -10,000 | 16,188 | 0 | 16 | ||||
76 | 2009.05.04 | 45.1 | -10,000 | 26,188 | 0 | 16 | ||||
77 | 2009.06.01 | 47.72 | -10,000 | 36,188 | 0 | 16 | ||||
78 | 2009.07.01 | 45.45 | -10,000 | 46,188 | 1 | 45,515 | 17 | |||
79 | 2009.08.03 | 49.19 | -10,000 | 10,674 | 0 | 17 | ||||
80 | 2009.09.01 | 50.2 | -10,000 | 20,674 | 0 | 17 | ||||
81 | 2009.10.01 | 53.65 | -10,000 | 30,674 | 0 | 17 | ||||
82 | 2009.10.23 | 53.25 | 30,674 | 0 | 17 | 17,000 | ||||
83 | 2009.11.02 | 51.35 | -10,000 | 57,674 | 1 | 51,423 | 18 | |||
84 | 2009.12.01 | 53.25 | -10,000 | 16,250 | 0 | 18 | ||||
85 | 2010.01.04 | 56.5 | -10,000 | 26,250 | 0 | 18 | ||||
86 | 2010.02.01 | 52.4 | -10,000 | 36,250 | 0 | 18 | ||||
87 | 2010.03.01 | 52.8 | -10,000 | 46,250 | 0 | 18 | ||||
88 | 2010.04.01 | 54.75 | -10,000 | 56,250 | 1 | 54,828 | 19 | |||
89 | 2010.05.03 | 54.45 | -10,000 | 11,422 | 0 | 19 | ||||
90 | 2010.06.01 | 49.83 | -10,000 | 21,422 | 0 | 19 | ||||
91 | 2010.07.01 | 49.19 | -10,000 | 31,422 | 0 | 19 | ||||
92 | 2010.08.02 | 54.95 | -10,000 | 41,422 | 0 | 19 | ||||
93 | 2010.09.01 | 53.7 | -10,000 | 51,422 | 0 | 19 | ||||
94 | 2010.10.01 | 57.75 | -10,000 | 61,422 | 1 | 57,832 | 20 | |||
95 | 2010.10.25 | 56.1 | 3,590 | 0 | 20 | 44,000 | ||||
96 | 2010.11.01 | 56.8 | -10,000 | 57,590 | 1 | 56,881 | 21 | |||
97 | 2010.12.01 | 58 | -10,000 | 10,709 | 0 | 21 | ||||
98 | 2011.01.03 | 61.45 | -10,000 | 20,709 | 0 | 21 | ||||
99 | 2011.02.08 | 62.6 | -10,000 | 30,709 | 0 | 21 | ||||
100 | 2011.03.01 | 59.95 | -10,000 | 40,709 | 0 | 21 |