Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Sep 2004
    Location
    Wolverhampton, Staffordshire, England
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Got to be a better way. (Excel 2003)

    Took a look at your sheets, looks complex so not entirely sure which part it is you want looking at, that's probably why no one has replied yet. Can you not do this:
    Have a cell to enter start period, a cell for end period (e,g 1, 4) then a button that would calculate, if you can do a cut-down version with only what you need calculating i can make you up an example with some code.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Got to be a better way. (Excel 2003)

    I agree with Danny. I looked at your sheet and an not even sure what you want calculated.

    Could you give a relevant sample of the spreadsheet with what the user will enter and what should be calculated from it.

    Steve

  3. #3
    New Lounger
    Join Date
    Sep 2006
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Got to be a better way. (Excel 2003)

    I am working with a fund return calculator that accounts for additions and subtractions to and from the fund over time. I would like to know what the return is for each period with out modifying the calculator for each time period. Example: I want the return for period 1, then period1-2, then period 1-3.....period 1-50. I am sure a macro could do all of those for me but I am sure a formula can be written to do it as well. I am stuck. Thanks.

    I am sorry I was not more clear. The data I am working with is quarterly data that the calculator refers to. I am trying get a "running total" cumulative return. For example I have modified the formulas and cell references of the Portfolio Life Calculator tab and created the tab named Annual Calculator. The Annual Calculator gives the return for the first 4 periods (4 quarters) of the funds life which is 19.4%. I would next like to calculate the return for the first 5 periods (5 quarters) without having to copy the calculator and change the formulas, insert rows, change cell references, etc. I was hoping to get a formula that I could just copy down a column that would give me that running cumulative total return. Another thing that might eliminate confusion is the input labeled Number of Days in period should be labeled Number of Periods. Thanks.

Posting Permissions

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