How to interpret Trades history fields

History-Export-Trades.png

Below is an explanation of fields you'll see on the trades export csv file.

Field Currency unit Description
txid n/a

Transaction ID; used for each partial execution of an Order (one Order may have multiple executions).

ordertxid n/a

Order ID.

For an order executed in multiple parts, the Order ID will be the same for each execution. Only the Transaction ID will be different/unique.

pair n/a Base currency + Quote currency.
time n/a

Includes both date + time (in UTC time zone).

But in some spreadsheet applications, only the time might show up by default.

type n/a "buy" or "sell"
order-type n/a "limit", "market", "touched market" (take profit), "stop market" (stop loss), "liquidation market"
price quote currency

If type is "buy", then "price" is the amount of quote currency needed to buy 1 unit of base currency.

If type is "sell", then "price" is the amount of quote currency received for selling 1 unit of base currency.

cost quote currency

cost = price x volume.

If type is "buy", then cost is the amount of quote currency deducted for the base currency purchased.

If type is "sell", then cost is the amount of quote currency received for the base currency sold.

Cost does NOT include fees and is NOT the amount paid to Kraken (a common misunderstanding).

fee quote currency

Amount of quote currency paid to Kraken as commission for the trade.

Note: this is not necessarily the fee that was deducted from your account! If you've set your fees to be deducted in the base currency, the Trades history will still show the fee value in the quote currency. To see exactly what fees were deducted and in which currency, you need to refer to the Ledger history.

The fee % is the fee ÷ cost × 100%.

vol base currency Amount of the base currency bought/sold.
margin quote currency

Amount of used margin (in quote currency).

If 5X leverage was used, then: margin ÷ cost = 20%.
If 4X leverage was used, then: margin ÷ cost = 25%.
If 3X leverage was used, then: margin ÷ cost = 33.33%.
If 2X leverage was used, then: margin ÷ cost = 50%.

"0" = non-margin trade.

misc n/a

"closing" = if it's a trade that closes a margin position.

blank = if it's a trade that opens a margin position, or if it's a non-margin trade.

ledgers n/a Corresponding ledger entry IDs (one for the base currency, and one for the quote currency).