Hi Jeff,
The sample provided show the final result AFTER the matching and sorting.
So here is and example of what happens behind the scene
(Dont get overwhelmed by all the numbers thrown at you, this is accounting so what to do..)
(Basic commission fee is $22.50 + SEC Fee for sales)
Trade#1 Buy 500sh MSFT at $100 (1/10) for 50,000.00 (plus $22.50 fee)
Trade#2 Sell 200sh MSFT at $105 (1/12) for 21,000.00 (plus $23.21 fee)
Trade#3 Sell 300sh MSFT at $110 (1/15) for 33,000.00 (plus $23.61 fee)
StockTax will first sort all the trades and the match up the trades:
Jan10: +500 MSFT 50,000 + 22.50 fee
Jan12: Sold 200 for $105 for $21,000.00 + $23.21 fee (22.50+0.71 SEC fee)
StockTax will find out what you paid for these 200 shares:
$20,009.00: 200x$100 = $20,000.00 + $9.00(40% of the $22.50 fee for buying 500)
StockTax will find out what you received for these 200 shares:
$20,976.79: 200x$105 = $21,000.00 - $23.21
Actual Profit: $967.79 (4.84% of the original $20,000 invested)
Jan15: Sold 300 for $110 for $33,000.00 + $23.61 fee (22.50+ 1.11 SEC fee)
StockTax will find out what you paid for these 300 shares:
$30,013.50: 300x$100 = $30,000.00 + $13.50(60% of the $22.50 fee for buying 500)
StockTax will find out what you received for these 300 shares:
$32,976.39: 300x$110 = $33,000.00 - $23.61
Actual Profit: $2,962.89 (9.87% of the original $30,000 invested)
Now to make along story short StockTax will show in the final report:
=====================================================================
Type Shares Symbol Date Net Paid Date Net Received Gain or Loss Percent
==== ====== ====== ========== =============== ========== =============== =============== =======
Long 200 MSFT 1998/01/10 20,009.00 1998/01/12 20,976.79 967.79 4.84
Long 300 MSFT 1998/01/10 30,013.50 1999/01/15 32,976.39 2,962.89 9.87
==== ====== ====== ========== =============== ========== =============== =============== =======
TOTAL 50,022.50 53,953.18 3,930.68 7.35
FEES -69.32
Processed 14 Lines in 1 Files
3 Error(s) occured - see c:\tmp\x1.txt
========================================================================================
ACCOUNT ACTIVITIES
Total Cash In : 0.00
Total Cash Out : 10,000.00
Total Credit : 384.00
Total Debit : 0.00
Total Movements : 10,384.00
TRADE ANALYSIS
Total Trades : 2
Avg Trade Size : 25011.25 $ (400 Shares, 1.500 Orders)
Avg Trade PL : 1965.34 $ (7.86%)
Real Profit/Loss : 3930.68 $ (15.72%)
Total Long Pos. : 1 (0 Joined)
Total Short Pos. : 0 (0 Joined)
Total Positions : 1 (0 Joined)
Total Shares : 800
Total Orders : 3 (Buy 1, Sell 2)
=====================================================================
Cheers,
Burkhard (Madhur) Eichberger
(Professional Software Solutions)
pss@pobox.com |
