ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Instructions:
Inputs:
Important: this fee may change over time as BNB value increases
2
1. Do your own copy of the sheet
Value Locked (in $):3,185.47Avg TX fee:0.001612
The purpose of this sheet is to help people determining when it's best to compound. It's based on the original "Optimal Defi Compounding" from Tradewatch (from LeoFinance Discord)
3
2. Modify the green cells for your purposes
Daily Return:1.17TX factor:4
For small cubs, looking to become leo, and needing to know when going back to their dens
4
Cub/Usd 3day tuesday 8pm
4dayDen (0) or Farm (1)?1
5
Cub/BnB tues 848hrsMode:2
0 = Default, 1 = Day, 2 = Week, 3 = 30d <- To compare different hourly rate, you can change the mode to have the all cases with respect to 1 compound "per Day" or "per Week"
6
Cub den Detailed computation here:
7
Comp. RateUnit (H/D)Hourly Comp.Results:Simple Period ReturnTXBaseBaseBaseComp. ReturnPerformance Gain %Performance Gain $TX BurdenNet Gain/Loss $
8
1H1If compound every 1 hours -> 168 TX per Week net gain is 9434515.09 $ Compared to 1 compound per Week4.88%167.007168Week296992.44%296173.44%9,434,516.171.0779,434,515.09
9
4H4If compound every 4 hours -> 42 TX per Week net gain is 5628238.02 $ Compared to 1 compound per Week19.50%41.007168Week177503.71%176684.71%5,628,238.280.2645,628,238.02
10
12H12If compound every 12 hours -> 14 TX per Week net gain is 1982518.25 $ Compared to 1 compound per Week58.50%13.007168Week63055.29%62236.29%1,982,518.340.0841,982,518.25
11
1D24If compound every 24 hours (every 1 days)-> 7 TX per Week net gain is 692483.58 $ Compared to 1 compound per Week117.00%6.007168Week22557.82%21738.82%692,483.610.039692,483.58
12
2D48If compound every 48 hours (every 2 days)-> 3.5 TX per Week net gain is 187638.8 $ Compared to 1 compound per Week234.00%2.507168Week6709.46%5890.46%187,638.820.016187,638.80
13
3D72If compound every 72 hours (every 3 days)-> 2.33 TX per Week net gain is 77775.22 $ Compared to 1 compound per Week351.00%1.337168Week3260.56%2441.56%77,775.230.00977,775.22
14
4D96If compound every 96 hours (every 4 days)-> 1.75 TX per Week net gain is 37296.22 $ Compared to 1 compound per Week468.00%0.757168Week1989.82%1170.82%37,296.230.00537,296.22
15
5D120If compound every 120 hours (every 5 days)-> 1.4 TX per Week net gain is 17838.48 $ Compared to 1 compound per Week585.00%0.407168Week1379.00%560.00%17,838.480.00317,838.48
16
6D144If compound every 144 hours (every 6 days)-> 1.17 TX per Week net gain is 6870.15 $ Compared to 1 compound per Week702.00%0.177168Week1034.67%215.67%6,870.150.0016,870.15
17
7D168If compound every 168 hours (every 7 days)-> 1 TX per Week net gain is 0 $ Compared to 1 compound per Week819.00%0.007168Week819.00%0.00%0.000.0000.00
18
10D240If compound every 240 hours (every 10 days)-> 0.7 TX per Week net gain is -10401.68 $ Compared to 1 compound per Week1170.00%-0.307168Week492.46%-326.54%(10,401.68)-0.002(10,401.68)
19
20
March 27th 10am4-1 5:00 AM
21
CUB/BUSDCUB/BUSD1670.96 CUB
22
288.75 CUB / 825.03 BUSD
242.83 CUB / 983.61 BUSD
7,654.63 USD
23
1,650.05 USD1,967.23 USDTOTAL WORTH
24
CUB/WBNBCUB/WBNB7,654.63 USD
25
165.82 CUB / 1.80 WBNB
394.28 CUB / 5.10 WBNB
26
948.44 USD3,185.47 USD
27
TOTAL WORTHCUB
28
2,598.49 USD223.94 CUB
29
907.11 USD
30
TOTAL WORTH
31
6,059.81 USD
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
March 26th 5pmMarch 27th 10am
50
CUB/BUSDCUB/BUSD
51
281.23 CUB / 846.88 BUSD
288.75 CUB / 825.03 BUSD
<--Harvest Monday evening
52
1,693.75 USD1,650.05 USD
53
CUB/WBNBCUB/WBNB
54
158.78 CUB / 1.88 WBNB
165.82 CUB / 1.80 WBNB
55
959.66 USD948.44 USD
56
TOTAL WORTHTOTAL WORTH
57
2,653.41 USD2,598.49 USD
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100