Describe the problem:
I have 7,000+ transactions imported from Binance CSV using UTC time zone. I have found all the instances of Deposits & Withdrawals that show a grey globe on one side, that are actually transfers between my wallets, and have fixed those. But now I’m running into 1,000s of instances where a Trade/Swap of two coins is separated into three transactions: a deposit, a withdrawal and a cost. I started to try and go through and merge them, and sometimes I can see that the deposit and withdrawal amounts look similar, so I assume they are one Tx, but most times that is not evident, as the amounts are not obvious. Between not wanting to guess, or manually comb through 1000s of transactions, I’m hoping there is a way of automating this by editing the sheet, or some other solution.
Which exchange/wallet is this regarding?
How did you import data into this wallet?
CSV with UTC time zone
What have you tried to fix this so far?
Manually merging them, through guesswork.