Daily interest rate calculation

[nigel987]

Hi,

I've attached a sample calculation for daily interst rates in the script. My problem is, that the values/fields that I need to use in the calculation are not created when I start the calculation. I tried around with RangeSum but couldn't find a proper solution.

Appreciate any hint!

KR, Nigel

[niclaz79]

Hi,

I would set the interest rate in a variable:

let vInterest = 0,09;

And then I would work with Peek() function to load data from the previous lines calculated value to the next one for Capital.