Re: [GNC] Corrupt security information

2020-01-06 Thread Bruno Acklin
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 could be a double entry in the trading account. I just found that I had other stocks w

Re: [GNC] Corrupt security information

2020-01-06 Thread John Ralls
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 a

Re: [GNC] Corrupt security information

2020-01-06 Thread Bruno Acklin
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, p

Re: [GNC] Corrupt security information

2020-01-05 Thread John Ralls
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:U

Re: [GNC] Corrupt security information

2020-01-05 Thread Bruno Acklin
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 se

Re: [GNC] Corrupt security information

2020-01-05 Thread John Ralls
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

Re: [GNC] Corrupt security information

2020-01-05 Thread Bruno Acklin
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 acco

Re: [GNC] Corrupt security information

2020-01-05 Thread John Ralls
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. Unfort

Re: [GNC] Corrupt security information

2020-01-05 Thread D via gnucash-user
Historical price data is available on the web (e.g., Yahoo! or Alphavantage), and can be imported into the price db from csv or tab files pretty easily. On January 5, 2020, at 11:09 PM, Bruno Acklin wrote: Hi John, Thanks for the impressively quick reply - and yes, I agree this looks like the

Re: [GNC] Corrupt security information

2020-01-05 Thread Bruno Acklin
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?

Re: [GNC] Corrupt security information

2020-01-04 Thread John Ralls
> On Jan 4, 2020, at 6:39 PM, Bruno Acklin 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 f

[GNC] Corrupt security information

2020-01-04 Thread Bruno Acklin
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