[GNC] Balance sheet Trading Gains details

[john]

Fred,

No, the balance sheet's trading gains is an aggregate calculation, there's no option to show its breakdown in the report. But if you switch the price source in report options to average cost then trading gains will reflect the net balance of your trading accounts on the date of the report. It also makes the balance sheet show your book value for all accounts instead of using the price database. That should make it a bit easier to track down where it goes out of balance. Since your book involves securities priced in different currencies you'll need to be aware of how pricing foreign stock->foreign currency->report currency affects the balance.

Regards,
John Ralls


> On Apr 24, 2023, at 8:18 AM, Fred Tydeman <tydeman.fred at gmail.com> wrote:
> 
> Sorry, but that did not work for my needs.
> For the three days I am looking at, no transactions took place.
> I believe that the Balance Sheet Trading Gains is showing Unrealized Gains
> The number on an Advanced Portfolio for Unrealized Gains is the same
> as Total Gains; neither matches the Balance Sheet (and the Balance Sheet
> is out of balance).  I am trying to figure out what I have wrong.
> 
> On Mon, Apr 24, 2023 at 6:09 PM Murugan Muruganandam <
> m.muruganandam at hotmail.com> wrote:
> 
>> Fred
>> 
>> you can generate a P&L report for the period by selecting only the Trading
>> accounts.  The polarity will be changed between profit and loss.
>> 
>> 
>> 
>> Saludos Cordiales
>> 
>> 
>> Murugan
>> ------------------------------
>> *From:* gnucash-user <gnucash-user-bounces+m.muruganandam=
>> hotmail.com at gnucash.org> on behalf of Fred Tydeman <tydeman.fred at gmail.com
>>> 
>> *Sent:* Monday, April 24, 2023 10:55 AM
>> *To:* Gnucash Users <gnucash-user at gnucash.org>
>> *Subject:* [GNC] Balance sheet Trading Gains details
>> 
>> Is it possible to get the details of Trading Gains on a Balance Sheet?
>> In particular, the list of securities involved.
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.