UNIv3 IL CALC

	B	C	D	E	F	G	I	J
1
2	CONCENTRATED LIQUIDITY IMPERMANENT LOSS CALC (STABLE/UNSTABLE PAIR)						SPECIAL THANKS
3							Barry Fried
4	BLUE = INPUTS, EDIT THESE			GREEN = OUTPUTS, DON'T EDIT THESE			Ologai
5	Volatile Asset	Initial Price (ETH)	ETH Initial Amount	Future Amount, ETH	Future Amount, Stables	Future Value
6	ETH	3500	3.00	-1.451	-$4,604.90	-$6,926.20	INITIAL ASSET AMOUNTS IN LP
7	ETH Upper Tick	ETH Lower Tick	Estimated APR	Effective APR	Initial Stables Needed	LP YIELD	ETH	STABLES
8	2000.00	1000.00	50%	43.00%	-$15,137.45	5.89%	3.00	-$15,137.45
9	Future Price (ETH)	Days in The Future	Days Out of Range	Estimated Interest	Future Value w/ Interest
10	1600	50	7	-$407.98	-$7,334.18
11	IMPERMANT LOSS CALCULATIONS			FINAL TALLIES
12	ETH Value if Held	Stables Value if Held	Total Value if Held	Impermanent Loss ($)	Impermanent Loss (%)	HODL or LP?
13	$4,800.00	-$15,137.45	-$10,337.45	$3,411.25	-33.00%	HODL or LP?
14	ETH Value if LP	Stables Value if LP	Total if LP	PnL After Yield Added ($)	PnL After Yield Added (%)	LP	Hi guys
15	-$2,321.30	-$4,604.90	-$6,926.20	$3,003.26	-29.05%	LP	- Stephen
16
17		UNDER THE HOOD
18		UNDER THE HOOD
19		VARIABLE	DESCRIPTION	FORMULA	VALUES
20		Lx	Liquidity of X	X((√Px*Pb)/(√Pb-√Px)	-549.6927082
21		Ly	Liquidity of Y	Y/(√Px-√Pa)	-549.69
22		Px	Price, Asset X		3500
23		Py	Price, Asset Y		1
24		Pa	Price, Lower Tick Range		1000.00
25		Pb	Price, Upper Tick Range		2000.00
26		X	Amount, Asset X		3.00
27		Y	Amount, Asset Y	Lx(√Px-√Pa)	-$15,137.45
28		L	Liquidity	√K	-549.69
29		K	🤷‍♂️	L²	302162.07
30		X'	Future Amount, Asset X	L((√Pb-√Px')/(√Px'*√Pb))	-1.450815082
31		Y'	Future Amount, Asset Y	L(√Px'-√Pa)	-$4,604.90
32		Px'	Future Price, Asset X		1600
33		Py'	Future Price, Asset Y		1
34		UniV3 AMM Formula		(X + (L/√Pb))(Y + L√Pa) = L²
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
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