tt_NPER function

dynamic tt_NPER(
  1. dynamic v1,
  2. dynamic v2,
  3. dynamic v3
)

tt_NPER(rate, pmt, pv): number of payment periods

Implementation

dynamic tt_NPER(dynamic v1, dynamic v2, dynamic v3) {
  final rate = varToDouble(v1);
  final pmt = varToDouble(v2);
  final pv = varToDouble(v3);
  if (rate == 0) return -pv / pmt;
  return log(pmt / (pmt + pv * rate)) / log(1 + rate);
}