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.