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.
