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