As the title says.
There are a number of apps I have used that spit out data, but they don’t seem to recognise when I am putting liquidity into pools, claiming fees etc.
Even some of the tax defi websites I have looked at don’t seem to be able to identify what these are.
And yet programmes like apeboard debank etc recognise it, but I can’t figure out how to get an excel file from those ones.
Have tried Zerion too
3 thoughts on “Has anyone had any luck exporting blockchain (ETH) data to an excel / csv file in a way that clearly identifies liquidity pool activities? (adding / removing liquidity / claiming fees etc)”
Haven’t heard of any existing tool to do this, but it may exist…
I had to do it for my tax last year (>10,000 on chain txns) and had to write my own code to do it, but should be doable by excel.
My method was to download all transaction and token transaction data from the block explorer (you can do on website if don’t know how to use their APIs), then you can categorise the transaction based on the method / bytes4 / input data which can be mapped to the function called (e.g. ‘add liquidity’). Sometimes this is already included in the csv extract. Then it’s just a mapping exercise for all txns and token txns, including some ‘manual’ mapping for more exotic txns.
If it’s ethereum, try using Binocs.co . It reads defi data and the transactions can be exported to excel.
Hey tren I’m a DeFi veteran and that doesn’t exist.
The closest you can get is Zerion since they record the price of the asset when you received it (exit pool or claim rewards) and when you send it (enter pool or sold). You need to call the Zerion API to get those transactions in a json file which you can convert to a csv. Super manual task but if you want to learn something new it is fun.
The complex thing is that each protocol and smart contract has unique functions to enter/exit/claim rewards that aren’t standardized at all. An app like what you described would need to manually integrate each DeFi smart contract, so it seems impossible that will exist