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