Question: 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


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 "O" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.) Date Adj Close 3-Day Simple Moving Average Buy/Sell Signal 3-Day Exponential Moving Average Buy/Sell Signal Signal Comparison 3/25/2019 3/26/2019 25,517.00 25,657.90 25,625.76 3/27/2019 3/28/2019 25,717.63 25,928.85 3/29/2019 4/1/2019 4/2/2019 4/3/2019 26,258.59 26,179.30 26,218.30 26,384.80 26,425.16 4/4/2019 4/5/2019 4/8/2019 26,341.19 4/9/2019 26,150.75 26,157.33 4/10/2019 4/11/2019 26,143.22 4/12/2019 26,412.47
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
