Improve stock handling in QIF import

Derek Atkins warlord@MIT.EDU
16 Feb 2001 15:43:06 -0500


Unfortunately this didn't solve my problem (it solved _some_ of it,
but not all of it).  I have the following GnuCash hierarchy.  All
accounts are in US Currency:

+-Assets (Asset)
|  +-Vanguard (Asset)
|     +-Treas MM (Bank, Security[Grey]="FUND:VMPXX (VMPXX)")
|     +-500 Index (Mutual Fund, Security="FUND:VFINX (VFINX)")
+-Income (Income)
   +-Dividends (Income)
      +-Mutual Fund (Income)

The accounts are all empty.  I import the following file,
500index.qif.  In the account matchups I map:

500index:500 Index	-> Assets:Vangard:500 Index
Dividends:500 Index	-> Income:Dividends:Mutual Fund
Treas MM		-> Assets:Vanguard:Treas MM

There are no other choices to make.  Once I 'finalize' the import, I
wind up with a duplicate "500 Index" account.  I at least no longer
wind up with two "Treas MM" accounts, too :) Anyways, the two "500
Index" accounts have the following (different) properties:

Name:	500 Index		500 Index 2
Desc:	Vanguard-40		QIF import: Name conflict with another account.
Sec:	FUND:VFINX (VFINX)	ISO4217:USD (US Dollar)
Type:	Mutual Fund		Stock

The currenies and parents are the same.

-derek

PS: Here is the 500index.QIF file:

!Type:Invst
D09/03/99
NBuyX    
Y500 Index
T100.00
I125.70
Q0.796
L[Treas MM]
$100.00
^
D08/06/99
NBuyX    
Y500 Index
T100.00
I120.29
Q0.831
L[Treas MM]
$100.00
^
D06/25/99
NReinvDiv
Y500 Index
T15.11
I121.50
Q0.104
^

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord@MIT.EDU                        PGP key available