Dec 24 2022 01:54 AM - edited Dec 24 2022 01:59 AM
Hi everyone,
Are there any way I can make a binomial lattice graphic like the one i put below?
Binomial
Thank you
Dec 24 2022 01:18 PM - edited Dec 24 2022 01:19 PM
This was possible but involved some pretty awkward 365 formulas.
= LET(
level, SEQUENCE(levels),
nodes, REDUCE({"x","y"}, level,
LAMBDA(acc,n,
VSTACK(acc,
LET(
x, SEQUENCE(n,1,n-1,0),
y, SEQUENCE(n,1,n-1,-2),
b, IF(SEQUENCE(n),NA()),
HSTACK(x, y, x+1, y+1,b, b, x, y, x+1, y-1,b,b)
)
)
)
),
WRAPROWS(TOCOL(DROP(nodes,1)), 2))