Calculate TVL amount

[djeck1432]

1. Read guidelines.
2. We're fetching amount for all opened position here but we sum all position together despite on the token for each position, however, there could be different tokens, like: ETH, STRK, USDC.
3. Fetch current prices using this method get_current_prices
4. Map current prices and amount for each token position and then return in this methodget_stats sum of all assets based on current price:
   p.s. so if you have in db ETH: 100, STRK: 20, USDC: 100, you should convert ETH and STRK to USDC current price and multiply on the amount of these tokens appropriate and return total amount of all assets in USDC

[mimisavage]

Can I work on this ?

[josephchimebuka]

Could I be assigned to this?

[martinvibes]

holla @djeck1432
can i work on this issue :)
i like 🍒

[Akshola00]

Hi
i would love to work on this issue
this will be my first contribution to this project
i like 🍒

[mimisavage]

I want to take on this issue, can I be assigned?

[Yunusabdul38]

I’d like to resolve this.

[anonfedora]

hi, i'm a fullstack blockchain developer, and i can handle the issue efficiently. ETA: 8hours

[mimisavage]

I want to take on this issue, can I be assigned?

[aniruddhaaps]

I'm a python dev, a new-comer here. I want to take up the issue and solve it.

[mimisavage]

I want to take on this issue, can I be assigned?

[suhas-sensei]

I like 🍒. I'll implement a token-price aggregation solution using async batched price fetching and decimal precision handling for accurate multi-token position valuation in USDC, delivering by Nov 1st. Experienced with DeFi protocols and token price normalization implementations.

[mimisavage]

Would love to tackle this

[aniruddhaaps]

I modified the get_stats method to pull the prices using the get_current_prices method; however, each token needs to be converted into USD and then added together as all assets in USDC. With this, assets will be valued differently across every token.

[0xdevcollins]

May I handle this issue?

[caxtonacollins]

Is it okay if I take this? I like 🍒 and am ready to work..... please assign me

[mimisavage]

Will resolve this by trying to retrieve all opened positions from the database, regardless of token type (ETH, STRK, USDC, etc.).
Get current prices
Using the get_current_prices method, I'll fetch the current prices for each token.
Map prices to positions
Will then create a dictionary mapping each token to its current price
Convert tokens to USDC
For each position, I'll convert the token amount to USDC using the current price.
Calculate total assets
I'll sum up the USDC-converted amounts for all positions.
Return total stats
In the get_stats method, 'll return the total sum of all assets in USDC.

[Benjtalkshow]

I am a Full Stack Developer with a strong background in blockchain and extensive experience in Next.js, TypeScript, and Python. I’ve made over 31 contributions to over 12 projects in the OnlyDust ecosystem, solving complex issues and delivering efficient, scalable solutions.

I will tackle this task by enhancing the stats endpoint by implementing accurate TVL calculation that properly handles multiple token types.
The current implementation incorrectly sums different token amounts without price conversion. I will modify the PositionDBConnector to group opened positions by token symbol, fetch current prices using the existing get_current_prices() method, convert each token position to its "USDC" equivalent, and aggregate all values for total TVL in "USDC". For example, if we have "100 ETH at $3000/ETH, 20 STRK at $50/STRK", and 100 "USDC", the system will correctly report TVL as "301,100 USDC "rather than just summing raw amounts. The implementation will include error handling, logging, and use Decimal type for precision. ETA 48 hours from task assignment. I like 🍇.

[djeck1432]

@suhas-sensei 1. November, it won't work, if you can do it till during 24 hours, it's okay

[suhas-sensei]

@djeck1432 maybe i can try in 24hours, ill reschedule some of my work for later