Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
★★★★★
3.41 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
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...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