2 Replies Latest reply on Jan 16, 2017 6:36 AM by Cosimo Mercuro Branched to a new discussion.

    Calculate Monthly Return

    Cosimo Mercuro

      I need to calculate Monthly Returns using this algorithm:

       

      MonthsValuesMonthly Return
      Jan10
      Feb8- 25 %
      Mar11+ 37,5 %
      Apr13+ 18,2 %
      ..............

       

      Monthly Return (month i) = (Value (month i) - Value (month i - 1) ) / Value (month i - 1)

       

      In other words, Monthly returnn of - i.e. - Febraury is equal to = (Value Feb - Value Jan) / Value Jan

      An this for an undefinied number of rows...

      Any idea?

      Thanks in advance