Hello,
I have a problem that XNPV almost solves, but only almost.
XNPV is defined as XNPV(rate,values,dates). The 'values' and 'dates' are arrays while the rate is a constant param. I would like to make something very similar - but I would like to use the 'rate' param as an array. That way will be able tocalculate NPV using a yield curve. I guess VBA may be needed.
10x, Gidon
I have a problem that XNPV almost solves, but only almost.
XNPV is defined as XNPV(rate,values,dates). The 'values' and 'dates' are arrays while the rate is a constant param. I would like to make something very similar - but I would like to use the 'rate' param as an array. That way will be able tocalculate NPV using a yield curve. I guess VBA may be needed.
10x, Gidon