Investment Reports

westwill3

Ever since the R44-27 y investment reports have been incorrect. They show totals 3 or 4 times the actual value. The register totals are correct. I can't drill down in the reports to see what's happening.

DaveD2

I don't trust Quicken investment tracking. If I show investments by account, I get one ROI number, if I group by security, I get another wildly different number.

Jim_Harman

DaveD2 said:

I don't trust Quicken investment tracking. If I show investments by account, I get one ROI number, if I group by security, I get another wildly different number.

For more on this topic, see this discussion
https://community.quicken.com/discussion/7864889/account-level-amount-invested-and-roi-are-calculated-incorrectly-when-a-security-is-sold

Bob_L

Any chance you have made changes affecting accounts?  For example, Vanguard has moved a lot of folks into new brokerage accounts over the years.  When that happens, the group by accounts will show return numbers, etc. that only reflect the time securities are in a particular account over the time range of the indicator (1 year, 3 year, etc.).  So if you are looking at a security that you have held for, say 3 years, but it has only been in the current account for 1 year, the return computation grouped by account only goes back to the time in that current account.

Group by security, however, will capture the return over the entire time range even if the security was in two different accounts.

DaveD2

> @Bob_L said:
> Any chance you have made changes affecting accounts?  For example, Vanguard has moved a lot of folks into new brokerage accounts over the years.  When that happens, the group by accounts will show return numbers, etc. that only reflect the time securities are in a particular account over the time range of the indicator (1 year, 3 year, etc.).  So if you are looking at a security that you have held for, say 3 years, but it has only been in the current account for 1 year, the return computation grouped by account only goes back to the time in that current account.
> Group by security, however, will capture the return over the entire time range even if the security was in two different accounts.

That explains it. Thanks Bob.