How to interpret Trades history fields
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). |
How to construct your order history
It is currently not possible to directly export your order history.
But you can easily piece together your order history by exporting your "Trades" data and then in a spreadsheet application consolidate all rows that share the same ordertxid.
Note: Trades data only shows partially or fully executed orders and not cancelled or untouched orders.
How to associate rollover fees with margin trades
You'll need to go to History > Export and do both a "ledgers" export and a "trades" export.
Method 1: Start with Trades export
To find all the rollover fees applied to a given trade, start from a given entry in the trades export.
The IDs under "ledgers" is a list of all the ledger IDs associated with that trade, including all the ledger IDs for the rollover fees assessed for that trade.
For example, you might have the following ledger IDs associated with this trade: L2UMHE-XARGI-JAYO5O, LYZAGQ-CCLOH-C7SESD, LGSVAI-5VW3I-DZJWCI, LKJSX5-LQDGJ-LC64IO. The first 3 IDs are the ledger IDs for the rollover fees and the last ID is the ledger ID for the trade that opened the spot position on margin. So in this example, assuming the position is now closed, the position was charged 3 rollover fees while it was open. Looking these 3 ledger IDs up in the ledgers export will tell you what the rollover fees were for this position.
Method 2: Start with Ledgers export
You can also go the other way to find the trade associated with a given rollover fee.
Take a given rollover fee in the ledgers export and grab it's ledger ID (it's the "txid" in the export - e.g. L2UMHE-XARGI-JAYO5O).
Now search the trades export for this txid. It will match under the "ledgers" column which is a list of all the ledger entries for a given trade. The associated trade is the trade that opened the position.
The "txid" entry for the row where you get the match is the trade ID of the associated trade (e.g. TC2YOK-QBNAA-UFAQRV). If you do a full "trades" export, the row will also have a bunch of other information about the trade (the associated order ID, volume, etc.).
We realize this is not the most convenient way of associating rollover fees with margin trades. Unfortunately, it is currently the only way, but we are developing an easier way to do this.
Why the date field on Trades export files is "missing"
We include both the time and date under the Time column, using the format:
YYYY-MM-DD HH:MM:SS.0000
The issue is that in many spreadsheet applications, dates with microseconds aren't built-in formats. So the Time column may end up being displayed with only the time value.
The date data is still there, the Time column just needs to be reformatted in the spreadsheet application to include date formatting.
Below is a screenshot of how to adjust this setting in Google Sheets:
For Microsoft Excel on Windows and MacOS:
- 1.Highlight the cells you need to format.
- 2.Right click and choose Format Cells.
- 3.Click Custom.
- 4.Enter YYYY-MM-DD HH:MM:SS.000 in the "type" field and click OK.
Note:
- •Depending on your device's language settings the above custom formula may not work. This happens because in Excel date format placeholder letters will sometimes vary with device language settings. In order to adjust the formula correctly please visit the following external Microsoft documentation, change the page language to the same one as your device and adjust the formula to your language according to the correct date and time formatting placeholders.
- •If you live in a country which uses decimal commas, then please correct it in by following our guide before adjusting the the date field formatting.
- •While we provide data to the Microsecond (four decimal places after a second) Microsoft Excel rounds time data to the nearest Millisecond (three decimal places).
If it still doesn't work:
- •Try another spreadsheet application,
- •Try a text editor to view the raw csv contents,
- •Try re-downloading your Trades export,