Closed Thread
Results 1 to 2 of 2

how to calculate daily return to monthly return

  1. #1
    Registered User
    Join Date
    05-27-2010
    Location
    auckland
    MS-Off Ver
    Excel 2007
    Posts
    12

    how to calculate daily return to monthly return

    I'm doing stock market return analysis, I have daily return data from Global financial data website. please help me on how to calculate monthly return. thank you so much

    11/02/2009 0.009282884
    11/03/2009 -0.014798372
    11/04/2009 0.019949162
    11/05/2009 0.008045049
    11/06/2009 -0.00204121
    11/09/2009 0.019581353
    11/10/2009 -0.003404769
    11/11/2009 0.009231566
    11/12/2009 -0.001626447
    11/13/2009 0.002208123
    11/16/2009 0.013195577
    11/17/2009 -0.007944259
    11/18/2009 -0.001380169
    11/19/2009 -0.019815696
    11/20/2009 -0.012904153
    11/23/2009 0.021237329
    11/24/2009 -0.009774965
    11/25/2009 0.000422558
    11/26/2009 -0.034065228
    11/27/2009 0.012340417
    11/30/2009 -0.011412341
    12/01/2009 0.026111178
    12/02/2009 0.001243293
    12/03/2009 0.001519818
    12/04/2009 0.010597264
    12/07/2009 -0.004311544
    12/08/2009 -0.015554287
    12/09/2009 -0.007395742
    12/10/2009 0.005335194
    12/11/2009 0.002208201
    12/14/2009 0.009948576
    12/15/2009 -0.000830589
    12/16/2009 0.010964916
    12/17/2009 -0.007923578
    12/18/2009 -0.009372816
    12/21/2009 0.010894407
    12/22/2009 0.009617938
    12/23/2009 0.00503862
    12/28/2009 0.008172814
    12/29/2009 0.00299621
    12/30/2009 -0.003785131
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: how to calculate daily return to monthly return

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1