economic report with some calculation needed
excel 3 comaparison
| Date | SPY | TLT | GLD | BTC | Return | SPY | TLT | GLD | BTC | 2018 | SPY | TLT | GLD | BTC | |||
| 1/2/19 | 268.769989 | 125.489998 | 125.150002 | 13444.879883 | |||||||||||||
| 1/3/19 | 270.470001 | 126.089996 | 124.82 | 14754.129883 | 0.63% | 0.48% | -0.26% | 9.74% | Mean Return | -0.03% | -0.01% | -0.01% | -0.29% | ||||
| 1/4/19 | 271.609985 | 126.07 | 125.459999 | 15156.620117 | 0.42% | -0.02% | 0.51% | 2.73% | Ann Return | -7.73% | -1.49% | -2.66% | -51.81% | ||||
| 1/7/19 | 273.420013 | 125.709999 | 125.330002 | 15180.080078 | 0.67% | -0.29% | -0.10% | 0.15% | SD | 1.09% | 0.59% | 0.62% | 4.54% | ||||
| 1/8/19 | 273.920013 | 125.629997 | 125.309998 | 16954.779297 | 0.18% | -0.06% | -0.02% | 11.69% | Ann Volatility | 17.32% | 9.31% | 9.78% | 72.09% | ||||
| 1/9/19 | 274.540009 | 123.949997 | 124.730003 | 17172.300781 | 0.23% | -1.34% | -0.46% | 1.28% | |||||||||
| 1/10/19 | 274.119995 | 123.800003 | 125.029999 | 16228.160156 | -0.15% | -0.12% | 0.24% | -5.50% | Sharpe Ratio | -0.44620 | -0.15966 | -0.27185 | -0.71862 | ||||
| 1/11/19 | 276.119995 | 124.309998 | 125.440002 | 14976.169922 | 0.73% | 0.41% | 0.33% | -7.71% | Max | 5.05% | 2.19% | 2.57% | 13.62% | ||||
| 1/14/19 | 277.920013 | 124.519997 | 126.959999 | 14468.5 | 0.65% | 0.17% | 1.21% | -3.39% | Min | -4.18% | -1.74% | -1.66% | -17.24% | ||||
| 1/15/19 | 276.970001 | 125.040001 | 127.169998 | 14919.490234 | -0.34% | 0.42% | 0.17% | 3.12% | |||||||||
| 1/16/19 | 279.609985 | 124.870003 | 126.139999 | 13308.05957 | 0.95% | -0.14% | -0.81% | -10.80% | Skew | -0.373631374 | 0.0321646467 | 0.3201727991 | -0.2944584675 | ||||
| 1/17/19 | 279.140015 | 123.709999 | 125.860001 | 13841.19043 | -0.17% | -0.93% | -0.22% | 4.01% | Kurt | 3.143 | 0.476 | 1.565 | 1.316 | ||||
| 1/18/19 | 280.410004 | 123.059998 | 126.419998 | 14243.120117 | 0.45% | -0.53% | 0.44% | 2.90% | |||||||||
| 1/22/19 | 282.690002 | 123.18 | 126.650002 | 13638.629883 | 0.81% | 0.10% | 0.18% | -4.24% | CORRELATION | SPY | TLT | GLD | BTC | ||||
| 1/23/19 | 283.290009 | 123.709999 | 127.279999 | 13631.980469 | 0.21% | 0.43% | 0.50% | -0.05% | SPY | 1.000 | |||||||
| 1/24/19 | 283.179993 | 123.040001 | 128.830002 | 11282.490234 | -0.04% | -0.54% | 1.22% | -17.24% | TLT | -0.278 | 1.000 | ||||||
| 1/25/19 | 283.299988 | 124.050003 | 127.970001 | 11162.700195 | 0.04% | 0.82% | -0.67% | -1.06% | GLD | -0.026 | 0.178 | 1.000 | |||||
| 1/28/19 | 286.579987 | 123.589996 | 128.070007 | 11175.519531 | 1.16% | -0.37% | 0.08% | 0.11% | BTC | -0.154 | 0.091 | -0.098 | 1.000 | ||||
| 1/29/19 | 284.679993 | 122.730003 | 127.349998 | 11521.759766 | -0.66% | -0.70% | -0.56% | 3.10% | |||||||||
| 1/30/19 | 281.76001 | 122.010002 | 126.800003 | 12783.94043 | -1.03% | -0.59% | -0.43% | 10.95% | |||||||||
| 1/31/19 | 281.899994 | 122.730003 | 127.650002 | 11549.929688 | 0.05% | 0.59% | 0.67% | -9.65% | |||||||||
| 2/1/19 | 281.579987 | 120.699997 | 128.070007 | 10814.519531 | -0.11% | -1.65% | 0.33% | -6.37% | |||||||||
| 2/4/19 | 275.450012 | 119.580002 | 126.389999 | 10858.230469 | -2.18% | -0.93% | -1.31% | 0.40% | |||||||||
| 2/5/19 | 263.929993 | 120.709999 | 126.709999 | 11429.019531 | -4.18% | 0.94% | 0.25% | 5.26% | |||||||||
| 2/6/19 | 269.130005 | 119.959999 | 125.379997 | 11175.870117 | 1.97% | -0.62% | -1.05% | -2.21% | |||||||||
| 2/7/19 | 267.670013 | 118.82 | 124.790001 | 11104.200195 | -0.54% | -0.95% | -0.47% | -0.64% | |||||||||
| 2/8/19 | 257.630005 | 118.690002 | 124.980003 | 11459.709961 | -3.75% | -0.11% | 0.15% | 3.20% | |||||||||
| 2/11/19 | 261.5 | 117.940002 | 124.769997 | 11767.740234 | 1.50% | -0.63% | -0.17% | 2.69% | |||||||||
| 2/12/19 | 265.339996 | 118.459999 | 125.370003 | 11233.950195 | 1.47% | 0.44% | 0.48% | -4.54% | |||||||||
| 2/13/19 | 266 | 118.989998 | 126.080002 | 10107.259766 | 0.25% | 0.45% | 0.57% | -10.03% | |||||||||
| 2/14/19 | 269.589996 | 117.669998 | 128.229996 | 10226.860352 | 1.35% | -1.11% | 1.71% | 1.18% | |||||||||
| 2/15/19 | 273.029999 | 118.07 | 128.380005 | 9114.719727 | 1.28% | 0.34% | 0.12% | -10.87% | |||||||||
| 2/19/19 | 273.109985 | 118.709999 | 127.959999 | 8870.820313 | 0.03% | 0.54% | -0.33% | -2.68% | |||||||||
| 2/20/19 | 271.399994 | 118.190002 | 126.239998 | 9251.269531 | -0.63% | -0.44% | -1.34% | 4.29% | |||||||||
| 2/21/19 | 270.049988 | 116.739998 | 125.660004 | 8218.049805 | -0.50% | -1.23% | -0.46% | -11.17% | |||||||||
| 2/22/19 | 270.399994 | 117.089996 | 126.300003 | 6937.080078 | 0.13% | 0.30% | 0.51% | -15.59% | |||||||||
| 2/25/19 | 274.709991 | 118.129997 | 126.139999 | 7701.25 | 1.59% | 0.89% | -0.13% | 11.02% | |||||||||
| 2/26/19 | 277.899994 | 118.169998 | 126.449997 | 7592.720215 | 1.16% | 0.03% | 0.25% | -1.41% | |||||||||
| 2/27/19 | 274.429993 | 118 | 125.129997 | 8260.69043 | -1.25% | -0.14% | -1.04% | 8.80% | |||||||||
| 2/28/19 | 271.649994 | 118.75 | 125 | 8696.830078 | -1.01% | 0.64% | -0.10% | 5.28% | |||||||||
| 3/1/19 | 267.700012 | 119.32 | 124.720001 | 8569.290039 | -1.45% | 0.48% | -0.22% | -1.47% | |||||||||
| 3/4/19 | 269.079987 | 118.349998 | 125.389999 | 8084.609863 | 0.52% | -0.81% | 0.54% | -5.66% | |||||||||
| 3/5/19 | 272.190002 | 118.029999 | 125.18 | 8911.269531 | 1.16% | -0.27% | -0.17% | 10.23% | |||||||||
| 3/6/19 | 272.880005 | 118.139999 | 126.529999 | 8544.69043 | 0.25% | 0.09% | 1.08% | -4.11% | |||||||||
| 3/7/19 | 272.779999 | 118.010002 | 125.720001 | 9485.639648 | -0.04% | -0.11% | -0.64% | 11.01% | |||||||||
| 3/8/19 | 274.100006 | 118.690002 | 125.419998 | 10033.75 | 0.48% | 0.58% | -0.24% | 5.78% | |||||||||
| 3/11/19 | 278.869995 | 117.910004 | 125.540001 | 10188.730469 | 1.74% | -0.66% | 0.10% | 1.54% | |||||||||
| 3/12/19 | 278.519989 | 118.589996 | 125.540001 | 11097.209961 | -0.13% | 0.58% | 0.00% | 8.92% | |||||||||
| 3/13/19 | 276.720001 | 119.190002 | 125.779999 | 10417.230469 | -0.65% | 0.51% | 0.19% | -6.13% | |||||||||
| 3/14/19 | 275.299988 | 120.239998 | 125.699997 | 11182.280273 | -0.51% | 0.88% | -0.06% | 7.34% | |||||||||
| 3/15/19 | 275 | 120.239998 | 124.900002 | 11256.429688 | -0.11% | 0.00% | -0.64% | 0.66% | |||||||||
| 3/18/19 | 274.200012 | 119.809998 | 124.599998 | 10481.660156 | -0.29% | -0.36% | -0.24% | -6.88% | |||||||||
| 3/19/19 | 270.48999 | 119.43 | 124.870003 | 9847.959961 | -1.35% | -0.32% | 0.22% | -6.05% | |||||||||
| 3/20/19 | 270.950012 | 118.949997 | 124.309998 | 10175.509766 | 0.17% | -0.40% | -0.45% | 3.33% | |||||||||
| 3/21/19 | 270.429993 | 119.080002 | 126.480003 | 9705.730469 | -0.19% | 0.11% | 1.75% | -4.62% | |||||||||
| 3/22/19 | 263.670013 | 120.260002 | 125.980003 | 9610.110352 | -2.50% | 0.99% | -0.40% | -0.99% | |||||||||
| 3/25/19 | 258.049988 | 120.169998 | 127.610001 | 10326.5 | -2.13% | -0.07% | 1.29% | 7.45% | |||||||||
| 3/26/19 | 265.109985 | 119.709999 | 128.279999 | 10594.759766 | 2.74% | -0.38% | 0.53% | 2.60% | |||||||||
| 3/27/19 | 260.600006 | 120.989998 | 127.489998 | 10334.44043 | -1.70% | 1.07% | -0.62% | -2.46% | |||||||||
| 3/28/19 | 259.829987 | 121.309998 | 125.730003 | 10929.370117 | -0.30% | 0.26% | -1.38% | 5.76% | |||||||||
| 3/29/19 | 263.149994 | 121.900002 | 125.790001 | 11043.120117 | 1.28% | 0.49% | 0.05% | 1.04% | |||||||||
| 3/30/19 | 257.470001 | 121.879997 | 127.260002 | 11465.360352 | -2.16% | -0.02% | 1.17% | 3.82% | |||||||||
| 3/31/19 | 260.769989 | 120.940002 | 126.300003 | 11504.419922 | 1.28% | -0.77% | -0.75% | 0.34% | |||||||||
| 4/1/19 | 263.559998 | 120.690002 | 126.449997 | 11440.730469 | 1.07% | -0.21% | 0.12% | -0.55% | |||||||||
| 4/2/19 | 265.640015 | 119.790001 | 125.800003 | 10735.450195 | 0.79% | -0.75% | -0.51% | -6.16% | |||||||||
| 4/3/19 | 259.720001 | 121.099998 | 126.389999 | 9928.55957 | -2.23% | 1.09% | 0.47% | -7.52% | |||||||||
| 4/4/19 | 261 | 121.300003 | 126.82 | 9316.719727 | 0.49% | 0.17% | 0.34% | -6.16% | |||||||||
| 4/5/19 | 265.149994 | 121.080002 | 127.120003 | 9252.759766 | 1.59% | -0.18% | 0.24% | -0.69% | |||||||||
| 4/6/19 | 263.76001 | 121.510002 | 128.110001 | 8797.269531 | -0.52% | 0.36% | 0.78% | -4.92% | |||||||||
| 4/7/19 | 265.929993 | 120.620003 | 126.620003 | 9544.839844 | 0.82% | -0.73% | -1.16% | 8.50% | |||||||||
| 4/8/19 | 265.149994 | 120.900002 | 127.449997 | 9142.150391 | -0.29% | 0.23% | 0.66% | -4.22% | |||||||||
| 4/9/19 | 267.329987 | 120.940002 | 127.629997 | 9160.120117 | 0.82% | 0.03% | 0.14% | 0.20% | |||||||||
| 4/10/19 | 270.190002 | 121.269997 | 127.75 | 8217.700195 | 1.07% | 0.27% | 0.09% | -10.29% | |||||||||
| 4/11/19 | 270.390015 | 120.300003 | 127.849998 | 8268.410156 | 0.07% | -0.80% | 0.08% | 0.62% | |||||||||
| 4/12/19 | 268.890015 | 119.32 | 127.599998 | 8283.230469 | -0.55% | -0.81% | -0.20% | 0.18% | |||||||||
| 4/13/19 | 266.609985 | 118.459999 | 126.629997 | 7883.450195 | -0.85% | -0.72% | -0.76% | -4.83% | |||||||||
| 4/14/19 | 266.570007 | 118.489998 | 125.620003 | 8215.400391 | -0.01% | 0.03% | -0.80% | 4.21% | |||||||||
| 4/15/19 | 262.980011 | 117.949997 | 126.230003 | 8623.139648 | -1.35% | -0.46% | 0.49% | 4.96% | |||||||||
| 4/16/19 | 263.630005 | 117.160004 | 125.410004 | 8920.709961 | 0.25% | -0.67% | -0.65% | 3.45% | |||||||||
| 4/17/19 | 266.309998 | 117.980003 | 124.970001 | 8911.349609 | 1.02% | 0.70% | -0.35% | -0.10% | |||||||||
| 4/18/19 | 266.559998 | 118.889999 | 125.5 | 8724.980469 | 0.09% | 0.77% | 0.42% | -2.09% | |||||||||
| 4/19/19 | 264.51001 | 119.099998 | 124.589996 | 8934.799805 | -0.77% | 0.18% | -0.73% | 2.40% | |||||||||
| 4/20/19 | 264.980011 | 118.410004 | 123.709999 | 8548.05957 | 0.18% | -0.58% | -0.71% | -4.33% | |||||||||
| 4/21/19 | 263.200012 | 118.279999 | 123.650002 | 8472.839844 | -0.67% | -0.11% | -0.05% | -0.88% | |||||||||
| 4/22/19 | 262.619995 | 118.809998 | 124.279999 | 8152.200195 | -0.22% | 0.45% | 0.51% | -3.78% | |||||||||
| 4/23/19 | 266.019989 | 118.989998 | 124.540001 | 7808.47998 | 1.29% | 0.15% | 0.21% | -4.22% | |||||||||
| 4/24/19 | 266.920013 | 118.800003 | 124.57 | 7959.779785 | 0.34% | -0.16% | 0.02% | 1.94% | |||||||||
| 4/25/19 | 266.920013 | 118.690002 | 124.589996 | 7106.620117 | 0.00% | -0.09% | 0.02% | -10.72% | |||||||||
| 4/26/19 | 269.5 | 117.980003 | 124.330002 | 6853.759766 | 0.97% | -0.60% | -0.21% | -3.56% | |||||||||
| 4/27/19 | 272.019989 | 118.93 | 125.18 | 6943.77002 | 0.94% | 0.81% | 0.68% | 1.31% | |||||||||
| 4/28/19 | 272.850006 | 119.230003 | 125 | 6835.839844 | 0.31% | 0.25% | -0.14% | -1.55% | |||||||||
| 4/29/19 | 272.980011 | 118.599998 | 124.489998 | 7074.600098 | 0.05% | -0.53% | -0.41% | 3.49% | |||||||||
| 4/30/19 | 271.100006 | 117.25 | 122.480003 | 7434.299805 | -0.69% | -1.14% | -1.61% | 5.08% | |||||||||
| 5/1/19 | 272.23999 | 116.800003 | 122.290001 | 6815.5 | 0.42% | -0.38% | -0.16% | -8.32% | |||||||||
| 5/2/19 | 272.01001 | 116.209999 | 122.360001 | 6790.450195 | -0.08% | -0.51% | 0.06% | -0.37% | |||||||||
| 5/3/19 | 271.329987 | 117.209999 | 122.410004 | 6634.859863 | -0.25% | 0.86% | 0.04% | -2.29% | |||||||||
| 5/4/19 | 273.369995 | 117.269997 | 122.480003 | 6917.200195 | 0.75% | 0.05% | 0.06% | 4.26% | |||||||||
| 5/5/19 | 272.609985 | 117.089996 | 122.410004 | 7049.919922 | -0.28% | -0.15% | -0.06% | 1.92% | |||||||||
| 5/6/19 | 273.359985 | 117.940002 | 122.540001 | 6789.529785 | 0.28% | 0.73% | 0.11% | -3.69% | |||||||||
| 5/7/19 | 272.799988 | 118.879997 | 123.589996 | 6871.069824 | -0.20% | 0.80% | 0.86% | 1.20% | |||||||||
| 5/8/19 | 272.149994 | 119.620003 | 123.209999 | 6977.129883 | -0.24% | 0.62% | -0.31% | 1.54% | |||||||||
| 5/9/19 | 269.019989 | 122.239998 | 123.190002 | 7927.72998 | -1.15% | 2.19% | -0.02% | 13.62% | |||||||||
| 5/10/19 | 272.609985 | 121.419998 | 123.370003 | 7899.109863 | 1.33% | -0.67% | 0.15% | -0.36% | |||||||||
| 5/11/19 | 270.940002 | 121.220001 | 123.099998 | 8022.509766 | -0.61% | -0.16% | -0.22% | 1.56% | |||||||||
| 5/12/19 | 273.600006 | 120.300003 | 122.489998 | 8376.730469 | 0.98% | -0.76% | -0.50% | 4.42% | |||||||||
| 5/13/19 | 274.899994 | 119.43 | 122.370003 | 8079.77002 | 0.48% | -0.72% | -0.10% | -3.55% | |||||||||
| 5/14/19 | 275.100006 | 119.709999 | 122.849998 | 7921.629883 | 0.07% | 0.23% | 0.39% | -1.96% | |||||||||
| 5/15/19 | 277.399994 | 118.739998 | 122.919998 | 8189.959961 | 0.84% | -0.81% | 0.06% | 3.39% | |||||||||
| 5/16/19 | 277.369995 | 119.889999 | 122.860001 | 8301.820313 | -0.01% | 0.97% | -0.05% | 1.37% | |||||||||
| 5/17/19 | 278.190002 | 119.529999 | 123.010002 | 8877.080078 | 0.30% | -0.30% | 0.12% | 6.93% | |||||||||
| 5/18/19 | 278.559998 | 119.309998 | 123.230003 | 8935.719727 | 0.13% | -0.18% | 0.18% | 0.66% | |||||||||
| 5/19/19 | 278.920013 | 119.339996 | 122.82 | 8823.360352 | 0.13% | 0.03% | -0.33% | -1.26% | |||||||||
| 5/20/19 | 278.029999 | 119.279999 | 123.190002 | 8968.25 | -0.32% | -0.05% | 0.30% | 1.64% | |||||||||
| 5/21/19 | 278.730011 | 120.269997 | 123.379997 | 9655.769531 | 0.25% | 0.83% | 0.15% | 7.67% | |||||||||
| 5/22/19 | 277.130005 | 120.379997 | 121.339996 | 8873.620117 | -0.57% | 0.09% | -1.65% | -8.10% | |||||||||
| 5/23/19 | 276.559998 | 120.269997 | 121.110001 | 9282.120117 | -0.21% | -0.09% | -0.19% | 4.60% | |||||||||
| 5/24/19 | 275.5 | 120.970001 | 120.800003 | 8938.469727 | -0.38% | 0.58% | -0.26% | -3.70% | |||||||||
| 5/25/19 | 275.970001 | 119.910004 | 120.260002 | 9351.469727 | 0.17% | -0.88% | -0.45% | 4.62% | |||||||||
| 5/26/19 | 274.23999 | 120.540001 | 120.050003 | 9407.040039 | -0.63% | 0.53% | -0.17% | 0.59% | |||||||||
| 5/27/19 | 274.73999 | 120.529999 | 120.339996 | 9248.450195 | 0.18% | -0.01% | 0.24% | -1.69% | |||||||||
| 5/28/19 | 271 | 120.800003 | 119.889999 | 9077.280273 | -1.36% | 0.22% | -0.37% | -1.85% | |||||||||
| 5/29/19 | 271.600006 | 120.970001 | 119.260002 | 9232.19043 | 0.22% | 0.14% | -0.53% | 1.71% | |||||||||
| 5/30/19 | 269.350006 | 122.110001 | 118.580002 | 9745.040039 | -0.83% | 0.94% | -0.57% | 5.56% | |||||||||
| 5/31/19 | 270.890015 | 122.139999 | 118.220001 | 9699.610352 | 0.57% | 0.02% | -0.30% | -0.47% | |||||||||
| 6/1/19 | 271.279999 | 121.720001 | 118.650002 | 9845.900391 | 0.14% | -0.34% | 0.36% | 1.51% | |||||||||
| 6/2/19 | 271.859985 | 121.349998 | 117.459999 | 9644.919922 | 0.21% | -0.30% | -1.00% | -2.04% | |||||||||
| 6/3/19 | 270.899994 | 122 | 118.650002 | 9377.80957 | -0.35% | 0.54% | 1.01% | -2.77% | |||||||||
| 6/4/19 | 273.109985 | 122.349998 | 119.050003 | 9196.129883 | 0.82% | 0.29% | 0.34% | -1.94% | |||||||||
| 6/5/19 | 275.420013 | 122.75 | 118.860001 | 9321.160156 | 0.85% | 0.33% | -0.16% | 1.36% | |||||||||
| 6/6/19 | 277.899994 | 121.959999 | 119.150002 | 9032.219727 | 0.90% | -0.64% | 0.24% | -3.10% | |||||||||
| 6/7/19 | 278.899994 | 121.949997 | 118.93 | 8421 | 0.36% | -0.01% | -0.18% | -6.77% | |||||||||
| 6/8/19 | 276.859985 | 122.419998 | 117.639999 | 8486.669922 | -0.73% | 0.39% | -1.08% | 0.78% | |||||||||
| 6/9/19 | 279.369995 | 122.410004 | 118.129997 | 8709.459961 | 0.91% | -0.01% | 0.42% | 2.63% | |||||||||
| 6/10/19 | 279.589996 | 122.720001 | 117.610001 | 8672.900391 | 0.08% | 0.25% | -0.44% | -0.42% | |||||||||
| 6/11/19 | 279.339996 | 122.209999 | 117.550003 | 8480.160156 | -0.09% | -0.42% | -0.05% | -2.22% | |||||||||
| 6/12/19 | 280.470001 | 121.980003 | 116.279999 | 8344.780273 | 0.40% | -0.19% | -1.08% | -1.60% | |||||||||
| 6/13/19 | 281.059998 | 121.489998 | 116.309998 | 8071.040039 | 0.21% | -0.40% | 0.03% | -3.28% | |||||||||
| 6/14/19 | 280 | 122.260002 | 115.809998 | 8247.910156 | -0.38% | 0.63% | -0.43% | 2.19% | |||||||||
| 6/15/19 | 279.679993 | 120.760002 | 116.559998 | 8249.240234 | -0.11% | -1.23% | 0.65% | 0.02% | |||||||||
| 6/16/19 | 280.200012 | 119.269997 | 116 | 8533 | 0.19% | -1.23% | -0.48% | 3.44% | |||||||||
| 6/17/19 | 281.609985 | 119.68 | 116.040001 | 8419.650391 | 0.50% | 0.34% | 0.03% | -1.33% | |||||||||
| 6/18/19 | 284.01001 | 119.489998 | 116.68 | 7992.75 | 0.85% | -0.16% | 0.55% | -5.07% | |||||||||
| 6/19/19 | 283.339996 | 119.260002 | 115.769997 | 7505.77002 | -0.24% | -0.19% | -0.78% | -6.09% | |||||||||
| 6/20/19 | 281.420013 | 119.459999 | 115.830002 | 7584.740234 | -0.68% | 0.17% | 0.05% | 1.05% | |||||||||
| 6/21/19 | 279.950012 | 119.050003 | 115.650002 | 7475.359863 | -0.52% | -0.34% | -0.16% | -1.44% | |||||||||
| 6/22/19 | 281.329987 | 119.699997 | 115.989998 | 7355.060059 | 0.49% | 0.55% | 0.29% | -1.61% | |||||||||
| 6/23/19 | 280.859985 | 118.459999 | 115.139999 | 7362.22998 | -0.17% | -1.04% | -0.73% | 0.10% | |||||||||
| 6/24/19 | 282.390015 | 118.629997 | 114.519997 | 7118.879883 | 0.54% | 0.14% | -0.54% | -3.31% | |||||||||
| 6/25/19 | 283.600006 | 119.220001 | 114.919998 | 7474.75 | 0.43% | 0.50% | 0.35% | 5.00% | |||||||||
| 6/26/19 | 284.640015 | 119.290001 | 114.330002 | 7393.02002 | 0.37% | 0.06% | -0.51% | -1.09% | |||||||||
| 6/27/19 | 285.579987 | 118.669998 | 114.589996 | 7502.149902 | 0.33% | -0.52% | 0.23% | 1.48% | |||||||||
| 6/28/19 | 285.459991 | 118.790001 | 114.910004 | 7530.549805 | -0.04% | 0.10% | 0.28% | 0.38% | |||||||||
| 6/29/19 | 285.070007 | 119.790001 | 114.739998 | 7643.259766 | -0.14% | 0.84% | -0.15% | 1.50% | |||||||||
| 6/30/19 | 283.160004 | 120.660004 | 114.690002 | 7719.75 | -0.67% | 0.73% | -0.04% | 1.00% | |||||||||
| 7/1/19 | 282.100006 | 120.410004 | 112.959999 | 7503.200195 | -0.37% | -0.21% | -1.51% | -2.81% | |||||||||
| 7/2/19 | 283.899994 | 120.139999 | 113.07 | 7629.399902 | 0.64% | -0.22% | 0.10% | 1.68% | |||||||||
| 7/3/19 | 281.779999 | 120.839996 | 111.190002 | 7661.790039 | -0.75% | 0.58% | -1.66% | 0.42% | |||||||||
| 7/4/19 | 284.059998 | 120.830002 | 111.099998 | 7700.109863 | 0.81% | -0.01% | -0.08% | 0.50% | |||||||||
| 7/5/19 | 285.059998 | 120.980003 | 112.129997 | 7627.52002 | 0.35% | 0.12% | 0.93% | -0.94% | |||||||||
| 7/6/19 | 285.670013 | 121.790001 | 112.690002 | 7513.689941 | 0.21% | 0.67% | 0.50% | -1.49% | |||||||||
| 7/7/19 | 286.339996 | 121.379997 | 113.019997 | 6773.720215 | 0.23% | -0.34% | 0.29% | -9.85% | |||||||||
| 7/8/19 | 286.170013 | 121.860001 | 113.269997 | 6887.370117 | -0.06% | 0.40% | 0.22% | 1.68% | |||||||||
| 7/9/19 | 285.790009 | 122.050003 | 112.199997 | 6556.939941 | -0.13% | 0.16% | -0.94% | -4.80% | |||||||||
| 7/10/19 | 287.51001 | 122.290001 | 114.160004 | 6310.430176 | 0.60% | 0.20% | 1.75% | -3.76% | |||||||||
| 7/11/19 | 289.779999 | 121.589996 | 114.589996 | 6643.259766 | 0.79% | -0.57% | 0.38% | 5.27% | |||||||||
| 7/12/19 | 289.920013 | 120.860001 | 113.68 | 6396.709961 | 0.05% | -0.60% | -0.79% | -3.71% | |||||||||
| 7/13/19 | 291.480011 | 121.019997 | 114.199997 | 6503.100098 | 0.54% | 0.13% | 0.46% | 1.66% | |||||||||
| 7/14/19 | 290.299988 | 121.279999 | 113.639999 | 6457.779785 | -0.40% | 0.21% | -0.49% | -0.70% | |||||||||
| 7/15/19 | 290.309998 | 121 | 113.510002 | 6714.819824 | 0.00% | -0.23% | -0.11% | 3.98% | |||||||||
| 7/16/19 | 289.809998 | 120.029999 | 112.93 | 6741.279785 | -0.17% | -0.80% | -0.51% | 0.39% | |||||||||
| 7/17/19 | 289.029999 | 119.709999 | 113.32 | 6761.27002 | -0.27% | -0.27% | 0.35% | 0.30% | |||||||||
| 7/18/19 | 288.160004 | 120.150002 | 113.540001 | 6720.640137 | -0.30% | 0.37% | 0.19% | -0.60% | |||||||||
| 7/19/19 | 287.600006 | 119.129997 | 113.230003 | 6051.470215 | -0.19% | -0.85% | -0.27% | -9.96% | |||||||||
| 7/20/19 | 288.100006 | 119.57 | 113.150002 | 6166.540039 | 0.17% | 0.37% | -0.07% | 1.90% | |||||||||
| 7/21/19 | 289.049988 | 118.660004 | 113.220001 | 6157.779785 | 0.33% | -0.76% | 0.06% | -0.14% | |||||||||
| 7/22/19 | 289.119995 | 118.940002 | 114.169998 | 6260.350098 | 0.02% | 0.24% | 0.84% | 1.67% | |||||||||
| 7/23/19 | 290.829987 | 119.120003 | 113.760002 | 6088.390137 | 0.59% | 0.15% | -0.36% | -2.75% | |||||||||
| 7/24/19 | 290.880005 | 118.550003 | 113.019997 | 6141.569824 | 0.02% | -0.48% | -0.65% | 0.87% | |||||||||
| 7/25/19 | 289.339996 | 118.550003 | 113.610001 | 5871.279785 | -0.53% | 0.00% | 0.52% | -4.40% | |||||||||
| 7/26/19 | 290.910004 | 117.309998 | 113.440002 | 6203.799805 | 0.54% | -1.05% | -0.15% | 5.66% | |||||||||
| 7/27/19 | 291.220001 | 116.610001 | 113.879997 | 6385.379883 | 0.11% | -0.60% | 0.39% | 2.93% | |||||||||
| 7/28/19 | 293.579987 | 117.150002 | 114.269997 | 6339.040039 | 0.81% | 0.46% | 0.34% | -0.73% | |||||||||
| 7/29/19 | 291.98999 | 117.099998 | 113.489998 | 6615.660156 | -0.54% | -0.04% | -0.68% | 4.36% | |||||||||
| 7/30/19 | 291.019989 | 116.800003 | 113.470001 | 6509.580078 | -0.33% | -0.26% | -0.02% | -1.60% | |||||||||
| 7/31/19 | 290.75 | 116.68 | 113.650002 | 6590.060059 | -0.09% | -0.10% | 0.16% | 1.24% | |||||||||
| 8/1/19 | 289.880005 | 117.5 | 113.050003 | 6534.810059 | -0.30% | 0.70% | -0.53% | -0.84% | |||||||||
| 8/2/19 | 290.690002 | 117.580002 | 112.050003 | 6602.02002 | 0.28% | 0.07% | -0.88% | 1.03% | |||||||||
| 8/3/19 | 290.720001 | 117.269997 | 112.760002 | 6758.080078 | 0.01% | -0.26% | 0.63% | 2.36% | |||||||||
| 8/4/19 | 291.730011 | 116.150002 | 112.57 | 6707.379883 | 0.35% | -0.96% | -0.17% | -0.75% | |||||||||
| 8/5/19 | 291.559998 | 116.860001 | 113.870003 | 6668.839844 | -0.06% | 0.61% | 1.15% | -0.57% | |||||||||
| 8/6/19 | 291.720001 | 114.830002 | 113.419998 | 6306.850098 | 0.05% | -1.74% | -0.40% | -5.43% | |||||||||
| 8/7/19 | 289.440002 | 114.019997 | 113.480003 | 6394.359863 | -0.78% | -0.71% | 0.05% | 1.39% | |||||||||
| 8/8/19 | 287.820007 | 113.040001 | 113.800003 | 6253.600098 | -0.56% | -0.86% | 0.28% | -2.20% | |||||||||
| 8/9/19 | 287.820007 | 112.660004 | 112.540001 | 6229.830078 | 0.00% | -0.34% | -1.11% | -0.38% | |||||||||
| 8/10/19 | 287.399994 | 113.800003 | 112.599998 | 6268.75 | -0.15% | 1.01% | 0.05% | 0.62% | |||||||||
| 8/11/19 | 278.299988 | 113.489998 | 112.879997 | 6364.259766 | -3.17% | -0.27% | 0.25% | 1.52% | |||||||||
| 8/12/19 | 272.170013 | 114.870003 | 115.779999 | 6740.549805 | -2.20% | 1.22% | 2.57% | 5.91% | |||||||||
| 8/13/19 | 275.950012 | 114.470001 | 115.230003 | 7326.700195 | 1.39% | -0.35% | -0.48% | 8.70% | |||||||||
| 8/14/19 | 274.399994 | 114.419998 | 116 | 7383.390137 | -0.56% | -0.04% | 0.67% | 0.77% | |||||||||
| 8/15/19 | 280.399994 | 114.68 | 115.800003 | 7477.5 | 2.19% | 0.23% | -0.17% | 1.27% | |||||||||
| 8/16/19 | 280.450012 | 114 | 115.790001 | 7333.930176 | 0.02% | -0.59% | -0.01% | -1.92% | |||||||||
| 8/17/19 | 276.399994 | 113.959999 | 115.919998 | 7405.399902 | -1.44% | -0.04% | 0.11% | 0.97% | |||||||||
| 8/18/19 | 276.25 | 113.709999 | 116.010002 | 7398.640137 | -0.05% | -0.22% | 0.08% | -0.09% | |||||||||
| 8/19/19 | 275.01001 | 113.559998 | 115.709999 | 7718 | -0.45% | -0.13% | -0.26% | 4.32% | |||||||||
| 8/20/19 | 273.609985 | 113.919998 | 116.389999 | 8395.820313 | -0.51% | 0.32% | 0.59% | 8.78% | |||||||||
| 8/21/19 | 265.320007 | 114.779999 | 116.660004 | 8170.22998 | -3.03% | 0.75% | 0.23% | -2.69% | |||||||||
| 8/22/19 | 270.079987 | 114.300003 | 116.400002 | 7937.25 | 1.79% | -0.42% | -0.22% | -2.85% | |||||||||
| 8/23/19 | 265.329987 | 114.989998 | 116.769997 | 8182.890137 | -1.76% | 0.60% | 0.32% | 3.09% | |||||||||
| 8/24/19 | 263.859985 | 114.730003 | 116.309998 | 8230.870117 | -0.55% | -0.23% | -0.39% | 0.59% | |||||||||
| 8/25/19 | 267.769989 | 114.160004 | 115.800003 | 8216.780273 | 1.48% | -0.50% | -0.44% | -0.17% | |||||||||
| 8/26/19 | 270.630005 | 113.580002 | 115.150002 | 8176.060059 | 1.07% | -0.51% | -0.56% | -0.50% | |||||||||
| 8/27/19 | 273.51001 | 113.410004 | 116.629997 | 7735.299805 | 1.06% | -0.15% | 1.29% | -5.39% | |||||||||
| 8/28/19 | 271.890015 | 112 | 116.650002 | 7610.899902 | -0.59% | -1.24% | 0.02% | -1.61% | |||||||||
| 8/29/19 | 273.390015 | 112.440002 | 116.370003 | 7542.339844 | 0.55% | 0.39% | -0.24% | -0.90% | |||||||||
| 8/30/19 | 275.119995 | 112.370003 | 116.040001 | 7417.600098 | 0.63% | -0.06% | -0.28% | -1.65% | |||||||||
| 8/31/19 | 281.01001 | 112.519997 | 116.029999 | 7017.890137 | 2.14% | 0.13% | -0.01% | -5.39% | |||||||||
| 9/1/19 | 280.5 | 112.510002 | 115.779999 | 7042.390137 | -0.18% | -0.01% | -0.22% | 0.35% | |||||||||
| 9/2/19 | 277.76001 | 113.349998 | 114.480003 | 6945.779785 | -0.98% | 0.75% | -1.12% | -1.37% | |||||||||
| 9/3/19 | 272.570007 | 114.089996 | 113.660004 | 6723.209961 | -1.87% | 0.65% | -0.72% | -3.20% | |||||||||
| 9/4/19 | 272.059998 | 114.019997 | 113.699997 | 6285.02002 | -0.19% | -0.06% | 0.04% | -6.52% | |||||||||
| 9/5/19 | 270.200012 | 114.089996 | 114.639999 | 6543.240234 | -0.68% | 0.06% | 0.83% | 4.11% | |||||||||
| 9/6/19 | 273.019989 | 114.040001 | 114.769997 | 6153.410156 | 1.04% | -0.04% | 0.11% | -5.96% | |||||||||
| 9/7/19 | 273.730011 | 114.699997 | 115.620003 | 6242.540039 | 0.26% | 0.58% | 0.74% | 1.45% | |||||||||
| 9/8/19 | 269.100006 | 115.019997 | 115.669998 | 6322.919922 | -1.69% | 0.28% | 0.04% | 1.29% | |||||||||
| 9/9/19 | 264.119995 | 115.059998 | 115.669998 | 6263.200195 | -1.85% | 0.03% | 0.00% | -0.94% | |||||||||
| 9/10/19 | 265.019989 | 115.019997 | 115.860001 | 6199.600098 | 0.34% | -0.03% | 0.16% | -1.02% | |||||||||
| 9/11/19 | 263.25 | 115.139999 | 115.769997 | 6274.220215 | -0.67% | 0.10% | -0.08% | 1.20% | |||||||||
| 9/12/19 | 267.5 | 114.879997 | 115.639999 | 6323.810059 | 1.61% | -0.23% | -0.11% | 0.79% | |||||||||
| 9/13/19 | 268.399994 | 115.010002 | 114.949997 | 6591.160156 | 0.34% | 0.11% | -0.60% | 4.23% | |||||||||
| 9/14/19 | 274.579987 | 114.449997 | 115.379997 | 6405.709961 | 2.30% | -0.49% | 0.37% | -2.81% | |||||||||
| 9/15/19 | 273.980011 | 114.900002 | 115.739998 | 6502.180176 | -0.22% | 0.39% | 0.31% | 1.51% | |||||||||
| 9/16/19 | 275.649994 | 115.330002 | 115.540001 | 6269.899902 | 0.61% | 0.37% | -0.17% | -3.57% | |||||||||
| 9/17/19 | 279.299988 | 115.879997 | 116.410004 | 6491.109863 | 1.32% | 0.48% | 0.75% | 3.53% | |||||||||
| 9/18/19 | 270.25 | 117.82 | 117.120003 | 6366.129883 | -3.24% | 1.67% | 0.61% | -1.93% | |||||||||
| 9/19/19 | 269.839996 | 118.190002 | 117.139999 | 6538.950195 | -0.15% | 0.31% | 0.02% | 2.71% | |||||||||
| 9/20/19 | 263.570007 | 118.410004 | 118.089996 | 6708.959961 | -2.32% | 0.19% | 0.81% | 2.60% | |||||||||
| 9/21/19 | 264.070007 | 118.900002 | 117.68 | 6749.560059 | 0.19% | 0.41% | -0.35% | 0.61% | |||||||||
| 9/22/19 | 264.130005 | 118.879997 | 117.540001 | 6720.600098 | 0.02% | -0.02% | -0.12% | -0.43% | |||||||||
| 9/23/19 | 265.459991 | 118.349998 | 117.790001 | 6915.72998 | 0.50% | -0.45% | 0.21% | 2.90% | |||||||||
| 9/24/19 | 265.369995 | 118.07 | 117.529999 | 7091.379883 | -0.03% | -0.24% | -0.22% | 2.54% | |||||||||
| 9/25/19 | 260.470001 | 118.480003 | 117.059998 | 7052 | -1.85% | 0.35% | -0.40% | -0.56% | |||||||||
| 9/26/19 | 255.360001 | 119.169998 | 117.870003 | 6998.759766 | -1.96% | 0.58% | 0.69% | -0.75% | |||||||||
| 9/27/19 | 255.080002 | 119.599998 | 118.150002 | 7026.959961 | -0.11% | 0.36% | 0.24% | 0.40% | |||||||||
| 9/28/19 | 251.259995 | 121.18 | 117.43 | 7203.459961 | -1.50% | 1.32% | -0.61% | 2.51% | |||||||||
| 9/29/19 | 247.169998 | 120.739998 | 119.239998 | 7301.259766 | -1.63% | -0.36% | 1.54% | 1.36% | |||||||||
| 9/30/19 | 240.699997 | 120.720001 | 118.720001 | 7270.049805 | -2.62% | -0.02% | -0.44% | -0.43% | |||||||||
| 10/1/19 | 234.339996 | 121.32 | 120.019997 | 7369.859863 | -2.64% | 0.50% | 1.10% | 1.37% | |||||||||
| 10/2/19 | 246.179993 | 120.019997 | 119.660004 | 6705.029785 | 5.05% | -1.07% | -0.30% | -9.02% | |||||||||
| 10/3/19 | 248.070007 | 120.040001 | 120.57 | 6515.419922 | 0.77% | 0.02% | 0.76% | -2.83% | |||||||||
| 10/4/19 | 247.75 | 121.050003 | 121.059998 | 6411.779785 | -0.13% | 0.84% | 0.41% | -1.59% | |||||||||
| 10/5/19 | 249.919998 | 121.510002 | 121.25 | 6200.160156 | 0.88% | 0.38% | 0.16% | -3.30% | |||||||||
| 10/6/19 | 6249.069824 | 0.79% | |||||||||||||||
| 10/7/19 | 6324.430176 | 1.21% | |||||||||||||||
| 10/8/19 | 6295.540039 | -0.46% | |||||||||||||||
| 10/9/19 | 6337.109863 | 0.66% | |||||||||||||||
| 10/10/19 | 6492 | 2.44% | |||||||||||||||
| 10/11/19 | 6486.009766 | -0.09% | |||||||||||||||
| 10/12/19 | 6522.080078 | 0.56% | |||||||||||||||
| 10/13/19 | 6502.439941 | -0.30% | |||||||||||||||
| 10/14/19 | 6261.47998 | -3.71% | |||||||||||||||
| 10/15/19 | 6346.439941 | 1.36% | |||||||||||||||
| 10/16/19 | 6398.799805 | 0.83% | |||||||||||||||
| 10/17/19 | 6505.899902 | 1.67% | |||||||||||||||
| 10/18/19 | 6762.060059 | 3.94% | |||||||||||||||
| 10/19/19 | 6716.600098 | -0.67% | |||||||||||||||
| 10/20/19 | 6702.700195 | -0.21% | |||||||||||||||
| 10/21/19 | 6583.529785 | -1.78% | |||||||||||||||
| 10/22/19 | 6437.740234 | -2.21% | |||||||||||||||
| 10/23/19 | 6462.600098 | 0.39% | |||||||||||||||
| 10/24/19 | 6686.129883 | 3.46% | |||||||||||||||
| 10/25/19 | 6635.379883 | -0.76% | |||||||||||||||
| 10/26/19 | 6603.75 | -0.48% | |||||||||||||||
| 10/27/19 | 6623.709961 | 0.30% | |||||||||||||||
| 10/28/19 | 6594.97998 | -0.43% | |||||||||||||||
| 10/29/19 | 6525.470215 | -1.05% | |||||||||||||||
| 10/30/19 | 6492.259766 | -0.51% | |||||||||||||||
| 10/31/19 | 6579.790039 | 1.35% | |||||||||||||||
| 11/1/19 | 6632.870117 | 0.81% | |||||||||||||||
| 11/2/19 | 6589.939941 | -0.65% | |||||||||||||||
| 11/3/19 | 6601.149902 | 0.17% | |||||||||||||||
| 11/4/19 | 6650.069824 | 0.74% | |||||||||||||||
| 11/5/19 | 6631.790039 | -0.27% | |||||||||||||||
| 11/6/19 | 6581.069824 | -0.76% | |||||||||||||||
| 11/7/19 | 6209.470215 | -5.65% | |||||||||||||||
| 11/8/19 | 6250.850098 | 0.67% | |||||||||||||||
| 11/9/19 | 6267.27002 | 0.26% | |||||||||||||||
| 11/10/19 | 6277.72998 | 0.17% | |||||||||||||||
| 11/11/19 | 6612.359863 | 5.33% | |||||||||||||||
| 11/12/19 | 6583.049805 | -0.44% | |||||||||||||||
| 11/13/19 | 6574.52002 | -0.13% | |||||||||||||||
| 11/14/19 | 6488.720215 | -1.31% | |||||||||||||||
| 11/15/19 | 6469.279785 | -0.30% | |||||||||||||||
| 11/16/19 | 6490.560059 | 0.33% | |||||||||||||||
| 11/17/19 | 6509.870117 | 0.30% | |||||||||||||||
| 11/18/19 | 6483.22998 | -0.41% | |||||||||||||||
| 11/19/19 | 6470.220215 | -0.20% | |||||||||||||||
| 11/20/19 | 6476.25 | 0.09% | |||||||||||||||
| 11/21/19 | 6462.77002 | -0.21% | |||||||||||||||
| 11/22/19 | 6457.209961 | -0.09% | |||||||||||||||
| 11/23/19 | 6470.169922 | 0.20% | |||||||||||||||
| 11/24/19 | 6470.740234 | 0.01% | |||||||||||||||
| 11/25/19 | 6313.910156 | -2.42% | |||||||||||||||
| 11/26/19 | 6309.109863 | -0.08% | |||||||||||||||
| 11/27/19 | 6342.609863 | 0.53% | |||||||||||||||
| 11/28/19 | 6381.299805 | 0.61% | |||||||||||||||
| 11/29/19 | 6394.660156 | 0.21% | |||||||||||||||
| 11/30/19 | 6376.319824 | -0.29% | |||||||||||||||
| 12/1/19 | 6467.049805 | 1.42% | |||||||||||||||
| 12/2/19 | 6433.740234 | -0.52% | |||||||||||||||
| 12/3/19 | 6479.720215 | 0.71% | |||||||||||||||
| 12/4/19 | 6529.680176 | 0.77% | |||||||||||||||
| 12/5/19 | 6446.060059 | -1.28% | |||||||||||||||
| 12/6/19 | 6377.990234 | -1.06% | |||||||||||||||
| 12/7/19 | 6396.370117 | 0.29% | |||||||||||||||
| 12/8/19 | 6408.180176 | 0.18% | |||||||||||||||
| 12/9/19 | 6375.080078 | -0.52% | |||||||||||||||
| 12/10/19 | 6339.169922 | -0.56% | |||||||||||||||
| 12/11/19 | 5741.470215 | -9.43% | |||||||||||||||
| 12/12/19 | 5647.5 | -1.64% | |||||||||||||||
| 12/13/19 | 5586.27002 | -1.08% | |||||||||||||||
| 12/14/19 | 5568.939941 | -0.31% | |||||||||||||||
| 12/15/19 | 5615.259766 | 0.83% | |||||||||||||||
| 12/16/19 | 4809.620117 | -14.35% | |||||||||||||||
| 12/17/19 | 4441.810059 | -7.65% | |||||||||||||||
| 12/18/19 | 4593.040039 | 3.40% | |||||||||||||||
| 12/19/19 | 4320.680176 | -5.93% | |||||||||||||||
| 12/20/19 | 4343.419922 | 0.53% | |||||||||||||||
| 12/21/19 | 3854.110107 | -11.27% | |||||||||||||||
| 12/22/19 | 4004.149902 | 3.89% | |||||||||||||||
| 12/23/19 | 3784.590088 | -5.48% | |||||||||||||||
| 12/24/19 | 3822.98999 | 1.01% | |||||||||||||||
| 12/25/19 | 4263.549805 | 11.52% | |||||||||||||||
| 12/26/19 | 4286.689941 | 0.54% | |||||||||||||||
| 12/27/19 | 4009.669922 | -6.46% | |||||||||||||||
| 12/28/19 | 4197.459961 | 4.68% | |||||||||||||||
| 12/29/19 | 4143.859863 | -1.28% | |||||||||||||||
| 12/30/19 | 3871.409912 | -6.57% | |||||||||||||||
| 12/31/19 | 3948.439941 | 1.99% | |||||||||||||||
| 1/1/20 | 3737.530029 | -5.34% | |||||||||||||||
| 1/2/20 | 3485.179932 | -6.75% | |||||||||||||||
| 1/3/20 | 3420.570068 | -1.85% | |||||||||||||||
| 1/4/20 | 3461.070068 | 1.18% | |||||||||||||||
| 1/5/20 | 3592.840088 | 3.81% | |||||||||||||||
| 1/6/20 | 3467.159912 | -3.50% | |||||||||||||||
| 1/7/20 | 3401.02002 | -1.91% | |||||||||||||||
| 1/8/20 | 3485.590088 | 2.49% | |||||||||||||||
| 1/9/20 | 3305.110107 | -5.18% | |||||||||||||||
| 1/10/20 | 3235.47998 | -2.11% | |||||||||||||||
| 1/11/20 | 3232.51001 | -0.09% | |||||||||||||||
| 1/12/20 | 3255.370117 | 0.71% | |||||||||||||||
| 1/13/20 | 3548.189941 | 8.99% | |||||||||||||||
| 1/14/20 | 3715.850098 | 4.73% | |||||||||||||||
| 1/15/20 | 3736.540039 | 0.56% | |||||||||||||||
| 1/16/20 | 4137.660156 | 10.74% | |||||||||||||||
| 1/17/20 | 3898.810059 | -5.77% | |||||||||||||||
| 1/18/20 | 4045.23999 | 3.76% | |||||||||||||||
| 1/19/20 | 4007.629883 | -0.93% | |||||||||||||||
| 1/20/20 | 4081.949951 | 1.85% | |||||||||||||||
| 1/21/20 | 3834.72998 | -6.06% | |||||||||||||||
| 1/22/20 | 3848.780029 | 0.37% | |||||||||||||||
| 1/23/20 | 3646.090088 | -5.27% | |||||||||||||||
| 1/24/20 | 3947.860107 | 8.28% | |||||||||||||||
| 1/25/20 | 3797.060059 | -3.82% | |||||||||||||||
| 1/26/20 | 3896.209961 | 2.61% | |||||||||||||||
| 1/27/20 | 3747.389893 | -3.82% | |||||||||||||||
| 1/28/20 | 3880.149902 | 3.54% |
excel 2 banchmark comp to mine
| Date | SPY | TLT | Q1 2019 | SPY | TLT | BASE PORTFOLIO 60% EQUITY 40% DEBT | |||||
| 1/3/19 | 244.21 | 123.54 | Return over 3 months | 9.07% | 4.56% | 7.72% | |||||
| 1/4/19 | 252.39 | 0.0335 | 122.11 | -0.0116 | Annual Return | 41.54% | 19.51% | 32.73% | |||
| 1/7/19 | 254.38 | 0.0079 | 121.75 | -0.0029 | Standard Deviation | 0.0069051668 | 0.005616092 | 0.006 | |||
| 1/8/19 | 256.77 | 0.0094 | 121.43 | -0.0026 | Volatility over 3 months | 5.44% | 4.42% | 5.03% | |||
| 1/9/19 | 257.97 | 0.0047 | 121.24 | -0.0016 | |||||||
| 1/10/19 | 258.88 | 0.0035 | 120.46 | -0.0064 | Sharpe Ratio | 1.66890 | 4.41176 | ||||
| 1/11/19 | 258.98 | 0.0004 | 120.93 | 0.0039 | Skew | -0.3186673371 | -0.0249281295 | ||||
| 1/14/19 | 257.40 | -0.0061 | 120.48 | -0.0037 | Kurt | 78.01% | -7.57% | ||||
| 1/15/19 | 260.35 | 0.0115 | 120.04 | -0.0037 | |||||||
| 1/16/19 | 260.98 | 0.0024 | 120.16 | 0.0010 | CORRELATION | SPY | TLT | ||||
| 1/17/19 | 262.96 | 0.0076 | 120.19 | 0.0002 | SPY | ||||||
| 1/18/19 | 266.46 | 0.0133 | 119.56 | -0.0052 | TLT | ||||||
| 1/22/19 | 262.86 | -0.0135 | 120.37 | 0.0068 | |||||||
| 1/23/19 | 263.41 | 0.0021 | 120.32 | -0.0004 | |||||||
| 1/24/19 | 263.55 | 0.0005 | 121.11 | 0.0066 | |||||||
| 1/25/19 | 265.78 | 0.0085 | 120.53 | -0.0048 | |||||||
| 1/28/19 | 263.76 | -0.0076 | 120.41 | -0.0010 | |||||||
| 1/29/19 | 263.41 | -0.0013 | 121.02 | 0.0051 | |||||||
| 1/30/19 | 267.58 | 0.0158 | 120.93 | -0.0007 | |||||||
| 1/31/19 | 269.93 | 0.0088 | 121.97 | 0.0086 | |||||||
| 2/1/19 | 270.06 | 0.0005 | 120.96 | -0.0083 | |||||||
| 2/4/19 | 271.96 | 0.0070 | 120.42 | -0.0045 | |||||||
| 2/5/19 | 273.10 | 0.0042 | 120.97 | 0.0046 | |||||||
| 2/6/19 | 272.74 | -0.0013 | 121.03 | 0.0005 | |||||||
| 2/7/19 | 270.14 | -0.0095 | 121.83 | 0.0066 | |||||||
| 2/8/19 | 270.47 | 0.0012 | 122.35 | 0.0043 | |||||||
| 2/11/19 | 270.62 | 0.0006 | 121.87 | -0.0039 | |||||||
| 2/12/19 | 274.10 | 0.0129 | 121.56 | -0.0025 | |||||||
| 2/13/19 | 274.99 | 0.0032 | 121.10 | -0.0038 | |||||||
| 2/14/19 | 274.38 | -0.0022 | 121.79 | 0.0057 | |||||||
| 2/15/19 | 277.37 | 0.0109 | 121.98 | 0.0016 | |||||||
| 2/19/19 | 277.85 | 0.0017 | 122.29 | 0.0025 | |||||||
| 2/20/19 | 278.41 | 0.0020 | 121.94 | -0.0029 | |||||||
| 2/21/19 | 277.42 | -0.0036 | 120.85 | -0.0089 | |||||||
| 2/22/19 | 279.14 | 0.0062 | 121.57 | 0.0060 | |||||||
| 2/25/19 | 279.52 | 0.0014 | 121.21 | -0.0030 | |||||||
| 2/26/19 | 279.32 | -0.0007 | 121.81 | 0.0050 | |||||||
| 2/27/19 | 279.20 | -0.0004 | 120.43 | -0.0113 | |||||||
| 2/28/19 | 278.68 | -0.0019 | 120.02 | -0.0034 | |||||||
| 3/1/19 | 280.42 | 0.0062 | 118.66 | -0.0113 | |||||||
| 3/4/19 | 279.40 | -0.0036 | 119.59 | 0.0078 | |||||||
| 3/5/19 | 279.02 | -0.0014 | 119.84 | 0.0021 | |||||||
| 3/6/19 | 277.33 | -0.0061 | 120.28 | 0.0037 | |||||||
| 3/7/19 | 275.01 | -0.0084 | 121.06 | 0.0065 | |||||||
| 3/8/19 | 274.46 | -0.0020 | 121.57 | 0.0042 | |||||||
| 3/11/19 | 278.44 | 0.0145 | 121.21 | -0.0030 | |||||||
| 3/12/19 | 279.49 | 0.0038 | 122.06 | 0.0070 | |||||||
| 3/13/19 | 281.34 | 0.0066 | 121.83 | -0.0019 | |||||||
| 3/14/19 | 281.16 | -0.0006 | 120.95 | -0.0072 | |||||||
| 3/15/19 | 281.31 | 0.0005 | 121.75 | 0.0066 | |||||||
| 3/18/19 | 282.33 | 0.0036 | 121.68 | -0.0006 | |||||||
| 3/19/19 | 282.40 | 0.0002 | 121.41 | -0.0022 | |||||||
| 3/20/19 | 281.55 | -0.0030 | 122.68 | 0.0105 | |||||||
| 3/21/19 | 284.73 | 0.0113 | 122.95 | 0.0022 | |||||||
| 3/22/19 | 279.25 | -0.0192 | 124.86 | 0.0155 | |||||||
| 3/25/19 | 279.04 | -0.0008 | 125.06 | 0.0016 | |||||||
| 3/26/19 | 281.12 | 0.0075 | 124.97 | -0.0007 | |||||||
| 3/27/19 | 279.65 | -0.0052 | 126.12 | 0.0092 | |||||||
| 3/28/19 | 280.71 | 0.0038 | 126.56 | 0.0035 | |||||||
| 3/29/19 | 282.48 | 0.0063 | 126.44 | -0.0009 | |||||||
excel 1my calculation
| Date | Spy | Spy.r | Change in percentage | |||
| 3/28/18 | 259.829987 | |||||
| 3/29/18 | 263.149994 | 0.0127776129 | 1.2777612924 | % | ||
| 4/2/18 | 257.470001 | -0.0215846214 | -2.1584621431 | % | ||
| 4/3/18 | 260.769989 | 0.0128169806 | 1.2816980569 | % | ||
| 4/4/18 | 263.559998 | 0.0106991184 | 1.0699118448 | % | ||
| 4/5/18 | 265.640015 | 0.0078920057 | 0.7892005675 | % | ||
| 4/6/18 | 259.720001 | -0.0222858518 | -2.2285851776 | % | ||
| 4/9/18 | 261 | 0.0049283805 | 0.4928380545 | % | ||
| 4/10/18 | 265.149994 | 0.0159003602 | 1.5900360153 | % | ||
| 4/11/18 | 263.76001 | -0.0052422554 | -0.5242255446 | % | ||
| 4/12/18 | 265.929993 | 0.0082271115 | 0.8227111456 | % | ||
| 4/13/18 | 265.149994 | -0.002933099 | -0.2933099013 | % | ||
| 4/16/18 | 267.329987 | 0.0082217351 | 0.8221735053 | % | ||
| 4/17/18 | 270.190002 | 0.0106984444 | 1.0698444391 | % | ||
| 4/18/18 | 270.390015 | 0.000740268 | 0.0740267954 | % | ||
| 4/19/18 | 268.890015 | -0.0055475421 | -0.5547542131 | % | ||
| 4/20/18 | 266.609985 | -0.0084794149 | -0.8479414901 | % | ||
| 4/23/18 | 266.570007 | -0.0001499494 | -0.0149949373 | % | ||
| 4/24/18 | 262.980011 | -0.0134673666 | -1.3467366567 | % | ||
| 4/25/18 | 263.630005 | 0.0024716479 | 0.2471647931 | % | ||
| 4/26/18 | 266.309998 | 0.0101657359 | 1.0165735877 | % | ||
| 4/27/18 | 266.559998 | 0.0009387556 | 0.0938755593 | % | ||
| 4/30/18 | 264.51001 | -0.0076905313 | -0.769053127 | % | ||
| 5/1/18 | 264.980011 | 0.0017768742 | 0.1776874153 | % | ||
| 5/2/18 | 263.200012 | -0.0067174841 | -0.671748406 | % | ||
| 5/3/18 | 262.619995 | -0.0022037119 | -0.2203711906 | % | ||
| 5/4/18 | 266.019989 | 0.01294644 | 1.2946439969 | % | ||
| 5/7/18 | 266.920013 | 0.0033832946 | 0.3383294629 | % | ||
| 5/8/18 | 266.920013 | 0 | 0 | % | ||
| 5/9/18 | 269.5 | 0.0096657683 | 0.9665768299 | % | ||
| 5/10/18 | 272.019989 | 0.0093506085 | 0.9350608534 | % | ||
| 5/11/18 | 272.850006 | 0.0030513089 | 0.3051308851 | % | ||
| 5/14/18 | 272.980011 | 0.0004764706 | 0.0476470578 | % | ||
| 5/15/18 | 271.100006 | -0.0068869695 | -0.6886969464 | % | ||
| 5/16/18 | 272.23999 | 0.0042050313 | 0.4205031261 | % | ||
| 5/17/18 | 272.01001 | -0.0008447694 | -0.0844769352 | % | ||
| 5/18/18 | 271.329987 | -0.0024999926 | -0.2499992555 | % | ||
| 5/21/18 | 273.369995 | 0.0075185497 | 0.7518549728 | % | ||
| 5/22/18 | 272.609985 | -0.0027801515 | -0.2780151494 | % | ||
| 5/23/18 | 273.359985 | 0.0027511832 | 0.275118316 | % | ||
| 5/24/18 | 272.799988 | -0.0020485698 | -0.2048569764 | % | ||
| 5/25/18 | 272.149994 | -0.0023826761 | -0.2382676058 | % | ||
| 5/29/18 | 269.019989 | -0.0115010291 | -1.1501029098 | % | ||
| 5/30/18 | 272.609985 | 0.0133447184 | 1.334471841 | % | ||
| 5/31/18 | 270.940002 | -0.0061259055 | -0.6125905476 | % | ||
| 6/1/18 | 273.600006 | 0.0098176865 | 0.98176865 | % | ||
| 6/4/18 | 274.899994 | 0.004751418 | 0.4751418024 | % | ||
| 6/5/18 | 275.100006 | 0.000727581 | 0.0727580954 | % | ||
| 6/6/18 | 277.399994 | 0.0083605523 | 0.8360552344 | % | ||
| 6/7/18 | 277.369995 | -0.0001081435 | -0.0108143477 | % | ||
| 6/8/18 | 278.190002 | 0.0029563652 | 0.2956365197 | % | ||
| 6/11/18 | 278.559998 | 0.0013300119 | 0.1330011853 | % | ||
| 6/12/18 | 278.920013 | 0.0012924146 | 0.129241457 | % | ||
| 6/13/18 | 278.029999 | -0.0031909291 | -0.319092915 | % | ||
| 6/14/18 | 278.730011 | 0.0025177571 | 0.2517757086 | % | ||
| 6/15/18 | 277.130005 | -0.0057403435 | -0.5740343475 | % | ||
| 6/18/18 | 276.559998 | -0.0020568217 | -0.2056821671 | % | ||
| 6/19/18 | 275.5 | -0.0038327958 | -0.3832795804 | % | ||
| 6/20/18 | 275.970001 | 0.0017059927 | 0.170599274 | % | ||
| 6/21/18 | 274.23999 | -0.0062688372 | -0.626883717 | % | ||
| 6/22/18 | 274.73999 | 0.0018232206 | 0.1823220603 | % | ||
| 6/25/18 | 271 | -0.0136128344 | -1.3612834448 | % | ||
| 6/26/18 | 271.600006 | 0.0022140443 | 0.221404428 | % | ||
| 6/27/18 | 269.350006 | -0.0082842413 | -0.8284241349 | % | ||
| 6/28/18 | 270.890015 | 0.0057175013 | 0.5717501265 | % | ||
| 6/29/18 | 271.279999 | 0.0014396396 | 0.1439639626 | % | ||
| 7/2/18 | 271.859985 | 0.0021379608 | 0.2137960786 | % | ||
| 7/3/18 | 270.899994 | -0.0035311964 | -0.3531196399 | % | ||
| 7/5/18 | 273.109985 | 0.0081579588 | 0.8157958837 | % | ||
| 7/6/18 | 275.420013 | 0.0084582334 | 0.8458233411 | % | ||
| 7/9/18 | 277.899994 | 0.0090043602 | 0.9004360188 | % | ||
| 7/10/18 | 278.899994 | 0.0035984168 | 0.3598416774 | % | ||
| 7/11/18 | 276.859985 | -0.0073144821 | -0.7314482051 | % | ||
| 7/12/18 | 279.369995 | 0.0090659905 | 0.9065990522 | % | ||
| 7/13/18 | 279.589996 | 0.0007874897 | 0.0787489723 | % | ||
| 7/16/18 | 279.339996 | -0.0008941665 | -0.0894166471 | % | ||
| 7/17/18 | 280.470001 | 0.0040452675 | 0.4045267474 | % | ||
| 7/18/18 | 281.059998 | 0.0021036011 | 0.2103601091 | % | ||
| 7/19/18 | 280 | -0.0037714296 | -0.3771429615 | % | ||
| 7/20/18 | 279.679993 | -0.0011428821 | -0.1142882143 | % | ||
| 7/23/18 | 280.200012 | 0.0018593357 | 0.1859335716 | % | ||
| 7/24/18 | 281.609985 | 0.0050320233 | 0.5032023339 | % | ||
| 7/25/18 | 284.01001 | 0.0085225139 | 0.8522513859 | % | ||
| 7/26/18 | 283.339996 | -0.0023591211 | -0.2359121075 | % | ||
| 7/27/18 | 281.420013 | -0.0067762512 | -0.6776251243 | % | ||
| 7/30/18 | 279.950012 | -0.0052235127 | -0.5223512658 | % | ||
| 7/31/18 | 281.329987 | 0.0049293622 | 0.4929362175 | % | ||
| 8/1/18 | 280.859985 | -0.0016706431 | -0.1670643094 | % | ||
| 8/2/18 | 282.390015 | 0.005447661 | 0.5447661047 | % | ||
| 8/3/18 | 283.600006 | 0.0042848222 | 0.4284822181 | % | ||
| 8/6/18 | 284.640015 | 0.0036671685 | 0.366716847 | % | ||
| 8/7/18 | 285.579987 | 0.0033023185 | 0.3302318544 | % | ||
| 8/8/18 | 285.459991 | -0.0004201835 | -0.0420183505 | % | ||
| 8/9/18 | 285.070007 | -0.0013661599 | -0.1366159925 | % | ||
| 8/10/18 | 283.160004 | -0.0067001191 | -0.6700119104 | % | ||
| 8/13/18 | 282.100006 | -0.0037434595 | -0.3743459475 | % | ||
| 8/14/18 | 283.899994 | 0.0063806734 | 0.6380673384 | % | ||
| 8/15/18 | 281.779999 | -0.0074674007 | -0.7467400651 | % | ||
| 8/16/18 | 284.059998 | 0.0080914153 | 0.8091415317 | % | ||
| 8/17/18 | 285.059998 | 0.003520383 | 0.3520383042 | % | ||
| 8/20/18 | 285.670013 | 0.002139953 | 0.2139953007 | % | ||
| 8/21/18 | 286.339996 | 0.0023453039 | 0.2345303915 | % | ||
| 8/22/18 | 286.170013 | -0.0005936404 | -0.0593640436 | % | ||
| 8/23/18 | 285.790009 | -0.0013278959 | -0.1327895946 | % | ||
| 8/24/18 | 287.51001 | 0.0060184084 | 0.6018408432 | % | ||
| 8/27/18 | 289.779999 | 0.007895339 | 0.7895339018 | % | ||
| 8/28/18 | 289.920013 | 0.0004831734 | 0.0483173444 | % | ||
| 8/29/18 | 291.480011 | 0.0053807876 | 0.5380787562 | % | ||
| 8/30/18 | 290.299988 | -0.004048384 | -0.4048383956 | % | ||
| 8/31/18 | 290.309998 | 0.0000344816 | 0.0034481572 | % | ||
| 9/4/18 | 289.809998 | -0.0017222969 | -0.1722296867 | % | ||
| 9/5/18 | 289.029999 | -0.0026914151 | -0.2691415084 | % | ||
| 9/6/18 | 288.160004 | -0.0030100509 | -0.301005087 | % | ||
| 9/7/18 | 287.600006 | -0.0019433578 | -0.194335783 | % | ||
| 9/10/18 | 288.100006 | 0.0017385257 | 0.1738525694 | % | ||
| 9/11/18 | 289.049988 | 0.0032974036 | 0.3297403611 | % | ||
| 9/12/18 | 289.119995 | 0.0002421969 | 0.0242196862 | % | ||
| 9/13/18 | 290.829987 | 0.0059144716 | 0.5914471602 | % | ||
| 9/14/18 | 290.880005 | 0.0001719836 | 0.0171983641 | % | ||
| 9/17/18 | 289.339996 | -0.0052943103 | -0.5294310278 | % | ||
| 9/18/18 | 290.910004 | 0.00542617 | 0.5426169979 | % | ||
| 9/19/18 | 291.220001 | 0.0010656113 | 0.1065611343 | % | ||
| 9/20/18 | 293.579987 | 0.0081037909 | 0.8103790921 | % | ||
| 9/21/18 | 291.98999 | -0.0054158903 | -0.5415890287 | % | ||
| 9/24/18 | 291.019989 | -0.0033220351 | -0.3322035115 | % | ||
| 9/25/18 | 290.75 | -0.0009277335 | -0.0927733524 | % | ||
| 9/26/18 | 289.880005 | -0.0029922442 | -0.2992244196 | % | ||
| 9/27/18 | 290.690002 | 0.0027942493 | 0.2794249296 | % | ||
| 9/28/18 | 290.720001 | 0.0001031993 | 0.0103199284 | % | ||
| 10/1/18 | 291.730011 | 0.0034741676 | 0.3474167572 | % | ||
| 10/2/18 | 291.559998 | -0.0005827751 | -0.0582775147 | % | ||
| 10/3/18 | 291.720001 | 0.0005487824 | 0.0548782416 | % | ||
| 10/4/18 | 289.440002 | -0.0078157102 | -0.7815710243 | % | ||
| 10/5/18 | 287.820007 | -0.0055969976 | -0.5596997612 | % | ||
| 10/8/18 | 287.820007 | 0 | 0 | % | ||
| 10/9/18 | 287.399994 | -0.0014592905 | -0.1459290493 | % | ||
| 10/10/18 | 278.299988 | -0.0316632087 | -3.1663208733 | % | ||
| 10/11/18 | 272.170013 | -0.0220265011 | -2.2026501129 | % | ||
| 10/12/18 | 275.950012 | 0.0138883742 | 1.3888374249 | % | ||
| 10/15/18 | 274.399994 | -0.0056170246 | -0.5617024579 | % | ||
| 10/16/18 | 280.399994 | 0.0218658897 | 2.1865889691 | % | ||
| 10/17/18 | 280.450012 | 0.0001783809 | 0.0178380888 | % | ||
| 10/18/18 | 276.399994 | -0.0144411404 | -1.4441140405 | % | ||
| 10/19/18 | 276.25 | -0.0005426701 | -0.0542670055 | % | ||
| 10/22/18 | 275.01001 | -0.0044886516 | -0.4488651584 | % | ||
| 10/23/18 | 273.609985 | -0.0050908147 | -0.5090814694 | % | ||
| 10/24/18 | 265.320007 | -0.0302985215 | -3.0298521452 | % | ||
| 10/25/18 | 270.079987 | 0.0179405242 | 1.7940524176 | % | ||
| 10/26/18 | 265.329987 | -0.0175873824 | -1.7587382363 | % | ||
| 10/29/18 | 263.859985 | -0.0055402784 | -0.5540278416 | % | ||
| 10/30/18 | 267.769989 | 0.0148184803 | 1.4818480339 | % | ||
| 10/31/18 | 270.630005 | 0.0106808683 | 1.0680868348 | % | ||
| 11/1/18 | 273.51001 | 0.010641854 | 1.0641853995 | % | ||
| 11/2/18 | 271.890015 | -0.0059229825 | -0.592298249 | % | ||
| 11/5/18 | 273.390015 | 0.0055169367 | 0.5516936692 | % | ||
| 11/6/18 | 275.119995 | 0.0063278829 | 0.6327882897 | % | ||
| 11/7/18 | 281.01001 | 0.0214088947 | 2.140889469 | % | ||
| 11/8/18 | 280.5 | -0.0018149176 | -0.1814917554 | % | ||
| 11/9/18 | 277.76001 | -0.0097682353 | -0.9768235294 | % | ||
| 11/12/18 | 272.570007 | -0.018685206 | -1.8685205981 | % | ||
| 11/13/18 | 272.059998 | -0.001871112 | -0.187111196 | % | ||
| 11/14/18 | 270.200012 | -0.0068366758 | -0.6836675784 | % | ||
| 11/15/18 | 273.019989 | 0.010436628 | 1.043662796 | % | ||
| 11/16/18 | 273.730011 | 0.0026006228 | 0.260062277 | % | ||
| 11/19/18 | 269.100006 | -0.0169144954 | -1.6914495357 | % | ||
| 11/20/18 | 264.119995 | -0.018506172 | -1.8506172014 | % | ||
| 11/21/18 | 265.019989 | 0.0034075194 | 0.3407519374 | % | ||
| 11/23/18 | 263.25 | -0.0066787 | -0.6678699998 | % | ||
| 11/26/18 | 267.5 | 0.0161443495 | 1.6144349478 | % | ||
| 11/27/18 | 268.399994 | 0.0033644636 | 0.3364463551 | % | ||
| 11/28/18 | 274.579987 | 0.0230253098 | 2.3025309755 | % | ||
| 11/29/18 | 273.980011 | -0.0021850682 | -0.2185068207 | % | ||
| 11/30/18 | 275.649994 | 0.0060952731 | 0.6095273133 | % | ||
| 12/3/18 | 279.299988 | 0.0132414079 | 1.324140787 | % | ||
| 12/4/18 | 270.25 | -0.0324023931 | -3.2402393086 | % | ||
| 12/6/18 | 269.839996 | -0.0015171286 | -0.1517128585 | % | ||
| 12/7/18 | 263.570007 | -0.0232359513 | -2.3235951278 | % | ||
| 12/10/18 | 264.070007 | 0.0018970292 | 0.1897029202 | % | ||
| 12/11/18 | 264.130005 | 0.0002272049 | 0.0227204902 | % | ||
| 12/12/18 | 265.459991 | 0.0050353461 | 0.5035346136 | % | ||
| 12/13/18 | 265.369995 | -0.0003390191 | -0.0339019073 | % | ||
| 12/14/18 | 260.470001 | -0.0184647628 | -1.8464762755 | % | ||
| 12/17/18 | 255.360001 | -0.0196183821 | -1.961838208 | % | ||
| 12/18/18 | 255.080002 | -0.0010964873 | -0.1096487308 | % | ||
| 12/19/18 | 251.259995 | -0.0149757212 | -1.4975721225 | % | ||
| 12/20/18 | 247.169998 | -0.0162779475 | -1.627794747 | % | ||
| 12/21/18 | 240.699997 | -0.0261763202 | -2.6176320154 | % | ||
| 12/24/18 | 234.339996 | -0.0264229376 | -2.6422937596 | % | ||
| 12/26/18 | 246.179993 | 0.0505248664 | 5.0524866442 | % | ||
| 12/27/18 | 248.070007 | 0.0076773664 | 0.7677366373 | % | ||
| 12/28/18 | 247.75 | -0.0012899867 | -0.1289986661 | % | ||
| 12/31/18 | 249.919998 | 0.0087588214 | 0.8758821393 | % | ||
| 1/2/19 | 250.179993 | 0.0010403129 | 0.1040312908 | % | ||
| 1/3/19 | 244.210007 | -0.0238627635 | -2.3862763478 | % | ||
| 1/4/19 | 252.389999 | 0.0334957281 | 3.3495728126 | % | ||
| 1/7/19 | 254.380005 | 0.0078846468 | 0.7884646808 | % | ||
| 1/8/19 | 256.769989 | 0.0093953296 | 0.9395329637 | % | ||
| 1/9/19 | 257.970001 | 0.0046734901 | 0.4673490094 | % | ||
| 1/10/19 | 258.880005 | 0.0035275575 | 0.3527557454 | % | ||
| 1/11/19 | 258.980011 | 0.0003863025 | 0.0386302527 | % | ||
| 1/14/19 | 257.399994 | -0.0061009226 | -0.6100922592 | % | ||
| 1/15/19 | 260.350006 | 0.0114608083 | 1.1460808348 | % | ||
| 1/16/19 | 260.980011 | 0.0024198386 | 0.2419838623 | % | ||
| 1/17/19 | 262.959991 | 0.0075867113 | 0.7586711306 | % | ||
| 1/18/19 | 266.459991 | 0.0133100096 | 1.3310009582 | % | ||
| 1/22/19 | 262.859985 | -0.0135104936 | -1.3510493589 | % | ||
| 1/23/19 | 263.410004 | 0.002092441 | 0.2092440962 | % | ||
| 1/24/19 | 263.549988 | 0.0005314301 | 0.0531430082 | % | ||
| 1/25/19 | 265.779999 | 0.0084614346 | 0.8461434648 | % | ||
| 1/28/19 | 263.76001 | -0.0076002295 | -0.7600229542 | % | ||
| 1/29/19 | 263.410004 | -0.0013269866 | -0.1326986604 | % | ||
| 1/30/19 | 267.579987 | 0.0158307693 | 1.5830769282 | % | ||
| 1/31/19 | 269.929993 | 0.0087824431 | 0.8782443061 | % | ||
| 2/1/19 | 270.059998 | 0.0004816249 | 0.0481624878 | % | ||
| 2/4/19 | 271.959991 | 0.0070354477 | 0.703544773 | % | ||
| 2/5/19 | 273.100006 | 0.0041918482 | 0.4191848205 | % | ||
| 2/6/19 | 272.73999 | -0.001318257 | -0.131825702 | % | ||
| 2/7/19 | 270.140015 | -0.0095327972 | -0.9532797152 | % | ||
| 2/8/19 | 270.470001 | 0.0012215369 | 0.1221536913 | % | ||
| 2/11/19 | 270.619995 | 0.000554568 | 0.0554567972 | % | ||
| 2/12/19 | 274.100006 | 0.0128594009 | 1.2859400873 | % | ||
| 2/13/19 | 274.98999 | 0.0032469317 | 0.3246931706 | % | ||
| 2/14/19 | 274.380005 | -0.002218208 | -0.2218208015 | % | ||
| 2/15/19 | 277.369995 | 0.0108972591 | 1.0897259077 | % | ||
| 2/19/19 | 277.850006 | 0.0017305801 | 0.1730580123 | % | ||
| 2/20/19 | 278.410004 | 0.0020154687 | 0.2015468735 | % | ||
| 2/21/19 | 277.420013 | -0.0035558744 | -0.3555874379 | % | ||
| 2/22/19 | 279.140015 | 0.0061999925 | 0.61999925 | % | ||
| 2/25/19 | 279.519989 | 0.0013612309 | 0.136123085 | % | ||
| 2/26/19 | 279.320007 | -0.0007154479 | -0.0715447939 | % | ||
| 2/27/19 | 279.200012 | -0.0004295969 | -0.0429596867 | % | ||
| 2/28/19 | 278.679993 | -0.0018625322 | -0.1862532155 | % | ||
| 3/1/19 | 280.420013 | 0 | % | |||
| 3/4/19 | 279.399994 | -0.0036374686 | -0.3637468628 | % | ||
| 3/5/19 | 279.019989 | -0.0013600752 | -0.136007519 | % | ||
| 3/6/19 | 277.329987 | -0.0060569209 | -0.605692089 | % | ||
| 3/7/19 | 275.01001 | -0.0083654026 | -0.8365402621 | % | ||
| 3/8/19 | 274.459991 | -0.0019999963 | -0.1999996291 | % | ||
| 3/11/19 | 278.440002 | 0.0145012429 | 1.4501242915 | % | ||
| 3/12/19 | 279.48999 | 0.0037709668 | 0.3770966788 | % | ||
| 3/13/19 | 281.339996 | 0.006619221 | 0.661922096 | % | ||
| 3/14/19 | 281.160004 | -0.0006397668 | -0.0639766839 | % | ||
| 3/15/19 | 281.309998 | 0.0005334827 | 0.0533482707 | % | ||
| 3/18/19 | 282.329987 | 0.0036258541 | 0.3625854066 | % | ||
| 3/19/19 | 282.399994 | 0.0002479616 | 0.0247961617 | % | ||
| 3/20/19 | 281.549988 | -0.0030099363 | -0.3009936325 | % | ||
| 3/21/19 | 284.730011 | 0.0112947012 | 1.1294701245 | % | ||
| 3/22/19 | 279.25 | -0.0192463414 | -1.9246341405 | % | ||
| 3/25/19 | 279.040009 | -0.0007519821 | -0.0751982095 | % | ||
| 3/26/19 | 281.119995 | 0.007454078 | 0.7454078028 | % | ||
| 3/27/19 | 279.649994 | -0.0052290873 | -0.5229087316 | % | ||
| 3/28/19 | 280.709991 | 0.0037904417 | 0.3790441705 | % | ||
| 3/29/19 | 282.48 | 0.006305472 | 0.6305472041 | % | ||
| In this part you explain the calculation that I did , you say what those results mean ( I STARTED THE TRADE THE SECONF WEEK ON jENUARY 2019 THE 11NTH ON JENUARY ) | ||||||
| Standard Deviation | 0.0098419967 | |||||
| Annualised Volatility | 0.1562368536 | |||||
| Sharpe Ratio | 2.6589223592 | |||||
| Quarterly Return | 0.0907405514 | |||||
| Annual return | 0.4154216634 | |||||
| Skew | -0.276105358 | |||||
| Kurt | 0.8148807476 | |||||
student performance
| this is the portfolio value between mine and other students you compare them saying also that me and one more student had the best performance (is highleted the best performance ) | ||||||
| STUDENT ID | Portfolio Value | |||||
| amaa34 | 1024051 | |||||
| zyfa | 1057454.6 | |||||
| ama55 | 1050481.85 | |||||
| jb1399 | 1028075.9 | |||||
| mmb19 | 1034493.2 | |||||
| sb940 | 1057279.36 | |||||
| dc509 | 1070028 | |||||
| ac889 | 1000000 | |||||
| wc74 | 1062460.96 | |||||
| gc273 | 1006213 | |||||
| jc678 | 1000000 | |||||
| vc113 | 1000000 | |||||
| rd287 | 1017668 | |||||
| ed340 | 1052809 | |||||
| sd632 | 1013756.4 | |||||
| kdg14 | 1018222.4 | |||||
| kd374 | 1000000 | |||||
| je283 | 1046390.3 | |||||
| gme14 | 1079193.79 | |||||
| tf171 | 1053756 | |||||
| df238 | 813760 | |||||
| bjrg10 | 1046153 | |||||
| mgb33 | 1015688.45 | |||||
| afdg10 | 1063334.16 | |||||
| tg190 | 1020106.95 | |||||
| hjh20 | 1059982.8 | |||||
| dh369 | 1041586.16 | |||||
| mh723 | 1051592.06 | |||||
| teh14 | 1048397.25 | |||||
| sh865 | 1000000 | |||||
| ch613 | 1000000 | |||||
| si106 | 1059002.81 | |||||
| fj47 | 1090733.5 | |||||
| jj302 | 1037746.59 | |||||
| maj32 | 1000000 | |||||
| tnk13 | 1038003.4 | |||||
| mk441 | 1055166.04 | |||||
| jrl23 | 1028614.45 | |||||
| wtal10 | 1057136.54 | |||||
| wqm10 | 1007931.4 | |||||
| tm354 | 1058978.43 | |||||
| tmjm39 | 1031756.55 | |||||
| mm1149 | 1000000 | |||||
| am1982 | 1045542 | |||||
| mm821 | 1067846.85 | |||||
| tm338 | 1057832.28 | |||||
| jm1260 | 1000000 | |||||
| onhh10 | 1074164.66 | |||||
| bo68 | 1041954.93 | |||||
| do105 | 1044786.45 | |||||
| poo17 | 1012693.3 | |||||
| zeo11 | 1029360.21 | |||||
| pp189 | 1000000 | |||||
| ajr54 | 1044308.65 | |||||
| os89 | 999419 | |||||
| ss812 | 1023316.75 | |||||
| atbs10 | 1039002 | |||||
| as1190 | 1004700 | |||||
| mjs73 | 1032799.41 | |||||
| jjsk10 | 1009076 | |||||
| js1104 | 1066950.3 | |||||
| trjs11 | 1040581.75 | |||||
| st554 | 1048411.6 | |||||
| cv817 | 1039126.84 | |||||
| tv52 | 1028936.1 | |||||
| ev57 | 1000000 | |||||
| amvl10 | 1035759 | |||||
| aw784 | 1030035.15 | |||||
| jaw73 | 1017218 | |||||
| aww12 | 1000000 | |||||
| cw544 | 1073012.9 | |||||
| lw446 | 1059585.87 | |||||
| dw349 | 1065674.23 | |||||
| gw216 | 1061908.77 | |||||
| jspy10 | 1067325.54 | |||||
Portfolio Value amaa34 zyfa ama55 jb1399 mmb19 sb940 dc509 ac889 wc74 gc273 jc678 vc113 rd287 ed340 sd632 kdg14 kd374 je283 gme14 tf171 df238 bjrg10 mgb33 afdg10 tg190 hjh20 dh369 mh723 teh14 sh865 ch613 si106 fj47 jj302 maj32 tnk13 mk441 jrl23 wtal10 wqm10 tm354 tmjm39 mm1149 am1982 mm821 tm338 jm1260 onhh10 bo68 do105 poo17 zeo11 pp189 ajr54 os89 ss812 atbs10 as1190 mjs73 jjsk10 js1104 trjs11 st554 cv817 tv52 ev57 amvl10 aw784 jaw73 aww12 cw544 lw446 dw349 gw216 jspy10 1024051 1057454.6000000001 1050481.8500000001 1028075.9 1034493.2 1057279.3600000001 1070028 1000000 1062460.96 1006213 1000000 1000000 1017668 1052809 1013756.4 1018222.4 1000000 1046390.3 1079193.79 1053756 813760 1046153 1015688.45 1063334.1599999999 102010 6.95 1059982.8 1041586.16 1051592.06 1048397.25 1000000 1000000 1059002.81 1090733.5 1037746.59 1000000 1038003.4 1055166.04 1028614.45 1057136.54 1007931.4 1058978.43 1031756.55 1000000 1045542 1067846.8500000001 1057832.28 1000000 1074164.6599999999 1041954.93 1044786.45 1012693.3 1029360.21 1000000 1044308.65 999419 1023316.75 1039002 1004700 1032799.41 1009076 1066950.3 1040581.75 1048411.6 1039126.84 1028936.1 1000000 1035759 1030035.15 1017218 1000000 1073012.8999999999 1059585.8700000001 1065674.23 1061908.77 1067325.54