I have the below file. When I import transactions manually in a new portfolio with settings, "PORT,SYMB,YY/MM/DD,TRAN,ANUM,BNUM,CNUM,MEMO" multiple times, the TXIN transactions get repeated while the BUY and SELL don't. This is preventing me from periodically appending my transactions to a single file and importing it repeatedly. Although there are workarounds, I'd like to know if this is a bug or a feature.
My sample import file:
acct1,XYZ,1901/01/01,TXIN,1.0,100,0.0,line 1
acct1,XYZ,2014/06/02,SELL,1.0,50,0.0,line 2
acct1,XYZ,2014/06/03,BUY,1.0,50,0.0,line 2
acct1,ABC,2014/01/01,TXIN,1.0,100,0.0,line 1
acct1,ABC,2014/06/02,SELL,1.0,50,0.0,line 2
acct1,ABC,2014/06/03,BUY,1.0,50,0.0,line 2
Four imports gave this as a result after export:
acct1,CASH,2014/6/2,BUY,1.000000,50.000000,0.00
acct1,CASH,2014/6/2,BUY,1.000000,50.000000,0.00
acct1,CASH,2014/6/3,SELL,1.000000,50.000000,-0.00
acct1,CASH,2014/6/3,SELL,1.000000,50.000000,-0.00
acct1,XYZ,1901/1/1,TXIN,1.000000,100.000000,1/1/1901:0.000000:0.000000
acct1,XYZ,1901/1/1,TXIN,1.000000,100.000000,1/1/1901:0.000000:0.000000
acct1,XYZ,1901/1/1,TXIN,1.000000,100.000000,1/1/1901:0.000000:0.000000
acct1,XYZ,1901/1/1,TXIN,1.000000,100.000000,1/1/1901:0.000000:0.000000
acct1,XYZ,2014/6/2,SELL,1.000000,50.000000,-0.00
acct1,XYZ,2014/6/3,BUY,1.000000,50.000000,0.00
acct1,ABC,2014/1/1,TXIN,1.000000,100.000000,1/1/2014:0.000000:0.000000
acct1,ABC,2014/1/1,TXIN,1.000000,100.000000,1/1/2014:0.000000:0.000000
acct1,ABC,2014/1/1,TXIN,1.000000,100.000000,1/1/2014:0.000000:0.000000
acct1,ABC,2014/1/1,TXIN,1.000000,100.000000,1/1/2014:0.000000:0.000000
acct1,ABC,2014/6/2,SELL,1.000000,50.000000,-0.00
acct1,ABC,2014/6/3,BUY,1.000000,50.000000,0.00
Thanks for your considerations.