economic report with some calculation needed

ffff2019
calculationpart.xlsx
Home>Business & Finance homework help>Economics homework help>economic report with some calculation needed

Q1 2019

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

2018

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%