Data import

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

timeequitybuy/sellamountpricecomission
2018-05-31-13.14.06equity2B20101
2018-06-04-09.32.09equity2S10141
2018-06-30-13.14.01equity1B20100,2
2018-07-01-09.32.05equity1S10142

The columns are:

* - mandatory data

Date-time format

Y
year*
m
month*
d
day*
H
hour
M
minute
S
second
* - mandatory data

Examples

PatternDate-time
Y-m-d-H.M.S2018-07-01-09.32.05
Y-m-d2018-07-01
Y/m/d-H:M:S2018/07/01-09:32:05

Import errors

Reports

Report contents

Transaction status

To understand the concept of open, partially open and closed transaction better, lets look at the example below. We have here 4 transactions:

trans. idbuy/sellamountprice
1B1010
2B2015
3B1015
4S1520

After applaying FIFO we have

trans. id_1trans_id_2amountgain
1410100
24525

The transactions status is

trans. idbuy/sellamountpricestatus
1B1010Closed
2B2015Part. open
3B1015Open
4S1520Closed

Transaction: