Jan-25-2021, 11:50 AM
Hello,
I have a very basic question and would appreciate any help.
I have a column with percentage changes on a daily basis for the last 100 days. Now I'd like to calculate a new column that shows the cumulative return for each day, i.e. for day 3 it would be: % change day 1* % change day 2 * % change day 3.
In Excel this task would be very simple, but in Python I have no idea how to solve this.
I'd be happy if someone could please help me.
Many thanks,
Tim
I have a very basic question and would appreciate any help.
I have a column with percentage changes on a daily basis for the last 100 days. Now I'd like to calculate a new column that shows the cumulative return for each day, i.e. for day 3 it would be: % change day 1* % change day 2 * % change day 3.
In Excel this task would be very simple, but in Python I have no idea how to solve this.
I'd be happy if someone could please help me.
Many thanks,
Tim