Recursive calculation

Thanks Anonymous, I've actually seen it before posting but couldn't extract exactly what I need from it,

I'll give it another try.

Thanks v-qiuyu-msft.

Basically what I am trying to do is like compund interest.

Imagine you have a 100 dollars. Each day you get 1% on your 100 so in day 2 you have 101, In day 3 you have 102.01, In day 4 you have 103.0301 etc.

Now, let's change it a bit - 1% a day is not fixed. It can change. On one day it's 1%, the next day it's zero, the next day it's 2%.

You need to be able to calculate your return over time. After 3 or 300 or 4562 days, for any given date range.

Example of dataset :

date,interest

11/1/2016, 0.01

11/2/2016, 0.01

11/3/2016, 0.005

11/4/2016, 0

11/5/2016, 0.02

So, based on the above dataset, if I want to calculate the return for the entire period, it would be like that :

100*(1+0.01)*(1+0.01)*(1+0.005)*(1+0)*(1+0.02)

If I want to calculate the return in the date ramge 2/11-4/11 :

100*(1+0.01)*(1+0.005)*(1+0)

I hope it makes sense.

Please let me know if you need additional information.

Any help is much appreciated. Thanks !