A | B | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | DATA IMPORTED FROM THINKORSWIM | QLD | ||||||||||||||||||
2 | Symbol | Date | Close | PrevClose | % Change (QQQ) | % Change (QLD) | QLD Value: Starting at $1,000 | Expense Ratio: -0.95% at end of year | QQQ's value (1/24/2025): | QLD's value (1/24/2025): | ||||||||||
3 | RESULTS---> | $10,372 | $10,113 | |||||||||||||||||
4 | $1,000 | 0.95% | <--- INPUTS | |||||||||||||||||
5 | QQQ | 3/11/1999 | 51.31 | 51.06 | 0.49% | 0.98% | $1,010 | |||||||||||||
6 | QQQ | 3/12/1999 | 50.06 | 51.31 | -2.44% | -4.87% | $961 | |||||||||||||
7 | QQQ | 3/15/1999 | 51.50 | 50.06 | 2.87% | 5.74% | $1,016 | |||||||||||||
8 | QQQ | 3/16/1999 | 51.94 | 51.50 | 0.85% | 1.70% | $1,033 | |||||||||||||
9 | QQQ | 3/17/1999 | 51.56 | 51.94 | -0.72% | -1.44% | $1,018 | |||||||||||||
10 | QQQ | 3/18/1999 | 52.56 | 51.56 | 1.94% | 3.88% | $1,058 | |||||||||||||
11 | QQQ | 3/19/1999 | 51.22 | 52.56 | -2.56% | -5.11% | $1,004 | |||||||||||||
12 | QQQ | 3/22/1999 | 50.59 | 51.22 | -1.22% | -2.44% | $979 | $54 | ||||||||||||
13 | QQQ | 3/23/1999 | 48.81 | 50.59 | -3.52% | -7.04% | $910 | |||||||||||||
14 | QQQ | 3/24/1999 | 50.47 | 48.81 | 3.39% | 6.79% | $972 | |||||||||||||
15 | QQQ | 3/25/1999 | 52.31 | 50.47 | 3.65% | 7.31% | $1,043 | |||||||||||||
16 | QQQ | 3/26/1999 | 51.75 | 52.31 | -1.08% | -2.15% | $1,020 | |||||||||||||
17 | QQQ | 3/29/1999 | 53.63 | 51.75 | 3.62% | 7.25% | $1,094 | |||||||||||||
18 | QQQ | 3/30/1999 | 53.25 | 53.63 | -0.70% | -1.40% | $1,079 | |||||||||||||
19 | QQQ | 3/31/1999 | 52.47 | 53.25 | -1.47% | -2.93% | $1,047 | |||||||||||||
20 | QQQ | 4/1/1999 | 53.56 | 52.47 | 2.08% | 4.17% | $1,091 | |||||||||||||
21 | QQQ | 4/5/1999 | 55.50 | 53.56 | 3.62% | 7.23% | $1,170 | |||||||||||||
22 | QQQ | 4/6/1999 | 55.61 | 55.50 | 0.20% | 0.39% | $1,175 | |||||||||||||
23 | QQQ | 4/7/1999 | 55.03 | 55.61 | -1.04% | -2.08% | $1,150 | |||||||||||||
24 | QQQ | 4/8/1999 | 55.47 | 55.03 | 0.80% | 1.59% | $1,168 | |||||||||||||
25 | QQQ | 4/9/1999 | 55.81 | 55.47 | 0.62% | 1.24% | $1,183 | |||||||||||||
26 | QQQ | 4/12/1999 | 55.44 | 55.81 | -0.67% | -1.34% | $1,167 | |||||||||||||
27 | QQQ | 4/13/1999 | 54.69 | 55.44 | -1.35% | -2.71% | $1,135 | |||||||||||||
28 | QQQ | 4/14/1999 | 52.81 | 54.69 | -3.43% | -6.86% | $1,058 | |||||||||||||
29 | QQQ | 4/15/1999 | 53.53 | 52.81 | 1.36% | 2.72% | $1,086 | |||||||||||||
30 | QQQ | 4/16/1999 | 51.97 | 53.53 | -2.92% | -5.84% | $1,023 | |||||||||||||
31 | QQQ | 4/19/1999 | 49.53 | 51.97 | -4.69% | -9.38% | $927 | |||||||||||||
32 | QQQ | 4/20/1999 | 50.66 | 49.53 | 2.27% | 4.54% | $969 | |||||||||||||
33 | QQQ | 4/21/1999 | 53.16 | 50.66 | 4.94% | 9.87% | $1,065 | |||||||||||||
34 | QQQ | 4/22/1999 | 54.59 | 53.16 | 2.70% | 5.41% | $1,122 | |||||||||||||
35 | QQQ | 4/23/1999 | 55.31 | 54.59 | 1.32% | 2.63% | $1,152 | |||||||||||||
36 | QQQ | 4/26/1999 | 56.59 | 55.31 | 2.30% | 4.60% | $1,205 | |||||||||||||
37 | QQQ | 4/27/1999 | 55.72 | 56.59 | -1.53% | -3.06% | $1,168 | |||||||||||||
38 | QQQ | 4/28/1999 | 53.81 | 55.72 | -3.42% | -6.84% | $1,088 | |||||||||||||
39 | QQQ | 4/29/1999 | 53.38 | 53.81 | -0.81% | -1.63% | $1,070 | |||||||||||||
40 | QQQ | 4/30/1999 | 53.72 | 53.38 | 0.64% | 1.29% | $1,084 | |||||||||||||
41 | QQQ | 5/3/1999 | 53.44 | 53.72 | -0.52% | -1.05% | $1,073 | |||||||||||||
42 | QQQ | 5/4/1999 | 52.59 | 53.44 | -1.58% | -3.16% | $1,039 | |||||||||||||
43 | QQQ | 5/5/1999 | 54.19 | 52.59 | 3.03% | 6.06% | $1,102 | |||||||||||||
44 | QQQ | 5/6/1999 | 52.22 | 54.19 | -3.63% | -7.27% | $1,022 | |||||||||||||
45 | QQQ | 5/7/1999 | 52.97 | 52.22 | 1.44% | 2.87% | $1,051 | |||||||||||||
46 | QQQ | 5/10/1999 | 53.50 | 52.97 | 1.00% | 2.01% | $1,072 | |||||||||||||
47 | QQQ | 5/11/1999 | 54.34 | 53.50 | 1.58% | 3.15% | $1,106 | |||||||||||||
48 | QQQ | 5/12/1999 | 55.47 | 54.34 | 2.07% | 4.14% | $1,152 | |||||||||||||
49 | QQQ | 5/13/1999 | 54.44 | 55.47 | -1.86% | -3.72% | $1,109 | |||||||||||||
50 | QQQ | 5/14/1999 | 53.41 | 54.44 | -1.89% | -3.79% | $1,067 | |||||||||||||
51 | QQQ | 5/17/1999 | 54.37 | 53.41 | 1.80% | 3.60% | $1,105 | |||||||||||||
52 | QQQ | 5/18/1999 | 54.13 | 54.37 | -0.45% | -0.89% | $1,096 | |||||||||||||
53 | QQQ | 5/19/1999 | 54.88 | 54.13 | 1.39% | 2.77% | $1,126 | |||||||||||||
54 | QQQ | 5/20/1999 | 53.37 | 54.88 | -2.75% | -5.50% | $1,064 | |||||||||||||
55 | QQQ | 5/21/1999 | 52.88 | 53.37 | -0.92% | -1.84% | $1,045 | |||||||||||||
56 | QQQ | 5/24/1999 | 51.53 | 52.88 | -2.54% | -5.08% | $991 | |||||||||||||
57 | QQQ | 5/25/1999 | 49.84 | 51.53 | -3.27% | -6.55% | $926 | |||||||||||||
58 | QQQ | 5/26/1999 | 51.23 | 49.84 | 2.79% | 5.58% | $978 | |||||||||||||
59 | QQQ | 5/27/1999 | 51.19 | 51.23 | -0.09% | -0.18% | $976 | |||||||||||||
60 | QQQ | 5/28/1999 | 52.03 | 51.19 | 1.65% | 3.30% | $1,009 | |||||||||||||
61 | QQQ | 6/1/1999 | 50.88 | 52.03 | -2.22% | -4.44% | $964 | |||||||||||||
62 | QQQ | 6/2/1999 | 51.73 | 50.88 | 1.69% | 3.38% | $996 | |||||||||||||
63 | QQQ | 6/3/1999 | 51.00 | 51.73 | -1.42% | -2.84% | $968 | |||||||||||||
64 | QQQ | 6/4/1999 | 52.56 | 51.00 | 3.06% | 6.13% | $1,027 | |||||||||||||
65 | QQQ | 6/7/1999 | 53.66 | 52.56 | 2.08% | 4.16% | $1,070 | |||||||||||||
66 | QQQ | 6/8/1999 | 52.31 | 53.66 | -2.50% | -5.01% | $1,016 | |||||||||||||
67 | QQQ | 6/9/1999 | 53.19 | 52.31 | 1.67% | 3.35% | $1,051 | |||||||||||||
68 | QQQ | 6/10/1999 | 52.58 | 53.19 | -1.15% | -2.29% | $1,026 | |||||||||||||
69 | QQQ | 6/11/1999 | 51.78 | 52.58 | -1.52% | -3.03% | $995 | |||||||||||||
70 | QQQ | 6/14/1999 | 50.80 | 51.78 | -1.89% | -3.77% | $958 | |||||||||||||
71 | QQQ | 6/15/1999 | 51.56 | 50.80 | 1.49% | 2.98% | $986 | |||||||||||||
72 | QQQ | 6/16/1999 | 54.21 | 51.56 | 5.14% | 10.27% | $1,088 | |||||||||||||
73 | QQQ | 6/17/1999 | 54.81 | 54.21 | 1.11% | 2.22% | $1,112 | |||||||||||||
74 | QQQ | 6/18/1999 | 55.06 | 54.81 | 0.46% | 0.91% | $1,122 | |||||||||||||
75 | QQQ | 6/21/1999 | 56.71 | 55.06 | 2.99% | 5.99% | $1,189 | |||||||||||||
76 | QQQ | 6/22/1999 | 55.00 | 56.71 | -3.02% | -6.03% | $1,117 | |||||||||||||
77 | QQQ | 6/23/1999 | 55.87 | 55.00 | 1.58% | 3.15% | $1,153 | |||||||||||||
78 | QQQ | 6/24/1999 | 54.76 | 55.87 | -1.99% | -3.97% | $1,107 | |||||||||||||
79 | QQQ | 6/25/1999 | 54.69 | 54.76 | -0.13% | -0.26% | $1,104 | |||||||||||||
80 | QQQ | 6/28/1999 | 55.98 | 54.69 | 2.37% | 4.74% | $1,156 | |||||||||||||
81 | QQQ | 6/29/1999 | 56.75 | 55.98 | 1.37% | 2.74% | $1,188 | |||||||||||||
82 | QQQ | 6/30/1999 | 57.63 | 56.75 | 1.54% | 3.08% | $1,225 | |||||||||||||
83 | QQQ | 7/1/1999 | 58.02 | 57.63 | 0.68% | 1.36% | $1,241 | |||||||||||||
84 | QQQ | 7/2/1999 | 58.75 | 58.02 | 1.27% | 2.53% | $1,273 | |||||||||||||
85 | QQQ | 7/6/1999 | 58.38 | 58.75 | -0.64% | -1.28% | $1,256 | |||||||||||||
86 | QQQ | 7/7/1999 | 58.47 | 58.38 | 0.16% | 0.32% | $1,260 | |||||||||||||
87 | QQQ | 7/8/1999 | 59.25 | 58.47 | 1.34% | 2.67% | $1,294 | |||||||||||||
88 | QQQ | 7/9/1999 | 59.84 | 59.25 | 1.00% | 2.00% | $1,320 | |||||||||||||
89 | QQQ | 7/12/1999 | 59.53 | 59.84 | -0.52% | -1.04% | $1,306 | |||||||||||||
90 | QQQ | 7/13/1999 | 59.25 | 59.53 | -0.47% | -0.94% | $1,294 | |||||||||||||
91 | QQQ | 7/14/1999 | 60.26 | 59.25 | 1.70% | 3.40% | $1,338 | |||||||||||||
92 | QQQ | 7/15/1999 | 60.81 | 60.26 | 0.92% | 1.84% | $1,363 | |||||||||||||
93 | QQQ | 7/16/1999 | 61.38 | 60.81 | 0.92% | 1.85% | $1,388 | |||||||||||||
94 | QQQ | 7/19/1999 | 60.75 | 61.38 | -1.02% | -2.04% | $1,360 | |||||||||||||
95 | QQQ | 7/20/1999 | 58.41 | 60.75 | -3.86% | -7.72% | $1,255 | |||||||||||||
96 | QQQ | 7/21/1999 | 58.69 | 58.41 | 0.48% | 0.96% | $1,267 | |||||||||||||
97 | QQQ | 7/22/1999 | 57.20 | 58.69 | -2.54% | -5.09% | $1,202 | |||||||||||||
98 | QQQ | 7/23/1999 | 57.28 | 57.20 | 0.15% | 0.30% | $1,206 | |||||||||||||
99 | QQQ | 7/26/1999 | 55.88 | 57.28 | -2.45% | -4.91% | $1,147 | |||||||||||||
100 | QQQ | 7/27/1999 | 57.00 | 55.88 | 2.01% | 4.03% | $1,193 |