Scribd Logo
Upload

Welcome to Scribd!

  • 47 views

    Moving Average Solution: Strictly Confidential

    Uploaded by

    C.E.O Annie

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Moving Average Solution: Strictly Confidential

    Uploaded by

    C.E.O Annie
    47 views3 pages

    Original Title

    Moving Average Solution

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    47 views3 pages

    Moving Average Solution: Strictly Confidential

    Uploaded by

    C.E.O Annie

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 3

    Moving Average Solution Strictly Confidential

    Table of Contents
    #VALUE!

    Notes
    This Excel model is for educational purposes only and should not be used for any other reason.
    All content is Copyright material of CFI Education Inc.
    https://corporatefinanceinstitute.com/

    © 2019 CFI Education Inc.


    All rights reserved.  The contents of this publication, including but not limited to all written material, content layout, images, formulas, and code, are protected under international copyright and trademark laws.  
    No part of this publication may be modified, manipulated, reproduced, distributed, or transmitted in any form by any means, including photocopying, recording, or other electronic or mechanical methods,
    © Corporate Finance Institute. All rights reserved. 
    Moving Average Solution
    Below are the closing prices for Google, from oldest to the most recent.
    1. Calculate a 5 day moving average and 5 day weighted moving average.
    2. Plot the raw data, and both your moving averages on a line graph to compare.

    Day Closing price 5 Day MA 5 Day WMA


    1 609.07 Clos
    2 613.5 650.00
    3 616.44
    640.00
    4 614.21
    5 616.01 613.85 614.82 630.00
    6 616.87 615.41 615.83
    620.00
    7 616.69 616.04 616.25
    8 624.18 617.59 618.97 610.00
    9 639.63 622.68 626.31
    600.00
    10 631.75 625.82 629.34
    590.00
    11 626.77 627.80 629.65
    12 611.83 626.83 624.33 580.00
    13 611.08 624.21 619.08 1 2 3 4 5 6
    14 619.91 620.27 617.64
    Closing pric
    15 616.5 617.22 616.39
    16 616.79 615.22 616.24
    17 600.99 613.05 611.50
    18 600.36 610.91 607.27
    19 611.04 609.14 607.31
    20 612 608.24 608.27
    Closing Price of Google
    650.00

    640.00

    630.00

    620.00

    610.00

    600.00

    590.00

    580.00
    1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

    Closing price 5 Day MA 5 Day WMA

    You might also like