Re: [GNC] Versions after 4.13 freeze in splash screen
On Mon, 2023-09-11 at 10:15 -0700, John Ralls wrote: > > > > On Sep 11, 2023, at 9:33 AM, john wrote: > > > > > > > > > On Sep 11, 2023, at 09:24, zuperkoleoptera > > > wrote: > > > > > > On Mon, 2023-09-11 at 09:13 -0700, john wrote: > > > > > > > > > > > > > On Sep 11, 2023, at 02:29, zuperkoleoptera > > > > > wrote: > > > > > > > > > > Hi, > > > > > > > > > > I use gnucash under Debian testing with the mariadb backend, > > > > > through an > > > > > ssh tunnel to a VPS I maintain. > > > > > Version of the mariadb is 10.3.39. > > > > > Everything worked as normal, until I upgraded in version 5.1 > > > > > from > > > > > 4.13 > > > > > where gnucash seemed to start but then remained indefinitely > > > > > in the > > > > > splash screen occasionally bringing forward the "Gnucash not > > > > > responding" error with the option to wait or to force quit > > > > > it. > > > > > If I pressed wait nothing happened until the error screen > > > > > appeared > > > > > again. > > > > > > > > > > I waited until gnucash version 5.3 was migrated to Debian > > > > > testing > > > > > but > > > > > the issue has not been resolved. > > > > > I have an older box with Debian testing that still runs 4.13 > > > > > and is > > > > > still operational, so for the time being I use that one. > > > > > > > > > > I am attaching the gnucash_trace file from the box with the > > > > > 5.3 > > > > > version. > > > > > If needed I have the gnucash_trace also from the one running > > > > > 4.13. > > > > > > > > > > Any ideas? > > > > > __ > > > > > _ > > > > > > > > The tracefile shows 10 minutes of > > > > 10:59:29 INFO > > > > [gnc_main_window_set_vis_of_items_by_action] Found menu_item > > > > 0x5570bb796ab0 with action name 'ABGetBalanceAction', seting > > > > vis to > > > > 'true' > > > > > > > > For most, but not all, of the AQBanking actions registered by > > > > the > > > > AQBanking plugin. I haven't yet tracked down why GnuCash would > > > > get > > > > stuck in a loop trying to load the plugin, but I guess there's > > > > also a > > > > packaging problem with the 5.x .deb that you're using. I can't > > > > tell > > > > you what it might be until I figure out what's causing the > > > > loop. > > > > > > > > Regards, > > > > John Ralls > > > > > > > Is there a way to disable AQBanking plugin in application start? > > > I > > > don't use it so I do not care. > > > > Not at runtime. GnuCash can be built without AQBanking support. > > > > You could try using the flatpak instead. > > Two more questions: Do you have a bazillion tabs or windows open? > Have you uninstalled AQBanking because you don't use it? > > Regards, > John Ralls To answer you questions (1) other than the register I keep always open another 5 tabs ( reports, views ) no other window open. (2) No I have not uninstalled AQBanking To add more into the mystery, I installed the flatpak and when I tried to open it it asked me for credentials. Since I maintain multiple dbs, for different entities, I entered a different db this time and gnucash opened it. When I tried to change back to my main db it produced the " The server at experienced an error or encountered bad or corrupt data". I know that my db is ok since I can still access it from the 4.13 installation. ___ 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 remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Versions after 4.13 freeze in splash screen
On Mon, 2023-09-11 at 09:13 -0700, john wrote: > > > > On Sep 11, 2023, at 02:29, zuperkoleoptera > > wrote: > > > > Hi, > > > > I use gnucash under Debian testing with the mariadb backend, > > through an > > ssh tunnel to a VPS I maintain. > > Version of the mariadb is 10.3.39. > > Everything worked as normal, until I upgraded in version 5.1 from > > 4.13 > > where gnucash seemed to start but then remained indefinitely in the > > splash screen occasionally bringing forward the "Gnucash not > > responding" error with the option to wait or to force quit it. > > If I pressed wait nothing happened until the error screen appeared > > again. > > > > I waited until gnucash version 5.3 was migrated to Debian testing > > but > > the issue has not been resolved. > > I have an older box with Debian testing that still runs 4.13 and is > > still operational, so for the time being I use that one. > > > > I am attaching the gnucash_trace file from the box with the 5.3 > > version. > > If needed I have the gnucash_trace also from the one running 4.13. > > > > Any ideas? > > ___ > > The tracefile shows 10 minutes of > 10:59:29 INFO > [gnc_main_window_set_vis_of_items_by_action] Found menu_item > 0x5570bb796ab0 with action name 'ABGetBalanceAction', seting vis to > 'true' > > For most, but not all, of the AQBanking actions registered by the > AQBanking plugin. I haven't yet tracked down why GnuCash would get > stuck in a loop trying to load the plugin, but I guess there's also a > packaging problem with the 5.x .deb that you're using. I can't tell > you what it might be until I figure out what's causing the loop. > > Regards, > John Ralls > Is there a way to disable AQBanking plugin in application start? I don't use it so I do not care. ___ 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 remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trading accounts functionality
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/currency of the top level placeholder account > > Trading. > > Shouldn't that be set in my base currency EUR? Strangely enough in > > my > > case it's set in VOW which is a security I trade. > I'm not sure where that came from, but I don't think it matters. I > can't think of anything that GnuCash would use that commodity for. > Another thing that we've sort of passed over without comment is that > trading accounts don't have much to do with realized gains. You still > need to record them as you presumably have been by using splits to a > "realized gain" income account with zero shares and non-zero value. > Trading accounts are more about making the books balance with > unrealized gains. > Mike Yes you are right and that was what I was looking for when I first looked into the functionality. The problem is that it produces a lot of new transaction splits that don't make sense to me or to my usecase scenario. I think for now my testing is over and I will move on deleting the trading accounts and all related splits, as I have read in some previous messages in the list. I have turned the feature on in another book, an individual upstart bussiness that I am now starting and see how this works out in a different setting. Anyhow for my use case I have discovered 3 following issues, which could be bugs - Trading placeholder account is set in the wrong security / currency - Splits are automatically created in past cross-currency/commodity transactions - Trading accounts do not obey commodity value smallest fraction Do you think I should file bug reports? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trading accounts functionality
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-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/. > > > > > > > > > > > > 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 exact a fraction as can be represented with two 64-bit > > > > > > integers. > > > > > > > > > > Sorry, you meant that the BTC amount in the trading split is > > > > > rounded > > > > > to 1/1000. Maybe there's a 1/100 clamp left somewhere in > > > > > the > > > > > balancing logic? > > > > > > > > > > Regards, > > > > > John Ralls > > > > > > > > > Yes you are right, the account created by the trading > > > > subsystem, > > > > Trading:Crypto Currency:BTC-EUR, is in BTC which is a security > > > > in > > > > the > > > > system not in eur which is a currency. > > > > Although I have switched to use "commodity value" in the > > > > "smallest > > > > fraction" switch it still uses 1/ instead the 1/. > > > > But this is somehow minor issue as I assume it does not affect > > > > the > > > > actual value of the account, it's just visual. > > > > > > No, it's pretty clearly keeping the transaction from balancing > > > because .0012 != .00115652. > > > > > > As for the trading splits miraculously appearing, did that happen > > > to > > > all cross-commodity transactions in your book or just ones that > > > you > > > touched? > > > > > > Regards, > > > John Ralls > > > > > > > > To all cross-commodity transactions, I haven't touched - balanced > > any > > transaction yet. > > I turned on trading accounts just a few days a go and still trying > > to > > evaluate my situation, whether I will keep the feature on or not. > > Well, you've touched at least the one from the screenshot. You can't > get that dialog box unless you've opened the transaction for editing. > > If you open the register for Trading:BTC-EUR are there lots of > transactions listed? > > Regards, > John Ralls > Sorry did not understand that by touching you meant click inside. Yes I have touched several transactions. No there are not lots in Trading:Crypto Currency:BTC-EUR 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 in my base currency EUR? Strangely enough in my case it's set in VOW which is a security I trade. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trading accounts functionality
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 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 exact a fraction as can be represented with two 64-bit > > > > integers. > > > > > > Sorry, you meant that the BTC amount in the trading split is > > > rounded > > > to 1/1000. Maybe there's a 1/100 clamp left somewhere in the > > > balancing logic? > > > > > > Regards, > > > John Ralls > > > > > Yes you are right, the account created by the trading subsystem, > > Trading:Crypto Currency:BTC-EUR, is in BTC which is a security in > > the > > system not in eur which is a currency. > > Although I have switched to use "commodity value" in the "smallest > > fraction" switch it still uses 1/ instead the 1/. > > But this is somehow minor issue as I assume it does not affect the > > actual value of the account, it's just visual. > > No, it's pretty clearly keeping the transaction from balancing > because .0012 != .00115652. > > As for the trading splits miraculously appearing, did that happen to > all cross-commodity transactions in your book or just ones that you > touched? > > Regards, > John Ralls > > To all cross-commodity transactions, I haven't touched - balanced any transaction yet. I turned on trading accounts just a few days a go and still trying to evaluate my situation, whether I will keep the feature on or not. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trading accounts functionality
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/. > > > > 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 exact a fraction as can be represented with two 64-bit integers. > > Sorry, you meant that the BTC amount in the trading split is rounded > to 1/1000. Maybe there's a 1/100 clamp left somewhere in the > balancing logic? > > Regards, > John Ralls > Yes you are right, the account created by the trading subsystem, Trading:Crypto Currency:BTC-EUR, is in BTC which is a security in the system not in eur which is a currency. Although I have switched to use "commodity value" in the "smallest fraction" switch it still uses 1/ instead the 1/. But this is somehow minor issue as I assume it does not affect the actual value of the account, it's just visual. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trading accounts functionality
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... This is a past purchase of bitcoin using euros. So the system has created (1) a split to Trading:CURRENCY:EUR for 39.90 and (2) a split in Trasing:Crypto Currency:BTC-EUR fro 0.0011 BTC, which by the way it does not use the default security fraction which is 1/ but 1/. Furthermore the system recognises that the transaction is not balanced and each time I try to change the splits it pops up the window that I am attaching you in the 2nd file. To my understanding the system has created a bunch of splits in all my transactions involved with my crypto portfolio that I need to go and manualy rebalance. Did any of the above helped to you to understand the situation better? On Fri, 2021-04-02 at 03:32 -0400, Mike Alexander wrote: > 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 trading:currency:EUR account has a balance > > of > > almost 2.300 eur and includes all my transactions related to my > > crypto > > portfolio. > > Merely turning on trading accounts shouldn't create any new splits in > existing transactions. I suspect you must have used one or more of > the > scrub commands to create them. > > I would have to have more details to see what is going on, but if you > use one ore more commodities for crypto and have transactions that > buy > or sell those commodities in Euros, then it is normal for trading > account splits to be created for those transactions, but only when > the > transaction is edited or scrubbed. > > Mike ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Trading accounts functionality
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 in USD, so I started exploring the trading accounts functionality. I have read both articles from P. Selinger and browsed through the documentation and mailing lists, for related subjects. 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 trading:currency:EUR account has a balance of almost 2.300 eur and includes all my transactions related to my crypto portfolio. Is this normal for the trading system to create splits in already recorded transactions? And what does it mean for the trading:currency:EUR to have a positive balance of 2.300 eur, is this exchange realized gain? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.