Problem 8-17 Bollinger Bands (LO4, CFA1) From the data below for Apple (AAPL) stock, calculate the upper and lower Bollinger bands, which represent plus (or minus) two standard deviations of the 20-day simple moving average added (subtracted) from the 20-day simple moving average. If the daily price approaches or exceeds the upper Bollinger band, traders will look for a continued upward movement in the stock price. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Date AAPL Close Lower Bollinger Band Upper Bollinger Band Standard Deviation of 20-Day Simple Moving Average 20-Day Moving Average 180.90 3.42 181.52 3.62 3/26/2019 186.81 3/27/2019 188.49 3/28/2019 188.74 182.20 3.82 3/29/2019 189.97 182.98 4.02 4/1/2019 191.26 183.73 4.22 4/2/2019 194.04 184.50 4.41 4/3/2019 195.37 185.42 4.59 4/4/2019 195.71 186.47 4.74 4/5/2019 187.63 4.88 197.02 200.12 4/8/2019 188.83 5.01 4/9/2019 199.52 189.89 5.12 4/10/2019 200.64 190.82 5.21 4/11/2019 198.97 191.76 5.27 4/12/2019 198.89 192.53 5.29 Problem 8-17 Bollinger Bands (LO4, CFA1) From the data below for Apple (AAPL) stock, calculate the upper and lower Bollinger bands, which represent plus (or minus) two standard deviations of the 20-day simple moving average added (subtracted) from the 20-day simple moving average. If the daily price approaches or exceeds the upper Bollinger band, traders will look for a continued upward movement in the stock price. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Date AAPL Close Lower Bollinger Band Upper Bollinger Band Standard Deviation of 20-Day Simple Moving Average 20-Day Moving Average 180.90 3.42 181.52 3.62 3/26/2019 186.81 3/27/2019 188.49 3/28/2019 188.74 182.20 3.82 3/29/2019 189.97 182.98 4.02 4/1/2019 191.26 183.73 4.22 4/2/2019 194.04 184.50 4.41 4/3/2019 195.37 185.42 4.59 4/4/2019 195.71 186.47 4.74 4/5/2019 187.63 4.88 197.02 200.12 4/8/2019 188.83 5.01 4/9/2019 199.52 189.89 5.12 4/10/2019 200.64 190.82 5.21 4/11/2019 198.97 191.76 5.27 4/12/2019 198.89 192.53 5.29