
Guru Idea Flow
How do you approach ideas, and how much do you stick to them once you start following them? When do you pivot to a new direction, turning the flow of previously shiny ideas in a new direction or wrapping things up under a new umbrella when they outgrow the old one? These are questions that often challenge Web2 startup founders and, even more so, Web3. FOMO, volatility, and trends are constantly shifting—bull cycles, winters, and who knows where we are now. We started as a Multi-Chain/Multi-De...

In Search of an Infrastructure Holy Grail for DexGuru: Mastering Cost-Effectiveness and Performance
TL;DRDexGuru's transition from cloud-based infrastructure to an on-premises setup marks a strategic shift towards unparalleled cost-effectiveness and control. This move not only aligns with our commitment to full data supply chain control but also enables us to deliver custom-tailored, high-performance solutions, especially for data-intensive applications like OLAP databases.Unrivaled Cost-EffectivenessWe started our MVP in AWS (Got to $170k a month check), then decided to move towards H...

Inscriptions EVM Madness
As we are running our own EVM infrastructure ourselves and not relying on any third party services, we have to deal with all kind of new trendy things allowing bots/users to hit new bottom of Geth performance against hardware. In December it was Inscriptions. For whatever reason someone decided that moving BRC-20 on EVM chains is a good idea, which can be cheaply implemented submitting transactions with nothing but data in Input fieldinscriptions rawParsed easily with Clickhouse JSONExtractSt...
CTO & Co-Founder of dex.guru, block explorer https://b2b.dex.guru/explorer and data warehouse https://warehouse.dex.guru/


Guru Idea Flow
How do you approach ideas, and how much do you stick to them once you start following them? When do you pivot to a new direction, turning the flow of previously shiny ideas in a new direction or wrapping things up under a new umbrella when they outgrow the old one? These are questions that often challenge Web2 startup founders and, even more so, Web3. FOMO, volatility, and trends are constantly shifting—bull cycles, winters, and who knows where we are now. We started as a Multi-Chain/Multi-De...

In Search of an Infrastructure Holy Grail for DexGuru: Mastering Cost-Effectiveness and Performance
TL;DRDexGuru's transition from cloud-based infrastructure to an on-premises setup marks a strategic shift towards unparalleled cost-effectiveness and control. This move not only aligns with our commitment to full data supply chain control but also enables us to deliver custom-tailored, high-performance solutions, especially for data-intensive applications like OLAP databases.Unrivaled Cost-EffectivenessWe started our MVP in AWS (Got to $170k a month check), then decided to move towards H...

Inscriptions EVM Madness
As we are running our own EVM infrastructure ourselves and not relying on any third party services, we have to deal with all kind of new trendy things allowing bots/users to hit new bottom of Geth performance against hardware. In December it was Inscriptions. For whatever reason someone decided that moving BRC-20 on EVM chains is a good idea, which can be cheaply implemented submitting transactions with nothing but data in Input fieldinscriptions rawParsed easily with Clickhouse JSONExtractSt...

CTO & Co-Founder of dex.guru, block explorer https://b2b.dex.guru/explorer and data warehouse https://warehouse.dex.guru/
Share Dialog
Share Dialog

Subscribe to evahteev

Subscribe to evahteev
<100 subscribers
<100 subscribers
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.

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.
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
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.
https://twitter.com/evahteev/status/1747641847512543557
Or fork and change it yourself in https://warehouse.dex.guru
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.

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.
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
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.
https://twitter.com/evahteev/status/1747641847512543557
Or fork and change it yourself in https://warehouse.dex.guru
No activity yet