kursenkoalla
New Member
- Joined
- Mar 6, 2017
- Messages
- 1
My input is daily data from 2001 to 2016 for 200 companies.
The output is monthly data (Here I calculate "Product" in June, 2000 = product of all "(RD/100+1)" in June 2000:
<tbody>
</tbody>
Here (in J3): =PRODUCT(E3:E24)
Here (in J4): =PRODUCT(E25:E68) etc.
The problem is that I have to enter the formula for each month for each company to compute this. Is there a more efficient solution to the problem? P.S. Number of days each month/year/for each company isn't the same.
The output is monthly data (Here I calculate "Product" in June, 2000 = product of all "(RD/100+1)" in June 2000:
A | B | C | D | E | F | G | H | I | J | ||
1 | |||||||||||
2 | Company | Price Close | Date | Daily Returns | Daily Data | Company | Date | Monthly Data | |||
3 | XOM | 41,46 | 01.06.2000 | -0,45 | 0,99 | XOM | 30.06.2000 | 0,94 | |||
4 | XOM | 39,59 | 02.06.2000 | -4,52 | 0,95 | XOM | 31.07.2000 | 1,02 | |||
5 | XOM | 39,66 | 03.06.2000 | 0,16 | 1 | XOM | 31.08.2000 | 1,01 | |||
6 | XOM | 41,16 | 04.06.2000 | 3,78 | 1,04 | XOM | 30.09.2000 | ||||
7 | XOM | 40,56 | 05.06.2000 | -1,44 | 0,99 | XOM | 31.10.2000 | ||||
7 | XOM | 40,03 | 06.06.2000 | -1,31 | 0,99 | XOM | 30.11.2000 | ||||
9 | XOM | 39,59 | 07.06.2000 | -1,09 | 0,99 | XOM | 31.12.2000 |
<tbody>
</tbody>
Here (in J3): =PRODUCT(E3:E24)
Here (in J4): =PRODUCT(E25:E68) etc.
The problem is that I have to enter the formula for each month for each company to compute this. Is there a more efficient solution to the problem? P.S. Number of days each month/year/for each company isn't the same.