After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 311549 - Advanced Portfolio report miscalculates money in/out (and hence gain and total return)
Advanced Portfolio report miscalculates money in/out (and hence gain and tota...
Status: VERIFIED FIXED
Product: GnuCash
Classification: Other
Component: Reports
1.8.x
Other All
: High critical
: ---
Assigned To: Chris Lyttle
Chris Lyttle
Depends on:
Blocks:
 
 
Reported: 2005-07-26 03:01 UTC by Boris Zbarsky
Modified: 2018-06-29 20:53 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Proposed change (1.17 KB, patch)
2005-07-26 03:02 UTC, Boris Zbarsky
committed Details | Review

Description Boris Zbarsky 2005-07-26 03:01:27 UTC
Please describe the problem:
VERSION: GnuCash 1.8.9

The problem is that the "money in" and "money out" columns include reinvested
dividends under "money in" and include broker's fees under "money out".  This
doesn't accurately reflect the role of those transactions for a typical
investment account.

Steps to reproduce:
1. Purchase $100 worth of a mutual fund.
2. Receive a $50 dividend.
3. Pay $30 in broker's fees.
4. Assume the value of the fund's shares doubled after all this.

Actual results:
Money In == $150
Money Out == $30
Current Value == $240
Gain == $120
Total Return == $120/$150 = 80%

Expected results:
Money In == $100
Money Out == $0
Current Value == $240
Gain == $140
Total Return == $140/$100 = 140%

Does this happen every time?


Other information:
I have a suggested patch based on the existing calculation of dividendcoll and
brokeragecoll in advanced-portfolio.scm (they are currently unused, but I think
they should be used to adjust the moneyincoll and moneyoutcoll lists).
Comment 1 Boris Zbarsky 2005-07-26 03:02:48 UTC
Created attachment 49754 [details] [review]
Proposed change
Comment 2 Derek Atkins 2006-02-12 20:29:50 UTC
Applied to SVN r13242.  Thanks for the patch.
Comment 3 John Ralls 2018-06-29 20:53:03 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=311549. Please update any external references or bookmarks.