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
jivansh.eth
@parzuko
we spent a lot of time trying to solve this problem at /castmoney unfortunately, indexing is a hard problem when you get into the nuances. values are not consistent across data aggregators/vendors and computing everything yourself is expensive and tedious (it is not impossible tho 😅) biggest fix for a lot of logic is to have opinionated design. for example: airdrops gains maybe don’t count towards pnl, specifically according to your algorithm also, important metrics to rank traders are usually not singular events. “good” traders have multiple wins, have active wallets, also lose sometimes, usually terminally onchain etc
1 reply
0 recast
4 reactions
Apurv
@apurvkaushal
tried this for a crypto rewind concept (similar to Spotify wrapped etc.) - custom indexing pipelines with support from OP for contextualisation (tysm @binji.eth ) we were able to do PnL etc. for a lot of smart contracts doing it multi chain is extremely difficult - often end up using Debank APIs for this (a lil expensive than we'd like)
1 reply
0 recast
1 reaction
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
Preator
@fourvork
no but curious to see the list of your top traders :) btw doing a list of top airdrop receivers (not fc, in general) would be interesting as well, as a side project dune dashboard
1 reply
0 recast
1 reaction
