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.

Reply via email to