Home » Support » User Guide
 

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 have been 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/04/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 share" error has been resolved and the trades are matched correctly.

 

Return to Adjusting for Stock Splits topic