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 Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
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 Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education