[GNC] moving stocks across accounts lost the basis price in the Portfolio report
Mattia Rizzolo
mattia at mapreri.org
Tue Apr 25 07:23:46 EDT 2023
Hello Murugan, and apologizes, it seems back in January I missed your
answer somehow!
So, I attached here a screenshot of just the AMZN stock which I moved
around. For the purposes of the move, I eneded up including the fees
into the basis price; normally I use the "gross pricing" method as I am
interested in tracking how much fees I pay and to whom. Do you think
this the correct way to handle this?
Incidentally, doing this also created a new entry in the price database,
with the price that I inserted there… (which is… wrong in this case,
isn't it? So I'll end up having to manually delete them all again?)
On Mon, Apr 24, 2023 at 02:42:51PM +0000, Murugan Muruganandam wrote:
>
> hi mattia
>
> this query was responded in January
>
>
> On the transfer transaction, you are transferring it with zero price.
> you need to transfer it with a cost price , then only system will recognize the profit/loss. in your transaction you are buying and selling at 0 price , so the system considers it as 100% loss
>
> please look at the sample images attached in the email
>
>
> Saludos Cordiales
>
>
> Murugan
>
> ________________________________
> From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on behalf of Mattia Rizzolo <mattia at mapreri.org>
> Sent: Monday, April 24, 2023 9:44 AM
> To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> Subject: [GNC] moving stocks across accounts lost the basis price in the Portfolio report
>
> 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 `-
> Date: Fri, 27 Jan 2023 02:16:03 +0000
> From: Murugan Muruganandam <m.muruganandam at hotmail.com>
> To: Mattia Rizzolo <mattia at mapreri.org>
> Subject: Re: [GNC] coalesce the stock accounts in the report
> Message-ID: <CP6P284MB16223DEEB2F6EB5BC0F5835B9CCC9 at CP6P284MB1622.BRAP284.PROD.OUTLOOK.COM>
>
> Mattia
>
> you can export the portfolio report as .html. Then you can import it into a spreadsheet and you can manipulate the data
>
> On the transfer transaction, you are transferring it with zero price.
> you need to transfer it with a cost price , then only system will recognize the profit/loss. in your transaction you are buying and selling at 0 price , so the system considers it as 100% loss
>
> attached 3 images for your review, hope it helps
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> ________________________________
> From: Mattia Rizzolo
> Sent: Thursday, January 26, 2023 5:07 PM
> To: Murugan Muruganandam
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] coalesce the stock accounts in the report
>
> Could you please tell me how to export this single report in something
> usable in a spreadsheet?
>
> Also, attached are 3 screenshots.
> I have this broker that I use to "try out" some things, and if I feel so
> I move them to anothe account later (this is mostly to take advantage
> of different fees and leverage options).
>
> So here are 2 ETFs, and then an excerpt of what the "advance portfolio
> report" shows of them.
>
>
>
> On Thu, Jan 26, 2023 at 07:27:12PM +0000, Murugan Muruganandam wrote:
> > Mattia
> >
> > a faster and less invasive solution is to extract the Advanced Portfolio into a spread sheet and create a Pivot table which can consolidate the data at Stock level
> >
> > I have a question though, when you moved your stocks between broker what was the operation you did which reflected 100% loss
> >
> >
> >
> >
> > Saludos Cordiales
> >
> >
> > Murugan
> >
> > ________________________________
> > From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on behalf of Mattia Rizzolo <mattia at mapreri.org>
> > Sent: Wednesday, January 25, 2023 6:27 PM
> > To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> > Subject: [GNC] coalesce the stock accounts in the report
> >
> > Hello,
> >
> > I own several stocks across multiple brokers, so I have an account
> > structure that, roughly, looks like this:
> >
> > Assets
> > |- Bank1
> > | |- EUR
> > | |- Stocks EUR
> > | |- AAA
> > | |- BBB
> > | |- CCC
> > |- Bank2
> > |- EUR
> > |- Stocks EUR
> > |- BBB
> >
> > So, in this simple case, I hold 4 different stocks across two brokers,
> > of which one (BBB) is held in two places at the same time.
> >
> > In this situation the "Advanced Portfolio" report lists:
> > AAA
> > BBB
> > CCC
> > BBB
> >
> > Duplicating BBB and listing it separately between the accounts.
> >
> > I get why this might be interesting in some cases, but for my uses I
> > have really have no interest in having a separated view in this report;
> > it's actually quite confusing right now as I had cases in the past where
> > I moved holdings across different brokers (without liquidating the
> > position, directly moving the titles), and this seems to be recorded
> > actually as a 100% loss (?!!) in the report. Sure I can tick the "hide
> > accounts with no shares" options, but I also had cases where I only
> > partially moved a position so I still hold some shares in both places.
> >
> > Any suggestion on what I could do?
> >
> > Clearly I can't unify the accounts as I do need to keep them separated.
> >
> > Thank you in advance for your insights!
> >
> > --
> > 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 `-
>
> --
> 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 `-
--
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: 2023-04-25_13-15.png
Type: image/png
Size: 135853 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230425/b11b1eb8/attachment-0001.png>
More information about the gnucash-user
mailing list