Increasing Positions

Introduction :

Mean Finance is the state-of-the-art DCA open protocol that enables users (or dapps) to Dollar Cost Average (DCA) any ERC20 into any ERC20 with their preferred period frequency, without sacrificing decentralization or giving up personal information to any centralized parties.

Positions :

Mean Finance allows users to exchange ERC20 tokens for others ERC20 tokens. In order to do so, users will need to create a Mean Finance position with the following properties:

From: ERC20 token to sell
To: ERC20 token to buy
Rate: amount of token "from" to swap for their "to" equivalent at the time of the swap
Amount of swaps: how many swaps to execute
Swap interval: daily, weekly,..

Actions :

users can create a position at any time. Once their position is created, there are some actions that they can perform on them.

Modify a position

Users can choose to modify their positions in a few different ways. They can Add more funds to their position

 For example, increasing the rate from 5 DAI to 10 DAI

 Remove funds from their position

 For example, reducing the rate from 5 DAI to 3 DAI

 Reorganize the available funds

Now , only a position's "rate" and "amount of swaps" properties can be modified. The "swap interval", "from" and "to" properties cannot be changed. Withdraw swapped balance

Terminate a position

Users can also choose to terminate their position at any point. When this happens, the position is destroyed, and all remaining and swapped balance is returned to the user.

The Question :

Compare users terminating vs increasing positions over the last 30 days.
By how much are they increasing positions?
How much are they receiving back after terminating?

Approach :

  - items used :

  - tables : polygon.core.fact_transactions ,polygon.core.dim_labels 
  - Related address : 0x059d306a25c4ce8d7437d25743a8b94520536bd5
  - ORIGIN_FUNCTION_SIGNATURE = '0xded700a6' for increasing positions 
  - ORIGIN_FUNCTION_SIGNATURE = '0x72ada4c5' for terminating positions

Results :

the chart below, illustrates the increased vs terminated actions count foe different assets. number of terminating actions for Matic was higher than others (31) followed by USDC (13).theres no increasing action recorded for matic in past 30 days. assets illustrated in the graph below are :

MAtic, USDC, DAI ,Link, Jeur, wBTC, USDT, ETH and CRV

as shown in the pie chart below, the total number of terminating actions in past 6 months was 68 and total increasing actions was 13

Findings :

Mean Finance is the state-of-the-art DCA open protocol that enables users (or dapps) to Dollar Cost Average (DCA) any ERC20 into any ERC20 with their preferred period frequency, without sacrificing decentralization or giving up personal information to any centralized parties
number of terminating actions for Matic was higher than others (31) followed by USDC (13).theres no increasing action recorded for matic in past 30 days. assets : MAtic, USDC, DAI ,Link, Jeur, wBTC, USDT, ETH and CRV
the total number of terminating actions in past 6 months was 68 and total increasing actions was 13
in terms of amount increased in past 1 month, USDC with 1551 is higher than other assets followed by DAI, USDT and ETH

flipside