aave / aave/protocol-subgraphs

Debt displayed in dashboard different from transaction sum

Open
#139 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
TypeScript
Stars
150
Forks
130
PR merge metrics
No merged PRs in 30d

Description

Describe the bug
It seems that I found a user with ~488K usdc debt that you can see in his dashboard, but when I go to the transaction page and extract as CSV and doing the Sum, then I get ~482k debt.

I've got same result (482k) if I use the subgraph.

To Reproduce
Subgraph : protocol v3 polygon
Here is the user address with the problem : 0x028f505041c9015b58a23e43c40bd6b63d5a2a13

You can go to aave app and watch this address, check dashboard and export transactions. Then in excel or numbers juste calculate the following :
Debt = sum(borrows) - sum(repays) = ~482k

The subgraph gives same result as transaction export.

The user is very active so data may be varying. If you want to reproduce to get my values its before 2024/09/24.

Expected behavior
I expect that what I see in dashboard is the same (minus a small delta of missing interest) as what i can calculate in transaction export or subgraph.

Which is right ? Subgraph and transaction export ? Or dashboard ?

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the reported address in the protocol v3 Polygon subgraph, Aave dashboard, and transaction CSV before 2024/09/24. Compare the borrow and repay totals with the dashboard debt, accounting for the user's activity. Done means the discrepancy's cause is identified and the correct source or required correction is documented.

Written by the indexing model from the issue text.

Assessment

Tech stack
typescript
Domain
blockchain, data
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.