Deribit import of swaps & option trades via API or CSV

I understand that you guys currently do not import trade and swap transactions via the API but only deposits, withdrawals and P&L.

Is this feature on the agenda for the near future? If not via API then via CSV (deribit log export)?

Cheers

At this time, the API information that we receive from Deribit does not send the data that you requested. When Deribit does add that information to their API, then we will certainly add them to Accointing :smiley:

@Matt. Thanks, appreciate it, I gathered as much from the existing threads on this topic.

If the information is not available via API at the moment, any chance you guys can add this feature via CSV import of the Deribit log file (=transactions) - as you already do it for other exchanges, e.g. bitcoin.de.

1 Like

Please fill in any missing transactions by going to full data set and on the top left, you can add a transaction.
OR
You can go to your wallets page and add the .CSV file (reformat it to match Accointing’s format).

  1. Edit your Deribit connection - image
  2. Click on Manually
  3. Follow the steps (Please exclude any transactions that was already added through the API.

Can you please try to contact Deribit? I will do it as well.
A tax train wreck is coming for German users.

Deribit sometimes makes 20 log entries for 1 trade. For tax compliance reasons we will have to file taxes on a trade (example: if I buy and sell one contract for a call option, that one trade that has to be accounted for taxes. Profit and loss is summed together.

Grouping by transactions (log entries)-> the sum of the wins in Fiat is high and so the losses
Grouping by trades → the sum of wins in Fiat is less than above. The same for the losses.

Now in Germany in 2021 we can only deduct a certain amount of losses per year. (20.000 EUR). If amount of Fiat Gains is artificially high we have to pay a lot of taxes unnecessarily.

Dear Matt,

Here is the answer from Deribit:

Hi,
*we provide trade and swap transaction log via this end-point *
https:// docs.deribit.com/ #private-get_transaction_log

can you help us? I insert two void spaces or else it will not show it here. Please remove the void if you want to look up.

Thanks.

Thanks, Matt. That is, of course, possible but I have to admit that I am loath to invest the substantial time required to manually map the deribit transactions - by trial and error - to your accointing classifications (margin_gain, margin_fee, …) without knowing the implications for the tax report. That is, ultimately, what I pay accointing for. Feel free to reach out to me to talk about a consulting contract with me. :wink:

I think there are already a lot of people trading in options that would appreciate the deribit integration, with deribit being the absolute market leader (ex US). And the user base will only grow, so that will be a valuable offering for you guys in the future. And thanks to @Poorboy 's clarification an API integration seems possible.

Let us know how we can get this feature request prioritized please.

Thanks for clarifying w/ deribit. Fully agree on the train wreck… It is imperative that Accointing is automatically importing Deribit transactions to treat it correctly in our tax returns. For me, this is becoming a go / no-go feature for using accointing.

Hey guys, we currently support Deribit


If you are experiencing an issue when trying to add your data, please fill out this form:

In the form please also leave a link to this post so that we have background context :slight_smile:

For Germany you have to aggregate the transactions on a per trade basis. Or Else you are going to pay too much… and I am above the 20.000 euro limit that you can offset with losses.

@secondaryrealms Maybe you can fill in the ticket as well? I will do it over the weekend.

done…

1 Like

Hi Matt + whole group!

I agree with the others that this issue needs to be fixed. In the meantime, for the 2021 tax return please educate me how to add transactions manually. There is no „coin“ for each deribit option obviously. if I look to FTX, they only record fees and margin gains/losses on an hourly basis. But his is hard to do manually. So taking a current example

ETH 10k March 2022 call option: currently 0,0215 ETH at deribit. Assume I buy one, the fees are automatically recorded via API. Which order do I record manually?

Thanks,
Clemens

1 Like

Can someone please email us your Read-only API keys as well as a .csv of this so that we can look into this deeper?
Tell them that Matt sent you:

1 Like

sent per private message

1 Like

Hi Matt,

while we’re waiting to have you guys update/fix your API (open since Nov last year) - how do I enter the purchase and sales of options manually via your manual upload of data? As “type” of transaction you offer “withdraw (send)”, “deposit (receive)”, “order” and “internal”. Now if I choose “order” here which fits best I can’t specify what I bought under “Amount bought” because it’s not a currency I bought but a option (there is no number and no currency). (Amount sold here would be the BTC I buy the options with → that’s ok).

.
Later and once I sell an option I have the inverse problem → the gain will be in BTC (and the difference between buying and selling the option would be the P&L which has to be accounted for somehow, too) but the instrument sold (the option) I can’t choose and also it has no “amount of currency” per se.

So I can’t enter the data manually at the moment either - maybe that’s why your API doesn’t work → this is not a traditional “order” that might fit into your traditional order format of “Buy XX Currency while Sell XX Currency” (minus fee etc.)…?

In theory one could simply take profit and loss data for each transaction (buying and then later selling the option) but I can’t choose that option manually either, right? It’s not a deposit, not a send and not internal in your Accointing classification…

Please advise because I need to prepare my tax report and while I was able to do all the crypto.com stuff manually I am lost as to how to do this stuff here manually for the Deribit transactions… I think what Clemens and others flagged here in the discussions refers to the same issue…

Thank you,
Christopher

When you buy an options trade:
I would create an OTC transaction since you have a predetermined date and price for the asset through your options trade.

1 Like