| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | MonthYr | Price | SPY | TLT | Day of Month | SPY Ret | TLT Ret | ||||||||||
2 | 7/1/2002 | 7/30/2002 | 59.34179306 | 37.32603073 | 19 | 1 | 0.16% | -0.02% | |||||||||
3 | 7/1/2002 | 7/31/2002 | 59.48537445 | 37.78850937 | 20 | 0.24% | 1.23% | 2 | 0.08% | -0.04% | |||||||
4 | 8/1/2002 | 8/1/2002 | 57.9323082 | 38.00371552 | 1 | -2.65% | 0.57% | 3 | 0.00% | -0.17% | |||||||
5 | 8/1/2002 | 8/2/2002 | 56.6337738 | 38.39291 | 2 | -2.27% | 1.02% | 4 | 0.03% | 0.02% | |||||||
6 | 8/1/2002 | 8/5/2002 | 54.66309357 | 38.56227875 | 3 | -3.54% | 0.44% | 5 | 0.01% | -0.08% | |||||||
7 | 8/1/2002 | 8/6/2002 | 56.50325775 | 38.23263168 | 4 | 3.31% | -0.86% | 6 | 0.02% | -0.04% | |||||||
8 | 8/1/2002 | 8/7/2002 | 57.48861694 | 38.3241806 | 5 | 1.73% | 0.24% | 7 | 0.04% | -0.07% | |||||||
9 | 8/1/2002 | 8/8/2002 | 59.34833527 | 38.3241806 | 6 | 3.18% | 0.00% | 8 | -0.01% | 0.00% | |||||||
10 | 8/1/2002 | 8/9/2002 | 59.57019806 | 38.86449814 | 7 | 0.37% | 1.40% | 9 | 0.10% | 0.01% | |||||||
11 | 8/1/2002 | 8/12/2002 | 59.13299561 | 39.10261536 | 8 | -0.74% | 0.61% | 10 | 0.07% | 0.03% | |||||||
12 | 8/1/2002 | 8/13/2002 | 58.05632782 | 39.58336639 | 9 | -1.84% | 1.22% | 11 | 0.13% | 0.04% | |||||||
13 | 8/1/2002 | 8/14/2002 | 60.17708206 | 39.73446655 | 10 | 3.59% | 0.38% | 12 | 0.11% | 0.07% | |||||||
14 | 8/1/2002 | 8/15/2002 | 61.01230621 | 39.38652039 | 11 | 1.38% | -0.88% | 13 | -0.09% | -0.01% | |||||||
15 | 8/1/2002 | 8/16/2002 | 60.8296051 | 38.94694519 | 12 | -0.30% | -1.12% | 14 | -0.13% | 0.06% | |||||||
16 | 8/1/2002 | 8/19/2002 | 62.25214005 | 39.06599045 | 13 | 2.31% | 0.31% | 15 | 0.06% | 0.06% | |||||||
17 | 8/1/2002 | 8/20/2002 | 61.5930481 | 39.50098038 | 14 | -1.06% | 1.11% | 16 | 0.02% | 0.06% | |||||||
18 | 8/1/2002 | 8/21/2002 | 62.48052216 | 39.29032898 | 15 | 1.43% | -0.53% | 17 | 0.02% | 0.09% | |||||||
19 | 8/1/2002 | 8/22/2002 | 63.0873642 | 38.94694519 | 16 | 0.97% | -0.88% | 18 | 0.05% | -0.08% | |||||||
20 | 8/1/2002 | 8/23/2002 | 61.73009109 | 39.33155441 | 17 | -2.17% | 0.98% | 19 | 0.08% | 0.13% | |||||||
21 | 8/1/2002 | 8/26/2002 | 62.16078186 | 39.36818695 | 18 | 0.70% | 0.09% | 20 | 0.05% | 0.12% | |||||||
22 | 8/1/2002 | 8/27/2002 | 61.44297028 | 39.12095642 | 19 | -1.16% | -0.63% | 21 | 0.12% | 0.14% | |||||||
23 | 8/1/2002 | 8/28/2002 | 60.09873199 | 39.31783295 | 20 | -2.21% | 0.50% | 22 | -0.07% | 0.16% | |||||||
24 | 8/1/2002 | 8/29/2002 | 60.12485123 | 39.63371658 | 21 | 0.04% | 0.80% | 23 | 0.09% | 0.12% | |||||||
25 | 8/1/2002 | 8/30/2002 | 59.88997269 | 39.87182999 | 22 | -0.39% | 0.60% | ||||||||||
26 | 9/1/2002 | 9/3/2002 | 57.60605621 | 40.4848175 | 1 | -3.89% | 1.53% | ||||||||||
27 | 9/1/2002 | 9/4/2002 | 58.42825317 | 40.47560883 | 2 | 1.42% | -0.02% | ||||||||||
28 | 9/1/2002 | 9/5/2002 | 57.9323082 | 40.69632339 | 3 | -0.85% | 0.54% | ||||||||||
29 | 9/1/2002 | 9/6/2002 | 58.7284317 | 40.21808243 | 4 | 1.36% | -1.18% | ||||||||||
30 | 9/1/2002 | 9/9/2002 | 59.15908432 | 40.15832901 | 5 | 0.73% | -0.15% | ||||||||||
31 | 9/1/2002 | 9/10/2002 | 59.83773422 | 40.35147476 | 6 | 1.14% | 0.48% | ||||||||||
32 | 9/1/2002 | 9/11/2002 | 59.46580887 | 40.13991547 | 7 | -0.62% | -0.53% | ||||||||||
33 | 9/1/2002 | 9/12/2002 | 58.36951828 | 40.45261383 | 8 | -1.86% | 0.78% | ||||||||||
34 | 9/1/2002 | 9/13/2002 | 58.51309586 | 40.82509613 | 9 | 0.25% | 0.92% | ||||||||||
35 | 9/1/2002 | 9/16/2002 | 58.65662384 | 40.89407349 | 10 | 0.24% | 0.17% | ||||||||||
36 | 9/1/2002 | 9/17/2002 | 57.312397 | 40.97223663 | 11 | -2.32% | 0.19% | ||||||||||
37 | 9/1/2002 | 9/18/2002 | 56.73819351 | 40.98143768 | 12 | -1.01% | 0.02% | ||||||||||
38 | 9/1/2002 | 9/19/2002 | 55.26996994 | 41.25738144 | 13 | -2.62% | 0.67% | ||||||||||
39 | 9/1/2002 | 9/20/2002 | 55.28830338 | 41.06417465 | 14 | 0.03% | -0.47% | ||||||||||
40 | 9/1/2002 | 9/23/2002 | 54.83603668 | 41.43207169 | 15 | -0.82% | 0.89% | ||||||||||
41 | 9/1/2002 | 9/24/2002 | 53.95118713 | 41.69876862 | 16 | -1.63% | 0.64% | ||||||||||
42 | 9/1/2002 | 9/25/2002 | 55.28830338 | 41.19300079 | 17 | 2.45% | -1.22% | ||||||||||
43 | 9/1/2002 | 9/26/2002 | 56.19285583 | 41.09641266 | 18 | 1.62% | -0.23% | ||||||||||
44 | 9/1/2002 | 9/27/2002 | 54.23961258 | 41.40449142 | 19 | -3.54% | 0.75% | ||||||||||
45 | 9/1/2002 | 9/30/2002 | 53.61035919 | 41.57005692 | 20 | -1.17% | 0.40% | ||||||||||
46 | 10/1/2002 | 10/1/2002 | 56.18627167 | 41.05444717 | 1 | 4.69% | -1.25% | ||||||||||
47 | 10/1/2002 | 10/2/2002 | 54.50178528 | 41.28986359 | 2 | -3.04% | 0.57% | ||||||||||
48 | 10/1/2002 | 10/3/2002 | 53.95118713 | 41.18829346 | 3 | -1.02% | -0.25% | ||||||||||
49 | 10/1/2002 | 10/4/2002 | 52.96141434 | 41.31753922 | 4 | -1.85% | 0.31% | ||||||||||
50 | 10/1/2002 | 10/7/2002 | 51.86679459 | 41.3867836 | 5 | -2.09% | 0.17% | ||||||||||
51 | 10/1/2002 | 10/8/2002 | 52.6795578 | 41.4006424 | 6 | 1.55% | 0.03% | ||||||||||
52 | 10/1/2002 | 10/9/2002 | 51.19167328 | 41.61297989 | 7 | -2.87% | 0.51% | ||||||||||
53 | 10/1/2002 | 10/10/2002 | 52.84999466 | 41.28523254 | 8 | 3.19% | -0.79% | ||||||||||
54 | 10/1/2002 | 10/11/2002 | 55.16379547 | 40.79595184 | 9 | 4.28% | -1.19% | ||||||||||
55 | 10/1/2002 | 10/14/2002 | 55.47185898 | 40.73591995 | 10 | 0.56% | -0.15% | ||||||||||
56 | 10/1/2002 | 10/15/2002 | 58.13961792 | 39.77120209 | 11 | 4.70% | -2.40% | ||||||||||
57 | 10/1/2002 | 10/16/2002 | 56.73035049 | 39.7896347 | 12 | -2.45% | 0.05% | ||||||||||
58 | 10/1/2002 | 10/17/2002 | 57.85773468 | 39.30500793 | 13 | 1.97% | -1.23% | ||||||||||
59 | 10/1/2002 | 10/18/2002 | 58.10025787 | 39.40655518 | 14 | 0.42% | 0.26% | ||||||||||
60 | 10/1/2002 | 10/21/2002 | 59.10311508 | 39.02340317 | 15 | 1.71% | -0.98% | ||||||||||
61 | 10/1/2002 | 10/22/2002 | 58.67705917 | 38.91261673 | 16 | -0.72% | -0.28% | ||||||||||
62 | 10/1/2002 | 10/23/2002 | 59.12277985 | 38.92644119 | 17 | 0.76% | 0.04% | ||||||||||
63 | 10/1/2002 | 10/24/2002 | 57.91672134 | 39.2680397 | 18 | -2.06% | 0.87% | ||||||||||
64 | 10/1/2002 | 10/25/2002 | 59.12277985 | 39.41115189 | 19 | 2.06% | 0.36% | ||||||||||
65 | 10/1/2002 | 10/28/2002 | 58.73606491 | 39.3557663 | 20 | -0.66% | -0.14% | ||||||||||
66 | 10/1/2002 | 10/29/2002 | 58.05437469 | 39.8681488 | 21 | -1.17% | 1.29% | ||||||||||
67 | 10/1/2002 | 10/30/2002 | 58.61806488 | 39.85430527 | 22 | 0.97% | -0.03% | ||||||||||
68 | 10/1/2002 | 10/31/2002 | 58.02157211 | 40.03429413 | 23 | -1.02% | 0.45% | ||||||||||
69 | 11/1/2002 | 11/1/2002 | 59.16868591 | 39.86693192 | 1 | 1.96% | -0.42% | ||||||||||
70 | 11/1/2002 | 11/4/2002 | 59.73239517 | 39.69074249 | 2 | 0.95% | -0.44% | ||||||||||
71 | 11/1/2002 | 11/5/2002 | 60.20429993 | 39.53769684 | 3 | 0.79% | -0.39% | ||||||||||
72 | 11/1/2002 | 11/6/2002 | 60.98430252 | 39.69538498 | 4 | 1.29% | 0.40% | ||||||||||
73 | 11/1/2002 | 11/7/2002 | 59.48984909 | 40.67834473 | 5 | -2.48% | 2.45% | ||||||||||
74 | 11/1/2002 | 11/8/2002 | 58.76229858 | 41.0075531 | 6 | -1.23% | 0.81% | ||||||||||
75 | 11/1/2002 | 11/11/2002 | 57.85118866 | 41.23011017 | 7 | -1.56% | 0.54% | ||||||||||
76 | 11/1/2002 | 11/12/2002 | 58.310009 | 40.99363708 | 8 | 0.79% | -0.58% | ||||||||||
77 | 11/1/2002 | 11/13/2002 | 58.3690033 | 41.08174896 | 9 | 0.10% | 0.21% | ||||||||||
78 | 11/1/2002 | 11/14/2002 | 59.47016525 | 40.22859955 | 10 | 1.87% | -2.10% | ||||||||||
79 | 11/1/2002 | 11/15/2002 | 59.90933609 | 40.39088058 | 11 | 0.74% | 0.40% | ||||||||||
80 | 11/1/2002 | 11/18/2002 | 59.30632782 | 40.57171631 | 12 | -1.01% | 0.45% | ||||||||||
81 | 11/1/2002 | 11/19/2002 | 59.22763443 | 40.72012711 | 13 | -0.13% | 0.37% | ||||||||||
82 | 11/1/2002 | 11/20/2002 | 60.54513168 | 40.32131577 | 14 | 2.20% | -0.98% | ||||||||||
83 | 11/1/2002 | 11/21/2002 | 61.67251205 | 39.93181229 | 15 | 1.84% | -0.97% | ||||||||||
84 | 11/1/2002 | 11/22/2002 | 61.23339081 | 39.89473724 | 16 | -0.71% | -0.09% | ||||||||||
85 | 11/1/2002 | 11/25/2002 | 61.27267456 | 39.82054901 | 17 | 0.06% | -0.19% | ||||||||||
86 | 11/1/2002 | 11/26/2002 | 60.10596466 | 40.32131577 | 18 | -1.92% | 1.25% | ||||||||||
87 | 11/1/2002 | 11/27/2002 | 61.79705429 | 39.41253662 | 19 | 2.77% | -2.28% | ||||||||||
88 | 11/1/2002 | 11/29/2002 | 61.60043716 | 39.66752243 | 20 | -0.32% | 0.64% | ||||||||||
89 | 12/1/2002 | 12/2/2002 | 61.69874191 | 39.7043457 | 1 | 0.16% | 0.09% | ||||||||||
90 | 12/1/2002 | 12/3/2002 | 60.87285995 | 39.76025772 | 2 | -1.35% | 0.14% | ||||||||||
91 | 12/1/2002 | 12/4/2002 | 60.59757996 | 39.96518707 | 3 | -0.45% | 0.51% | ||||||||||
92 | 12/1/2002 | 12/5/2002 | 59.92896652 | 40.06765747 | 4 | -1.11% | 0.26% | ||||||||||
93 | 12/1/2002 | 12/6/2002 | 60.3222847 | 40.13750839 | 5 | 0.65% | 0.17% | ||||||||||
94 | 12/1/2002 | 12/9/2002 | 58.66398621 | 40.36111069 | 6 | -2.79% | 0.56% | ||||||||||
95 | 12/1/2002 | 12/10/2002 | 59.45051575 | 40.46822739 | 7 | 1.33% | 0.27% | ||||||||||
96 | 12/1/2002 | 12/11/2002 | 59.50294113 | 40.73838425 | 8 | 0.09% | 0.67% | ||||||||||
97 | 12/1/2002 | 12/12/2002 | 59.49639511 | 40.70116043 | 9 | -0.01% | -0.09% | ||||||||||
98 | 12/1/2002 | 12/13/2002 | 58.55913162 | 40.30521393 | 10 | -1.59% | -0.98% | ||||||||||
99 | 12/1/2002 | 12/16/2002 | 60.07321548 | 40.00247192 | 11 | 2.55% | -0.75% | ||||||||||
100 | 12/1/2002 | 12/17/2002 | 59.5488205 | 40.00247192 | 12 | -0.88% | 0.00% |