Example of Stock Split Adjustment

 
The scenario:
 
  • On 10/04/2005, John bought 500 shares of AMCC.
     
  • A "2 for 1" stock split occurred on 10/15/2005.
     
  • On 11/02/2005, he sold 1000 "post-split" shares.
     
  • This caused a negative shares condition in TradeLog, as more shares were sold than were previously bought.
 
Tr
Date
O/C
L/S
Ticker
  Shares
Price
    Comm
Amount
58
10/4/2005
O
  L
    AMCC
500
200.5
$14.95
($100,264.95)
58
11/2/2005
C
  L
    AMCC
1000
102.25
$14.95
$102,235.05
Open Shares:     -500
 
To correct this, the "pre-split" opening transaction must be adjusted:
 
  • John finds and selects the opening transaction, clicks Edit, Adjust for Stock Split, enters the appropriate ticker (AMCC), split ratio ("2" for "1") and leaves the split date set at 10/4/2005) and clicks OK.
     
  • The "pre-split" transaction is adjusted accordingly:  the number of "pre-split" shares are doubled and the price is halved (see below).
 
Tr
Date
O/C
L/S
Ticker
  Shares
Price
    Comm
Amount
58
10/4/2005
O
  L
    AMCC
1000
100.25
$14.95
($43,767.95)
58
11/2/2005
C
  L
    AMCC
1000
102.25
$14.95
$102,235.05
Open Shares:     0
 
The "negative shares" error has been resolved and the trades are matched correctly.