See attachedGraded Home Work #1 FIN 352 Investments, Fall 2019 Dr. ZarBabal Do everything in Excel,...

Question

See attachedGraded Home Work #1 FIN 352 Investments, Fall 2019 Dr. ZarBabal Do everything in Excel, and upload your Excel spreadsheet to blackboard.  Please ask a classmate if you are not sure how to upload the assignment to blackboard before assignment is due.  Late assignments will not be accepted, please be sure you upload the correct file. 1) You have $12,000 to invest today.  Based on the following table:  a. What is the expected risk premium for the stock market over the next year?   b. What is the zero coupon yield?  c. What is the Sharpe ratio expected to be over the next year?  	Invest in Stocks 	Probability 	Expected future portfolio value in one year 	Expected Dividend or coupon in one year 	 	0.08 	$10,000  	$0  	 	0.45 	$13,000  	$500  	 	0.35 	$14,000  	$1,000  	 	0.12 	$18,000  	$1,000  	 	 	 	 	Invest in 1yr Zero coupon  bond 	1 	$12,360  	$0  2) Use data downloaded from StockTrak to calculate the following for the last 5 years (or 60 months): a) Calculate the gross geometric average (aka TV) return on the S&P 500 price level (column B) since 1871, using the monthly data. b) What is the monthly geometric average return? c) What is the correlation coefficient between the S&P price and the 10 year US bond yield using monthly data? What is your economic explanation for your results? d) What is the arithmetic average return on the S&P 500, adjusted for dividends and stock splits? e) Extra Credit: What is the average real return on the S&P 500, including dividends?  What does this say about inflation and stock market returns? 3) Use data downloaded from StockTrak to calculate the following for the last 5 years, with the S&P 500 Index as the Market Benchmark, and the : 	a) What is the Sharpe Ratio of the S&P 500 Index, using Annual data for the last 5 years? b) What is the Sharpe Ratio of GE, using Annual data for the last 5 years? 	c) What is the Sharpe Ratio of GLD Gold ETF, using Annual data for the last 5 years?

Pooja · Accepted Answer

1
		Invest in Stocks	Probability	Expected future portfolio value in one year	Expected Dividend or coupon in one year
			0.08	10000	0
			0.45	13000	500
			0.35	14000	1000
			0.12	18000	1000
		Invest in 1yr Zero coupon  bond	1	12360	0
	a)
		Risk premium is extra premium earned from investing in stock market over the risk free rate.
		Rsik premium =		Rm - Rf
		where,	Rm =	Market return over next year
			Rf =	Risk free rate
		Rp =	sum [ probability stock i * [(Future value of stock I + dividend earned for I )/ Invested Value of i -1] ; i=1,2,…,n
		Rp =	20.04%
		Rf =	0.03
		Rp = Rf + Beta ( Rm - Rf)
		(Rp - Rf)/beta + Rf = Rm
		Rm =	20.04%
	b)
		Risk free bond yield =	3%
	c)
		Sharpe ratio = (Rp- Rf) / Standard deviation of market
		Sharpe ratio	0.17
		 -> sub-optimal
qm-pricehistory-current-nrhwyoq
	Date	Open	High	Low	Close	VWAP	Unadj. Open	Unadj. High	Unadj. Low	Unadj. Close	Unadj. VWAP	Volume	Change Percent	Change	Trade Value	Total Trades	Total Interest
	9/19/19	3010.36	3021.99	3003.16	3006.79		3010.36	3021.99	3003.16	3006.79		0	0.002	0.06		22996
	9/18/19	3001.5	3007.83	2978.57	3006.73		3001.5	3007.83	2978.57	3006.73		0	0.034	1.03		22510
	9/17/19	2995.67	3006.21	2993.73	3005.7		2995.67	3006.21	2993.73	3005.7		0	0.258	7.74		23358
	9/16/19	2996.41	3002.19	2990.67	2997.96		2996.41	3002.19	2990.67	2997.96		0	-0.314	-9.43		8943
	9/13/19	3012.21	3017.33	3002.9	3007.39		3012.21	3017.33	3002.9	3007.39		0	-0.072	-2.18		20808
	9/12/19	3009.08	3020.74	3000.92	3009.57		3009.08	3020.74	3000.92	3009.57		0	0.288	8.64		18634
	9/11/19	2981.41	3000.93	2975.31	3000.93		2981.41	3000.93	2975.31	3000.93		0	0.723	21.54		23859
	9/10/19	2971.01	2979.39	2957.01	2979.39		2971.01	2979.39	2957.01	2979.39		0	0.032	0.96		23618
	9/9/19	2988.43	2989.43	2969.39	2978.43		2988.43	2989.43	2969.39	2978.43		0	-0.009	-0.28		11168
	9/6/19	2980.33	2985.03	2972.51	2978.71		2980.33	2985.03	2972.51	2978.71		0	0.091	2.71		14454
	9/5/19	2960.6	2985.86	2960.6	2976		2960.6	2985.86	2960.6	2976		0	1.301	38.22		2999
	9/4/19	2924.67	2938.84	2921.86	2937.78		2924.67	2938.84	2921.86	2937.78		0	1.084	31.51		22947
	9/3/19	2909.01	2914.39	2891.85	2906.27		2909.01	2914.39	2891.85	2906.27		0	-0.69	-20.19		2709
	8/30/19	2937.09	2940.43	2913.32	2926.46		2937.09	2940.43	2913.32	2926.46		0	0.064	1.88		6988
	8/29/19	2910.37	2930.5	2905.67	2924.58		2910.37	2930.5	2905.67	2924.58		0	1.269	36.64		17083
	8/28/19	2861.28	2890.03	2853.05	2887.94		2861.28	2890.03	2853.05	2887.94		0	0.655	18.78		0
	8/27/19	2893.14	2898.79	2860.59	2869.16		2893.14	2898.79	2860.59	2869.16		0	-0.32	-9.22		0
	8/26/19	2866.7	2879.27	2856	2878.38		2866.7	2879.27	2856	2878.38		0	1.098	31.27		0
	8/23/19	2911.07	2927.01	2834.97	2847.11		2911.07	2927.01	2834.97	2847.11		0	-2.595	-75.84		0
	8/22/19	2930.94	2939.08	2904.51	2922.95		2930.94	2939.08	2904.51	2922.95		0	-0.051	-1.48		0
	8/21/19	2922.04	2928.73	2917.91	2924.43		2922.04	2928.73	2917.91	2924.43		0	0.825	23.92		0
	8/20/19	2919.01	2923.63	2899.6	2900.51		2919.01	2923.63	2899.6	2900.51		0	-0.791	-23.14		0
	8/19/19	2913.48	2931	2913.48	2923.65		2913.48	2931	2913.48	2923.65		0	1.211	34.97		0
	8/16/19	2864.74	2893.63	2864.74	2888.68		2864.74	2893.63	2864.74	2888.68		0	1.443	41.08		0
	8/15/19	2846.2	2856.67	2825.51	2847.6		2846.2	2856.67	2825.51	2847.6		0	0.246	7		0
	8/14/19	2894.15	2894.15	2839.64	2840.6		2894.15	2894.15	2839.64	2840.6		0	-2.929	-85.72		0
	8/13/19	2880.72	2943.31	2877.05	2926.32		2880.72	2943.31	2877.05	2926.32		0	1.499	43.23		0
	8/12/19	2907.07	2907.58	2873.14	2883.09		2907.07	2907.58	2873.14	2883.09		0	-1.218	-35.56		0
	8/9/19	2930.51	2935.75	2900.15	2918.65		2930.51	2935.75	2900.15	2918.65		0	-0.662	-19.44		0
	8/8/19	2896.21	2938.72	2894.47	2938.09		2896.21	2938.72	2894.47	2938.09		0	1.876	54.11		0
	8/7/19	2858.65	2892.17	2825.71	2883.98		2858.65	2892.17	2825.71	2883.98		0	0.077	2.21		0
	8/6/19	2861.18	2884.4	2847.42	2881.77		2861.18	2884.4	2847.42	2881.77		0	1.302	37.03		0
	8/5/19	2898.07	2898.07	2822.12	2844.74		2898.07	2898.07	2822.12	2844.74		0	-2.978	-87.31		0
	8/2/19	2943.9	2945.5	2914.11	2932.05		2943.9	2945.5	2914.11	2932.05		0	-0.728	-21.51		0
	8/1/19	2980.32	3013.59	2945.23	2953.56		2980.32	3013.59	2945.23	2953.56		0	-0.9	-26.82		0
	7/31/19	3016.22	3017.4	2958.08	2980.38		3016.22	3017.4	2958.08	2980.38		0	-1.089	-32.8		0
	7/30/19	3007.66	3017.19	3000.94	3013.18		3007.66	3017.19	3000.94	3013.18		0	-0.258	-7.79		0
	7/29/19	3024.47	3025.61	3014.3	3020.97		3024.47	3025.61	3014.3	3020.97		0	-0.162	-4.89		0
	7/26/19	3013.25	3027.98	3012.59	3025.86		3013.25	3027.98	3012.59	3025.86		0	0.739	22.19		0
	7/25/19	3016.26	3016.31	2997.24	3003.67		3016.26	3016.31	2997.24	3003.67		0	-0.526	-15.89		0
	7/24/19	2998.77	3019.59	2996.82	3019.56		2998.77	3019.59	2996.82	3019.56		0	0.469	14.09		0
	7/23/19	2994.74	3005.9	2988.56	3005.47		2994.74	3005.9	2988.56	3005.47		0	0.685	20.44		0
	7/22/19	2981.93	2990.71	2976.65	2985.03		2981.93	2990.71	2976.65	2985.03		0	0.283	8.42		0
	7/19/19	3004.26	3006.02	2975.86	2976.61		3004.26	3006.02	2975.86	2976.61		0	-0.618	-18.5		0
	7/18/19	2978.87	2998.28	2973.09	2995.11		2978.87	2998.28	2973.09	2995.11		0	0.358	10.69		0
	7/17/19	3005.1	3005.26	2984.25	2984.42		3005.1	3005.26	2984.25	2984.42		0	-0.653	-19.62		0
	7/16/19	3012.13	3015.02	3001.15	3004.04		3012.13	3015.02	3001.15	3004.04		0	-0.34	-10.26		0
	7/15/19	3017.8	3017.8	3008.77	3014.3		3017.8	3017.8	3008.77	3014.3		0	0.018	0.53		0
	7/12/19	3003.36	3013.92	3001.87	3013.77		3003.36	3013.92	3001.87	3013.77		0	0.462	13.86		0
	7/11/19	2999.62	3002.33	2988.8	2999.91		2999.62	3002.33	2988.8	2999.91		0	0.229	6.84		0
	7/10/19	2989.3	3002.98	2984.62	2993.07		2989.3	3002.98	2984.62	2993.07		0	0.451	13.44		0
	7/9/19	2965.52	2981.9	2963.44	2979.63		2965.52	2981.9	2963.44	2979.63		0	0.124	3.68		0
	7/8/19	2979.77	2980.76	2970.09	2975.95		2979.77	2980.76	2970.09	2975.95		0	-0.484	-14.46		0
	7/5/19	2984.25	2994.03	2967.97	2990.41		2984.25	2994.03	2967.97	2990.41		0	-0.181	-5.41		0
	7/3/19	2978.08	2995.84	2977.96	2995.82		2978.08	2995.84	2977.96	2995.82		0	0.767	22.81		0
	7/2/19	2964.66	2973.21	2955.92	2973.01		2964.66	2973.21	2955.92	2973.01		0	0.293	8.68		0
	7/1/19	2971.41	2977.93	2952.22	2964.33		2971.41	2977.93	2952.22	2964.33		0	0.767	22.57		0
	6/28/19	2932.94	2943.98	2929.05	2941.76		2932.94	2943.98	2929.05	2941.76		0	0.576	16.84		0
	6/27/19	2919.66	2929.3	2918.57	2924.92		2919.66	2929.3	2918.57	2924.92		0	0.382	11.14		0
	6/26/19	2926.07	2932.59	2912.99	2913.78		2926.07	2932.59	2912.99	2913.78		0	-0.123	-3.6		0
	6/25/19	2945.78	2946.52	2916.01	2917.38		2945.78	2946.52	2916.01	2917.38		0	-0.95	-27.97		0
	6/24/19	2951.42	2954.92	2944.05	2945.35		2951.42	2954.92	2944.05	2945.35		0	-0.173	-5.11		0
	6/21/19	2952.71	2964.15	2946.87	2950.46		2952.71	2964.15	2946.87	2950.46		0	-0.126	-3.72		0
	6/20/19	2949.6	2958.06	2931.5	2954.18		2949.6	2958.06	2931.5	2954.18		0	0.947	27.72		0
	6/19/19	2920.55	2931.74	2911.43	2926.46		2920.55	2931.74	2911.43	2926.46		0	0.299	8.71		0
	6/18/19	2906.71	2930.79	2905.44	2917.75		2906.71	2930.79	2905.44	2917.75		0	0.972	28.08		0
	6/17/19	2889.75	2897.27	2887.3	2889.67		2889.75	2897.27	2887.3	2889.67		0	0.093	2.69		0
	6/14/19	2886.82	2894.45	2879.62	2886.98		2886.82	2894.45	2879.62	2886.98		0	-0.161	-4.66		0
	6/13/19	2886.24	2895.24	2881.99	2891.64		2886.24	2895.24	2881.99	2891.64		0	0.41	11.8		0
	6/12/19	2882.73	2888.57	2874.68	2879.84		2882.73	2888.57	2874.68	2879.84		0	-0.204	-5.88		0
	6/11/19	2903.27	2910.61	2878.53	2885.72		2903.27	2910.61	2878.53	2885.72		0	-0.035	-1.01		0
	6/10/19	2885.83	2904.77	2885.51	2886.73		2885.83	2904.77	2885.51	2886.73		0	0.466	13.39		0
	6/7/19	2852.87	2884.97	2852.87	2873.34		2852.87	2884.97	2852.87	2873.34		0	1.05	29.85		0
	6/6/19	2828.51	2852.1	2822.45	2843.49		2828.51	2852.1	2822.45	2843.49		0	0.614	17.34		0
	6/5/19	2818.09	2827.28	2800.92	2826.15		2818.09	2827.28	2800.92	2826.15		0	0.816	22.88		0
	6/4/19	2762.64	2804.49	2762.64	2803.27		2762.64	2804.49	2762.64	2803.27		0	2.143	58.82		0
	6/3/19	2751.53	2763.07	2728.81	2744.45		2751.53	2763.07	2728.81	2744.45		0	-0.277	-7.61		0
	5/31/19	2766.15	2768.98	2750.52	2752.06		2766.15	2768.98	2750.52	2752.06		0	-1.32	-36.8		0
	5/30/19	2786.94	2799	2776.74	2788.86		2786.94	2799	2776.74	2788.86		0	0.21	5.84		0
	5/29/19	2790.25	2792.03	2766.06	2783.02		2790.25	2792.03	2766.06	2783.02		0	-0.691	-19.37		0
	5/28/19	2830.03	2840.51	2801.58	2802.39		2830.03	2840.51	2801.58	2802.39		0	-0.838	-23.67		0
	5/24/19	2832.41	2841.36	2820.19	2826.06		2832.41	2841.36	2820.19	2826.06		0	0.135	3.82		0
	5/23/19	2836.7	2836.7	2805.49	2822.24		2836.7	2836.7	2805.49	2822.24		0	-1.191	-34.03		0
	5/22/19	2856.06	2865.47	2851.11	2856.27		2856.06	2865.47	2851.11	2856.27		0	-0.282	-8.09		0
	5/21/19	2854.02	2868.88	2854.02	2864.36		2854.02	2868.88	2854.02	2864.36		0	0.85	24.13		0
	5/20/19	2841.94	2853.86	2831.29	2840.23		2841.94	2853.86	2831.29	2840.23		0	-0.675	-19.3		0
	5/17/19	2858.6	2885.48	2854.23	2859.53		2858.6	2885.48	2854.23	2859.53		0	-0.584	-16.79		0
	5/16/19	2855.8	2892.15	2855.8	2876.32		2855.8	2892.15	2855.8	2876.32		0	0.89	25.36		0
	5/15/19	2820.38	2858.68	2815.08	2850.96		2820.38	2858.68	2815.08	2850.96		0	0.584	16.55		0
	5/14/19	2820.12	2852.54	2820.12	2834.41		2820.12	2852.54	2820.12	2834.41		0	0.802	22.54		0
	5/13/19	2840.19	2840.19	2801.43	2811.87		2840.19	2840.19	2801.43	2811.87		0	-2.413	-69.53		0
	5/10/19	2863.1	2891.31	2825.39	2881.4		2863.1	2891.31	2825.39	2881.4		0	0.372	10.68		0
	5/9/19	2859.84	2875.97	2836.4	2870.72		2859.84	2875.97	2836.4	2870.72		0	-0.302	-8.7		0
	5/8/19	2879.61	2897.96	2873.28	2879.42		2879.61	2897.96	2873.28	2879.42		0	-0.161	-4.63		0
	5/7/19	2913.03	2913.03	2862.6	2884.05		2913.03	2913.03	2862.6	2884.05		0	-1.651	-48.42		0
	5/6/19	2908.89	2937.32	2898.21	2932.47		2908.89	2937.32	2898.21	2932.47		0	-0.447	-13.17		0
	5/3/19	2929.21	2947.85	2929.21	2945.64		2929.21	2947.85	2929.21	2945.64		0	0.964	28.12		0
	5/2/19	2922.16	2931.68	2900.5	2917.52		2922.16	2931.68	2900.5	2917.52		0	-0.212	-6.21		0
	5/1/19	2952.33	2954.13	2923.36	2923.73		2952.33	2954.13	2923.36	2923.73		0	-0.75	-22.1		0
	4/30/19	2937.14	2948.22	2924.11	2945.83		2937.14	2948.22	2924.11	2945.83		0	0.095	2.8		0
	4/29/19	2940.58	2949.52	2939.35	2943.03		2940.58	2949.52	2939.35	2943.03		0	0.107	3.15		0
	4/26/19	2925.81	2939.88	2917.56	2939.88		2925.81	2939.88	2917.56	2939.88		0	0.469	13.71		0
	4/25/19	2928.99	2933.1	2912.84	2926.17		2928.99	2933.1	2912.84	2926.17		0	-0.037	-1.08		0
	4/24/19	2934	2936.83	2926.05	2927.25		2934	2936.83	2926.05	2927.25		0	-0.219	-6.43		0
	4/23/19	2909.99	2936.31	2908.53	2933.68		2909.99	2936.31	2908.53	2933.68		0	0.884	25.71		0
	4/22/19	2898.78	2909.51	2896.35	2907.97		2898.78	2909.51	2896.35	2907.97		0	0.101	2.94		0
	4/18/19	2904.81	2908.4	2891.9	2905.03		2904.81	2908.4	2891.9	2905.03		0	0.158	4.58		0
	4/17/19	2916.04	2918	2895.45	2900.45		2916.04	2918	2895.45	2900.45		0	-0.227	-6.61		0
	4/16/19	2912.26	2916.06	2900.71	2907.06		2912.26	2916.06	2900.71	2907.06		0	0.051	1.48		0
	4/15/19	2908.32	2909.6	2896.48	2905.58		2908.32	2909.6	2896.48	2905.58		0	-0.063	-1.83		0
	4/12/19	2900.86	2910.54	2898.37	2907.41		2900.86	2910.54	2898.37	2907.41		0	0.661	19.09		0
	4/11/19	2891.92	2893.42	2881.99	2888.32		2891.92	2893.42	2881.99	2888.32		0	0.004	0.11		0
	4/10/19	2881.37	2889.71	2879.13	2888.21		2881.37	2889.71	2879.13	2888.21		0	0.348	10.01		0
	4/9/19	2886.58	2886.88	2873.33	2878.2		2886.58	2886.88	2873.33	2878.2		0	-0.607	-17.57		0
	4/8/19	2888.46	2895.95	2880.78	2895.77		2888.46	2895.95	2880.78	2895.77		0	0.105	3.03		0
	4/5/19	2884.16	2893.24	2882.99	2892.74		2884.16	2893.24	2882.99	2892.74		0	0.464	13.35		0
	4/4/19	2873.99	2881.28	2867.14	2879.39		2873.99	2881.28	2867.14	2879.39		0	0.208	5.99		0
	4/3/19	2876.09	2885.25	2865.17	2873.4		2876.09	2885.25	2865.17	2873.4		0	0.215	6.16		0
	4/2/19	2868.24	2872.9	2858.75	2867.24		2868.24	2872.9	2858.75	2867.24		0	0.002	0.05		0
	4/1/19	2848.63	2869.4	2848.63	2867.19		2848.63	2869.4	2848.63	2867.19		0	1.157	32.79		0
	3/29/19	2828.27	2836.03	2819.23	2834.4		2828.27	2836.03	2819.23	2834.4		0	0.673	18.96		0
	3/28/19	2809.4	2819.71	2798.77	2815.44		2809.4	2819.71	2798.77	2815.44		0	0.359	10.07		0
	3/27/19	2819.72	2825.56	2787.72	2805.37		2819.72	2825.56	2787.72	2805.37		0	-0.464	-13.09		0
	3/26/19	2812.66	2829.87	2803.99	2818.46		2812.66	2829.87	2803.99	2818.46		0	0.718	20.1		0
	3/25/19	2796.01	2809.79	2785.02	2798.36		2796.01	2809.79	2785.02	2798.36		0	-0.084	-2.35		0
	3/22/19	2844.52	2846.16	2800.47	2800.71		2844.52	2846.16	2800.47	2800.71		0	-1.897	-54.17		0
	3/21/19	2819.72	2860.31	2817.38	2854.88		2819.72	2860.31	2817.38	2854.88		0	1.085	30.65		0
	3/20/19	2831.34	2843.54	2812.43	2824.23		2831.34	2843.54	2812.43	2824.23		0	-0.294	-8.34		0
	3/19/19	2840.76	2852.42	2823.27	2832.57		2840.76	2852.42	2823.27	2832.57		0	-0.013	-0.37		0
	3/18/19	2822.61	2835.41	2821.99	2832.94		2822.61	2835.41	2821.99	2832.94		0	0.371	10.46		0
	3/15/19	2810.79	2830.73	2810.79	2822.48		2810.79	2830.73	2810.79	2822.48		0	0.498	14		0
	3/14/19	2810.38	2815	2803.46	2808.48		2810.38	2815	2803.46	2808.48		0	-0.087	-2.44		0
	3/13/19	2799.78	2821.24	2799.78	2810.92		2799.78	2821.24	2799.78	2810.92		0	0.695	19.4		0
	3/12/19	2787.34	2798.32	2786.73	2791.52		2787.34	2798.32	2786.73	2791.52		0	0.295	8.22		0
	3/11/19	2747.61	2784	2747.61	2783.3		2747.61	2784	2747.61	2783.3		0	1.467	40.23		0
	3/8/19	2730.79	2744.13	2722.27	2743.07		2730.79	2744.13	2722.27	2743.07		0	-0.213	-5.86		0
	3/7/19	2766.53	2767.25	2739.09	2748.93		2766.53	2767.25	2739.09	2748.93		0	-0.813	-22.52		0
	3/6/19	2790.27	2790.27	2768.69	2771.45		2790.27	2790.27	2768.69	2771.45		0	-0.652	-18.2		0
	3/5/19	2794.41	2796.44	2782.97	2789.65		2794.41	2796.44	2782.97	2789.65		0	-0.113	-3.16		0
	3/4/19	2814.37	2816.88	2767.66	2792.81		2814.37	2816.88	2767.66	2792.81		0	-0.388	-10.88		0
	3/1/19	2798.22	2808.02	2787.38	2803.69		2798.22	2808.02	2787.38	2803.69		0	0.69	19.2		0
	2/28/19	2788.11	2793.73	2782.51	2784.49		2788.11	2793.73	2782.51	2784.49		0	-0.283	-7.89		0
	2/27/19	2787.5	2795.76	2775.13	2792.38		2787.5	2795.76	2775.13	2792.38		0	-0.054	-1.52		0
	2/26/19	2792.36	2803.12	2789.47	2793.9		2792.36	2803.12	2789.47	2793.9		0	-0.079	-2.21		0
	2/25/19	2804.35	2813.49	2794.99	2796.11		2804.35	2813.49	2794.99	2796.11		0	0.123	3.44		0
	2/22/19	2780.67	2794.2	2779.11	2792.67		2780.67	2794.2	2779.11	2792.67		0	0.641	17.79		0
	2/21/19	2780.24	2781.58	2764.55	2774.88		2780.24	2781.58	2764.55	2774.88		0	-0.353	-9.82		0
	2/20/19	2779.05	2789.88	2774.06	2784.7		2779.05	2789.88	2774.06	2784.7		0	0.178	4.94		0
	2/19/19	2769.28	2787.33	2767.29	2779.76		2769.28	2787.33	2767.29	2779.76		0	0.15	4.16		0
	2/15/19	2760.24	2775.66	2760.24	2775.6		2760.24	2775.66	2760.24	2775.6		0	1.088	29.87		0
	2/14/19	2743.5	2757.9	2731.23	2745.73		2743.5	2757.9	2731.23	2745.73		0	-0.265	-7.3		0
	2/13/19	2750.3	2761.85	2748.63	2753.03		2750.3	2761.85	2748.63	2753.03		0	0.302	8.3		0
	2/12/19	2722.61	2748.19	2722.61	2744.73		2722.61	2748.19	2722.61	2744.73		0	1.289	34.93		0
	2/11/19	2712.4	2718.05	2703.79	2709.8		2712.4	2718.05	2703.79	2709.8		0	0.071	1.92		0
	2/8/19	2692.36	2708.07	2681.83	2707.88		2692.36	2708.07	2681.83	2707.88		0	0.068	1.83		0
	2/7/19	2717.53	2719.32	2687.26	2706.05		2717.53	2719.32	2687.26	2706.05		0	-0.936	-25.56		0
	2/6/19	2735.05	2738.08	2724.15	2731.61		2735.05	2738.08	2724.15	2731.61		0	-0.222	-6.09		0
	2/5/19	2728.34	2738.98	2724.03	2737.7		2728.34	2738.98	2724.03	2737.7		0	0.471	12.83		0
	2/4/19	2706.49	2724.99	2698.75	2724.87		2706.49	2724.99	2698.75	2724.87		0	0.678	18.34		0
	2/1/19	2702.32	2716.66	2696.88	2706.53		2702.32	2716.66	2696.88	2706.53		0	0.09	2.43		0
	1/31/19	2685.49	2708.95	2678.65	2704.1		2685.49	2708.95	2678.65	2704.1		0	0.86	23.05		0
	1/30/19	2653.62	2690.44	2648.34	2681.05		2653.62	2690.44	2648.34	2681.05		0	1.555	41.05		0
	1/29/19	2644.89	2650.93	2631.05	2640		2644.89	2650.93	2631.05	2640		0	-0.146	-3.85		0
	1/28/19	2644.97	2644.97	2624.06	2643.85		2644.97	2644.97	2624.06	2643.85		0	-0.785	-20.91		0
	1/25/19	2657.44	2672.38	2657.33	2664.76		2657.44	2672.38	2657.33	2664.76		0	0.849	22.43		0
	1/24/19	2638.84	2647.2	2627.01	2642.33		2638.84	2647.2	2627.01	2642.33		0	0.138	3.63		0
	1/23/19	2643.48	2653.19	2612.86	2638.7		2643.48	2653.19	2612.86	2638.7		0	0.22	5.8		0
	1/22/19	2657.88	2657.88	2617.27	2632.9		2657.88	2657.88	2617.27	2632.9		0	-1.416	-37.81		0
	1/18/19	2651.27	2675.47	2647.58	2670.71		2651.27	2675.47	2647.58	2670.71		0	1.318	34.75		0
	1/17/19	2609.28	2645.06	2606.36	2635.96		2609.28	2645.06	2606.36	2635.96		0	0.759	19.86		0
	1/16/19	2614.75	2625.76	2612.68	2616.1		2614.75	2625.76	2612.68	2616.1		0	0.222	5.8		0
	1/15/19	2585.1	2613.08	2585.1	2610.3		2585.1	2613.08	2585.1	2610.3		0	1.072	27.69		0
	1/14/19	2580.31	2589.32	2570.41	2582.61		2580.31	2589.32	2570.41	2582.61		0	-0.526	-13.65		0
	1/11/19	2588.11	2596.27	2577.4	2596.26		2588.11	2596.27	2577.4	2596.26		0	-0.015	-0.38		0
	1/10/19	2573.51	2597.82	2562.02	2596.64		2573.51	2597.82	2562.02	2596.64		0	0.452	11.68		0
	1/9/19	2580	2595.32	2568.89	2584.96		2580	2595.32	2568.89	2584.96		0	0.41	10.55		0
	1/8/19	2568.11	2579.82	2547.56	2574.41		2568.11	2579.82	2547.56	2574.41		0	0.97	24.72		0
	1/7/19	2535.61	2566.16	2524.56	2549.69		2535.61	2566.16	2524.56	2549.69		0	0.701	17.75		0
	1/4/19	2474.33	2538.07	2474.33	2531.94		2474.33	2538.07	2474.33	2531.94		0	3.434	84.05		0
	1/3/19	2491.92	2493.14	2443.96	2447.89		2491.92	2493.14	2443.96	2447.89		0	-2.476	-62.14		0
	1/2/19	2476.96	2519.49	2467.47	2510.03		2476.96	2519.49	2467.47	2510.03		0	0.127	3.18		0
	12/31/18	2498.94	2509.24	2482.82	2506.85		2498.94	2509.24	2482.82	2506.85		0	0.849	21.11		0
	12/28/18	2498.77	2520.27	2472.89	2485.74		2498.77	2520.27	2472.89	2485.74		0	-0.124	-3.09		0
	12/27/18	2442.5	2489.1	2397.94	2488.83		2442.5	2489.1	2397.94	2488.83		0	0.856	21.13		0
	12/26/18	2363.12	2467.76	2346.58	2467.7		2363.12	2467.76	2346.58	2467.7		0	4.959	116.6		0
	12/24/18	2400.56	2410.34	2351.1	2351.1		2400.56	2410.34	2351.1	2351.1		0	-2.711	-65.52		0
	12/21/18	2465.38	2504.41	2408.55	2416.62		2465.38	2504.41	2408.55	2416.62		0	-2.059	-50.8		0
	12/20/18	2496.77	2509.63	2441.18	2467.42		2496.77	2509.63	2441.18	2467.42		0	-1.577	-39.54		0
	12/19/18	2547.05	2585.29	2488.96	2506.96		2547.05	2585.29	2488.96	2506.96		0	-1.54	-39.2		0
	12/18/18	2559.9	2573.99	2528.71	2546.16		2559.9	2573.99	2528.71	2546.16		0	0.009	0.22		0
	12/17/18	2590.75	2601.13	2530.54	2545.94		2590.75	2601.13	2530.54	2545.94		0	-2.077	-54.01		0
	12/14/18	2629.68	2635.07	2593.84	2599.95		2629.68	2635.07	2593.84	2599.95		0	-1.909	-50.59		0
	12/13/18	2658.7	2670.19	2637.27	2650.54		2658.7	2670.19	2637.27	2650.54		0	-0.02	-0.53		0
	12/12/18	2658.23	2685.44	2650.26	2651.07		2658.23	2685.44	2650.26	2651.07		0	0.542	14.29		0
	12/11/18	2664.44	2674.35	2621.3	2636.78		2664.44	2674.35	2621.3	2636.78		0	-0.036	-0.94		0
	12/10/18	2630.86	2647.51	2583.23	2637.72		2630.86	2647.51	2583.23	2637.72		0	0.176	4.64		0
	12/7/18	2691.26	2708.54	2623.14	2633.08		2691.26	2708.54	2623.14	2633.08		0	-2.332	-62.87		0
	12/6/18	2663.51	2696.15	2621.53	2695.95		2663.51	2696.15	2621.53	2695.95		0	-0.152	-4.11		0
	12/4/18	2782.43	2785.93	2697.18	2700.06		2782.43	2785.93	2697.18	2700.06		0	-3.236	-90.31		0
	12/3/18	2790.5	2800.18	2773.38	2790.37		2790.5	2800.18	2773.38	2790.37		0	1.094	30.2		0
	11/30/18	2737.76	2760.88	2732.76	2760.17		2737.76	2760.88	2732.76	2760.17		0	0.819	22.41		0
	11/29/18	2736.97	2753.75	2722.94	2737.76		2736.97	2753.75	2722.94	2737.76		0	-0.22	-6.03		0
	11/28/18	2691.45	2744	2684.38	2743.79		2691.45	2744	2684.38	2743.79		0	2.297	61.62		0
	11/27/18	2663.75	2682.53	2655.89	2682.17		2663.75	2682.53	2655.89	2682.17		0	0.326	8.72		0
	11/26/18	2649.97	2674.35	2649.97	2673.45		2649.97	2674.35	2649.97	2673.45		0	1.553	40.89		0
	11/23/18	2633.36	2647.55	2631.09	2632.56		2633.36	2647.55	2631.09	2632.56		0	-0.655	-17.37		0
	11/21/18	2657.74	2670.73	2649.82	2649.93		2657.74	2670.73	2649.82	2649.93		0	0.304	8.04		0
	11/20/18	2654.6	2669.44	2631.52	2641.89		2654.6	2669.44	2631.52	2641.89		0	-1.815	-48.84		0
	11/19/18	2730.74	2733.16	2681.09	2690.73		2730.74	2733.16	2681.09	2690.73		0	-1.664	-45.54		0
	11/16/18	2718.54	2746.75	2712.16	2736.27		2718.54	2746.75	2712.16	2736.27		0	0.222	6.07		0
	11/15/18	2693.52	2735.38	2670.75	2730.2		2693.52	2735.38	2670.75	2730.2		0	1.059	28.62		0
	11/14/18	2737.9	2746.8	2685.75	2701.58		2737.9	2746.8	2685.75	2701.58		0	-0.757	-20.6		0
	11/13/18	2730.05	2754.6	2714.98	2722.18		2730.05	2754.6	2714.98	2722.18		0	-0.148	-4.04		0
	11/12/18	2773.93	2775.99	2722	2726.22		2773.93	2775.99	2722	2726.22		0	-1.97	-54.79		0
	11/9/18	2794.1	2794.1	2764.24	2781.01		2794.1	2794.1	2764.24	2781.01		0	-0.92	-25.82		0
	11/8/18	2806.38	2814.75	2794.99	2806.83		2806.38	2814.75	2794.99	2806.83		0	-0.251	-7.06		0
	11/7/18	2774.13	2815.15	2774.13	2813.89		2774.13	2815.15	2774.13	2813.89		0	2.121	58.44		0
	11/6/18	2738.4	2756.82	2737.08	2755.45		2738.4	2756.82	2737.08	2755.45		0	0.626	17.14		0
	11/5/18	2726.37	2744.27	2717.94	2738.31		2726.37	2744.27	2717.94	2738.31		0	0.56	15.25		0
	11/2/18	2745.45	2756.55	2700.44	2723.06		2745.45	2756.55	2700.44	2723.06		0	-0.632	-17.31		0
	11/1/18	2717.58	2741.67	2708.85	2740.37		2717.58	2741.67	2708.85	2740.37		0	1.056	28.63		0
	10/31/18	2705.6	2736.69	2705.6	2711.74		2705.6	2736.69	2705.6	2711.74		0	1.085	29.11		0
	10/30/18	2640.68	2685.43	2635.34	2682.63		2640.68	2685.43	2635.34	2682.63		0	1.567	41.38		0
	10/29/18	2682.65	2706.85	2603.54	2641.25		2682.65	2706.85	2603.54	2641.25		0	-0.656	-17.44		0
	10/26/18	2667.86	2692.38	2628.16	2658.69		2667.86	2692.38	2628.16	2658.69		0	-1.733	-46.88		0
	10/25/18	2674.88	2722.7	2667.84	2705.57		2674.88	2722.7	2667.84	2705.57		0	1.863	49.47		0
	10/24/18	2737.87	2742.59	2651.89	2656.1		2737.87	2742.59	2651.89	2656.1		0	-3.086	-84.59		0
	10/23/18	2721.03	2753.59	2691.43	2740.69		2721.03	2753.59	2691.43	2740.69		0	-0.551	-15.19		0
	10/22/18	2773.94	2778.94	2749.22	2755.88		2773.94	2778.94	2749.22	2755.88		0	-0.43	-11.9		0
	10/19/18	2775.66	2797.77	2760.27	2767.78		2775.66	2797.77	2760.27	2767.78		0	-0.036	-1		0
	10/18/18	2802	2806.04	2755.18	2768.78		2802	2806.04	2755.18	2768.78		0	-1.439	-40.43		0
	10/17/18	2811.67	2816.94	2781.81	2809.21		2811.67	2816.94	2781.81	2809.21		0	-0.025	-0.71		0
	10/16/18	2767.05	2813.46	2766.91	2809.92		2767.05	2813.46	2766.91	2809.92		0	2.15	59.13		0
	10/15/18	2763.83	2775.99	2749.03	2750.79		2763.83	2775.99	2749.03	2750.79		0	-0.591	-16.34		0
	10/12/18	2770.54	2775.77	2729.44	2767.13		2770.54	2775.77	2729.44	2767.13		0	1.421	38.76		0
	10/11/18	2776.87	2795.14	2710.51	2728.37		2776.87	2795.14	2710.51	2728.37		0	-2.057	-57.31		0
	10/10/18	2873.9	2874.02	2784.86	2785.68		2873.9	2874.02	2784.86	2785.68		0	-3.286	-94.66		0
	10/9/18	2882.51	2894.83	2874.27	2880.34		2882.51	2894.83	2874.27	2880.34		0	-0.142	-4.09		0
	10/8/18	2877.53	2889.45	2862.08	2884.43		2877.53	2889.45	2862.08	2884.43		0	-0.04	-1.14		0
	10/5/18	2902.54	2909.64	2869.29	2885.57		2902.54	2909.64	2869.29	2885.57		0	-0.553	-16.04		0
	10/4/18	2919.35	2919.78	2883.92	2901.61		2919.35	2919.78	2883.92	2901.61		0	-0.817	-23.9		0
	10/3/18	2931.69	2939.86	2921.36	2925.51		2931.69	2939.86	2921.36	2925.51		0	0.071	2.08		0
	10/2/18	2923.8	2931.42	2919.37	2923.43		2923.8	2931.42	2919.37	2923.43		0	-0.04	-1.16		0
	10/1/18	2926.29	2937.06	2917.91	2924.59		2926.29	2937.06	2917.91	2924.59		0	0.364	10.61		0
	9/28/18	2910.03	2920.53	2907.5	2913.98		2910.03	2920.53	2907.5	2913.98		0	-0.001	-0.02		0
	9/27/18	2911.65	2927.22	2909.27	2914		2911.65	2927.22	2909.27	2914		0	0.276	8.03		0
	9/26/18	2916.98	2931.15	2903.28	2905.97		2916.98	2931.15	2903.28	2905.97		0	-0.329	-9.59		0
	9/25/18	2921.75	2923.95	2913.7	2915.56		2921.75	2923.95	2913.7	2915.56		0	-0.131	-3.81		0
	9/24/18	2921.83	2923.79	2912.63	2919.37		2921.83	2923.79	2912.63	2919.37		0	-0.352	-10.3		0
	9/21/18	2936.76	2940.91	2927.11	2929.67		2936.76	2940.91	2927.11	2929.67		0	-0.037	-1.08		0
	9/20/18	2919.73	2934.8	2919.73	2930.75		2919.73	2934.8	2919.73	2930.75		0	0.784	22.8		0
	9/19/18	2906.6	2912.36	2903.82	2907.95		2906.6	2912.36	2903.82	2907.95		0	0.125	3.64		0
	9/18/18	2890.74	2911.17	2890.43	2904.31		2890.74	2911.17	2890.43	2904.31		0	0.537	15.51		0
	9/17/18	2903.83	2904.65	2886.16	2888.8		2903.83	2904.65	2886.16	2888.8		0	-0.557	-16.18		0
	9/14/18	2906.38	2908.3	2895.77	2904.98		2906.38	2908.3	2895.77	2904.98		0	0.028	0.8		0
	9/13/18	2896.85	2906.76	2896.39	2904.18		2896.85	2906.76	2896.39	2904.18		0	0.528	15.26		0
	9/12/18	2888.29	2894.65	2879.2	2888.92		2888.29	2894.65	2879.2	2888.92		0	0.036	1.03		0
	9/11/18	2871.57	2892.52	2866.78	2887.89		2871.57	2892.52	2866.78	2887.89		0	0.374	10.76		0
	9/10/18	2881.39	2886.93	2875.94	2877.13		2881.39	2886.93	2875.94	2877.13		0	0.19	5.45		0
	9/7/18	2868.26	2883.81	2864.12	2871.68		2868.26	2883.81	2864.12	2871.68		0	-0.221	-6.37		0
	9/6/18	2888.64	2892.05	2867.29	2878.05		2888.64	2892.05	2867.29	2878.05		0	-0.365	-10.55		0
	9/5/18	2891.59	2894.21	2876.92	2888.6		2891.59	2894.21	2876.92	2888.6		0	-0.28	-8.12		0
	9/4/18	2896.96	2900.18	2885.13	2896.72		2896.96	2900.18	2885.13	2896.72		0	-0.165	-4.8		0
	8/31/18	2898.37	2906.32	2891.73	2901.52		2898.37	2906.32	2891.73	2901.52		0	0.013	0.39		0
	8/30/18	2908.94	2912.46	2895.22	2901.13		2908.94	2912.46	2895.22	2901.13		0	-0.443	-12.91		0
	8/29/18	2900.62	2916.5	2898.4	2914.04		2900.62	2916.5	2898.4	2914.04		0	0.57	16.52		0
	8/28/18	2901.45	2903.77	2893.5	2897.52		2901.45	2903.77	2893.5	2897.52		0	0.027	0.78		0
	8/27/18	2884.69	2898.25	2884.69	2896.74		2884.69	2898.25	2884.69	2896.74		0	0.767	22.05		0
	8/24/18	2862.35	2876.16	2862.35	2874.69		2862.35	2876.16	2862.35	2874.69		0	0.62	17.71		0
	8/23/18	2860.29	2868.78	2854.03	2856.98		2860.29	2868.78	2854.03	2856.98		0	-0.169	-4.84		0
	8/22/18	2860.99	2867.54	2856.05	2861.82		2860.99	2867.54	2856.05	2861.82		0	-0.04	-1.14		0
	8/21/18	2861.51	2873.23	2861.32	2862.96		2861.51	2873.23	2861.32	2862.96		0	0.207	5.91		0
	8/20/18	2853.93	2859.76	2850.62	2857.05		2853.93	2859.76	2850.62	2857.05		0	0.243	6.92		0
	8/17/18	2838.32	2855.63	2833.73	2850.13		2838.32	2855.63	2833.73	2850.13		0	0.332	9.44		0
	8/16/18	2831.44	2850.49	2831.44	2840.69		2831.44	2850.49	2831.44	2840.69		0	0.792	22.32		0
	8/15/18	2827.95	2827.95	2802.49	2818.37		2827.95	2827.95	2802.49	2818.37		0	-0.76	-21.59		0
	8/14/18	2827.88	2843.11	2826.58	2839.96		2827.88	2843.11	2826.58	2839.96		0	0.639	18.03		0
	8/13/18	2835.46	2843.4	2819.88	2821.93		2835.46	2843.4	2819.88	2821.93		0	-0.401	-11.35		0
	8/10/18	2839.64	2842.2	2825.81	2833.28		2839.64	2842.2	2825.81	2833.28		0	-0.711	-20.3		0
	8/9/18	2857.19	2862.48	2851.98	2853.58		2857.19	2862.48	2851.98	2853.58		0	-0.144	-4.12		0
	8/8/18	2856.79	2862.44	2853.09	2857.7		2856.79	2862.44	2853.09	2857.7		0	-0.026	-0.75		0
	8/7/18	2855.92	2863.43	2855.92	2858.45		2855.92	2863.43	2855.92	2858.45		0	0.282	8.05		0
	8/6/18	2840.29	2853.29	2835.98	2850.4		2840.29	2853.29	2835.98	2850.4		0	0.354	10.05		0
	8/3/18	2829.62	2840.38	2827.37	2840.35		2829.62	2840.38	2827.37	2840.35		0	0.464	13.13		0
	8/2/18	2800.48	2829.91	2796.34	2827.22		2800.48	2829.91	2796.34	2827.22		0	0.493	13.86		0
	8/1/18	2821.17	2825.83	2805.85	2813.36		2821.17	2825.83	2805.85	2813.36		0	-0.104	-2.93		0
	7/31/18	2809.73	2824.46	2808.06	2816.29		2809.73	2824.46	2808.06	2816.29		0	0.488	13.69		0
	7/30/18	2819	2821.74	2798.11	2802.6		2819	2821.74	2798.11	2802.6		0	-0.575	-16.22		0
	7/27/18	2842.35	2843.17	2808.34	2818.82		2842.35	2843.17	2808.34	2818.82		0	-0.656	-18.62		0
	7/26/18	2835.49	2845.57	2835.26	2837.44		2835.49	2845.57	2835.26	2837.44		0	-0.303	-8.63		0
	7/25/18	2817.73	2848.03	2817.73	2846.07		2817.73	2848.03	2817.73	2846.07		0	0.91	25.67		0
	7/24/18	2820.68	2829.99	2811.12	2820.4		2820.68	2829.99	2811.12	2820.4		0	0.478	13.42		0
	7/23/18	2799.17	2808.61	2795.14	2806.98		2799.17	2808.61	2795.14	2806.98		0	0.184	5.15		0
	7/20/18	2804.55	2809.7	2800.01	2801.83		2804.55	2809.7	2800.01	2801.83		0	-0.095	-2.66		0
	7/19/18	2809.37	2812.05	2799.77	2804.49		2809.37	2812.05	2799.77	2804.49		0	-0.395	-11.13		0
	7/18/18	2811.35	2816.76	2805.89	2815.62		2811.35	2816.76	2805.89	2815.62		0	0.216	6.07		0
	7/17/18	2789.34	2814.19	2789.24	2809.55		2789.34	2814.19	2789.24	2809.55		0	0.397	11.12		0
	7/16/18	2801.43	2803.71	2793.39	2798.43		2801.43	2803.71	2793.39	2798.43		0	-0.103	-2.88		0
	7/13/18	2796.93	2804.53	2791.69	2801.31		2796.93	2804.53	2791.69	2801.31		0	0.108	3.02		0
	7/12/18	2783.14	2799.22	2781.53	2798.29		2783.14	2799.22	2781.53	2798.29		0	0.875	24.27		0
	7/11/18	2779.82	2785.91	2770.77	2774.02		2779.82	2785.91	2770.77	2774.02		0	-0.709	-19.82		0
	7/10/18	2788.56	2795.58	2786.24	2793.84		2788.56	2795.58	2786.24	2793.84		0	0.347	9.67		0
	7/9/18	2768.51	2784.65	2768.51	2784.17		2768.51	2784.65	2768.51	2784.17		0	0.882	24.35		0
	7/6/18	2737.68	2764.41	2733.52	2759.82		2737.68	2764.41	2733.52	2759.82		0	0.848	23.21		0
	7/5/18	2724.19	2737.83	2716.02	2736.61		2724.19	2737.83	2716.02	2736.61		0	0.862	23.39		0
	7/3/18	2733.27	2736.58	2711.16	2713.22		2733.27	2736.58	2711.16	2713.22		0	-0.495	-13.49		0
	7/2/18	2704.95	2727.26	2698.95	2726.71		2704.95	2727.26	2698.95	2726.71		0	0.307	8.34		0
	6/29/18	2727.13	2743.26	2718.03	2718.37		2727.13	2743.26	2718.03	2718.37		0	0.076	2.06		0
	6/28/18	2698.69	2724.34	2691.99	2716.31		2698.69	2724.34	2691.99	2716.31		0	0.618	16.68		0
	6/27/18	2728.45	2746.09	2699.38	2699.63		2728.45	2746.09	2699.38	2699.63		0	-0.86	-23.43		0
	6/26/18	2722.12	2732.91	2715.6	2723.06		2722.12	2732.91	2715.6	2723.06		0	0.22	5.99		0
	6/25/18	2742.94	2742.94	2698.67	2717.07		2742.94	2742.94	2698.67	2717.07		0	-1.372	-37.81		0
	6/22/18	2760.79	2764.17	2752.68	2754.88		2760.79	2764.17	2752.68	2754.88		0	0.186	5.12		0
	6/21/18	2769.28	2769.28	2744.39	2749.76		2769.28	2769.28	2744.39	2749.76		0	-0.635	-17.56		0
	6/20/18	2769.73	2774.86	2763.91	2767.32		2769.73	2774.86	2763.91	2767.32		0	0.171	4.73		0
	6/19/18	2752.01	2765.05	2743.19	2762.59		2752.01	2765.05	2743.19	2762.59		0	-0.402	-11.16		0
	6/18/18	2765.79	2774.99	2757.12	2773.75		2765.79	2774.99	2757.12	2773.75		0	-0.213	-5.91		0
	6/15/18	2777.78	2782.81	2761.73	2779.66		2777.78	2782.81	2761.73	2779.66		0	-0.102	-2.83		0
	6/14/18	2783.21	2789.06	2776.52	2782.49		2783.21	2789.06	2776.52	2782.49		0	0.247	6.86		0
	6/13/18	2787.94	2791.47	2774.65	2775.63		2787.94	2791.47	2774.65	2775.63		0	-0.403	-11.22		0
	6/12/18	2785.6	2789.8	2778.78	2786.85		2785.6	2789.8	2778.78	2786.85		0	0.174	4.85		0
	6/11/18	2780.18	2790.21	2780.17	2782		2780.18	2790.21	2780.17	2782		0	0.107	2.97		0
	6/8/18	2765.84	2779.39	2763.59	2779.03		2765.84	2779.39	2763.59	2779.03		0	0.313	8.66		0
	6/7/18	2774.84	2779.9	2760.16	2770.37		2774.84	2779.9	2760.16	2770.37		0	-0.071	-1.98		0
	6/6/18	2753.25	2772.39	2748.46	2772.35		2753.25	2772.39	2748.46	2772.35		0	0.857	23.55		0
	6/5/18	2748.46	2752.61	2739.51	2748.8		2748.46	2752.61	2739.51	2748.8		0	0.07	1.93		0
	6/4/18	2741.67	2749.16	2740.54	2746.87		2741.67	2749.16	2740.54	2746.87		0	0.448	12.25		0
	6/1/18	2718.7	2736.93	2718.7	2734.62		2718.7	2736.93	2718.7	2734.62		0	1.085	29.35		0
	5/31/18	2720.98	2722.5	2700.68	2705.27		2720.98	2722.5	2700.68	2705.27		0	-0.688	-18.74		0
	5/30/18	2702.43	2729.34	2702.43	2724.01		2702.43	2729.34	2702.43	2724.01		0	1.27	34.15		0
	5/29/18	2705.11	2710.67	2676.81	2689.86		2705.11	2710.67	2676.81	2689.86		0	-1.156	-31.47		0
	5/25/18	2723.6	2727.36	2714.99	2721.33		2723.6	2727.36	2714.99	2721.33		0	-0.236	-6.43		0
	5/24/18	2730.94	2731.97	2707.38	2727.76		2730.94	2731.97	2707.38	2727.76		0	-0.202	-5.53		0
	5/23/18	2713.98	2733.33	2709.54	2733.29		2713.98	2733.33	2709.54	2733.29		0	0.325	8.85		0
	5/22/18	2738.34	2742.24	2721.88	2724.44		2738.34	2742.24	2721.88	2724.44		0	-0.314	-8.57		0
	5/21/18	2725.95	2739.19	2725.7	2733.01		2725.95	2739.19	2725.7	2733.01		0	0.739	20.04		0
	5/18/18	2717.35	2719.5	2709.18	2712.97		2717.35	2719.5	2709.18	2712.97		0	-0.263	-7.16		0
	5/17/18	2719.71	2731.96	2711.36	2720.13		2719.71	2731.96	2711.36	2720.13		0	-0.086	-2.33		0
	5/16/18	2712.62	2727.76	2712.17	2722.46		2712.62	2727.76	2712.17	2722.46		0	0.406	11.01		0
	5/15/18	2718.59	2718.59	2701.91	2711.45		2718.59	2718.59	2701.91	2711.45		0	-0.684	-18.68		0
	5/14/18	2733.37	2742.1	2725.47	2730.13		2733.37	2742.1	2725.47	2730.13		0	0.088	2.41		0
	5/11/18	2722.7	2732.86	2717.45	2727.72		2722.7	2732.86	2717.45	2727.72		0	0.171	4.65		0
	5/10/18	2705.02	2726.11	2704.54	2723.07		2705.02	2726.11	2704.54	2723.07		0	0.937	25.28		0
	5/9/18	2678.12	2701.27	2674.14	2697.79		2678.12	2701.27	2674.14	2697.79		0	0.968	25.87		0
	5/8/18	2670.26	2676.34	2655.2	2671.92		2670.26	2676.34	2655.2	2671.92		0	-0.027	-0.71		0
	5/7/18	2669.36	2683.35	2664.7	2672.63		2669.36	2683.35	2664.7	2672.63		0	0.346	9.21		0
	5/4/18	2621.45	2670.93	2615.32	2663.42		2621.45	2670.93	2615.32	2663.42		0	1.281	33.69		0
	5/3/18	2628.08	2637.14	2594.62	2629.73		2628.08	2637.14	2594.62	2629.73		0	-0.225	-5.94		0
	5/2/18	2654.24	2660.87	2631.7	2635.67		2654.24	2660.87	2631.7	2635.67		0	-0.721	-19.13		0
	5/1/18	2643.64	2655.27	2625.41	2654.8		2643.64	2655.27	2625.41	2654.8		0	0.255	6.75		0
	4/30/18	2675.05	2682.92	2648.04	2648.05		2675.05	2682.92	2648.04	2648.05		0	-0.819	-21.86		0
	4/27/18	2675.47	2677.35	2659.01	2669.91		2675.47	2677.35	2659.01	2669.91		0	0.111	2.97		0
	4/26/18	2651.65	2676.48	2647.16	2666.94		2651.65	2676.48	2647.16	2666.94		0	1.043	27.54		0
	4/25/18	2634.92	2645.3	2612.67	2639.4		2634.92	2645.3	2612.67	2639.4		0	0.184	4.84		0
	4/24/18	2680.8	2683.55	2617.32	2634.56		2680.8	2683.55	2617.32	2634.56		0	-1.338	-35.73		0
	4/23/18	2675.4	2682.86	2657.99	2670.29		2675.4	2682.86	2657.99	2670.29		0	0.006	0.15		0
	4/20/18	2692.56	2693.94	2660.61	2670.14		2692.56	2693.94	2660.61	2670.14		0	-0.854	-22.99		0
	4/19/18	2701.16	2702.84	2681.9	2693.13		2701.16	2702.84	2681.9	2693.13		0	-0.573	-15.51		0
	4/18/18	2710.11	2717.49	2703.63	2708.64		2710.11	2717.49	2703.63	2708.64		0	0.083	2.25		0
	4/17/18	2692.74	2713.34	2692.05	2706.39		2692.74	2713.34	2692.05	2706.39		0	1.066	28.55		0
	4/16/18	2670.1	2686.49	2665.16	2677.84		2670.1	2686.49	2665.16	2677.84		0	0.811	21.54		0
	4/13/18	2676.9	2680.26	2645.05	2656.3		2676.9	2680.26	2645.05	2656.3		0	-0.289	-7.69		0
	4/12/18	2653.83	2674.72	2653.83	2663.99		2653.83	2674.72	2653.83	2663.99		0	0.825	21.8		0
	4/11/18	2643.89	2661.43	2639.25	2642.19		2643.89	2661.43	2639.25	2642.19		0	-0.553	-14.68		0
	4/10/18	2638.41	2665.45	2635.78	2656.87		2638.41	2665.45	2635.78	2656.87		0	1.673	43.71		0
	4/9/18	2617.18	2653.55	2610.79	2613.16		2617.18	2653.55	2610.79	2613.16		0	0.334	8.69		0
	4/6/18	2645.82	2656.88	2586.27	2604.47		2645.82	2656.88	2586.27	2604.47		0	-2.192	-58.37		0
	4/5/18	2657.36	2672.08	2649.58	2662.84		2657.36	2672.08	2649.58	2662.84		0	0.686	18.15		0
	4/4/18	2584.04	2649.86	2573.61	2644.69		2584.04	2649.86	2573.61	2644.69		0	1.157	30.24		0
	4/3/18	2592.17	2619.14	2575.49	2614.45		2592.17	2619.14	2575.49	2614.45		0	1.261	32.57		0
	4/2/18	2633.45	2638.3	2553.8	2581.88		2633.45	2638.3	2553.8	2581.

Graded Home Work #1 FIN 352 Investments, Fall 2019 Dr. ZarBabal Do everything in Excel, and upload your Excel spreadsheet to blackboard. Please ask a classmate if you are not sure how to upload the...

Answer To: Graded Home Work #1 FIN 352 Investments, Fall 2019 Dr. ZarBabal Do everything in Excel, and upload...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment

Sun	Mon	Tue	Wed	Thu	Fri	Sat
30	31	1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	1	2	3