| A | B | C | D | E | F | G | H | I | J | K | L | M | N | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Balancer Price Calculator | Download or copy to modify! | 下载或复制以进行修改! | ||||||||||||||||||||||
2 | Sale duration | 3 | Days | Avg s/block | 13.50 | Ad hoc calculator | Capital from price calculator | Inputs | Outputs | ||||||||||||||||
3 | Sale Rate | 1,280,000 | TKN/Day | Steps | 72 | Swap fee | 0.1500% | TKN balance | 34 | Sale duration (in hours) | Total proceeds | ||||||||||||||
4 | Duration (hours) | 72 | TKN balance (pool) | 7,500,000 | Desired price | 1,500.00 | Type in desired price | Initial balances and weights | Unsold tokens | ||||||||||||||||
5 | Demo video | https://vimeo.com/466075719 | Duration (blocks) | 19,200 | USDC balance (pool) | $1,333,333 | Required USDC | $4,859.16 | System will find | Final weights | Price curve | ||||||||||||||
6 | Sale rate (hourly) | 53,333 | TKN weight | 36 | required amount | Sale Rate (TKN/Hr) | |||||||||||||||||||
7 | USDC weight | 4 | 40 | Sum <= 50 | of reserve currency | Lot Size (average size of sale) | |||||||||||||||||||
8 | Start weight | End weight | Start weight % | End weight % | Resulting USDC Price | $1.60 | (Using TKN/weights | Swap fee | |||||||||||||||||
9 | Initial TKN | 7,500,000 | 36 | 12 | 90.00 | 30.00 | from ad hoc) | Avg s/block | |||||||||||||||||
10 | Initial USDC | $1,333,333.00 | 4 | 28 | 10.00 | 70.00 | Resources | ||||||||||||||||||
11 | 40 | 40 | https://medium.com/balancer-protocol/a-new-paradigm-for-token-distribution-c82de13626bb | ||||||||||||||||||||||
12 | Lot Size | 10,000 | TKN | Proceeds | $4,035,559.67 | https://medium.com/balancer-protocol/building-liquidity-into-token-distribution-a49d4286e0d4 | |||||||||||||||||||
13 | Swap Fee | 0.1500% | Unsold tokens | 3,660,000 | |||||||||||||||||||||
14 | V2 Simulator | ||||||||||||||||||||||||
15 | Max Price | You can enter the max price users are willing to pay here | https://docs.google.com/spreadsheets/d/125MgAqv0f81Qp6y9VZHAcwMkVhvdcNKA | ||||||||||||||||||||||
16 | It represents the price at which users will start buying (after the "price discovery" period) | ||||||||||||||||||||||||
17 | And will halt buying if the price spikes above this value | ||||||||||||||||||||||||
18 | |||||||||||||||||||||||||
19 | TKN | USDC | TKN | USDC | SL(out); on lot size | ||||||||||||||||||||
20 | Step | Blocks | Hours | TKN Price | Weights (denormalized) | TKN Balance | USDC Balance | Weights (as percentages) | Total denorm | Balance override | Sale rate override (tokens/day) | Slippage | |||||||||||||
21 | 0 | 0 | 0.00 | $1.61 | 36 | 4 | 7,500,000 | $1,333,333.00 | 90.00 | 10.00 | 40.00 | TKN | USDC | 0.6657% | |||||||||||
22 | 1 | 267 | 1.00 | $1.58 | 35.67 | 4.33 | 7,446,667 | $1,419,367.04 | 89.17 | 10.83 | 40.00 | 0.6189% | |||||||||||||
23 | 2 | 533 | 2.00 | $1.55 | 35.33 | 4.67 | 7,393,333 | $1,503,684.91 | 88.33 | 11.67 | 40.00 | 0.5788% | |||||||||||||
24 | 3 | 800 | 3.00 | $1.52 | 35.00 | 5.00 | 7,340,000 | $1,586,415.50 | 87.50 | 12.50 | 40.00 | 0.5441% | |||||||||||||
25 | 4 | 1067 | 4.00 | $1.50 | 34.67 | 5.33 | 7,286,667 | $1,667,668.52 | 86.67 | 13.33 | 40.00 | 0.5139% | |||||||||||||
26 | 5 | 1333 | 5.00 | $1.47 | 34.33 | 5.67 | 7,233,333 | $1,747,538.36 | 85.83 | 14.17 | 40.00 | 0.4872% | |||||||||||||
27 | 6 | 1600 | 6.00 | $1.45 | 34.00 | 6.00 | 7,180,000 | $1,826,106.96 | 85.00 | 15.00 | 40.00 | 0.4636% | |||||||||||||
28 | 7 | 1867 | 7.00 | $1.43 | 33.67 | 6.33 | 7,126,667 | $1,903,446.01 | 84.17 | 15.83 | 40.00 | 0.4424% | |||||||||||||
29 | 8 | 2133 | 8.00 | $1.41 | 33.33 | 6.67 | 7,073,333 | $1,979,618.69 | 83.33 | 16.67 | 40.00 | 0.4235% | |||||||||||||
30 | 9 | 2400 | 9.00 | $1.39 | 33.00 | 7.00 | 7,020,000 | $2,054,681.05 | 82.50 | 17.50 | 40.00 | 0.4064% | |||||||||||||
31 | 10 | 2667 | 10.00 | $1.37 | 32.67 | 7.33 | 6,966,667 | $2,128,683.06 | 81.67 | 18.33 | 40.00 | 0.3909% | |||||||||||||
32 | 11 | 2933 | 11.00 | $1.35 | 32.33 | 7.67 | 6,913,333 | $2,201,669.48 | 80.83 | 19.17 | 40.00 | 0.3768% | |||||||||||||
33 | 12 | 3200 | 12.00 | $1.33 | 32.00 | 8.00 | 6,860,000 | $2,273,680.64 | 80.00 | 20.00 | 40.00 | 0.3639% | |||||||||||||
34 | 13 | 3467 | 13.00 | $1.32 | 31.67 | 8.33 | 6,806,667 | $2,344,752.95 | 79.17 | 20.83 | 40.00 | 0.3521% | |||||||||||||
35 | 14 | 3733 | 14.00 | $1.30 | 31.33 | 8.67 | 6,753,333 | $2,414,919.45 | 78.33 | 21.67 | 40.00 | 0.3412% | |||||||||||||
36 | 15 | 4000 | 15.00 | $1.28 | 31.00 | 9.00 | 6,700,000 | $2,484,210.20 | 77.50 | 22.50 | 40.00 | 0.3312% | |||||||||||||
37 | 16 | 4267 | 16.00 | $1.27 | 30.67 | 9.33 | 6,646,667 | $2,552,652.62 | 76.67 | 23.33 | 40.00 | 0.3219% | |||||||||||||
38 | 17 | 4533 | 17.00 | $1.25 | 30.33 | 9.67 | 6,593,333 | $2,620,271.79 | 75.83 | 24.17 | 40.00 | 0.3133% | |||||||||||||
39 | 18 | 4800 | 18.00 | $1.24 | 30.00 | 10.00 | 6,540,000 | $2,687,090.73 | 75.00 | 25.00 | 40.00 | 0.3054% | |||||||||||||
40 | 19 | 5067 | 19.00 | $1.22 | 29.67 | 10.33 | 6,486,667 | $2,753,130.56 | 74.17 | 25.83 | 40.00 | 0.2979% | |||||||||||||
41 | 20 | 5333 | 20.00 | $1.21 | 29.33 | 10.67 | 6,433,333 | $2,818,410.75 | 73.33 | 26.67 | 40.00 | 0.2910% | Because sheets won't let you have multiple axes apparently! | ||||||||||||
42 | 21 | 5600 | 21.00 | $1.20 | 29.00 | 11.00 | 6,380,000 | $2,882,949.21 | 72.50 | 27.50 | 40.00 | 0.2846% | |||||||||||||
43 | 22 | 5867 | 22.00 | $1.18 | 28.67 | 11.33 | 6,326,667 | $2,946,762.50 | 71.67 | 28.33 | 40.00 | 0.2785% | |||||||||||||
44 | 23 | 6133 | 23.00 | $1.17 | 28.33 | 11.67 | 6,273,333 | $3,009,865.93 | 70.83 | 29.17 | 40.00 | 0.2729% | |||||||||||||
45 | 24 | 6400 | 24.00 | $1.16 | 28.00 | 12.00 | 6,220,000 | $3,072,273.65 | 70.00 | 30.00 | 40.00 | 0.2676% | |||||||||||||
46 | 25 | 6667 | 25.00 | $1.14 | 27.67 | 12.33 | 6,166,667 | $3,133,998.75 | 69.17 | 30.83 | 40.00 | 0.2626% | |||||||||||||
47 | 26 | 6933 | 26.00 | $1.13 | 27.33 | 12.67 | 6,113,333 | $3,195,053.37 | 68.33 | 31.67 | 40.00 | 0.2579% | |||||||||||||
48 | 27 | 7200 | 27.00 | $1.12 | 27.00 | 13.00 | 6,060,000 | $3,255,448.75 | 67.50 | 32.50 | 40.00 | 0.2535% | |||||||||||||
49 | 28 | 7467 | 28.00 | $1.11 | 26.67 | 13.33 | 6,006,667 | $3,315,195.32 | 66.67 | 33.33 | 40.00 | 0.2493% | |||||||||||||
50 | 29 | 7733 | 29.00 | $1.10 | 26.33 | 13.67 | 5,953,333 | $3,374,302.71 | 65.83 | 34.17 | 40.00 | 0.2454% | |||||||||||||
51 | 30 | 8000 | 30.00 | $1.08 | 26.00 | 14.00 | 5,900,000 | $3,432,779.88 | 65.00 | 35.00 | 40.00 | 0.2418% | |||||||||||||
52 | 31 | 8267 | 31.00 | $1.07 | 25.67 | 14.33 | 5,846,667 | $3,490,635.09 | 64.17 | 35.83 | 40.00 | 0.2383% | |||||||||||||
53 | 32 | 8533 | 32.00 | $1.06 | 25.33 | 14.67 | 5,793,333 | $3,547,876.00 | 63.33 | 36.67 | 40.00 | 0.2350% | |||||||||||||
54 | 33 | 8800 | 33.00 | $1.05 | 25.00 | 15.00 | 5,740,000 | $3,604,509.67 | 62.50 | 37.50 | 40.00 | 0.2319% | |||||||||||||
55 | 34 | 9067 | 34.00 | $1.04 | 24.67 | 15.33 | 5,686,667 | $3,660,542.63 | 61.67 | 38.33 | 40.00 | 0.2290% | |||||||||||||
56 | 35 | 9333 | 35.00 | $1.03 | 24.33 | 15.67 | 5,633,333 | $3,715,980.85 | 60.83 | 39.17 | 40.00 | 0.2263% | |||||||||||||
57 | 36 | 9600 | 36.00 | $1.02 | 24.00 | 16.00 | 5,580,000 | $3,770,829.87 | 60.00 | 40.00 | 40.00 | 0.2237% | |||||||||||||
58 | 37 | 9867 | 37.00 | $1.01 | 23.67 | 16.33 | 5,526,667 | $3,825,094.70 | 59.17 | 40.83 | 40.00 | 0.2212% | |||||||||||||
59 | 38 | 10133 | 38.00 | $1.00 | 23.33 | 16.67 | 5,473,333 | $3,878,779.95 | 58.33 | 41.67 | 40.00 | 0.2189% | |||||||||||||
60 | 39 | 10400 | 39.00 | $0.99 | 23.00 | 17.00 | 5,420,000 | $3,931,889.80 | 57.50 | 42.50 | 40.00 | 0.2167% | |||||||||||||
61 | 40 | 10667 | 40.00 | $0.97 | 22.67 | 17.33 | 5,366,667 | $3,984,428.01 | 56.67 | 43.33 | 40.00 | 0.2147% | |||||||||||||
62 | 41 | 10933 | 41.00 | $0.96 | 22.33 | 17.67 | 5,313,333 | $4,036,397.95 | 55.83 | 44.17 | 40.00 | 0.2127% | |||||||||||||
63 | 42 | 11200 | 42.00 | $0.95 | 22.00 | 18.00 | 5,260,000 | $4,087,802.64 | 55.00 | 45.00 | 40.00 | 0.2109% | |||||||||||||
64 | 43 | 11467 | 43.00 | $0.94 | 21.67 | 18.33 | 5,206,667 | $4,138,644.72 | 54.17 | 45.83 | 40.00 | 0.2092% | |||||||||||||
65 | 44 | 11733 | 44.00 | $0.93 | 21.33 | 18.67 | 5,153,333 | $4,188,926.49 | 53.33 | 46.67 | 40.00 | 0.2076% | |||||||||||||
66 | 45 | 12000 | 45.00 | $0.92 | 21.00 | 19.00 | 5,100,000 | $4,238,649.90 | 52.50 | 47.50 | 40.00 | 0.2061% | |||||||||||||
67 | 46 | 12267 | 46.00 | $0.91 | 20.67 | 19.33 | 5,046,667 | $4,287,816.59 | 51.67 | 48.33 | 40.00 | 0.2047% | |||||||||||||
68 | 47 | 12533 | 47.00 | $0.90 | 20.33 | 19.67 | 4,993,333 | $4,336,427.87 | 50.83 | 49.17 | 40.00 | 0.2034% | |||||||||||||
69 | 48 | 12800 | 48.00 | $0.89 | 20.00 | 20.00 | 4,940,000 | $4,384,484.74 | 50.00 | 50.00 | 40.00 | 0.2021% | |||||||||||||
70 | 49 | 13067 | 49.00 | $0.88 | 19.67 | 20.33 | 4,886,667 | $4,431,987.88 | 49.17 | 50.83 | 40.00 | 0.2010% | |||||||||||||
71 | 50 | 13333 | 50.00 | $0.87 | 19.33 | 20.67 | 4,833,333 | $4,478,937.68 | 48.33 | 51.67 | 40.00 | 0.1999% | |||||||||||||
72 | 51 | 13600 | 51.00 | $0.86 | 19.00 | 21.00 | 4,780,000 | $4,525,334.23 | 47.50 | 52.50 | 40.00 | 0.1989% | |||||||||||||
73 | 52 | 13867 | 52.00 | $0.85 | 18.67 | 21.33 | 4,726,667 | $4,571,177.32 | 46.67 | 53.33 | 40.00 | 0.1980% | |||||||||||||
74 | 53 | 14133 | 53.00 | $0.84 | 18.33 | 21.67 | 4,673,333 | $4,616,466.46 | 45.83 | 54.17 | 40.00 | 0.1972% | |||||||||||||
75 | 54 | 14400 | 54.00 | $0.83 | 18.00 | 22.00 | 4,620,000 | $4,661,200.86 | 45.00 | 55.00 | 40.00 | 0.1965% | |||||||||||||
76 | 55 | 14667 | 55.00 | $0.82 | 17.67 | 22.33 | 4,566,667 | $4,705,379.45 | 44.17 | 55.83 | 40.00 | 0.1958% | |||||||||||||
77 | 56 | 14933 | 56.00 | $0.81 | 17.33 | 22.67 | 4,513,333 | $4,749,000.85 | 43.33 | 56.67 | 40.00 | 0.1952% | |||||||||||||
78 | 57 | 15200 | 57.00 | $0.80 | 17.00 | 23.00 | 4,460,000 | $4,792,063.41 | 42.50 | 57.50 | 40.00 | 0.1947% | |||||||||||||
79 | 58 | 15467 | 58.00 | $0.79 | 16.67 | 23.33 | 4,406,667 | $4,834,565.19 | 41.67 | 58.33 | 40.00 | 0.1942% | |||||||||||||
80 | 59 | 15733 | 59.00 | $0.78 | 16.33 | 23.67 | 4,353,333 | $4,876,503.94 | 40.83 | 59.17 | 40.00 | 0.1938% | |||||||||||||
81 | 60 | 16000 | 60.00 | $0.77 | 16.00 | 24.00 | 4,300,000 | $4,917,877.13 | 40.00 | 60.00 | 40.00 | 0.1935% | |||||||||||||
82 | 61 | 16267 | 61.00 | $0.75 | 15.67 | 24.33 | 4,246,667 | $4,958,681.93 | 39.17 | 60.83 | 40.00 | 0.1933% | |||||||||||||
83 | 62 | 16533 | 62.00 | $0.74 | 15.33 | 24.67 | 4,193,333 | $4,998,915.19 | 38.33 | 61.67 | 40.00 | 0.1931% | |||||||||||||
84 | 63 | 16800 | 63.00 | $0.73 | 15.00 | 25.00 | 4,140,000 | $5,038,573.46 | 37.50 | 62.50 | 40.00 | 0.1929% | |||||||||||||
85 | 64 | 17067 | 64.00 | $0.72 | 14.67 | 25.33 | 4,086,667 | $5,077,652.99 | 36.67 | 63.33 | 40.00 | 0.1929% | |||||||||||||
86 | 65 | 17333 | 65.00 | $0.71 | 14.33 | 25.67 | 4,033,333 | $5,116,149.69 | 35.83 | 64.17 | 40.00 | 0.1929% | |||||||||||||
87 | 66 | 17600 | 66.00 | $0.70 | 14.00 | 26.00 | 3,980,000 | $5,154,059.14 | 35.00 | 65.00 | 40.00 | 0.1930% | |||||||||||||
88 | 67 | 17867 | 67.00 | $0.69 | 13.67 | 26.33 | 3,926,667 | $5,191,376.60 | 34.17 | 65.83 | 40.00 | 0.1931% | |||||||||||||
89 | 68 | 18133 | 68.00 | $0.68 | 13.33 | 26.67 | 3,873,333 | $5,228,096.96 | 33.33 | 66.67 | 40.00 | 0.1933% | |||||||||||||
90 | 69 | 18400 | 69.00 | $0.67 | 13.00 | 27.00 | 3,820,000 | $5,264,214.76 | 32.50 | 67.50 | 40.00 | 0.1936% | |||||||||||||
91 | 70 | 18667 | 70.00 | $0.65 | 12.67 | 27.33 | 3,766,667 | $5,299,724.19 | 31.67 | 68.33 | 40.00 | 0.1940% | |||||||||||||
92 | 71 | 18933 | 71.00 | $0.64 | 12.33 | 27.67 | 3,713,333 | $5,334,619.03 | 30.83 | 69.17 | 40.00 | 0.1944% | |||||||||||||
93 | 72 | 19200 | 72.00 | $0.63 | 12 | 28 | 3,660,000 | $5,368,892.67 | 30.00 | 70.00 | 40.00 | 0.1949% | |||||||||||||
94 | |||||||||||||||||||||||||
95 | |||||||||||||||||||||||||
96 | |||||||||||||||||||||||||
97 | |||||||||||||||||||||||||
98 | |||||||||||||||||||||||||
99 | |||||||||||||||||||||||||
100 |