YOU are planning to invest your $100,000 savings in any stock for a year. Which stock will be the best option for your investment and what would be your return on an investment after a year. Please exclude AMAZON STOCK and perform your analysis on any five except AMAZON. Submit your work in the word document.

Please select only five stocks and choose the best based on forecasting. The 10 years data of stocks are given in the ZIP file.

Instructions: Choose any five stocks data (excluding amazon) from the Zip Folder (top of the page)

(1) Do the trend analysis and forecasting of each for the next 365 days

(2) Import results and analysis in the word document.

(3) Compare each stock future based on your forecasting

(3) Make your decision which would be the best stock to invest your fortune $100,000.

Date. Open High. Low CLose VOlume Name

12/4/17	136.42	137.95	135.81	136.36	2187969	TRV
12/5/17	135.62	137.25	135.12	135.32	1464026	TRV
12/6/17	135.72	136.15	135.11	135.36	1044778	TRV
12/7/17	134.8	135.14	133.95	134.21	1081234	TRV
12/8/17	133.76	133.81	132.81	133.75	1085281	TRV
12/11/17	133.92	133.99	132.54	133.16	1068738	TRV
12/12/17	134.35	134.6	132.76	134.35	1405529	TRV
12/13/17	134.37	134.37	133.22	133.56	1328622	TRV
12/14/17	134	134.17	131.85	132.58	1278685	TRV
12/15/17	133.23	135.34	132.91	134.89	3170654	TRV
12/18/17	135.6	137.29	134.69	135.21	1692799	TRV
12/19/17	136.01	136.61	134.93	135.54	1393041	TRV
12/20/17	136.45	136.45	134.8	135.26	1070160	TRV
12/21/17	135.88	136.2	131.44	134.44	937446	TRV
12/22/17	134.7	134.86	133.91	134.39	879374	TRV
12/26/17	134.9	135.61	134.16	134.78	564742	TRV
12/27/17	134.93	135.14	134.29	134.77	945416	TRV
12/28/17	135.25	135.7	134.79	135.66	698740	TRV
12/29/17	136.02	136.49	135.28	135.64	827560	TRV