All transactions imported as buy

[Bob_Patton]

I've created a csv file with my transactions exported from my old PFROI program and massaged with Excel to match Fund Manager's transaction codes as well as I could. But it is importing all my transactions as buys. Can you tell me what is wrong? My import format is: YY,MM,DD,TRAN,SYMB,BNUM,ANUM,CNUM

and the first lines of my file looks like this:

1991,3,17,TXIN ,EDPB ,2.00000 ,315.000 ,0.000
1991,3,18,TXIN ,GE ,240.00000 ,67.130 ,0.000
1991,3,31,TXIN ,S ,122.00000 ,35.250 ,0.000
1993,6,28,DIST_R ,S ,0.00000 ,0.000 ,0.000
1993,6,28,SELL ,MWD ,-0.61800 ,37.190 ,0.000
1993,6,28,TXIN ,MWD ,47.61800 ,37.190 ,0.000
1993,6,28,TXOUT ,S ,0.00000 ,0.000 ,0.000
1994,5,11,SPLIT ,GE ,240.00000 ,0.000 ,0.000
1995,6,28,DIST_R ,S ,0.00000 ,0.000 ,0.000
1995,6,28,SELL ,ALL ,-0.09830 ,29.690 ,0.000

Thanks for your help.

Bob

[Mark]

Hi Bob,

The problem is a mismatch of space characters between your file and your format string. Spaces are important. For example, your first line has a space after TXIN before the comma. This means the TRAN value read in is actually "TXIN " (without the double quotes), which doesn't match any valid transaction codes, so it defaults to a buy. You have this same problem in your SYMB field. The ANUM and BNUM fields also have this problem, but since they are numeric, it doesn't hurt them, like it does the alpha fields.

To fix this, you can either fix up your file, to not have spaces, or if every line has a space, you can add a space to your format string.

Solution 1:

Make your file look like this:
1991,3,17,TXIN,EDPB,2.00000,315.000,0.000
and still use the same format string you were using.

Solution 2:

Change your format string to:
YY,MM,DD,TRAN ,SYMB ,BNUM ,ANUM ,CNUM

[Bob_Patton]

Thank you. That did the trick.

Bob