BUY SELL
date ref holdings price
1/1/2011 FO48723 5 6 1290
1/1/2011 FO48724 3 4 1292
1/1/2011 FO48725 2 6 1294
1/1/2011 FO48726 6 3 1296
1/1/2011 FO48727 4 4 1302
1/1/2011 FO48728 1 1 1304
1/1/2011 FO48729 4 5 1306
eg: 5 holdings bought ref:FO48723 and 6 holdings sold @ price:1290. i want 6 holdings to go on FIFO method. that means 5 holdings under ref:FO48723 @ 1290. i insert another row, 1 holding go under ref:FO48724 @ 1292. then another 2 holdings remaing (REF:FO48724)
date ref holdings price
1/1/2011 FO48723 5 6 1290
1/1/2011 FO48724 3 4 1292
1/1/2011 FO48725 2 6 1294
1/1/2011 FO48726 6 3 1296
1/1/2011 FO48727 4 4 1302
1/1/2011 FO48728 1 1 1304
1/1/2011 FO48729 4 5 1306
eg: 5 holdings bought ref:FO48723 and 6 holdings sold @ price:1290. i want 6 holdings to go on FIFO method. that means 5 holdings under ref:FO48723 @ 1290. i insert another row, 1 holding go under ref:FO48724 @ 1292. then another 2 holdings remaing (REF:FO48724)
