I have been building a capital gain loss report and want to add an item.

Column E shows the action as buy or sell. Once in a while a stock gets split or reverse split.

Split: IE: Own 1,000 shares of ABC stock currently $100 per share. The stock gets split 10:1 and so then I would have 10,000 shares of ABC stock at $10.

Reverse Split: IE: Own 10,000 shares of ABC at $10 per share. The stock gets reverse split 1:10 and so then I would have 1,000 at $10 per share.

I would like to add this scenario as a possible action to Column E but not sure if it can be done as columns M,N,O,P need to stay the same.

Would appreciate guidance on this. Thanks. Capital Gains Reportb.xls