Import Generic Transactions

[NewCastlePA]

In the preview screen all my transaction have a type of BUY, although there is a mix of sell and buys.

I've specified TYPE in the import format.

NAME,ED,TRAN,SYMB,ANUM,BNUM,CNUM

I am sure there are SELL in the comma delimited file, because I loaded it Excell to review.

"Synaptics Incorporated ",20141215,"SELL","SYNA",67.13,31.46,0.58
"Take-Two Interactive Software Inc. ",20141215,"SELL","TTWO",28.26,91.22,0.7
"Tech Data Corporation ",20141215,"SELL","TECD",60.63,28.91,0.48
"American Electric Power Company ",20141215,"BUY","AEP",59.19,48.3,0.71
"AT&T ",20141215,"BUY","T",32.52,87.88,0.71
"CenterPoint Energy Inc. ",20141215,"BUY","CNP",22.305,128.09,0.71

Any clues,

Thanks

[Mark]

Hi NewCastlePA,

The problem is because of double quotes. If you have double quotes in your data, then you need them in your format string too. So, use:

"NAME",ED,"TRAN","SYMB",ANUM,BNUM,CNUM

instead, which matches the format of your data.

[NewCastlePA]

Thank you