QFX imports for Investment accounts

[GT-I9070 H]

Perhaps XLSM2QIF can help!

See: http://wiki.gnucash.org/wiki/Published_tools

Regards
GTIH

2015-10-16 20:17 GMT-03:00 Allan <allanhasmail at gmail.com>:

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