Puzzles of Finance: Six Practical Problems and Their Remarkable Solutions - Mark P. Kritzman - Google Livres

I have a simple database with monthly stock market index returns for a variety of indexes. 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.

And how do you define a month? Relationships can be set up to match to different sets of records by Stock ID and time interval, then a summary field that computes the average and that is defined in your child table can be referenced from the context of your parent table in order to compute the arithmatic mean.

How have foreign stocks historically fared? - CBS News

To compute a geometric mean can't be geometric stock market returns by year table with a summary field, nor a built in aggregate function. Shares stock market basics get the geometric mean would require an expression such as:.

Evaluate Substitute List ChildTable:: App Innovations Developer Conference Product Roadmap Product Documentation Examples and Tools Tech Briefs Videos.

Index Returns

Information Feedback Terms of Use. You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled.

Please turn JavaScript back on and reload this page. Please enter a title.

You can not post a blank message. Please type your message and try again.

Calculating Stock Index Returns. I am a little lost how to go about doing this? Thanks for your help.

I have the same question Show 0 Likes 0. This content has been marked as final.

Are the time intervals always the same? To get the geometric mean would require an expression such as: I looked up the info on this type of mean from Wikipedia. More Like This Retrieving data Home Top of page Help.