come on guys!

*push*  (and maybe move to "legal")

hey guys.

Last week i had a meeting with my accountant to prepare my hundreds of bitfinex transactions for tax-accounting. I never thought that this would end in such a nightmare.

Bitfinex transaction reports look like this:

pair		amount	price	fee
ETH/BTC		29	0.05	0.03ETH
ETH/BTC		15	0.05	0.03ETH
ETH/BTC		4	0.051	0.0004BTC (for some reason this part of the transaction has fees in BTC and not ETH)

These three transactions were made over the course of 1 minute, so i want to group them into one.

So the goal here is to find the proper way to transform them into the following format.

BUY/SELL	currency	amount	price in usd	fees in usd
SELL	BTC	xx	xx USD	xx USD
BUY	ETH	xx	xx USD	xx USD

how many BTC are we selling? (30*0.05)+(15*0.05)+(4*0.051)+0.0004 =2.4544
how many ETH are we getting? 30+15+4-0.03-0.03 = 48.94
(is that correct so far?)

let's say the btc/usd price is 1000 USD.

is someone smart enough to figure out what buying price in USD and fees in USD are? this just gives me a headache.

thx in advance