Recently wanted to tackle the problem of finding top profitable traders on DEXes, and extracting macro metrics out of them. We've been backing different features based of traders PnL(Profits and Losses) for a while, and it has some representations in Trader's and Token's profiles pages on DexGuru, but there is lack of overall Scores and Rankings, and Macro metrics falling out of those.

Algorithm

First of all we've calculated PnL in USD for each trader using two different approaches:

• Using transfer's we assume trader got in position when token was transfered towards his address, and got out of position when token was transfered out of his address. The difference there is the PnL.

• Using trades(swaps) we assume trader got in position when he bought token, and got out of position when he sold token on DEX.

Both applied to addresses which are EOA and have their flows. First one(Transfers) is not taking into account the fact that trader could just have multiple wallets, or it could be CEX technical wallet. Second one(Swaps) could be screwed by the fact that not all the AMM DEXES are supported, so we could miss some swaps, which would lead to Data Inconsistency and wrong PnL calculations.

Filters explanation

We were discussing internally the brackets there for assets value and period we are calculating PnL top for, and came to an assumption that we need to aim towards main DexGuru audience and show the numbers which are actually as close as it gets to our users. We assumed following profile for DexGuru users:

• managing in between $50k-500k in assets overall

• having average of 10-15 transactions per month(not daily traders), getting in and out of positions in a corse of a month.

So, we’ve decided on following filters:

• Only EOA

• Accounts with summary assets value $50k-500k

• Only tradable, verified tokens

Outcome

• We see both lists as a good representation of traders who are actually making money on DEXes, or other was in ERC-20 markets, as any move produces transfers. Depending on what you are aiming for you can research those traders, add them to favorites to follow their moves, or just see how they are doing overall.

• As that's second integration of Warehouse Dashboards in DexGuru, and the whole idea there is ease of editing and

• contribution, we are invite everyone to check the dashboard itself in our Warehouse and add metrics you see fit there based on your experience.

• API. All the queries are available via API, so anyone can build their own dashboards and analytics on top of it.

Feel free to discuss, suggest further development:

Or fork and change it yourself in https://warehouse.dex.guru