[GNC] Corrupt security information

Bruno Acklin backlin at gmail.com
Mon Jan 6 15:39:36 EST 2020


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 <jralls at 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 <backlin at 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 <jralls at 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 <backlin at 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 <jralls at 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 <backlin at 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 <jralls at 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 <backlin at 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 <jralls at ceridwen.us> wrote:
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>>> On Jan 4, 2020, at 6:39 PM, Bruno Acklin <backlin at 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
>>>>>>>> 
>>>>>>> 
>>>>>> 
>>>>> 
>>>> 
>>> 
>> 
> 



More information about the gnucash-user mailing list