Yes, this did the trick!! Thanks for the great coaching, John! I guess the takeaway is that the origin of bug https://bugs.gnucash.org/show_bug.cgi?id=797512 <https://bugs.gnucash.org/show_bug.cgi?id=797512> could be a double entry in the trading account.
I just found that I had other stocks with two or even three trading accounts; it seems that when I change the name of a stock, for instance when yahoo does so, eg from NESN.VX to NESN.SW, GnuCash creates another trading account, rather than renaming the existing one. Now I am trying to find out why the lot scrubber sometime insists to create two identical Realized Gain/Loss entries.. Best regards, Bruno > On Jan 6, 2020, at 10:11 AM, John Ralls <jra...@ceridwen.us> wrote: > > Bruno, > > First delete the test transactions and the gain/loss transactions. Then > delete Trading:NASDAQ:INTC. Save. > > You can try moving Trading:NYSE:INTC to Trading:NASDAQ:INTC (use Edit Account > and change the parent account to Trading:NASDAQ with the selector at the > bottom). While you're in the account editor check the commodity and make sure > that it's set to NASDAQ INTC and not NYSE INTC. > > Try running the Lot scrubber. If the G/L transactions are created correctly > then try your test transactions. > > If either fails you can quit GnuCash without saving to clear out the bad > transactions. > > Regards, > John Ralls > >> On Jan 6, 2020, at 9:29 AM, Bruno Acklin <back...@gmail.com> wrote: >> >> Hi John, >> >> Yes, a great feature if it worked fully, but.. (one of its flawed features >> is that one does not have control over when it generated Realized Gain/Loss >> entries.) >> >> Sorry to confuse you. The number of transactions does not tie: I have 5 >> trades, which are reflected in trading/NYSE/INTC, plus 2 test trades I >> entered using the NASDAQ/INTC security with the previously described >> problem. Then the lot scrubber generated 5 Gain/Loss entries also tied to >> the NASDAQ/NYSE account, and apparently unbalanced (same amount in >> Trading/NASDAQ/INTC, Orphaned Gains and (negative in Trading/Currency/USD)). >> Strangely, the initial purchase in the asset account against /NYSE/INTC is >> unbalanced and is reflected once in the Trading/NYSE/INTC and twice in the >> Trading/NASDAQ/INC account.. - all stuck in unbalanced. >> >> Do you agree that I should delete one of these trading accounts? If I delete >> Trading/NYSE/INTC I probably loose my correct transactions (saved). If I >> delete the Trading/NASDAQ/INTC account can rename the Trading/NYSE/INTC to >> Trading/NASDAQ/INTC? >> >> Best regards, >> Bruno >> >> >>> On Jan 5, 2020, at 8:31 PM, John Ralls <jra...@ceridwen.us> wrote: >>> >>> Bruno, >>> >>> Ugh, the lot scrubber. Another variable in the problem. >>> >>> Now I'm confused about the two trading accounts because you say that you've >>> got 5 trades in the asset account and each trading account. Do you have >>> splits both INTC trading accounts for one transaction? What about >>> Trading:CURRENCY:USD? >>> >>> Regards, >>> John Ralls >>> >>>> On Jan 5, 2020, at 3:17 PM, Bruno Acklin <back...@gmail.com> wrote: >>>> >>>> I don’t think I have more than one asset account for INTC, and none of the >>>> trading accounts shows any transactions outside of the one I am using. >>>> I am pretty sure I did not create a 2nd asset INTC (and doubt Gnucash >>>> would have let me), but I may have edited / moved it from NYSE to INTC in >>>> the security editor (which answers my last question, I guess ;-). >>>> No worries, only about 5 trades in the asset account (and each trading >>>> account); I am mostly worried about loosing 20 years of pricing history, >>>> which is why I was looking for a way to export. >>>> >>>> The issue came up when I started using Actions/View lots for calculating >>>> cap gains (working, but would need some work, such as an indication of the >>>> purchase date or lot in the automated entry, or way to define/edit a new >>>> lot, I think..) >>>> >>>> Best regards, >>>> Bruno >>>> >>>> >>>> >>>> >>>>> On Jan 5, 2020, at 2:56 PM, John Ralls <jra...@ceridwen.us> wrote: >>>>> >>>>> That's interesting. Do you have more than one INTC asset account, perhaps >>>>> with different brokers (and perhaps hidden on your Accounts page either >>>>> because you marked it hidden or have hide accounts with 0 balances turned >>>>> on)? When you realized that INTC trades on NASDAQ and not NYSE did you >>>>> edit the security or make a new one? >>>>> >>>>> How many transactions are in each account? >>>>> >>>>> Regards, >>>>> John Ralls >>>>> >>>>>> On Jan 5, 2020, at 2:34 PM, Bruno Acklin <back...@gmail.com> wrote: >>>>>> >>>>>> Thanks John, >>>>>> >>>>>> I had a suspicion that this may be due to an ambiguous trading account: >>>>>> I had noticed that originally some transactions appeared under NYSE/INTC >>>>>> while my present security and prices are all under NASDAQ/INTC. There is >>>>>> no security defined under NYSE/INTC, but there is a trading account with >>>>>> that name (which has correct transactions and behaves normally), and one >>>>>> under Trading/NASDAQ/INTC with phony transactions ($number in the >>>>>> increase column instead of INTC shares), which is also caught in a >>>>>> rebalance loop. >>>>>> >>>>>> Should I just delete one of the two trading accounts, and which one? I >>>>>> lean towards the NASDAQ one with the phony entries and then try to move >>>>>> INTC from NYSE to NASDAQ - how? >>>>>> >>>>>> Best regards, >>>>>> Bruno >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>> On Jan 5, 2020, at 11:22 AM, John Ralls <jra...@ceridwen.us> wrote: >>>>>>> >>>>>>> Bruno, >>>>>>> >>>>>>> Don't do anything drastic yet, but everything is pretty independent. >>>>>>> You could change the name on the old INTC and create a new INTC >>>>>>> security and GnuCash will happily use your INTC prices for pricing the >>>>>>> new security. They're linked by the security name and namespace, not by >>>>>>> GUID. Unfortunately GnuCash won't let you reassign the account but you >>>>>>> can create a new one and transfer the balance with a transaction. >>>>>>> >>>>>>> Regards, >>>>>>> John Ralls >>>>>>> >>>>>>>> On Jan 5, 2020, at 9:37 AM, Bruno Acklin <back...@gmail.com> wrote: >>>>>>>> >>>>>>>> Hi John, >>>>>>>> >>>>>>>> Thanks for the impressively quick reply - and yes, I agree this looks >>>>>>>> like the same problem! >>>>>>>> Unfortunately there does not seem to be another fix than recreating >>>>>>>> the stock, account and transactions.. >>>>>>>> >>>>>>>> Do you know of a way I might preserve the 20 years of price data I >>>>>>>> have on that stock? I saw a suggestion to create a suitable report and >>>>>>>> reimport the resulting file, but I dd not see any report that would >>>>>>>> allow me to save price information. >>>>>>>> >>>>>>>> Best regards, >>>>>>>> Bruno Acklin >>>>>>>> (408) 425 4753 >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>>> On Jan 4, 2020, at 7:43 PM, John Ralls <jra...@ceridwen.us> wrote: >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>>> On Jan 4, 2020, at 6:39 PM, Bruno Acklin <back...@gmail.com> wrote: >>>>>>>>>> >>>>>>>>>> Best wishes for 2020! >>>>>>>>>> >>>>>>>>>> I am struggling with a stock account, where I am unable to enter any >>>>>>>>>> valid transactions, and suspect the security information may be >>>>>>>>>> corrupted: >>>>>>>>>> >>>>>>>>>> Whenever I enter a trade from the account (declared as stock for an >>>>>>>>>> existing security INTC) and press return, Gnucash completes a >>>>>>>>>> transaction (cf attachment), which looks ok, except there is no >>>>>>>>>> shares traded and there is no way to enter any quantity on the >>>>>>>>>> trading account. Gnucash insists on balancing the transaction, after >>>>>>>>>> which there is a huge number in the trading/share account, but still >>>>>>>>>> no quantity of shares traded, and no way to complete the >>>>>>>>>> transaction, other than closing the account tab. >>>>>>>>>> >>>>>>>>>> I checked the security and my price information which looks ok and >>>>>>>>>> updates w/ finance::quote. If I have to recreate the account and >>>>>>>>>> reenter all transactions, I’d like to save the historic price >>>>>>>>>> information, but don’t know of a way to export it. >>>>>>>>>> >>>>>>>>> >>>>>>>>> That sounds like a variation on >>>>>>>>> https://bugs.gnucash.org/show_bug.cgi?id=797512. >>>>>>>>> >>>>>>>>> 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.
