I have the following issue:

I need to calculate the daily income of a financial application over a period based on a percentage of a daily financial index. The problem is that for each day, this index has a different value. For example:

Date     value
Apr-1    0,048089%
Apr-2    0,045442%
Apr-3    0,041886%
and so on...
Apr-31   0,035450%

On April 1, the initial value of the investment was $ 1,000. How much will the total be on April 31st?

Is there a way to get the final value using a single formula?

The way I do today, I need to calculate the day-to-day balance.


closed as off-topic by vanguard2k, LocalVolatility, noob2, Daneel Olivaw, amdopt Jun 23 '17 at 19:02

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Basic financial questions are off-topic as they are assumed to be common knowledge for those studying or working in the field of quantitative finance." – vanguard2k, LocalVolatility, noob2, amdopt
If this question can be reworded to fit the rules in the help center, please edit the question.


if the values are calculated using discrete compounding, you could do the following.

Formula in Excel:


one line in R


A word of warning: if you are using this to compound interest rates other than overnight rates, you are on the wrong track.

Anyway, I will vote to close the question since its too basic.


Not the answer you're looking for? Browse other questions tagged or ask your own question.