Trying to Import .CSV file of buys & sells

[gph65]

Hello,

I'm trying to figure out the format string for importing .csv of buys and sells. The import isn't working. I've looked at the help file on importing Generic and am still clueless. Any help appreciated in ordering the format string. Also, do I need to include the totals? (shares x price = x?). Also, fee is 1% of total portfolio, not per transaction. Thanks for any help with this.

Here's the Notepad file of the .csv transactions.

Date,Investment Name,Type,Price,Shares,Total,Fee
12/14/12,WDC,BUY,37.82,46,"$1,739.72-",
11/15/12,SAVE,BUY,16.914,27,$456.69-,
11/15/12,PDLI,BUY,7.207,220,"$1,585.69-",
11/15/12,NVDA,BUY,11.61,136,"$1,579.18-",
11/15/12,CACI,BUY,50.482,31,"$1,564.97-",
11/15/12,BAH,BUY,13.5599,117,"$1,586.51-",
11/15/12,WCRX,BUY,11.86,136,"$1,613.78-",
11/15/12,MRVL,BUY,7.494,214,"$1,603.87-",
11/14/12,WU,SELL,12.59,91,"$1,145.66 ",
11/14/12,VPHM,SELL,23.982,52,"$1,247.05 ",
11/14/12,UTHR,SELL,49.318,34,"$1,676.80 ",
11/14/12,SAI,SELL,11.03,128,"$1,412.93 ",
11/14/12,NOC,SELL,64.627,26,"$1,680.26 ",
11/14/12,ABC,SELL,40.57,32,"$1,298.21 ",
08/15/12,NUS,BUY,42.86,39,"$1,671.66-",
08/15/12,JCOM,BUY,28.572,59,"$1,685.79-",
08/15/12,EXPR,BUY,15.615,106,"$1,655.19-",
08/15/12,DLX,BUY,28.19,60,"$1,691.67-",
08/15/12,CHE,BUY,63.54,10,$635.40-,
08/15/12,APOL,BUY,27.763,60,"$1,665.81-",
08/15/12,STX,BUY,34.09,49,"$1,670.57-",
08/14/12,IDCC,SELL,31.778,42,"$1,334.68 ",
08/14/12,ICON,SELL,18.232,79,"$1,440.32 ",
08/14/12,FRX,SELL,33.95,51,"$1,731.53 ",
08/14/12,AMAT,SELL,11.78,125,"$1,472.77 ",
08/14/12,ADI,SELL,40.422,41,"$1,657.29 ",
05/15/12,VECO,BUY,36.74,41,"$1,506.35-",
05/15/12,HFC,BUY,28.606,51,"$1,458.93-",
05/15/12,CSCO,BUY,16.597,91,"$1,510.41-",
05/15/12,CF,BUY,165.57,9,"$1,490.14-",
05/15/12,BKE,BUY,42.38,25,"$1,059.62-",
05/15/12,HLF,BUY,42.455,35,"$1,485.95-",
05/14/12,SNDK,SELL,36.14,34,"$1,228.74 ",
05/14/12,MYGN,SELL,25.704,69,"$1,773.58 ",
05/14/12,MRX,SELL,37.929,48,"$1,820.57 ",
05/14/12,EME,SELL,27.95,54,"$1,509.26 ",
05/14/12,ATVI,SELL,12.6,131,"$1,651.08 ",
02/14/12,WU,BUY,17.54,91,"$1,596.26-",
02/14/12,VPHM,BUY,31.459,52,"$1,635.90-",
02/14/12,UTHR,BUY,47.07,34,"$1,600.51-",
02/14/12,SNDK,BUY,47.02,34,"$1,598.68-",
02/14/12,SAI,BUY,12.566,128,"$1,608.56-",
02/14/12,NOC,BUY,59.92,26,"$1,557.92-",
02/14/12,MYGN,BUY,23.1,69,"$1,594.09-",
02/14/12,MSFT,BUY,30.03,53,"$1,591.59-",
02/14/12,MRX,BUY,33.58,48,"$1,611.85-",
02/14/12,KLAC,BUY,49.28,32,"$1,576.96-",
02/14/12,IDCC,BUY,37.03,42,"$1,555.51-",
02/14/12,ICON,BUY,20.7,79,"$1,635.32-",
02/14/12,ESI,BUY,72.93,22,"$1,604.46-",
02/14/12,GME,BUY,22.93,70,"$1,605.56-",
02/14/12,FRX,BUY,31.56,51,"$1,609.66-",
02/14/12,EME,BUY,29.813,54,"$1,609.94-",
02/14/12,DLB,BUY,37.34,43,"$1,605.62-",
02/14/12,DELL,BUY,17.92,89,"$1,595.05-",
02/14/12,BPI,BUY,26.37,61,"$1,609.09-",
02/14/12,AMAT,BUY,12.78,125,"$1,597.88-",
02/14/12,AAPL,BUY,502.77,3,"$1,508.31-",
02/14/12,ADI,BUY,39.34,41,"$1,612.94-",
02/14/12,ABC,BUY,37.46,32,"$1,198.72-",
02/14/12,ATVI,BUY,12.367,131,"$1,620.09-",

[Mark]

Hi gph65,

No, you don't need the transaction total. You do need the commission fee though. You must have the value of the commission fee, you can't tell it "1% of the total". Or, you can just set the fee on a per-transaction basis to $0, and record an account fee for the total you were charged. You would put that in whatever investment it was taken out of, like cash. So, change your importing file to look like this:

Date,Symbol,Type,Price,Shares,Fee
12/14/12,WDC,BUY,37.82,46,0

and then when you import, you would use a format string of:

MM/DD/YY,SYMB,TRAN,ANUM,BNUM,CNUM

Note, even if the fee is $0, you still must have a 0 in the file, it can't be blank.

[gph65]

Hi Mark,

Thanks for your response above. In the general transaction import screen, I keep getting a message “Could not find all specified fields in the importing file.” It looks like I have all the specified fields: UD,SYMB,TRAN,ANUM,BNUM,CNUM so I cant figure out why I keep getting this message. I’ve also tried MM/DD/YY,SYMB,TRAN,ANUM,BNUM,CNUM.

A line in the .csv file looks like this: 12/14/12,WDC,BUY,37.82,46,0

[Mark]

Hi gph65,

For a line like:

12/14/12,WDC,BUY,37.82,46,0

That will import with the format string of:

MM/DD/YY,SYMB,TRAN,ANUM,BNUM,CNUM

I just tested this here to make sure, and it did import okay. If you're still having troubles, please try copying/pasting the format string from above. If that doesn't help, try attaching a small sample CSV file back to a post here, and let me know the exact format string you're using.

[gph65]

Worked! Thanks Mark