Format 2
This is a common spreadsheet format for storing share trades. It consists of the
6 fields shown below;
Date | Buy/Sell | 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. Valid
values for the Buy/Sell field are B, S , Buy and Sell and case is not important.
Example
01/12/02 |
buy |
BARC |
3000 |
4.8225 |
-14554.84 |
02/12/02 |
sell |
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 |