• Got to be a better way. (Excel 2003)

    Author
    Topic
    #435781

    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.

    Viewing 0 reply threads
    Author
    Replies
    • #1030955

      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.

      • #1031064

        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

    Viewing 0 reply threads
    Reply To: Got to be a better way. (Excel 2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: