How to count the total income of a certain currency in a certain currency in Ou Yizhong

1. I would like to count the total profit of YGG-USDT-SWAP in the past few months. Assets – Trading Accounts – Billing in the App. Transaction type: perpetual, transaction variety: USDT standard YGGUSDT perpetual. as shown in 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. Trading account bills in the web – historical delegate. Date: 2023-05-17 > 2023-08-17, currency: USDT; screening: perpetual; contract type: USDT standard; transaction variety: YGGUSDT. as shown in Figure 2

4. Since there is no income column statistics in the web page, click the download link, date: 2023-05-01 > 2023-08-16, as shown in Figure 3

5. Unzip the downloaded zip file, open the csv file, and then filter by yourself, the product name: ygg-usdt-swap, as shown in Figure 4

6. Click the income column, sum: 421.32. Click the Fee column, sum: -5.36. Add the two to calculate: from 2023/8/4 21:48 – 2023/8/16 6:45
During the time period, a total of 13 days, the total revenue is 421.32 – 5.36 = 415.96. as shown in Figure 5

7. Screening, type: capital fee income, capital expense expenditure, click the income column, sum: -108.3849. It can be seen that the capital cost of OKX is really high. The income of the liquidation is 108.3849/529.7068 = 0.20, and about 20% of the average income are used for the expenditure of funding fees. as shown in Figure 6