Answered step by step
Verified Expert Solution
Question
1 Approved Answer
**Ignore values in the cell boxes** Please show calculation and explanation Check my work 11 From the data below for the Dow Jones Industrial Average,
**Ignore values in the cell boxes** Please show calculation and explanation
Check my work 11 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.) 5 points Date Adj Close 3-Day Simple Moving Average Buy/Sell Signal Signal Comparison eBook Print 3/25/2019 References 3/26/2019 3/27/2019 3/28/2019 3/29/2019 25,516.98 25,657.88 25,625.74 25,717.61 25,928.83 26,258.57 26,179.28 Agree Agree Agree Agree Disagree 4/1/2019 3-Day Exponential Buy/Sell Moving Signal Average 0.00 0.00 25,600.20 Buy 25,694.13 Buy 25,881.89 Buy 26,183.23 Buy 26,180.07 Sell 26,210.64 Buy 26,349.95 Buy 26,410.10 Buy 26,354.96 Sell 26,191.58 Sell 26,164.18 Sell 26,147.39 Sell 26,359.44 Buy 4/2/2019 4/3/2019 4/4/2019 0.00 0.00 25,600.20 Buy 25,667.08 Buy 25,757.39 Buy 25,968.34 Buy 26,122.23 Buy 26,218.71 Sell 26,260.78 (Buy 26,342.73 Buy 26,383.70 Sell 26,305.68 Sell 26,216.40 Sell 26,150.41 Sell 26,237.65 Buy 26,218.28 Disagree 4/5/2019 4/8/2019 4/9/2019 26,384.78 26,425.14 26,341.17 26,150.73 26,157.31 26,143.20 26,412.45 Agree Agree Agree Agree Agree Agree Agree 4/10/2019 4/11/2019 4/12/2019Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started