SL Portfolio Tracking Example

.

Account

Date

TrxType

Symbol

qty

Price Each

Fee

Cash

Notes

Share Buy

Share Sell

Cash Out

Cash In


.	Fictitious Account	12/1/2007		Account	0	1.00	0.00	10,000.00		Initial Deposit
.
.	Fictitious Account	12/3/2007	Buy	XYZ	100	1.05	0.00	105.00		Buy 50 shares	100	0	105.00	0.00
.	Fictitious Account	12/3/2007	Buy	ABC	200	4.25	0.00	850.00		Buy 100 shares	200	0	850.00	0.00
.	Fictitious Account	12/10/2007	Sell	XYZ	(50)	1.25	1.88	(60.62)		Sell 50 shares	0	50	0.00	60.62
.	Fictitious Account	12/11/2007	Buy	EFJ	500	2.19	0.00	1,095.00		Buy 500 shares - good news announcement	500	0	1,095.00	0.00
.	Fictitious Account	12/15/2007	Sell	XYZ	(25)	1.10	0.83	(26.67)		Sell 25 shares	0	25	0.00	26.67
.	Fictitious Account	12/20/2007	Sell	EFJ	(100)	3.00	9.00	(291.00)		Sell 100 shares	0	100	0.00	291.00
.	Fictitious Account	12/24/2007	Sell	ABC	(150)	4.00	18.00	(582.00)		Sell 150 shares	0	150	0.00	582.00
.	Fictitious Account	12/30/2007	Buy	XYZ	25	0.50	0.00	12.50		Buy 25 share cheap	25	0	12.50	0.00
.	Fictitious Account	12/31/2007	Sell	EFJ	(300)	2.50	22.50	(727.50)		Sell 300 shares - take profit and run	0	300	0.00	727.50
.
.	Fictitious Account	12/31/2007		Account	0	1.00	0.00	9,625.29		Ending Balance for month
.
.										Summary	Shares Bought	Shares Sold	Shares Held	Cash Out	Cash In		Realized Gain/(Loss)	Basis For Remaining Shares
.										ABC	200	150	50	850.00	582.00		(55.50)	4.25
.										EFJ	500	400	100	1,095.00	1,018.50		142.50	2.19
.										XYZ	125	75	50	117.50	87.29		16.79	0.94
.
.										Ending Period	825	625	200	2,062.50	1,687.79		103.79

.