[GNC] Balance sheet Trading Gains details

Fred Tydeman tydeman.fred at gmail.com
Mon Apr 24 15:16:55 EDT 2023


I tried the different Commodities: Price Sources and the results did not
look like what you said.
Anyway, I found my problem.

On Mon, Apr 24, 2023 at 7:49 PM john <jralls at ceridwen.us> wrote:

> 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.
>
>


More information about the gnucash-user mailing list