Average return on investment over a year, given dates, investment, income and expense

asked 2018-10-11 11:20:14 +0200

Adriaan gravatar image

I have columns with

) year, ascending

) month, ascending

) day, ascending

) investment, variable

) income, variable

) expense, variable

and I want to calculate the return on investment column, which I define as

cumulative investment averaged over a year back in time / ( cumulative income over a year back in time - cumulative expense over a year back in time)

How do I define such a column?

edit retag flag offensive close merge delete


Please take a look on the financial functions help.


m.a.riosv gravatar imagem.a.riosv ( 2018-10-11 13:39:20 +0200 )edit