Results 1 to 12 of 12

Sensitivity analysis issue

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2014
    Location
    Chicago
    MS-Off Ver
    2010
    Posts
    9

    Sensitivity analysis issue

    Hi,

    I'm trying to do a sensitivity analysis of historical S&P Prices. Basically I'm trying to find the Max, Min, and Avg of historical prices via financial quarter. I've set up my sheet with individual dates dates since 9/2/1989 in the first column and all of the closing prices in the next column, along with columns for min, max, and avg to store the results.

    Basically the trouble I've been having is I'm not sure how to segment the dates into financial quarters and only find the max, min, and avg of just those dates. For example between 6/1/1989-9/31/1989 I can find the S&P closed at its highest of $377.73. I can't, however, find a formula that I can pull through the entire list, that will find the max, min, and avg for the quarters that follow it.

    Any help that could be offered would be greatly appreciated. Thanks
    Last edited by culpepper; 11-12-2014 at 11:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro coding help (i have no background in coding)
    By notgoodenough in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2014, 10:22 PM
  2. [SOLVED] Vb macro coding for transpose - complete coding?
    By Dharani Suresh in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 08-02-2013, 11:16 PM
  3. [SOLVED] Vb macro coding for transpose - complete coding?
    By Dharani Suresh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-02-2013, 05:04 AM
  4. [SOLVED] CheckBox coding to work with ComboBox coding
    By JimExcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2013, 12:23 PM
  5. [SOLVED] Implant macro coding into ASP coding
    By Sam yong in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-15-2005, 06:05 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