On the transaction log page all transactional events on the specific account are shown.
This includes (but not limited to):
-
Trades (Perpetual, futures, spot and options)
-
Deposits, withdrawals, transfers
-
Position moves
-
staking rewards
In the search settings the selected time frame can be chosen from account opening up to present date. The selection can be chosen up to the nearest minute.
The transactions can be queried by filling in a search term. There can only be one search term used at once
There are many possible queries, but here are some of the most common words to search for:
-
Trade
-
Open or close
-
Buy or Sell
-
Liquidation
-
Settlement or delivery
-
Deposit or withdrawal or transfer
-
web or api or FIX
-
Instrument names or trade ID or order ID
-
Block_trade or blocktrade ID
-
Perpetual or future or option
Transaction logs can be downloaded by API or CSV.
Make the timeframe selection and query for which the CSV is to be downloaded.
The maximum length of a transaction log is 3 years. If multiple years are required to download these need to be downloaded in separate batches with a maximum length of 3 years each.
Press download logs. The log will download in the browser.
It is also possible to export the transaction log for each calendar year to an email address. You can also specify additional recipients, which can be useful if you need to send your transaction logs to e.g. an accountant or an auditor.
To retreive transaction logs via the api, the following endpoint can be used: https://docs.deribit.com/#private-get_transaction_log
Table 1. Transaction log
|
Column |
Description |
Values |
User interface |
CSV |
|---|---|---|---|---|
|
ID |
|
Number |
Not available |
✓ |
|
UserSeq |
Number corresponding to unix in ms time. |
Number |
-Not available |
✓ |
|
Date |
Date and time of the event displayed as DD/MM/YY HH:MM:ss |
Date/time |
✓ |
✓ |
|
Instrument |
The name of the traded instrument. |
Instrument name |
✓ |
✓ |
|
Type |
The type of event specified as: |
|||
|
Any trade event including liquidation trades. |
Trade |
✓ |
✓ |
|
|
Delivery of instruments, applied to Futures and Options. |
Delivery |
✓ |
✓ |
|
|
Daily settlement at 8 AM UTC. |
Settlement |
The value is shown as positive number in green if credited to balance. The value is shown as negative number in red if deducted from balance. For futures and perpetuals:
|
The aggregated value of UPL and RPL (including total funding of the session). The value is shown as positive number if credited to balance. The value is shown as negative number if deducted from balance. |
|
|
Position moves, listed per instrument. The info column will show if the position is incoming (from) or outgoing (to) specified to the account or subaccount. A buy refers to opening or increasing a long position or closing a short position on the current account. A sell refers to opening or increasing a short position or closing a long position on the current account. |
Position move |
✓ |
✓ |
|
|
Rewards received on staked assets. |
Stake reward |
need to check if UI and CSV are equal |
need to check if UI and CSV are equal |
|
|
Affiliate income. |
Affiliate |
need to check if UI and CSV are equal |
need to check if UI and CSV are equal |
|
|
Fee credit deposits. |
Fee deposit |
✓ |
✓ |
|
|
Deposits made to the account. The info column will show the deposit address. |
Deposit |
+ Transaction link included in info column |
✓ |
|
|
Withdrawals made of the account. The info column will show the withdrawal link. |
Withdrawal |
+ Transaction link included in info column |
✓ |
|
|
Transfers in or out The info column will show if the fundareis incoming (from) or outgoing (to) specified to the account or subaccount. |
Transfer funds |
✓ |
✓ |
|
|
Transfers in or out The info column will show if the fundareis incoming (from) or outgoing (to) specified to the account or subaccount. |
Transfer fee |
✓ |
✓ |
|
|
Transfer received from insurance fund in case of a liquidation and negative equity. |
Transfer from insurance fund |
✓ |
✓ |
|
|
Fees paid for negative balance if account has cross collateral enabled. |
Negative balance fee |
need to check if UI and CSV are equal |
need to check if UI and CSV are equal |
|
|
Correction payment made by Deribit. |
Correction |
✓ |
✓ |
|
|
Depreciated. Older swap transactions. |
Swap |
✓ |
✓ |
|
|
Side |
The type of event specified as: |
|||
|
A buying trade which (partially) closed a position. |
Close Buy |
Marked in green |
✓ |
|
|
A buying trade which opened or increased a position. |
Open Buy |
Marked in green |
✓ |
|
|
A selling trade which (partially) closed a position. |
Close sell |
Marked in red |
✓ |
|
|
A selling trade which opened or increased a position. |
Open Sell |
Marked in red |
✓ |
|
|
A spot trade which bought the asset. |
Spot Buy |
Marked in green |
- Not available, shown as 'Close buy'. |
|
|
A spot trade which sold the asset. |
Spot Sell |
Marked in red |
- Not available, shown as 'Close sell'. |
|
|
Settlement entry clarifying the direction of the position |
long |
Marked in green |
✓ |
|
|
Settlement entry clarifying the direction of the position |
short |
Marked in red |
✓ |
|
|
Amount |
The traded amount. Depending on the type of instrument, this may be the amount of contracts, or the amount of a specific currency. If it is a specific currency, the currency symbol will be shown beside the value. |
Value |
✓ |
Value only, no currency symbol added. |
|
Base amount |
The traded amount expressed in the base currency. An option contract with a multiplier of 10 will show 1 contract traded as 'amount' and as 'base amount' 10. If it is a specific currency, the currency symbol will be shown beside the value. |
Value in asset |
✓ |
Value only, no currency symbol added. |
|
Position |
The position size of the instrument. Long positions are a positive value, short positions are a negative value. For trades it shows the new position size with the trade size reflected in the position size. For settlements it shows the position size open at settlement. |
Value |
✓ |
✓ |
|
Price |
The price the event executed on. For trades the actual traded price. For settlements the price used as settlement price. For deliveries the price the position expired on. |
Value |
✓ |
✓ |
|
Mark Price |
The mark price of the instrument at the time of event |
Value |
✓ |
✓ |
|
Index Price |
The index price of the instrument at the time of event |
Value |
✓ |
✓ |
|
Cash Flow |
For Futures and Perpetual contracts it is the realized sessions PNL (since last settlement). For options it is the amount paid or received for the options traded. Read more on Settlement. <<< insert link >>> |
Value |
Any cash flow awaiting daily settlement is shown between brackets as (value), it is however reflected in Equity. Any cash flow that is not awaiting settlement will also be shown in the column change and is immediately accounted in Balance and Equity. Positive cash flows are shown in green. Negative cash flows are shown in red. |
For easy processing of a CSV the cashflow cell will contain one number without brackets. In the column change the actual amount that is accounted towards balance can be seen. |
|
Funding |
The funding paid or received per trade where at settlement the daily funding is shown and settled. Funding paid or received between trades in the perpetual contract, or between last trade before settlement and settlement. |
Value |
Funding is awaiting daily settlement and will be displayed between between brackets as (value). At settlement it will show the total amount of funding of the session as settlement without brackets. This value is included in the RPL value in cash flow at settlement. On the second line the value of funding generated between the last trade prior to settlement and settlement is shown between brackets as (value). This is included in the total amount of funding settled. Paid funding is displayed as negative value in red. Received funding is displayed as positive value in green. |
Funding is shown as positive (received) or negative (paid) value. The value shows the aggregated sum of funding between last event and current event and is only displayed on trades and settlements of the instrument. At settlement the funding value shows the aggregated sum of funding between last trade prior to settlement and settlement. |
|
Fee rate |
The fee rate applicable to the trade. For Futures and Perpetual it will show the maker or taker fee in percentages, for options it will show the fee in the asset. |
Value |
Fee rate displayed in percentage. The rate for paid fees is displayed as positive value in red. The rate for received fees is displayed in negative value in green. |
The percentage value is shown as given as numeric value. The rate for paid fees is displayed as positive value. The rate for received fees is displayed as negative value. |
|
Fee charged |
The fees paid or received on the trade. The value is based on the traded amount and fee rate applicable on the account |
Value |
Paid fees are displayed as positive value and in red. Received fees are displayed as negative value and in green. If the account has fee balance available the amount of fee balance used for this trade is shown on the second line between brackets as (FB: Value) |
Paid fees are displayed as positive value. Received fees are displayed as negative value. |
|
Fee Balance |
The amount of fee credits available on the account. If the account has any fee balance the fee balance will be used for any trading fees (liquidations excluded) prior to using account balances. |
Value |
✓ |
✓ |
|
Change |
Change in (Cash) Balance. For trades and deliveries this reflect any fees paid or received as well as option premium paid or received. For settlements this reflects any RPL and UPNL being settled. Funding is included in RPL. |
Value |
The change deducted from balance is displayed in negative value in red. The change credited to balance is displayed as positive value in green. |
The change deducted from balance is displayed in negative value. The change credited to balance is displayed as positive value. |
|
Balance |
Copy explanation from Balance article |
Value |
✓ |
✓ |
|
Equity |
Copy explanation from Equity article |
Value |
✓ |
✓ |
|
Trade ID |
The trade ID is a unique identifier for a matching event. Trade IDs will be numeric in which any asset which can be preceded by the asset name. A trade ID is split in two rows if the side switches with the trade. A trade size 10 which closes a -5 position and immediately opens a +5 position against the same counter trader will therefor have two entries. One as side 'close' and one as side 'open'. The trade ID will remain the same. |
Value |
✓ |
✓ |
|
Order ID |
The order ID is a unique identifier for an order. The order can result in multiple trades. Order IDs will be numeric in which any asset which can be preceded by the asset name. |
Value |
✓ |
✓ |
|
Info |
Additional information on the event:
|
text |
✓ |
✓ |
|
Note |
|
|
Not available |
✓ |