Investment Dashboard, Performance, and Returns IRR discrepancies... please explain?
Hi all,
I have an "Investment View" that I've added to by Home Dashboard set-up where I've included the "Returns" display item. However, while all my accounts are positive for the year and/or for all dates… I have 2 accounts that are showing negative IRR. This same data is duplicated when I bring up the "Returns By Account" report. However, if I bring up the "Investment Performance" report for the same accounts… its all positive and aligns with the accounts true IRR for the YTD returns I've achieved. Additionally… only some of the non-negative accounts IRR values are the same. My two kids 529 accounts are equal between the reports while my and my wife's IRA's and our personal brokerage account are off by about ~10% between reports.
Am I missing something in the difference between these two reports or how they calculate IRR? Is there something wrong in the data for either of the "negative IRR" accounts dissimilar IRR value accounts I can check to see if its corrupted the calculation Quicken is doing?
I'm using Quicken Classic Deluxe - R57.26; However, this issue has been around for a while.
Picture included showing the Home Dashboard item as well as the two reports. I've added color to align the Key from the Dashboard Item to the accounts in the reports for clarity. Note that the Dashboard view appears limited to 5 accounts regardless of available space.
Any help/explanation or issue/error identification is appreciated!
Comments
-
(Sidebar gripe: Why can't the programmers be consistent? Doing so is important to avoid confusion. In most of Quicken (portfolio views), Return is not the same as Performance. Yet they put the IRR Performance chart on the Dashboard with the Return title. Just stupid of them.)
OK, so I don't do much with the dashboard setups. From what I have read here, those 'cards' can be flaky. Ergo, I trust the more tried and true reports in all cases. Now having moved past the name on the chart, I do see that your background view of the dashboard chart says 207 securities. Have you customized the security selection for that chart? Is it the same as for the report/graph (Investment Performance) chart?
If you change the date range does anything improve. In particular, the Average Annual Return (IRR) calculation generate values that can be misleading. Moving to a full year period might alter something.
Along that same line, moving the end date back in time from today (7/14/24) a few days, weeks, or months might also reveal some glitch in the data.
But if all else fails, blame the dashboard and scrap it.
1 -
@q_lurker… well, call me impressed on picking up the one data point I didn't notice!
I don't know how, but it was apparently the number of securities. There didn't seem to be any rhyme or reason I could quickly identify as to why some were filtered out (I hadn't manually done it, I wonder if it was as accounts/securities were added, etc… the dashboard item doesn't update automatically)
I hit "select all" on the "customize this graph" screen under securities and voila… 264 securities now and the data between the two report graphs and the Dashboard now all match.
Interestingly… I went back into the "customize this graph" screen and to the securities tab and in was set to "include only selected securities" again… but all were still selected. I wonder if it defaults to "only selected" and as new are added it ignores them because of some bad defaults or "forgetting" its previous setting.
As you can see below, the dashboard and "Returns" graph from it are now the same as the "Investment Performance" above.
Thank you for looking and noticing the issue! Appreciate the help!
0