• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

Calculate 1 year return based on 12 monthly returns

I currently use Excel to get the 1 year return by using the product function by taking all the monthly returns for a mutual fund, adding 1 to each of them and multiplying all the values together like =(A1*A2*A3.....*A12 )-1

I have looked all over in Crystal for this function and I have had no luck, is there a way to do this?
0
wilpitz
Asked:
wilpitz
1 Solution
 
mlmccCommented:
Are you dealing with 1 record with 12 values or 1 record per month

1 record with 12 values
(1+{JanReturn}) * (1+{FebReturn}) * (1+{MarReturn}) * (1+{AprReturn}) * (1+{MayReturn}) * (1+{JunReturn}) * (1+{JulReturn}) * (1+{AugReturn}) * (1+{SepReturn}) * (1+{OctReturn}) * (1+{NovReturn}) * (1+{DecReturn})

If you have 1 record per month
Group by the stock or security
In the report header add a formula
WhilePrintingRecords;
Global NumberVar RateofReturn;
RateofReturn := 1;
""

In the group header add a formula
WhilePrintingRecords;
Global NumberVar RateofReturn;
RateofReturn := 1;
""

In the details add a formula
WhilePrintingRecords;
Global NumberVar RateofReturn;
RateofReturn := RateofReturn * (1 + {ReturnRateField});
""

In the group footer add a formula to display the retunr
WhilePrintingRecords;
Global NumberVar RateofReturn;
RateofReturn

mlmcc
0
 
wilpitzAuthor Commented:
That works GREAT!!!!!!!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now