Results 1 to 3 of 3

Sum of stock returns with date constraint

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Danmark
    MS-Off Ver
    Excel 2010
    Posts
    10

    Sum of stock returns with date constraint

    Dear Excelforum

    I am about to creat momentum porfolios and need help to sum daily returns for each stock in the months t-12 to t-1. For example the cell january 01 2009 should sum the returns for the first trading day january 2008 to the last trading day novemer 2008, thereafter I want to roll this function so, do the same for the next month, first trading day february 2009 should sum the returns for first trading day february 2008 to last trading day december 2008.

    I have tried with an if formula but I am not sure how to set the constraints.

    Please see attached for example data.

    I am very grateful for your help!

    /Fransden
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-24-2013, 08:53 PM
  2. Replies: 4
    Last Post: 01-29-2013, 02:26 AM
  3. Replies: 0
    Last Post: 10-28-2012, 07:22 AM
  4. Replies: 1
    Last Post: 09-28-2012, 08:52 AM
  5. how to calcualte stock log returns
    By jayantrk2004 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-27-2012, 04:29 AM

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