Imported file format
Import file TransCalc takes as an input a list of transactions stored in a CSV (comma separated value) file. The CSV file is usually exported from a broker service. An example file is included which may look like
time | equity | buy/sell | amount | price | ccomission |
2018-05-31-13.14.06 | equity2 | K | 20 | 10 | 1 |
2018-06-04-09.32.09 | equity2 | S | 10 | 14 | 1 |
2018-06-30-13.14.01 | equity1 | K | 20 | 10 | 0,2 |
2018-07-01-09.32.05 | equity1 | S | 10 | 14 | 2 |
The columns are:
- datetime - transaction date and time*
- equity - name of an equity
- buy_sell - the buy or sell indication. If omitted, the sign (+ or -) of the amount decides about the direction of a trade.
- amount - number of traded shares*
- price - price for a single share*
- commission - transaction commission/provision
* - mandatory data
Date-time format
- Y - year*
- m - month*
- d - day*
- H - hour
- M - minute
- S - secunde
* - mandatory data
Examples
Pattern | Date-time |
Y-m-d-H.M.S | 2018-07-01-09.32.05 |
Y-m-d | 2018-07-01 |
Y/m/d-H:M:S | 2018/07/01-09:32:05 |
Import errors
- Date error:
date or time format in the imported file doesn't not match the format given in the field "Date-time format".
- Buy/sell error:
you defined a column with trade direction, which requires "B" letter for buy transaction and "S" letter for sell transaction. The data in the column doesn't match this pattern.
- Provision error:
the data in column 'provision' is not valid.
- Price error: the data in column 'price ' is not valid.
- Data incomplate: The data doesn't have all mandatory fields - date-time, price and amount. If the mandatory data exists check the columns separator.
Transaction status
- Closed:
- Open:
- Partially open: