λ Lambdas
Community lambdas.
Copyable definitions. Tested. Tagged. Star the ones you use.
STATS.QUANTILE
(data, p, [method])
Interpolated quantile using a configurable method (linear, lower, higher, midpoint).
IRR.BISECT
(cashflows, [guess])
Internal rate of return via bisection — more stable than the native IRR for irregular flows.
SIM.MONTECARLO
(n, fn)
Run n samples of a parameterless lambda, return the array of results.
STATS.ZSCORE
(data)
Z-score normalize a 1D array. Skips empty cells.