> ------------------------------ > Date: Mon, 29 Jun 2026 07:47:38 +0100 > From: Wm Tarr <[email protected]> > To: [email protected] > Subject: [GNC] Investment Lots report, no CAGR grand totals > Message-ID: <[email protected]> > Content-Type: text/plain; charset=UTF-8; format=flowed > > The updated Investment Lots report includes Grand Totals for > > Realized Gain? ? Realized ROI? ? ? ? Unrealized Gain Unrealized ROI > > but not Realized CAGR? ?and? Unrealized CAGR > > which would be useful if possible. > > Thanks > > Wm
Hi Wm, You're right that the report has Grand Totals for Realized/Unrealized Gain and ROI, but not for the CAGR columns — and that was a deliberate decision rather than an oversight. Here's the reasoning: The Gain and ROI totals work because they're built from plain currency amounts. Gains simply add up, and ROI is just total gain divided by total basis — both of which combine cleanly across everything in the report, even when different accounts hold different securities. CAGR is different. It's an annualized rate of return, not a dollar amount, so you can't just add the individual lots' CAGRs together. To produce a meaningful total you have to compute a weighted average, and each lot also covers a different holding period and different start/end dates. Within a single account (which holds one security), the report can weight each lot's CAGR by its share count and give you a sensible account-level figure. But the Grand Total spans multiple accounts holding different securities, and you can't meaningfully combine share counts across, say, Apple shares and an S&P 500 fund. Without a common basis to weight by, any single "grand total CAGR" number would be arbitrary and potentially misleading — so rather than show a figure that looks authoritative but isn't trustworthy, the report leaves it blank. A grand-total CAGR isn't impossible in principle — it would mean switching to a value-weighted average (weighting by each lot's cost basis in the report currency instead of by share count), or a proper money-weighted return (IRR) that accounts for the differing time periods. Both are more involved changes, and the harder part is being confident the resulting single number is actually meaningful rather than just plausible-looking. Thanks, Brent _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
