A	20160101	41.81	41.81	41.81	41.81	0
A	20160104	41.06	41.19	40.34	40.69	3287300
A	20160105	40.73	40.95	40.34	40.55	2587200
A	20160106	40.24	40.99	40.05	40.73	2103600
A	20160107	40.14	40.15	38.81	39	3504300
A	20160108	39.22	39.71	38.47	38.59	3736700
A	20160111	38.71	38.9	37.41	37.94	2818600
A	20160112	38.43	38.58	37.65	38.19	1989300

Please write a script that completes the 4 steps above (the answer should produce a chart similar to the one shown above)

Language: Visual Basic (excel)

Create a script that will loop through all the stocks for one year and output the following information: o The ticker symbol. Yearly change from opening price at the beginning of a given year to the closing price at the end of that year. o The percent change from opening price at the beginning of a given year to the closing price at the end of that year. The total stock volume of the stock. You should also have conditional formatting that will highlight positive change in green and negative change in red. The result should look as follows: 20140101 57.19 57.19 57.19 57.19 0 20140102 57.1 57.1 56.15 56.21 1916100 20140103 56.39 57.35 56.26 56.92 1866600 20140106 57.4 57.7 56.56 56.64 1777400 20140107 56.95 57.63 56.93 57.45 1463200 20140108 57.33 58.54 57.17 58.39 2659400 20140109 58.4 58.68 57.87 58.41 1757600 20140110 58.51 59.01 58.14 58.93 1623300 20140113 58.77 59.1 58.6 58.93 2946700 20140114 59.16 59.95 59.02 59.88 2562200 20140115 59.82 60.37 59.59 60.34 2335100 Ticker A AA AA-B AAC AAN AAV AB ABB ABBV Yearly Chang Percent Char Total Stock Volume -16.25 -28.41% 572978100 15.48 48.54% 5161412000 1.34 2.73% 21618200 10.92 54.60% 9789700 1.17 3.98% 237929300 48.6 43.91% 200376400 8.38 26.66% 40207800 0.45 10.37% 86658700 4.49 21.04% 83051600 -5.41 -20.37% 466820000 12.63 23.92% 2303237600