Content
@
0 reply
0 recast
0 reaction
Nastya
@nastya
So I'm trying to figure out who the best traders on Farcaster are - out of hundreds of thousands of users. What are the main challenges? First - the data. I mostly use Dune since it's the biggest source of blockchain data with rich context - but it's far from plug-and-play. Blockchain data is messy, and Dune queries often need cleanup or deeper knowledge to make sense. Even something that sounds simple - like getting DEX swaps for a wallet - turns into a whole project if you want to be accurate. Second - figuring out what metrics actually matter. How do you calculate PnL, and over what timeline, tokens, chains etc. A high total PnL might come from a one-time airdrop - not consistent skill. From what I've seen, past big wins don’t mean much - what really matters is whether the trader's still active and knows when to take profits. I've gone through many iterations of the algo, and I'm still refining it. But so far, the most useful approach is looking on the freshest metrics. Anyone cracked this already?
4 replies
4 recasts
15 reactions
ChristianØ
@christian
oof yeah, tough one. part of this is done for you if you wanted to try using /noves, basically deciphers txns and classifies them into a standard type (in this case identifies all the 'Swap' txns you're looking for). Even the most complex multicalls or handleops, if indeed they are swaps, will get classified. Problem is, you still need to pull into a db and start your calculations for pnl, etc. etc. etc. So it's not the full solution, but it is one of the hardest parts, solved.
0 reply
0 recast
1 reaction
