QFX imports for Investment accounts

[Al]

The first, and only the first import. I was asked for "What Account" and I pointed it to MY BROKERAGE ACCOUNT NAME. It then said "NEW ACCOUNT" with GBM as the account name, type = stock and Parent = Brokerage Account. If I point it to MY BROKERAGE ACCOUNT NAME, I get an error window saying Account already exists. So I point it to my existing GBM stock account and it goes to the next screen and it displays a green colored entry ready to accept import. At this point I have a new account as a child of my original GBM stock account with the name GBM and the imported transaction data. 
Your suggestion about deleting and choosing to MOVE the data does work and I end up with the transaction data added to my existing GBM account and the 'new child account' gone. . It is however incomplete as there is no commission entry. This is unexpected as I am certain that data is actually in the QFX file because Quicken puts this data in its transaction file after import. So yes, thank you, your suggestion does help a bit.
 I take that calc2qif is about a CSV import. That is available but not a QIF.

Thanks
Al
      From: Allan <allanhasmail at gmail.com>
 To: gnucash-user at gnucash.org 
 Sent: Friday, October 16, 2015 7:17 PM
 Subject: Re: QFX imports for Investment accounts
   
I've gotten this to work creating a QIF using the CALC2QIF macro and GC 
... 2.6.8 I think it is. During
the import, I tell GC to use the parent of all my stock accounts (i.e. 
Asset:Investment:Stock  not ..:Stock:IBM)
and it finds the sub accounts properly. ....
I wonder if it's the ... what is it? Baysian matching business of 
accounts that's confused. I think I saw
this once but it went away or something.

You give the importer: "What account? You say 
Assets---Investments---Brokerage Accounts---Stocks------
  "MY BROKERAGE COMPANY NAME"?

And it creates (top level) Brokerage Accounts:GBM ? not
Investments---Brokerage Accounts---Stocks------  "MY BROKERAGE COMPANY 
NAME":GBM?

If you could document step by step with me, we could compare notes. I 
have a few trades to do now anyway...

Like Dave said, I thought of when you delete accounts with transactions, 
... the dialog to say "Do you
want to move them somewhere before deleting?" Which would at least help 
a bit.

I'm getting happier using GC with CALC2QIF importing working, saving a 
lot of typing but it was a B****
getting it figured out. Sometimes... IDK. Free software has an 
alternative price to money.

Allan

On 10/16/2015 05:34 PM, David Carlson wrote:
> On 10/14/2015 2:47 PM, Al wrote:
>>  I am unable to get QFX imports to interact correctly with my existing
>>  investments accounts.
>>
>>  Example. I have under Assets---Investments---Brokerage 
>> Accounts---Stocks------
>>  "MY BROKERAGE COMPANY NAME" ; under which I have an account for 
>> each Stock (for
>>  example Gnu Business Machines),  Within this account I have 2
>>  historical transactions (BUY/SELL, Imported via QIF)) and the 
>> current view
>>  shows.....GNU Business Machines  0 GBM...... which is correct, at
>>  least the data is..
>>
>> My QFX file has a Buy Trade for GBM and when imported I get a New 
>> Account
>> Window showing GBM as a new Account, Type= stock, Parent Account= 
>> Brokerage
>> Accounts. I can change the Parent Account to indicate where my 
>> existing GBM
>> account lives, but no matter, when I OK the import I have a "New" GBM 
>> account
>> with the correct trade info per this QFX file. So now I have two GBM
>> accounts.  Another Import generates a another New Account as a sub 
>> account of
>> the prior import's new account. .  So every import creates a new account
>>  rather than adding new entries to my original GBM stock account and 
>> every new
>> account is a sub account of the prior import containing transaction 
>> data.
>>
>> I cannot seem to solve this issue on my own, your help will be 
>> greatly appreciated.
>> Final comment. I also have a separate file with Bank accounts and I 
>> have no problems
>> with importing QFX files.  New data is entered where old date lives 
>> and life
>> is good.
>>
>>  Thanks  Al
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> Al,
> I do not use the OFX/QFX import for investment transactions, but I did 
> notice that you do not mention whether it is possible for you to 
> manually correct those imported transactions to the correct accounts 
> in a manner similar to fixing a grocery store or gasoline station 
> transaction that was incorrectly guessed by GnuCash.  It seems to me 
> that should work for investment transactions too.
>
> David C


> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> 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 at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.