Average Annual Return calcs are hosed

Dec 14, 2009 2 Replies

Hi all:



QD2007



I just noticed today that all the "Avg. Annual Return" figures in the portfolio view of my securities are showing up as "N/A."



Running an Investment Performance report on individual securities results in obvious problems: either there's an error report that flashes up reading that Quicken can't calculate the IRR and it will show up as N/A or, if the report completes, there's generally an error in the "End Mkt Val" of the security - a wild overstatement - that makes the Avg. Annual Return number clearly wrong.



Any thoughts about what's going on here?



TIA.



Tom Young


OK, I figured out the problem. Just recently I changed some savings accounts and CD's from the Cash Flow to the Investing group. It turns out that the wild overstatement of the ending balance of individual securities was because the balance in these accounts WAS BEING ADDED TO THE SECURITY'S ENDING VALUE! Unbelievable.

A Quicken bug.

Tom Young

I've been griping (to Intuit) about how Quicken cannot calculate percentages such as "average gain". Quicken uses its Internal Rate of Return (IRR) routine to handle all of these. The IRR calaculation requires the asset price on the first day and the last day plus one of the period in question. That's easy if you have held the security for a long time, just snatch the values out of the price history file. But what does it do if you ask for IRR for, say, a month and you have only owned the asset for that month? The price on last day +1 isn't in yet.

Quicken was faking it by using the price for a whole year. But I think that has changed. It's still not right as far as I can tell and I NEVER trust it.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required