old Investment Tracker template
Posted: Wed Jun 22, 2005 1:02 pmOn a lark I opened the Investment Tracker template (this is a ClarisWorks 5-vintage template). It does a good job at demonstrating the interaction of your spreadsheet data and the program's graphing capabilities.
After entering some real data, I noticed that the formula for "Annual Return (%)" contains a typographical error (and consequently, a Math error, too). Here's the formula as it is given:
=IF(ISERROR((N9/H9)*((J9-D9)/365)),0,(N9/H9)*((J9-D9)/365))
It is apparently intended to give a really simplified annual rate of return (it calculates the overall return rate, then tries to adjust that to an annual rate) -- but it won't. The two "*"s (multiplication operators) in the formula should be "/"s (division operators).
If anybody uses the template, here's the corrected formula for the first line of user data:
=IF(ISERROR((N9/H9)/((J9-D9)/365)),0,(N9/H9)/((J9-D9)/365))
Make your correction in cell P9, then fill down to correct the rest of the column.
John@was
After entering some real data, I noticed that the formula for "Annual Return (%)" contains a typographical error (and consequently, a Math error, too). Here's the formula as it is given:
=IF(ISERROR((N9/H9)*((J9-D9)/365)),0,(N9/H9)*((J9-D9)/365))
It is apparently intended to give a really simplified annual rate of return (it calculates the overall return rate, then tries to adjust that to an annual rate) -- but it won't. The two "*"s (multiplication operators) in the formula should be "/"s (division operators).
If anybody uses the template, here's the corrected formula for the first line of user data:
=IF(ISERROR((N9/H9)/((J9-D9)/365)),0,(N9/H9)/((J9-D9)/365))
Make your correction in cell P9, then fill down to correct the rest of the column.
John@was