Re: [GNC] Trading Accounts Balance

2025-02-27 Thread David Warren
John, I'm curious what you'd suggest to do to track my issue down. I got rid of all my stock accounts save one open one (where the price hasn't moved since inception) and some closed accounts (where all positions were sold). A standard balance sheet report nevertheless shows a giant "unrealized tr

Re: [GNC] Trading Accounts Balance

2025-02-27 Thread John Ralls
Bo, Sorry, I seem to have forgotten the lessons I learned from https://bugs.gnucash.org/show_bug.cgi?id=775368, in particular https://bugs.gnucash.org/show_bug.cgi?id=775368#c6. The upshot is that the average cost price source hides the trading gains and losses as long as there’s a balance in

Re: [GNC] Trading Accounts Balance

2025-02-27 Thread Bo Buckley
Dear John, As always, thank you for your reply. Consider the simple case where you transfer $100 to your JPY Checking at > ¥14925 (about $0.67/¥100), then use Finanace::Quote to update the exchange > rate and it retrieves $0.70/¥100 and overwrites the entry for that day in > the price database. T

Re: [GNC] Trading Accounts Balance

2025-02-26 Thread John Ralls
Bo, We got started in this discussion because you had trouble understanding that price isn’t necessarily concrete across splits because of forced rounding of commodities to their minimum fractions. Clarifications first: You’re right, buying at $0.67/¥100 and spending (selling) at $0.70/¥100 is

Re: [GNC] Trading Accounts Balance

2025-02-26 Thread Bo Buckley
Thank you for your response John, but I have to say I've completely lost sight of the original question, so allow me to summarize from the beginning: I want to understand the meaning and underlying usage of the "Total" amount listed next to "Trading" in the "Accounts" tab. The docs appear to expla

Re: [GNC] Trading Accounts Balance

2025-02-20 Thread John Ralls
Bo, It doesn’t matter whether or not the gain is taxable. You must book trading gains to keep your book in balance. Please study https://www.gnucash.org/docs/v5/C/gnucash-guide/chapter_capgain.html for the different ways to accomplish that in GnuCash. One more time: The price database has noth

Re: [GNC] Trading Accounts Balance

2025-02-20 Thread Bo Buckley
Dear John, Thank you for the detailed example. Yes, your examples make sense to me, and what I expect to happen, though I'm still not clear on how to actually implement the following in GNUcash: You need to book that gain as income in order for your book to stay in > balance in USD. In your exa

Re: [GNC] Trading Accounts Balance

2025-02-15 Thread John Ralls
Bo, For this discussion I’m using the term trading gains to refer to both gains and losses and booking both (as credits and debits respectively) into an income account. As you say, the income occurs when you go the other way. Leaving off trading accounts for a moment, if you transfer $100 to J

Re: [GNC] Trading Accounts Balance

2025-02-15 Thread G R Hewitt
A caveat. John Ralls wrote ' ... If you need that you’ll have to turn off trading accounts in File>Properties and manage the trading accounts and splits manually.' It seems I needed to do this too, as when I enter a purchase in euros into a euro account that is paid for with GBP, it alters all th

Re: [GNC] Trading Accounts Balance

2025-02-14 Thread Bo Buckley
Dear John, Thank you for your reply. I don’t understand what you mean by “zero this out for today”. Maybe I misunderstood what you meant when you said, If the net gains aren’t taxable then you can book them to a separate > non-taxable income account. Say I'm doing my US reporting, and this t

Re: [GNC] Trading Accounts Balance

2025-02-13 Thread John Ralls
Bo, I don’t understand what you mean by “zero this out for today”. The Totals column on the Accounts page presents the ending balance for each account (even if that’s in the future), converted to the book currency using the most recent exchange rate available from the account’s commodity to the

Re: [GNC] Trading Accounts Balance

2025-02-13 Thread Bo Buckley
Thank you for your reply John, >If the net gains aren’t taxable then you can book them to a separate non-taxable income account. Even if I zero this out for today as an example, won't the Trading account balance continue to fluctuate even after doing so as new price entries come on day to day? I'

Re: [GNC] Trading Accounts Balance

2025-02-13 Thread John Ralls
> On Feb 13, 2025, at 01:19, Bo Buckley wrote: > > In the foreign currency docs: > https://gnucash.org/docs/v5/C/gnucash-guide/currency_trading_accts.html > > The Trading and CURRENCY placeholder accounts now indicate a modest >> realized loss of 0.82 USD on the currency transactions. > > >

[GNC] Trading Accounts Balance

2025-02-13 Thread Bo Buckley
In the foreign currency docs: https://gnucash.org/docs/v5/C/gnucash-guide/currency_trading_accts.html The Trading and CURRENCY placeholder accounts now indicate a modest > realized loss of 0.82 USD on the currency transactions. it appears to explain that the Trading top-most account balance repr

Re: [GNC] Trading accounts

2023-04-22 Thread john
Maybe, because it's all we've got for differentiating two securities with the same symbol. Regards, John Ralls > On Apr 22, 2023, at 1:20 AM, Fred Tydeman wrote: > > Is there a relationship between Security Namespaces and Trading accounts? > If I change which Namespace a security is in, shoul

Re: [GNC] Trading accounts

2023-04-22 Thread Fred Tydeman
Is there a relationship between Security Namespaces and Trading accounts? If I change which Namespace a security is in, should that affect a Trading account? On Fri, Apr 21, 2023 at 11:29 PM john wrote: > No, the naming scheme is hard-coded. Ralf Habacker made a start at > removing name depende

Re: [GNC] Trading accounts

2023-04-21 Thread john
No, the naming scheme is hard-coded. Ralf Habacker made a start at removing name dependencies but got it working only for opening balance accounts. Regards, John Ralls > On Apr 21, 2023, at 9:30 AM, Fred Tydeman wrote: > > Can Trading accounts be moved around? > That is, given a new parent. >

[GNC] Trading accounts

2023-04-21 Thread Fred Tydeman
Can Trading accounts be moved around? That is, given a new parent. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remem

Re: [GNC] Trading accounts

2022-07-27 Thread Mike Alexander
This is one side of the story. For another view of things you might take a look at https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html. You could also look at https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html which is outdated but still might be useful. If you want t

Re: [GNC] Trading accounts

2022-07-27 Thread David T. via gnucash-user
Geoff, Changing values of reconciled transactions without notice renders a book completely unreliable for any accounting purpose. If that's not evil, what is? David T. On July 27, 2022 2:46:34 PM GMT+03:00, Geoff wrote: >Lots. > >(And they aren't really evil, just wilful). > >;--)) > >Geoff

Re: [GNC] Trading accounts

2022-07-27 Thread David T. via gnucash-user
The thread I started, with the title "Evil Lots Behavior" was about the Gnucash *Lots* feature, which is designed to "assist" users in the management of individual lots of stock and mutual fund shares. (For the record, the lots feature will change reconciled gains transactions without notificati

Re: [GNC] Trading accounts

2022-07-27 Thread Geoff
Lots. (And they aren't really evil, just wilful). ;--)) Geoff = On 27/07/2022 8:36 pm, David Carlson wrote: This has confused me. Is the recent thread titled " [GNC] Evil Lots Behavior" about lots or trading accounts? On Wed, Jul 27, 2022 at 12:10 AM David T. wrote: David C. Trading

Re: [GNC] Trading accounts

2022-07-27 Thread David Carlson
This has confused me. Is the recent thread titled " [GNC] Evil Lots Behavior" about lots or trading accounts? On Wed, Jul 27, 2022 at 12:10 AM David T. wrote: > David C. > > Trading accounts are not the same as lots. Different concept, different > code. Just a for instance: trading accounts are

Re: [GNC] Trading accounts

2022-07-26 Thread David T. via gnucash-user
David C. Trading accounts are not the same as lots. Different concept, different code. Just a for instance: trading accounts are turned on by book; lots can be enabled by account. David T. On July 27, 2022 3:33:37 AM GMT+03:00, David Carlson wrote: >I believe that you are witnessing first

Re: [GNC] Trading accounts

2022-07-26 Thread David Carlson
I forgot to address fixing the mess. I think there are two ways to fix it. The easiest is to restore your last backup from before turning on TA's. The other, iirc, is to manually delete all those TA's. On Tue, Jul 26, 2022, 7:24 PM wrote: > Fred, > > Not early in the guide, but in the section

Re: [GNC] Trading accounts

2022-07-26 Thread David Carlson
I believe that you are witnessing first hand why trading accounts are not enabled by default, i.e. they create a royal mess in your trading history. You might want to re-read the recent thread about evil trading accounts. They may work ok for some users who's documentation goals align with the d

Re: [GNC] Trading accounts

2022-07-26 Thread davidcousens49
Fred, Not early in the guide, but in the section dealing with multiple currencies https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_trading_accts.html and discussed on the wiki (https://wiki.gnucash.org/wiki/Trading_Accounts). I don't think anyone has yet written anything about any applic

[GNC] Trading accounts

2022-07-26 Thread Fred Tydeman
Over the past several months, I have been importing Quicken data into GnuCash. There is about 6 years of data and lots of transactions. Besides normal income and expenses, that data involved many different stocks and many different currencies. Recently, I saw a reference to "Trading" accounts.

Re: [GNC] Trading accounts functionality

2021-04-05 Thread Mike Alexander
On 4 Apr 2021, at 3:29, zuperkoleopt...@gmail.com wrote: Do you think I should file bug reports? Sure, if you can specify detailed step by step instructions for reproducing the errors. The more information you can give the more likely it is to get fixed. Mike _

Re: [GNC] Trading accounts functionality

2021-04-04 Thread zuperkoleoptera
On Sat, 2021-04-03 at 03:21 -0400, Mike Alexander wrote: > On 3 Apr 2021, at 1:31, zuperkoleopt...@gmail.com wrote: > > Another issue that I just realized and is related to the > > functionality > > of trading accounts, but maybe not the one that we are discussing > > here, > > is the security/curr

Re: [GNC] Trading accounts functionality

2021-04-03 Thread Mike Alexander
On 3 Apr 2021, at 1:31, zuperkoleopt...@gmail.com wrote: Another issue that I just realized and is related to the functionality of trading accounts, but maybe not the one that we are discussing here, is the security/currency of the top level placeholder account Trading. Shouldn't that be set i

Re: [GNC] Trading accounts functionality

2021-04-02 Thread zuperkoleoptera
On Fri, 2021-04-02 at 13:38 -0700, John Ralls wrote: > > > > On Apr 2, 2021, at 12:23 PM, zuperkoleopt...@gmail.com wrote: > > > > On Fri, 2021-04-02 at 11:58 -0700, John Ralls wrote: > > > > > > > > > > On Apr 2, 2021, at 9:42 AM, zuperkoleopt...@gmail.com wrote: > > > > > > > > On Fri, 2021

Re: [GNC] Trading accounts functionality

2021-04-02 Thread John Ralls
> On Apr 2, 2021, at 12:23 PM, zuperkoleopt...@gmail.com wrote: > > On Fri, 2021-04-02 at 11:58 -0700, John Ralls wrote: >> >> >>> On Apr 2, 2021, at 9:42 AM, zuperkoleopt...@gmail.com wrote: >>> >>> On Fri, 2021-04-02 at 08:47 -0700, John Ralls wrote: > On Apr 2, 2021, at 8:

Re: [GNC] Trading accounts functionality

2021-04-02 Thread zuperkoleoptera
On Fri, 2021-04-02 at 11:58 -0700, John Ralls wrote: > > > > On Apr 2, 2021, at 9:42 AM, zuperkoleopt...@gmail.com wrote: > > > > On Fri, 2021-04-02 at 08:47 -0700, John Ralls wrote: > > > > > > > > > > On Apr 2, 2021, at 8:37 AM, John Ralls > > > > wrote: > > > > > > > > On Apr 2, 2021, at

Re: [GNC] Trading accounts functionality

2021-04-02 Thread John Ralls
> On Apr 2, 2021, at 9:42 AM, zuperkoleopt...@gmail.com wrote: > > On Fri, 2021-04-02 at 08:47 -0700, John Ralls wrote: >> >> >>> On Apr 2, 2021, at 8:37 AM, John Ralls wrote: >>> >>> On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: which by the way it does not u

Re: [GNC] Trading accounts functionality

2021-04-02 Thread zuperkoleoptera
On Fri, 2021-04-02 at 08:47 -0700, John Ralls wrote: > > > > On Apr 2, 2021, at 8:37 AM, John Ralls wrote: > > > > On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: > > > > > > which by the way it > > > does not use the default security fraction which is 1/ > > > but > > > 1

Re: [GNC] Trading accounts functionality

2021-04-02 Thread John Ralls
> On Apr 2, 2021, at 8:37 AM, John Ralls wrote: > > On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: >> >> which by the way it >> does not use the default security fraction which is 1/ but >> 1/. > > The price is in Euro, so it displays as 1/100 of the Euro's fract

Re: [GNC] Trading accounts functionality

2021-04-02 Thread John Ralls
On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: > > which by the way it > does not use the default security fraction which is 1/ but > 1/. The price is in Euro, so it displays as 1/100 of the Euro's fraction. That's for display only, the actual calculated price is as

Re: [GNC] Trading accounts functionality

2021-04-02 Thread zuperkoleoptera
I have been using lots and scrubing my investment accounts to track realized gains. But since I have turned on trading accounts I have not scrubbed any account. I am attaching an example of 2 splits created after turning on trading accounts. As a side-note some of the account names are in Greek..

Re: [GNC] Trading accounts functionality

2021-04-02 Thread Mike Alexander
On 28 Mar 2021, at 11:21, zuperkoleopt...@gmail.com wrote: The problem I am facing is the following, after activating trading accounts the system created the hierarchy for all the trading accounts, but also created a bunch of splits in already recorded transactions. So from the beginning the

[GNC] Trading accounts functionality

2021-03-28 Thread zuperkoleoptera
I've been using gnucash since 2014, recording my personal finances and investments. I am in Europe so my main currency is EUR. Up until now my investments were in EUR currency as well as some crypto, which are again expressed in EUR currency. Lately I started building an investment portfolio i