Re: [GNC] Trading accounts functionality
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 ___ 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 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 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 ___ 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 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 ___ 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 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 ___ 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
> 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 ___ 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 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. Regards, John Ralls ___ 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.
Re: [GNC] Trading accounts functionality
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.