How to count the total income of a certain currency in MEXC for a period of time

1. I want to count the total profit of CYBER_USD in the past few months. Transactions – Contract Transactions – Flow in the App. All trading pairs: Cyber USDT perpetual. as shown in Figure 1

Figure 1

2. However, if you want to count the total income of a certain period of time, you can only calculate one by one manually, which is too difficult.

3. In the Web Contract Order – Fund flow. Contract trading pair: Cyber USDT perpetual, date: 2023-09-01 > 2023-09-12. as shown in Figure 2

Figure 2

4. Since there is no income column in the web page, click the export fund flow link, please select the time period: the last month (2023-08-12 > 2023-09-12), as shown in Figure 3

Figure 3

5. Open the downloaded XLSX file, and then filter it yourself, the contract transaction pair: Cyber USDT, as shown in Figure 4

Figure 4

6. Click the amount column, sum: 491.5625. Calculated: From 2023-09-01 11:51 – 2023-09-08 04:56, a total of 8 days, the total revenue is 491.5625. as shown in Figure 5

Figure 5

7. However, I plan to count the funding fee (Funding), filter the fund type column: funding, click the amount column, and sum: -200.9233. as shown in Figure 6

Figure 6

8. Statistics on the fee (FEE), screen the fund type column: FEE, click the amount column, sum: -0.5270. as shown in Figure 6

9. Because of the type of funds: the income of close_position is: 690.013. It can be seen that the capital cost of MEXC is really high. The income of the liquidation is 200.9233/690.013 = 0.29, and about 30% are used for the expenditure of the funding fee.

10. Reference:How to count the total income of a certain currency in a certain currency in Ou Yizhong  . Compared with the 20% expenditure of OKX, OKX will be preferred in the future. However, in the end, I decided to try to make more orders in spot or low-plus leverage, which is more secure.