Below is an explanation of fields you'll see on the trades export csv file.
Matches the Trade ID seen on:
Kraken.com > History > Trades
Kraken.com > Trade > Trades
Order Transaction ID.
|pair||n/a||Base currency + Quote currency.|
Includes both date + time (in UTC time zone).
But in many spreadsheet applications, only the time shows up by default. The column needs to be reformatted in the spreadsheet application to include the date.
|type||n/a||"buy" or "sell"|
|order-type||n/a||"limit", "market", "touched market" (take profit), "stop market" (stop loss), "liquidation market"|
Amount of quote currency needed to buy 1 unit of base currency.
cost = price x volume.
Amount of quote currency deducted for the volume of base currency bought.
Cost does NOT include fees.
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 export CSV 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 Ledgers CSV.
To view the fee %, you need to create a new column in the Trades CSV and use the formula: fee ÷ cost × 100%.
|vol||base currency||Amount of the base currency bought/sold.|
Amount of used margin (in quote currency).
If 5X leverage was used, then: margin ÷ cost = 20%.
"0" = non-margin trade.
"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).|