[GNC] moving stocks across accounts lost the basis price in the Portfolio report

[Mattia Rizzolo]

Hello,

A couple of weeks ago I had some stocks moved across different accounts.

In gnucash, I tried recording them as this, for example:

                                        shares  price  debit  credit
A:Investements:Broker1:P1:USD:AMZN      -10
A:Investements:Broker1:P2:USD:AMZN       10

I left price/debit/credit completely empty, and no other split.

I noticed a few days later that these transactions (I moved roughly a
dozen titles) generated some prices in the Price Database, adding a
recorded price of $0 for all the stocks that were involved in this move;
I noticed this when I had a glance at the net worth report and noticed a
stupid downward peak.  So I removed the faulty prices from the database
and now that looks correct.

Even more recently I was looking at the "Advance Portfolio" report, and
realized now that all the stocks that were involved in this move seem to
have a "Basis" of €0.00 (and also money-in/money-out).

This seems to be caused by the fact that in the Advanced Portfolio each
account is on its own, so unticking the "Include accounts with no
shares" I noticed that, limiting to my example above, I have two AMZN
lines:
 * one with 0 shares, 0€ money out, -100.00% realized loss.
 * one with 10 shares, 0€ money in/out, 0€ basis, and empty cells (due
   to the 0€ basis, which I guess would cause divide-by-zero errors)
(I mentioned a related issue I had with this here:
https://lists.gnucash.org/pipermail/gnucash-user/2023-January/105229.html
)


How do you recommend I fix this situation?  Should I just add a price to
the transactions to give them a basis, or what else?  If I did that, how
could I also "carry over" the fees accrued till now?  Just manually
compute them in the "new basis"?


Thank you for your suggestions.



PS: For some stocks I could potentially rename the accounts instead of
doing this move, but this wouldn't be possible for all stocks, as both
portfolios (in the same broker, yes) have shares of the same companies
that I need to keep separate.

-- 
regards,
                        Mattia Rizzolo

GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540      .''`.
More about me:  https://mapreri.org                             : :'  :
Launchpad user: https://launchpad.net/~mapreri                  `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230424/b05a1622/attachment.sig>