-1
$\begingroup$

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.

$\endgroup$

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.

0
$\begingroup$

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

Formula in Excel:

=PROD(1+A1:A31)*1000

one line in R

prod(1+df$value)*1000

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.

$\endgroup$

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