[Bounty] Create Dune Analytics Dashboard with dHEDGE V2 data on Polygon

leckylao commented 3 years ago

Prize Title

Prize Bounty

$3000 USDC

Challenge Description

Create a dashboard with dHEDGE V2 data on Dune Analytics similar to the dashboard for mStable here https://dune.xyz/derc/mta-community. Including the following but not limited data:

TVL for all pools
Unique investor Addresses for all pools
Unique manager addresses for all pools
Unique assets and value for all pools
Total trading fees - Treasury DAO: 0x6f005cbceC52FFb28aF046Fd48CB8D6d19FD25E3

V2 Public Repo: https://github.com/dhedge/V2-Public V2 published addresses: https://github.com/dhedge/V2-Public/blob/master/publish/matic/versions.json#L338

Submission Requirements

Please include a link to the dashboard

Judging Criteria

Valid submission requires showing Dune Analytics dashboard including but not limited the above data.

Winner Announcement Date

Winners will be announced at the conclusion of Open Defi Hackathon

gitcoinbot commented 3 years ago

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

This issue now has a funding of 3000.0 USDC (3000.0 USD @ $1.0/USDC) attached to it.

If you would like to work on this issue you can 'start work' on the Gitcoin Issue Details page.
- Want to chip in? Add your own contribution here.
- Questions? Checkout Gitcoin Help or the Gitcoin's Discord
- $3,623,217.51 more funded OSS Work available on the Gitcoin Issue Explorer

gitcoinbot commented 3 years ago

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

Work has been started.

These users each claimed they can complete the work by 2 weeks, 6 days from now. Please review their action plans below:

1) izayl has started work.

A dashboard on Dune Analytics similar to the dashboard for mStable here dune.xyz/derc/mta-community.

Learn more on the Gitcoin Issue Details page.

SebastianLF commented 3 years ago

Hi, I'm about to start working for this bounty but first I have a question: why do you mention dhedge ? what the purpose of dhedge in this project ?

leckylao commented 3 years ago

Hi, I'm about to start working for this bounty but first I have a question: why do you mention dhedge ? what the purpose of dhedge in this project ?

Could you read the title again? The bounty is to build a Dune Analytics dashboard for dHEDGE V2 protocol on Polygon.

SebastianLF commented 3 years ago

I get it now, thanks.

tonytran1307 commented 3 years ago

I get it now, thanks.

Hi, can we keep in touch for further discussion on bounty working ? Currently, I am working on Bounty which same to you but on Ethereum. Hope to hear from you.

leckylao commented 3 years ago

I get it now, thanks.

Hi, can we keep in touch for further discussion on bounty working ? Currently, I am working on Bounty which same to you but on Ethereum. Hope to hear from you.

Ethereum is V1 on another bounty: https://github.com/dhedge/dhedge-docs/issues/6

tonytran1307 commented 3 years ago

I get it now, thanks.

Hi, can we keep in touch for further discussion on bounty working ? Currently, I am working on Bounty which same to you but on Ethereum. Hope to hear from you.

Ethereum is V1 on another bounty:

6

Hi, I know, but I think we will have discussion about methodology to finish the bounty, so that why I ask him about contact.

leckylao commented 3 years ago

Updated contract details.

poogooflupduck commented 3 years ago

Several Dune.xyz methods to dHedge seem to return no outputs. Trying to calculate the value of funds and total manager fees

leckylao commented 3 years ago

Hi everyone, as the Hackathon is ending soon, but there's still no submission and people report there's decode issue for Dune that returned no data. Therefore I am extending the bounty for another 3 weeks. Hopefully that could give enough time for everyone to resolve data issue with Dune and do a submission.

Please note bounty could still close early if there's a submission that has fulfilled all the requirements and we think that it could be a winner.

poogooflupduck commented 3 years ago

@leckylao Thanks. Do you know how the data issues with Dune can be resolved? At the moment, I'm not sure if it's possible to complete the requirements as the data on Dune is not there. I may be wrong.

leckylao commented 3 years ago

@leckylao Thanks. Do you know how the data issues with Dune can be resolved? At the moment, I'm not sure if it's possible to complete the requirements as the data on Dune is not there. I may be wrong.

Not sure, better check with Dune. But I am sure it's possible as it's mentioned in their docs https://openbase.com/js/dune-snippets#how-dune-handles-proxy-contracts

poogooflupduck commented 3 years ago

Hi @leckylao calculating TVL via Dune Analytics is currently difficult:

totalFundValue() doesn't return any output
Querying and adding value of all assets in all pools is difficult, as 'supported assets' for each pool is returned in json (not usable in Dune?), and any methods related to supported assets return no output

Grateful if you could provide any recommendations. I've already finished two metrics.

leckylao commented 3 years ago

Hi @leckylao calculating TVL via Dune Analytics is currently difficult:

totalFundValue() doesn't return any output

I think it should be getFundComposition

Querying and adding value of all assets in all pools is difficult, as 'supported assets' for each pool is returned in json (not usable in Dune?), and any methods related to supported assets return no output

Yea, don't do that, should use the getFundComposition. It sits in PoolManagerLogic, which you could call pool.poolManagerLogic() to get the address then call getFundComposition. But if no data return from Dune then might need to ping them.

Grateful if you could provide any recommendations. I've already finished two metrics.

poogooflupduck commented 3 years ago

Ok.

No data returned for getFundComposition at the moment.

poogooflupduck commented 3 years ago

I've pinged the Dune team about this on Discord

gitcoinbot commented 3 years ago

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

Work for 3000.0 USDC (3000.00 USD @ $1.0/USDC) has been submitted by:

Learn more on the Gitcoin Issue Details page
Want to chip in? Add your own contribution here.
Questions? Checkout Gitcoin Help or the Gitcoin's Discord
$4,568,387.89 more funded OSS Work available on the Gitcoin Issue Explorer

gitcoinbot commented 3 years ago

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

Work for 3000.0 USDC (3000.00 USD @ $1.0/USDC) has been submitted by:

@viswanathkgp12

@leckylao please take a look at the submitted work:

PR by @viswanathkgp12

Learn more on the Gitcoin Issue Details page
Want to chip in? Add your own contribution here.
Questions? Checkout Gitcoin Help or the Gitcoin's Discord
$4,594,237.53 more funded OSS Work available on the Gitcoin Issue Explorer

leckylao commented 3 years ago

Hi @viswanathkgp12,

The active Investor 1D, 7D, 30D is showing empty.

poogooflupduck commented 3 years ago

Hi @leckylao

I don't think anyone can produce the real TVL at this moment since there is no data returned for the supported assets of each pool.

Any aggregation includes assets that are not supported by the pool.

Karl

viswanathkgp12 commented 2 years ago

Hi @viswanathkgp12,

The active Investor 1D, 7D, 30D is showing empty.

Hi,

I've fixed this. The dashboard now shows accurate results.

leckylao commented 2 years ago

https://forum.dhedge.org/t/pay-open-defi-winners-proposal-to-grants-dao/236

gitcoinbot commented 2 years ago

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

This Bounty has been completed.

Learn more on the Gitcoin Issue Details page
Questions? Checkout Gitcoin Help or the Gitcoin's Discord
$4,967,275.46 more funded OSS Work available on the Gitcoin Issue Explorer

dhedge / dhedge-docs