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.
