Manual (in progress)




Explanation of import messages


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. Example data 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: