Question: From the data below, calculate the three - day simple moving average. Fill in the Buy or Sell Signal column for this trading indicator. Then,

From the data below, calculate the three-day simple moving average. Fill in the Buy or Sell Signal column for this trading indicator. Then, calculate the three-day exponential moving average and fill in the Buy or 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? 11
8.33 points
From the data below, calculate the three-day simple moving average. Fill in the "Buy or Sell Signal" column for this trading indicator. Then, calculate the three-day exponential moving average and fill in the "Buy or Sell Signal" column for this trading indicator. Assume that the current closing price will receive 45 of the weight in the exponential moving average. Finally, fill in the "Signal Comparison" column. On which days do the signals disagree?
Note: Leave no cells blank - be certain to enter "O" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.
\table[[Date,\table[[Adjusted],[Close]],\table[[3-Day Simple],[Moving],[Average]],\table[[Buy or Sell],[Signal]],\table[[3-Day],[Exponential],[Moving],[Average]],\table[[Buy or Sell],[Signal]],\table[[Signal],[Comparison]]],[1/24/2022,36,070.61,,,,,],[1/25/2022,36,186.64,,,,,],[1/26/2022,36,520.82,,,,,],[1/27/2022,36,261.75,,,,,],[1/28/2022,36,135.24,,,,,],[1/31/2022,36,691.17,,,,,],[2/1/2022,37,151.47,,,,,],[2/2/2022,37,378.19,,,,,],[2/3/2022,37,520.08,,,,,],[2/4/2022,37,095.74,,,,,],[2/7/2022,37,108.38,,,,,],[2/8/2022,37,160.68,,,,,],[2/9/2022,37,614.90,,,,,],[2/10/2022,37,630.81,,,,,],[2/11/2022,37,267.89,,,,,]]
Note: Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.
 From the data below, calculate the three-day simple moving average. Fill

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!