Re: [GNC] Recording stock holdings
Good that you've resolved the problem. Trading accounts are enabled and disabled on the first tab of File>Properties. You should make sure that it's disabled so that GnuCash doesn't create more trading accounts for you going forward. Regards, John Ralls > On Aug 23, 2022, at 2:37 AM, aeg wrote: > > PROBLEM RESOLVED (I think) > > - Forwarded message - > From: aeg > To: john > Cc: gnucash-user@gnucash.org > Sent: Tuesday, 23 August 2022 at 08:45:51 BST > Subject: Re: [GNC] Recording stock holdings > > >> On Aug 21, 2022, at 11:30 PM, aeg via gnucash-user >> wrote: >> >> I have been using GnuCash for about 6 years, starting with version 2.6 and >> now use 3.5 on a Windows 10 laptop. I like it very much, but have a >> persistent problem with entering stock investments. >> The day-to day financial transactions cause me no problems at all, but I've >> never been able to fully understand how stocks and shares are recorded and >> managed, and I'm frustrated that, despite following the tutorials very >> carefully, it never works for me as it does in the tutorial, so I hope >> someone can explain what's going on. >> I have a relatively small portfolio of shares that I've tried to enter, and >> the following example should illustrate the problems I've faced: >> >> Having set up the various accounts according to sections 9.4.1 and 9.4.2 of >> the tutorial, I then followed the instructions in section 9.5.1 to record 33 >> National Grid shares (NG.L) that were valued at 7.833030 GBP on 5/4/2019 as >> follows (note that I have used || to separate the columns): >> Transaction date: 5/4/2019Split 1: Brokerage Account:Stock:NG.L || 33.00 >> || 7.833030 || 258.49 ||Split 2: Equity:Opening Balances |||| >> || || 258.49 >> However, when I press Enter, GnuCash seeks to make corrections and adds >> three more splits, leaving me with: >> Split 1: Brokerage Account:Stock:NG.L || 33.00 || 0.903030303 || 258.49 >> ||Split 2: Trading:CURRENCY:GBP |||| || >> 258.49 ||Split 3: Imbalance - GBP |||| || >> 15,588,385,182,335.90 ||Split 4: Equity:Opening Balances |||| >>|| || 258.49Split 5: Trading:LSE:NG.L || >>|| || || 15,588,385,182,594.39 >> Subtracting the large number in column 5 of split 5 from the large number in >> column 4 of split 3 equals 258.49, so why is it making any of these changes? >> > > On Monday, 22 August 2022 at 16:52:08 BST, john wrote: > > It's creating the splits because you have trading accounts enabled on the > book, see https://wiki.gnucash.org/wiki/Trading_Accounts. I'd need to see the > rest of your book to figure out why the value of that split is so large. The > price change is strange too. > > Does it do that if you set up a new book and create just that transaction? > > What about upgrading to GnuCash 4.11? > > Regards, > John Ralls > > > > Thanks John. > > As far as I'm aware, all of my transactions are in GBP and I've never set up > any trading accounts manually, but they first appeared automatically when I > recorded my holding of Santander shares and added DRIP dividends. Although > that is a Spanish company, the shares and dividends are recorded in my book > in GBP. > > I set up a new book as you suggested, and was able to enter the transaction > without any problems, so when I returned to my current book, I decided to > delete the troublesome account and start again. This time, when I pressed > Enter, GnuCash inserted the trading account splits, but with a different set > of trading account numbers: 67,487,302.84 and 67,487,044.35. (Note that the > difference between those numbers is still 258.49) > > (Note also that I previously recorded other stocks in my original book > without problems. and without trading account splits) > > Regarding your suggested upgrade to GnuCash 4.11, I would normally have done > that by now but my last upgrade (to 3.5) resulted in the need for a > substantial amount of format tweaking to create the screen layout that works > for me, so I'm reluctant to rock the boat again unless I have to; (If it > ain't broke, etc...) > > Regards, > Alan G > > > > Dear John, > > After sending my previous message, I decided to delete the stock account for > the troublesome holding, as well as its associated trading account, then to > create a fresh stock account and re-enter transactions. That, I am pleased > (and relieved) to say, seems to have solved the problem and everything now > appears to be working correctly! > > It would be nice to know why the problem occurred in the first place, but at > least my chart of accounts now appears to reflect reality. > > Thank you again for your input. > > Regards, > Alan G > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update
Re: [GNC] Missing Documentation
Got it. Thanks! ___ 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] Missing Documentation
That is because a "Bill" is a subclass of "Invoice", subclassed solely by the Owner Type. -derek On Tue, August 23, 2022 9:19 am, Robert Simmons wrote: > I didn't include the URL to the location where it seems it should be: > > https://code.gnucash.org/docs/MAINT/group__Business.html > > On Tue, Aug 23, 2022 at 9:18 AM Robert Simmons > wrote: > >> Please correct me if I am wrong, but the Python bindings documentation >> is >> automatically generated, right? >> >> I looked in both master and maint, and I don't see documentation for >> "Bill", but it shows up in the python bindings results from both help() >> and >> dir(). And this object is a full object for vendor bills. >> >> Is there a reason it was omitted from the documentation or its >> generation >> process? If this was omitted by design, what is the thinking there? >> > ___ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Missing Documentation
I didn't include the URL to the location where it seems it should be: https://code.gnucash.org/docs/MAINT/group__Business.html On Tue, Aug 23, 2022 at 9:18 AM Robert Simmons wrote: > Please correct me if I am wrong, but the Python bindings documentation is > automatically generated, right? > > I looked in both master and maint, and I don't see documentation for > "Bill", but it shows up in the python bindings results from both help() and > dir(). And this object is a full object for vendor bills. > > Is there a reason it was omitted from the documentation or its generation > process? If this was omitted by design, what is the thinking there? > ___ 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.
[GNC] Missing Documentation
Please correct me if I am wrong, but the Python bindings documentation is automatically generated, right? I looked in both master and maint, and I don't see documentation for "Bill", but it shows up in the python bindings results from both help() and dir(). And this object is a full object for vendor bills. Is there a reason it was omitted from the documentation or its generation process? If this was omitted by design, what is the thinking there? ___ 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] Saved Report Configurations Missing After Upgrade to v3
Neville, You've responded to a thread from four years ago, referencing a problem with upgrading from version 2.4 to version 3.0 (on Windows, I believe). Gnucash is now up to version 4.11, so whatever problem you've been having is far in most users' rear view mirrors. Geert probably remembers the issue to which you refer, but that's because Geert is Geert. You might choose to follow an upgrade process and see whether your problem continues to exist in 4.11. David T. On August 23, 2022 12:07:25 PM GMT+03:00, Neville Young wrote: >Hi Geert > > > >I want to respond to the latest message Thu Jun 7 11:01:45 EDT 2018 to >confirm that using the 2.4 transaction report does work. > > > >How do I respond to the thread for all users to see. I have read the 'more >information' but am none the wiser. > > > >Cheers - Neville > > > >___ >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. ___ 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.
[GNC] Fw: Recording stock holdings
PROBLEM RESOLVED (I think) - Forwarded message - From: aeg To: john Cc: gnucash-user@gnucash.org Sent: Tuesday, 23 August 2022 at 08:45:51 BSTSubject: Re: [GNC] Recording stock holdings On Aug 21, 2022, at 11:30 PM, aeg via gnucash-user wrote: I have been using GnuCash for about 6 years, starting with version 2.6 and now use 3.5 on a Windows 10 laptop. I like it very much, but have a persistent problem with entering stock investments. The day-to day financial transactions cause me no problems at all, but I've never been able to fully understand how stocks and shares are recorded and managed, and I'm frustrated that, despite following the tutorials very carefully, it never works for me as it does in the tutorial, so I hope someone can explain what's going on. I have a relatively small portfolio of shares that I've tried to enter, and the following example should illustrate the problems I've faced: Having set up the various accounts according to sections 9.4.1 and 9.4.2 of the tutorial, I then followed the instructions in section 9.5.1 to record 33 National Grid shares (NG.L) that were valued at 7.833030 GBP on 5/4/2019 as follows (note that I have used || to separate the columns): Transaction date: 5/4/2019Split 1: Brokerage Account:Stock:NG.L || 33.00 || 7.833030 || 258.49 ||Split 2: Equity:Opening Balances || || || || 258.49 However, when I press Enter, GnuCash seeks to make corrections and adds three more splits, leaving me with: Split 1: Brokerage Account:Stock:NG.L || 33.00 || 0.903030303 || 258.49 || Split 2: Trading:CURRENCY:GBP || || || 258.49 ||Split 3: Imbalance - GBP || || || 15,588,385,182,335.90 ||Split 4: Equity:Opening Balances || || || || 258.49Split 5: Trading:LSE:NG.L || || || || 15,588,385,182,594.39 Subtracting the large number in column 5 of split 5 from the large number in column 4 of split 3 equals 258.49, so why is it making any of these changes? On Monday, 22 August 2022 at 16:52:08 BST, john wrote: It's creating the splits because you have trading accounts enabled on the book, see https://wiki.gnucash.org/wiki/Trading_Accounts. I'd need to see the rest of your book to figure out why the value of that split is so large. The price change is strange too. Does it do that if you set up a new book and create just that transaction? What about upgrading to GnuCash 4.11? Regards,John Ralls Thanks John. As far as I'm aware, all of my transactions are in GBP and I've never set up any trading accounts manually, but they first appeared automatically when I recorded my holding of Santander shares and added DRIP dividends. Although that is a Spanish company, the shares and dividends are recorded in my book in GBP. I set up a new book as you suggested, and was able to enter the transaction without any problems, so when I returned to my current book, I decided to delete the troublesome account and start again. This time, when I pressed Enter, GnuCash inserted the trading account splits, but with a different set of trading account numbers: 67,487,302.84 and 67,487,044.35. (Note that the difference between those numbers is still 258.49) (Note also that I previously recorded other stocks in my original book without problems. and without trading account splits) Regarding your suggested upgrade to GnuCash 4.11, I would normally have done that by now but my last upgrade (to 3.5) resulted in the need for a substantial amount of format tweaking to create the screen layout that works for me, so I'm reluctant to rock the boat again unless I have to; (If it ain't broke, etc...) Regards,Alan G Dear John, After sending my previous message, I decided to delete the stock account for the troublesome holding, as well as its associated trading account, then to create a fresh stock account and re-enter transactions. That, I am pleased (and relieved) to say, seems to have solved the problem and everything now appears to be working correctly! It would be nice to know why the problem occurred in the first place, but at least my chart of accounts now appears to reflect reality. Thank you again for your input. Regards,Alan G ___ 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] Saved Report Configurations Missing After Upgrade to v3
Hi Geert I want to respond to the latest message Thu Jun 7 11:01:45 EDT 2018 to confirm that using the 2.4 transaction report does work. How do I respond to the thread for all users to see. I have read the 'more information' but am none the wiser. Cheers - Neville ___ 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] Recording stock holdings
On Aug 21, 2022, at 11:30 PM, aeg via gnucash-user wrote: I have been using GnuCash for about 6 years, starting with version 2.6 and now use 3.5 on a Windows 10 laptop. I like it very much, but have a persistent problem with entering stock investments. The day-to day financial transactions cause me no problems at all, but I've never been able to fully understand how stocks and shares are recorded and managed, and I'm frustrated that, despite following the tutorials very carefully, it never works for me as it does in the tutorial, so I hope someone can explain what's going on. I have a relatively small portfolio of shares that I've tried to enter, and the following example should illustrate the problems I've faced: Having set up the various accounts according to sections 9.4.1 and 9.4.2 of the tutorial, I then followed the instructions in section 9.5.1 to record 33 National Grid shares (NG.L) that were valued at 7.833030 GBP on 5/4/2019 as follows (note that I have used || to separate the columns): Transaction date: 5/4/2019Split 1: Brokerage Account:Stock:NG.L || 33.00 || 7.833030 || 258.49 ||Split 2: Equity:Opening Balances || || || || 258.49 However, when I press Enter, GnuCash seeks to make corrections and adds three more splits, leaving me with: Split 1: Brokerage Account:Stock:NG.L || 33.00 || 0.903030303 || 258.49 || Split 2: Trading:CURRENCY:GBP || || || 258.49 ||Split 3: Imbalance - GBP || || || 15,588,385,182,335.90 ||Split 4: Equity:Opening Balances || || || || 258.49Split 5: Trading:LSE:NG.L || || || || 15,588,385,182,594.39 Subtracting the large number in column 5 of split 5 from the large number in column 4 of split 3 equals 258.49, so why is it making any of these changes? On Monday, 22 August 2022 at 16:52:08 BST, john wrote: It's creating the splits because you have trading accounts enabled on the book, see https://wiki.gnucash.org/wiki/Trading_Accounts. I'd need to see the rest of your book to figure out why the value of that split is so large. The price change is strange too. Does it do that if you set up a new book and create just that transaction? What about upgrading to GnuCash 4.11? Regards,John Ralls Thanks John. As far as I'm aware, all of my transactions are in GBP and I've never set up any trading accounts manually, but they first appeared automatically when I recorded my holding of Santander shares and added DRIP dividends. Although that is a Spanish company, the shares and dividends are recorded in my book in GBP. I set up a new book as you suggested, and was able to enter the transaction without any problems, so when I returned to my current book, I decided to delete the troublesome account and start again. This time, when I pressed Enter, GnuCash inserted the trading account splits, but with a different set of trading account numbers: 67,487,302.84 and 67,487,044.35. (Note that the difference between those numbers is still 258.49) (Note also that I previously recorded other stocks in my original book without problems. and without trading account splits) Regarding your suggested upgrade to GnuCash 4.11, I would normally have done that by now but my last upgrade (to 3.5) resulted in the need for a substantial amount of format tweaking to create the screen layout that works for me, so I'm reluctant to rock the boat again unless I have to; (If it ain't broke, etc...) Regards,Alan G ___ 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.