[GNC] coalesce the stock accounts in the report

[Mattia Rizzolo]

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  `-
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2023-01-26_21-01.png
Type: image/png
Size: 109529 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230126/3dc19ee6/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2023-01-26_21-03.png
Type: image/png
Size: 173274 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230126/3dc19ee6/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2023-01-26_21-04.png
Type: image/png
Size: 38241 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230126/3dc19ee6/attachment-0005.png>
-------------- 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/20230126/3dc19ee6/attachment-0001.sig>