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. |
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 spot position on margin. blank = if it's a trade that opens a spot position on margin, or if it's a non-margin trade. initiated = if the trade order was a taker order |
ledgers | n/a | Corresponding ledger entry IDs (one for the base currency, and one for the quote currency). |