advanced portfolio and liquidated stock accounts

Mark Johnson mrj001 at shaw.ca
Sat Nov 18 05:30:06 EST 2006


Philippe A. wrote:

> Hi Mark,
>
> 2006/11/17, Mark Johnson <mrj001 at shaw.ca <mailto:mrj001 at shaw.ca>>:
>
>     Philippe A. wrote:
>
>     >I was hoping to use the advanced portfolio report to keep a
>     detailed history
>     >of past and current investments. I am quite happy with the
>     tracking of
>     >current investments, but not with that of past investments. When
>     talking
>     >about "past investments", I refer more specifically to liquidated
>     accounts.
>     >The only column displaying accurate information for those is
>     their Value: 0.
>     >All other columns report information that's of no use because
>     amounts are
>     >skewed quite radically: money in, return, etc. I was expecting
>     the report to
>     >display all the numbers at the time of the liquidation. Isn't that a
>     >reasonable expectation?
>     >
>     >
>     >
>     I noticed when I ran this report that some of the numbers seem to
>     consolidate all instances of a particular security regardless of which
>     account it is held in (using version 2.0.1).  This is then reported as
>     though it belonged to a particular account.  Is this what you are
>     seeing? 
>
>
> My problem is different.
>
> I have narrowed it down to an account on which I made a loss. The 
> absolute value of the loss gets added to the money in column. Accounts 
> with gains seem ok.
>
> Here's an easy to reproduce example:
> - Create a dummy stock account.
> - Purchase 1000 shares at 1$ each
> - Sell 1000 shares at 0.75$
> - Use the lot viewer to calculate the loss. It wil lalso take care of 
> writing it in an orphaned gain/loss account as a 250$ charge.
> - Bring the advanced portfolio report. Set the date so it gets your 
> transactions. Also enable display of accounts with 0 shares. See what 
> the report shows:
>
> Value = 0 (ok)
> Money in = 1250 (wrong)
> money out = 750 (ok)
> realized gain = -500 (wrong)
> unrealized gain = 0 (ok)
> total gain = -500 (wrong)
> tot return = -40% (wrong)
>
> I tried changing the gain/loss account type to expense. Values of the 
> report changed but they were still off.
>
> Looks like a bug to me. Before I rush to bugzilla, maybe someone can 
> confirm I'm not doing something really stupid.

Searching bugzilla is a pretty good way of answering this question. I 
believe there was some discussion of the Advanced Portfolio Report on 
the list before (just after?) releasing 2.0.0.

I found the following in bugzilla.  The first looks like it might be 
your problem or at least related to it (and also lists a number of 
possibly related bugs you can check):
http://bugzilla.gnome.org/show_bug.cgi?id=347739
http://bugzilla.gnome.org/show_bug.cgi?id=344566
http://bugzilla.gnome.org/show_bug.cgi?id=346062

Christian has listed a number of possibly related bugs in the first and 
third.

Mark



More information about the gnucash-user mailing list