QIF Format Signs and Importing QIF

[sgurd4oilop]

When I import a qif file, the signs for transaction amount and shares appear to be correct: Negative shares for a sale and a positive Amount for that sale. However, when I import the QIF file transaction, it wants to import the transaction as a Sell (correct), but positive shares(?), negative price (?) and positive transaction amount (?).

Any ideas what may be happening? It looks like the import wants to use the transaction on the security side, and the QIF file appears to be from the cash side.

[Mark]

Hi sgurd4oilop,

How did you obtain this QIF file? Maybe it isn't formatted properly. For a transaction of type Sell or Buy the Q field should be positive in the QIF file. Q represents the shares. Here is an example correctly formatted QIF file for both a buy and a sell:

D3/3'10
NBuy
YDisney
I31.640000
Q240.000000
U7,601.55
T7,601.55
O7.95
^
D12/6'25
NSell
YDisney
I116.590000
Q8.577065
U1,000.00
T1,000.00
^

[sgurd4oilop]

Hi sgurd4oilop,

How did you obtain this QIF file? Maybe it isn't formatted properly.

I have a python script to convert the csv from Fidelity to QIF. It just direct maps the fields so it was confused with the signs, as the shares for sale and amounts for buys always showed up as negative in the csv.

I modded the python script and all is well now. I'm just looking for my work process flow should we not get access to Fidelity FDX/API. I just find it easier to import a QIF file than deal with the syntax and variable fields for importing csv.