Re: [GNC] Corrupt security information

[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 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  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  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  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  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  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  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 

Re: [GNC] Corrupt security information

[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 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  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  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  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  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  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  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 

Re: [GNC] Corrupt security information

[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, 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  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  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  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  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  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  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 

Re: [GNC] Corrupt security information

[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:USD?

Regards,
John Ralls

> On Jan 5, 2020, at 3:17 PM, Bruno Acklin  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  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  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  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  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  wrote:
>> 
>> 
>> 
>>> 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 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 

Re: [GNC] Corrupt security information

[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 
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  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  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  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  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  wrote:
> 
> 
> 
>> 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 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 

Re: [GNC] Corrupt security information

[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 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  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  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  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  wrote:
 
 
 
> 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 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.

Re: [GNC] Corrupt security information

[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 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  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  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  wrote:
>>> 
>>> 
>>> 
 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 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.

Re: [GNC] Corrupt security information

[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. 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  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  wrote:
>> 
>> 
>> 
>>> 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 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.

Re: [GNC] Corrupt security information

[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 
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  wrote:
> 
> 
> 
>> 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 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.
___
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.

Re: [GNC] Corrupt security information

[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? 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  wrote:
> 
> 
> 
>> 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 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.

Re: [GNC] Corrupt security information

[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 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.