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 |
