ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This sheet can be used to product DLM scenarios
2
Instructions:
3
Change any of the bright yellow cells to play with the scenario
4
5
6
Auction params (editable)
Derived params (don't edit)
7
Starting Token2000000Starting USDT4000000
8
Starting price $
2Min delay ratio0.2
9
Min price0.4
10
Duration (hr)24
11
12
13
14
15
16
17
EventTime (hr)
Time decay ratio (Using a Log function)
Token delta (-ve is a buy, +ve is a sell)
Pool Token Balance
Workings
Virtual USDT Pool
Actual USDT Pool
Price (w clamped) USD
Price w/o clamp USD
Price deltak
18
Init012,000,000200000040000004,000,0000.00002.00008000000000000
19
Market wait10.9846617212,000,0004,000,0000.00001.96931.9693-1.53%8000000000000
20
Market wait20.85869690282,000,0004,000,0000.00001.71741.7174-12.79%8000000000000
21
No Activity20.858696902802,000,00004,000,0000.00001.71741.71740.00%8000000000000
22
Market wait30.76932344192,000,0004,000,0000.00001.53861.5386-10.41%8000000000000
23
No Activity30.769323441902,000,00004,000,0000.00001.53861.53860.00%8000000000000
24
Market wait40.72,000,0004,000,0000.00001.40001.4000-9.01%8000000000000
25
No Activity40.702,000,00004,000,0000.00001.40001.40000.00%8000000000000
26
Market wait50.64335862372,000,0004,000,0000.00001.28671.2867-8.09%8000000000000
27
No Activity50.643358623702,000,00004,000,0000.00001.28671.28670.00%8000000000000
28
Market wait60.59546902242,000,0004,000,0000.00001.19091.1909-7.44%8000000000000
29
No Activity60.595469022402,000,00004,000,0000.00001.19091.19090.00%8000000000000
30
Market wait70.55398516292,000,0004,000,0000.00001.10801.1080-6.97%8000000000000
31
No Activity70.553985162902,000,00004,000,0000.00001.10801.10800.00%8000000000000
32
Market wait80.51739380552,000,0004,000,0000.00001.03481.0348-6.61%8000000000000
33
No Activity80.517393805502,000,00004,000,0000.00001.03481.03480.00%8000000000000
34
Market wait90.4846617212,000,0004,000,0000.00000.96930.9693-6.33%8000000000000
35
Buy Token90.484661721-100,0001,900,000102034.04654,102,034102,034.04651.04641.04647.95%7793864688385
36
Market wait100.45505194881,900,0004,102,034102,034.04650.98240.9824-6.11%7793864688385
37
Buy Token100.4550519488-100,0001,800,000103702.14374,205,736205,736.19021.06321.06328.22%7570325142424
38
Market wait110.42802034471,800,0004,205,736205,736.19021.00011.0001-5.94%7570325142424
39
Buy Token110.4280203447-100,0001,700,000105890.62674,311,627311,626.81691.08561.08568.55%7329765588779
40
Market wait120.40315367941,700,0004,311,627311,626.81691.02251.0225-5.81%7329765588779
41
Buy Token120.4031536794-100,0001,600,000108640.51354,420,267420,267.33041.11381.11388.93%7072427728638
42
Market wait130.38013074341,600,0004,420,267420,267.33041.05021.0502-5.71%7072427728638
43
Buy Token130.3801307434-100,0001,500,000112018.63384,532,286532,285.96421.14861.14869.37%6798428946232
44
Market wait140.35869690281,500,0004,532,286532,285.96421.08381.0838-5.64%6798428946232
45
Buy Token140.3586969028-100,0001,400,000116122.63844,648,409648,408.60261.19101.19109.89%6507772043592
46
Market wait150.33864688391,400,0004,648,409648,408.60261.12441.1244-5.59%6507772043592
47
Buy Token150.3386468839-100,0001,300,000121089.92994,769,499769,498.53241.24241.242410.50%62003480921492000000
48
Market wait160.31981278611,300,0004,769,499769,498.53241.17331.1733-5.56%6200348092149500000
49
Buy Token160.3198127861-100,0001,200,000127112.21784,896,611896,610.75031.30501.305011.22%5875932900321
50
Market wait170.30205552651,200,0004,896,611896,610.75031.23251.2325-5.55%5875932900321
51
Buy Token170.3020555265-100,0001,100,000134458.93985,031,0701,031,069.69011.38151.381512.09%5534176659106
52
Market wait180.28525859981,100,0005,031,0701,031,069.69011.30471.3047-5.56%5534176659106
53
Buy Token180.2852585998-100,0001,000,000143515.58955,174,5851,174,585.27961.47611.476113.14%5174585279617
54
Market wait190.26932344191,000,0005,174,5851,174,585.27961.39361.3936-5.59%5174585279617
55
Buy Token190.2693234419-100,000900,000154848.56875,329,4341,329,433.84831.59481.594814.44%4796490463460
56
Market wait200.2541659252900,0005,329,4341,329,433.84831.50511.5051-5.63%4796490463460
57
Buy Token200.2541659252-100,000800,000169320.06065,498,7541,498,753.90891.74701.747016.07%4399003127114
58
Market wait210.2397136698800,0005,498,7541,498,753.90891.64771.6477-5.69%4399003127114
59
Buy Token210.2397136698-100,000700,000188303.78275,687,0581,687,057.69161.94751.947518.20%3980940384086
60
Market wait220.2259039533700,0005,687,0581,687,057.69161.83531.8353-5.76%3980940384086
61
Buy Token220.2259039533-100,000600,000214121.46925,901,1791,901,179.16072.22182.221821.06%3540707496428
62
Market wait230.2126820656600,0005,901,1791,901,179.16072.09182.0918-5.85%3540707496428
63
Buy Token230.2126820656-100,000500,000251014.99476,152,1942,152,194.15542.61692.616925.10%3076097077722
64
Market wait240.2500,0006,152,1942,152,194.15542.46092.4609-5.96%3076097077722
65
No Activity240.20500,00006,152,1942,152,194.15542.46092.46090.00%3076097077722
66
End500,0002,152,194.1554
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