From the data below for the Dow Jones Industrial Average, calculate the three-day simple moving average....

Transcribed Image Text:

From the data below for the Dow Jones Industrial Average, calculate the three-day simple moving average. Fill in the "Buy/Sell Signal" column for this trading Indicator. Then, calculate the three-day exponential moving average and fill in the "Buy/Sell Signal" column for this trading indicator. Assume that the current closing price will receive 4/5 of the weight in the exponential moving average. Finally, fill in the "Signal Comparison" column. On which days do the signals disagree? (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.) Date 3/25/2019 3/26/2019 3/27/2019 3/28/2019 3/29/2019 4/1/2019 4/2/2019 4/3/2019 4/4/2019 4/5/2019 4/8/2019 4/9/2019 4/10/2019 4/11/2019 4/12/2019 Adj Close 25,516.91 25,657.81 25,625.67 25,717.54 25,928.76 26,258.50 26,179.21 26,218.21 26,384.71 26,425.07 26,341.10 26,150.66 26,157.24 26,143.13 26,412.38 3-Day Simple Moving Average Buy/Sell Signal 3-Day Exponential Moving Average Buy/Sell Signal Signal Comparison From the data below for the Dow Jones Industrial Average, calculate the three-day simple moving average. Fill in the "Buy/Sell Signal" column for this trading Indicator. Then, calculate the three-day exponential moving average and fill in the "Buy/Sell Signal" column for this trading indicator. Assume that the current closing price will receive 4/5 of the weight in the exponential moving average. Finally, fill in the "Signal Comparison" column. On which days do the signals disagree? (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.) Date 3/25/2019 3/26/2019 3/27/2019 3/28/2019 3/29/2019 4/1/2019 4/2/2019 4/3/2019 4/4/2019 4/5/2019 4/8/2019 4/9/2019 4/10/2019 4/11/2019 4/12/2019 Adj Close 25,516.91 25,657.81 25,625.67 25,717.54 25,928.76 26,258.50 26,179.21 26,218.21 26,384.71 26,425.07 26,341.10 26,150.66 26,157.24 26,143.13 26,412.38 3-Day Simple Moving Average Buy/Sell Signal 3-Day Exponential Moving Average Buy/Sell Signal Signal Comparison

Answer rating: 100% (QA)

To calculate the threeday simple moving average SMA we need to sum the closing prices of the three previous days and divide the result by 3 The calcul... View the full answer