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 Adj Close 3-Day Simple Moving Average Buy/Sell Signal 3-Day Exponential Moving Average Buy/Sell Signal Signal Comparison 3/25/2019 25,516.99           3/26/2019 25,657.89           3/27/2019 25,625.75           3/28/2019 25,717.62           3/29/2019 25,928.84           4/1/2019 26,258.58           4/2/2019 26,179.29           4/3/2019 26,218.29           4/4/2019 26,384.79           4/5/2019 26,425.15           4/8/2019 26,341.18           4/9/2019 26,150.74           4/10/2019 26,157.32           4/11/2019 26,143.21           4/12/2019 26,412.46

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter15: Decision Analysis
Section: Chapter Questions
Problem 4P: Investment advisors estimated the stock market returns for four market segments: computers,...
icon
Related questions
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 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 Adj Close 3-Day Simple Moving Average Buy/Sell Signal 3-Day Exponential Moving Average Buy/Sell Signal Signal Comparison
3/25/2019 25,516.99          
3/26/2019 25,657.89          
3/27/2019 25,625.75          
3/28/2019 25,717.62          
3/29/2019 25,928.84          
4/1/2019 26,258.58          
4/2/2019 26,179.29          
4/3/2019 26,218.29          
4/4/2019 26,384.79          
4/5/2019 26,425.15          
4/8/2019 26,341.18          
4/9/2019 26,150.74          
4/10/2019 26,157.32          
4/11/2019 26,143.21          
4/12/2019 26,412.46          
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Biases
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
International Financial Management
International Financial Management
Finance
ISBN:
9780357130698
Author:
Madura
Publisher:
Cengage