capital gains calculator
capital gains calculator

Format 1

This is a common spreadsheet format for storing share trades. It consists of the 5 fields shown below;

Date | Company | Shares | Price | Total

The "Total" field stores either the net proceeds on a sell or the total cost on a buy. This value is negative for a buy and almost always positive for a sell. For buys stamp-duty is assumed to be 0.5%.


Example
01/12/02 BARC 3000 4.8225 -14554.84
02/12/02 BARC 3000 4.91 14715.00

The result in correct format
B 01/12/2000 BARC 3000 4.8225 15.00 72.33
S 02/12/2000 BARC 3000 4.91 15.00 0.00