[GNC] Corrupt security information

John Ralls jralls at ceridwen.us
Sun Jan 5 23:31:58 EST 2020


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