AnsweredAssumed Answered

Calculating Stock Index Returns

Question asked by scotty476_1 on Oct 29, 2012
Latest reply on Oct 29, 2012 by philmodjunk


Calculating Stock Index Returns




     I have a simple database with monthly stock market index returns for a variety of indexes. I have a table with the indexes and a child table with the index id and the start date (8/31/2012) and the end date (9/30/12) and a return figure 2.58%.  I would like to calculate a geometric mean for different periods of time 3 months, 4 months, 1 year, 3 years, 5 years, 10 years, etc.

     I am a little lost how to go about doing this?


     Thanks for your help.