+ Reply to Thread
Results 1 to 2 of 2

Average by date

  1. #1
    Registered User
    Join Date
    03-22-2022
    Location
    asdf
    MS-Off Ver
    11
    Posts
    1

    Average by date

    We have an assignment. It says:
    MOMt =(Pt-1/Pt-12)-1.
    In each month t, calculate the average return of the 8 stocks that had the highest momentum in the previous month (MOMt-1).

    Therefore we have to calculate the average of the return, which can be derived (column c). But before that we have to identify the in which row/stock the highest momentum was for t-1 (column d). Is there a series of formulas to give output in a single cell?

    According to me, this becomes possible from row 230 and further since 12 months have past.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Average by date

    We do not do your homework for you. If you have made progress and have a specific question about an Excel feature that is giving you trouble, we are happy to help. But please do not post your assignment and ask us to complete it for you, tell you how to get started, or advise what approach to take. That is what you are supposed to be learning in your class.

    Also we frown on giving your location as "asdf".
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Merge All of Dates as one Date and Take Average of the Values of the Date
    By gozparlak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-22-2017, 03:00 AM
  2. [SOLVED] Sumproduct formula, add up by date, average by date
    By 3smees23 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-08-2017, 05:00 PM
  3. Month to Date and Quarter to Date Average from Daily data
    By asvanthi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2014, 07:10 AM
  4. [SOLVED] Need average of days for date values from date to current day that updates current date
    By FinGhost in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-12-2013, 04:41 PM
  5. Date and row average
    By cnunley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-2013, 11:58 AM
  6. Compare average before a date to the average after the date
    By stephanbrown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2012, 05:10 PM
  7. [SOLVED] Formula to find a date range and date average
    By 1Monkey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2012, 11:51 AM

Tags for this Thread

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