This forum has been archived. All content is frozen. Please use KDE Discuss instead.

QIF import: investments, shares not possible?

Tags: None
(comma "," separated)
j-m-s
Registered Member
Posts
7
Karma
0
When I buy shares, in my bank account I have a transfer to my invest account (depot).
As far as I see, the qif importer ignores those records with an investment target account?
Why are they ignored completely?
zebulon
Registered Member
Posts
417
Karma
2
OS
I think the problem comes from the fact that your Investment Action code does not end in "X."
From the Wikipedia page on QIF format:
Investment Actions track common investment activities such as Dividends, Reinvestment of income, and Capital Gains (CG). Codes that end in X indicate that the transaction was generated by the account, but the cash is transferred to a different account (in which case the Category field is the destination account name). Action codes include: CGLong (Capital Gains Long Term), CGLongX, CGMid, CGMidX, CGShort, CGShortX, Div, DivX, IntInc, IntIncX, MargInt, MargIntX, RtnCap, RtnCapX, XIn, XOut, Added, Removed, StkSplit

In clear, I suspect that you have this line in your QIF file:
Code: Select all
NBuy
while you should have
Code: Select all
NBuyX
So, a transaction should look like
Code: Select all
!Type:Invst
NInvest_Account
D04.30.2016
NBuyX
YBANANACORP
Q123
I0.01
L[Target_Account]
^

You can write a script to change your QIF file and use that as an QIF import filter (see manual). Post back if you need help with that.


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Yahoo [Bot]