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
Bookmarks