Spreadsheet: 720949d1614382756-turning-monthly-returns-based-on-a-stock-id-number-into-annualized-returns-for-each-stock-annualised-returns
Sheet: Sheet1

ISIN | Year | Month number | RET |  |  |  |  |  | Sum of RET
[NAME] | 2002 | 5 | 0.3088 |  |  |  |  |  |  | [NAME] | DE0001262152 | DE0001262186 | DE0003304002 | Grand Total
[NAME] | 2002 | 6 | -0.3333 |  |  |  |  |  | 1999 |  | -0.3499 |  |  | -0.3499
[NAME] | 2002 | 7 | -0.375 |  |  |  |  |  | 10 |  | -0.0155 |  |  | -0.0155
[NAME] | 2002 | 8 | -0.0837 |  |  |  |  |  | 11 |  | -0.3465 |  |  | -0.3465
[NAME] | 2002 | 9 | -0.2183 |  |  |  |  |  | 12 |  | 0.0121 |  |  | 0.0121
[NAME] | 2002 | 10 | 0.2339 |  |  |  |  |  | 2000 |  | 0.4930999999999998 | -1.1005 | -0.0207 | -0.6280999999999999
[NAME] | 2002 | 11 | -0.3593 |  |  |  |  |  | 1 |  | 0.5951 |  |  | 0.5951
[NAME] | 2002 | 12 | 0.1766 |  |  |  |  |  | 2 |  | 1 |  |  | 1
[NAME] | 2003 | 1 | -0.2251 |  |  |  |  |  | 3 |  | -0.3982 |  |  | -0.3982
[NAME] | 2003 | 2 | 0 |  |  |  |  |  | 4 |  | 0.2288 |  |  | 0.2288
[NAME] | 2003 | 3 | 0 |  |  |  |  |  | 5 |  | -0.1498 |  |  | -0.1498
[NAME] | 2003 | 4 | 0.2276 |  |  |  |  |  | 6 |  | 0 |  |  | 0
[NAME] | 2003 | 5 | 0.1045 |  |  |  |  |  | 7 |  | -0.0857 | 0.0807 | -0.0777 | -0.08270000000000001
[NAME] | 2003 | 6 | 0.0482 |  |  |  |  |  | 8 |  | 0.0417 | 0.0276 | 0.236 | 0.3053
[NAME] | 2003 | 7 | -0.3646 |  |  |  |  |  | 9 |  | 0.055 | -0.2338 | -0.0618 | -0.2406
[NAME] | 2003 | 8 | 0.1448 |  |  |  |  |  | 10 |  | 0.019 | -0.1664 | -0.1715 | -0.3189
[NAME] | 2003 | 9 | 0.4684 |  |  |  |  |  | 11 |  | -0.2046 | -0.5272 | -0.2807 | -1.0125
[NAME] | 2003 | 10 | -0.2456 |  |  |  |  |  | 12 |  | -0.6082 | -0.2814 | 0.335 | -0.5546
[NAME] | 2003 | 11 | -0.0951 |  |  |  |  |  | 2001 |  | -0.7030000000000001 | -0.5583 | -0.5489 | -1.8102
[NAME] | 2003 | 12 | 0.215 |  |  |  |  |  | 1 |  | -0.2612 | 0.4949 | -0.1754 | 0.05830000000000002
[NAME] | 2004 | 1 | 0.4865 |  |  |  |  |  | 2 |  | -0.3718 | -0.6103 | -0.1049 | -1.087
[NAME] | 2004 | 2 | -0.0233 |  |  |  |  |  | 3 |  | 0.1094 | 0.0443 | 0.0149 | 0.1686
[NAME] | 2004 | 3 | 0.1126 |  |  |  |  |  | 4 |  | 0 | -0.3562 | 0.1038 | -0.2524
[NAME] | 2004 | 4 | 0.1107 |  |  |  |  |  | 5 |  | 0.0462 | 0.1187 | 0.1111 | 0.276
[NAME] | 2004 | 5 | 0 |  |  |  |  |  | 6 |  | -0.202 | -0.2822 | 0.0133 | -0.4709
[NAME] | 2004 | 6 | 0.015 |  |  |  |  |  | 7 |  | -0.2953 | 0.0325 | -0.1368 | -0.3996000000000001
[NAME] | 2004 | 7 | -0.0285 |  |  |  |  |  | 8 |  | 0.0838 |  | -0.1722 | -0.08839999999999999
[NAME] | 2004 | 8 | 0.0435 |  |  |  |  |  | 9 |  | 0.0365 |  | -0.2266 | -0.1901
[NAME] | 2004 | 9 | -0.0281 |  |  |  |  |  | 10 |  | 0.1534 |  | 0.0476 | 0.201
[NAME] | 2004 | 10 | 0 |  |  |  |  |  | 11 |  | 0.2166 |  | 0.0909 | 0.3075
[NAME] | 2004 | 11 | -0.0139 |  |  |  |  |  | 12 |  | -0.2186 |  | -0.1146 | -0.3332
[NAME] | 2004 | 12 | 0.0076 |  |  |  |  |  | 2002 | -0.6503 | -1.3698 |  | -1.14 | -3.160099999999999
DE0001262152 | 1999 | 10 | -0.0155 |  |  |  |  |  | 1 |  | 0.6441 |  | -0.1423 | 0.5018
DE0001262152 | 1999 | 11 | -0.3465 |  |  |  |  |  | 2 |  | -0.2337 |  | -0.1605 | -0.3942
DE0001262152 | 1999 | 12 | 0.0121 |  |  |  |  |  | 3 |  | 0.1429 |  | -0.3366 | -0.1937
DE0001262152 | 2000 | 1 | 0.5951 |  |  |  |  |  | 4 |  | -0.2918 |  | -0.3472 | -0.639
DE0001262152 | 2000 | 2 | 1 |  |  |  |  |  | 5 | 0.3088 | 0 |  | 0.2472 | 0.556
DE0001262152 | 2000 | 3 | -0.3982 |  |  |  |  |  | 6 | -0.3333 | -0.4157 |  | -0.1501 | -0.8991
DE0001262152 | 2000 | 4 | 0.2288 |  |  |  |  |  | 7 | -0.375 | -0.2752 |  | -0.0587 | -0.7089
DE0001262152 | 2000 | 5 | -0.1498 |  |  |  |  |  | 8 | -0.0837 | -0.6389 |  | -0.0383 | -0.7609
DE0001262152 | 2000 | 6 | 0 |  |  |  |  |  | 9 | -0.2183 | -0.103 |  | -0.2852 | -0.6065
DE0001262152 | 2000 | 7 | -0.0857 |  |  |  |  |  | 10 | 0.2339 | 0.1148 |  | 0.4203 | 0.769
DE0001262152 | 2000 | 8 | 0.0417 |  |  |  |  |  | 11 | -0.3593 | -0.0244 |  | -0.0638 | -0.4475
DE0001262152 | 2000 | 9 | 0.055 |  |  |  |  |  | 12 | 0.1766 | -0.2889 |  | -0.2248 | -0.3371
DE0001262152 | 2000 | 10 | 0.019 |  |  |  |  |  | 2003 | 0.2781 | 0.7132000000000001 | 0.2245999999999998 | 0.7363999999999999 | 1.9523
DE0001262152 | 2000 | 11 | -0.2046 |  |  |  |  |  | 1 | -0.2251 | 0.0703 |  | -0.0299 | -0.1847
DE0001262152 | 2000 | 12 | -0.6082 |  |  |  |  |  | 2 | 0 | -0.2044 |  | 0.0455 | -0.1589
DE0001262152 | 2001 | 1 | -0.2612 |  |  |  |  |  | 3 | 0 | -0.0183 |  | 0.2392 | 0.2209
DE0001262152 | 2001 | 2 | -0.3718 |  |  |  |  |  | 4 | 0.2276 | 0.2804 | 0.3068 | -0.1316 | 0.6832
DE0001262152 | 2001 | 3 | 0.1094 |  |  |  |  |  | 5 | 0.1045 | -0.135 | 0.0652 | 0.0908 | 0.1255
DE0001262152 | 2001 | 4 | 0 |  |  |  |  |  | 6 | 0.0482 | 0.4768 | 0.1878 | 0.1019 | 0.8147
DE0001262152 | 2001 | 5 | 0.0462 |  |  |  |  |  | 7 | -0.3646 | -0.2171 | -0.0653 | 0.3404 | -0.3066
DE0001262152 | 2001 | 6 | -0.202 |  |  |  |  |  | 8 | 0.1448 | 0.0365 | 0.0588 | -0.0282 | 0.2119
DE0001262152 | 2001 | 7 | -0.2953 |  |  |  |  |  | 9 | 0.4684 | 0.3979 | 0.7326 | -0.0193 | 1.5796
DE0001262152 | 2001 | 8 | 0.0838 |  |  |  |  |  | 10 | -0.2456 | -0.2166 | -0.3928 | 0.3091 | -0.5459
DE0001262152 | 2001 | 9 | 0.0365 |  |  |  |  |  | 11 | -0.0951 | -0.1736 | -0.6898 | -0.0954 | -1.0539
DE0001262152 | 2001 | 10 | 0.1534 |  |  |  |  |  | 12 | 0.215 | 0.4163 | 0.0213 | -0.0861 | 0.5665
DE0001262152 | 2001 | 11 | 0.2166 |  |  |  |  |  | 2004 | 0.6821 | -0.5845 | 1.4776 | 0.4591000000000001 | 2.0343
DE0001262152 | 2001 | 12 | -0.2186 |  |  |  |  |  | 1 | 0.4865 | -0.1456 | 0.3021 | 0.0935 | 0.7365
DE0001262152 | 2002 | 1 | 0.6441 |  |  |  |  |  | 2 | -0.0233 | 0 | 0.384 | 0.2508 | 0.6115
DE0001262152 | 2002 | 2 | -0.2337 |  |  |  |  |  | 3 | 0.1126 | -0.2058 | 0.5087 | -0.0622 | 0.3533000000000001
DE0001262152 | 2002 | 3 | 0.1429 |  |  |  |  |  | 4 | 0.1107 | 0.1862 | -0.0651 | 0.1162 | 0.348
DE0001262152 | 2002 | 4 | -0.2918 |  |  |  |  |  | 5 | 0 | -0.0478 | 0.0984 | -0.0616 | -0.011
DE0001262152 | 2002 | 5 | 0 |  |  |  |  |  | 6 | 0.015 | -0.0466 | -0.0336 | 0.0408 | -0.02440000000000001
DE0001262152 | 2002 | 6 | -0.4157 |  |  |  |  |  | 7 | -0.0285 | 0.0414 | -0.112 | 0.2217 | 0.1226
DE0001262152 | 2002 | 7 | -0.2752 |  |  |  |  |  | 8 | 0.0435 | -0.1444 | -0.0087 | -0.1228 | -0.2324
DE0001262152 | 2002 | 8 | -0.6389 |  |  |  |  |  | 9 | -0.0281 | -0.0464 | 0.0746 | 0.0751 | 0.0752
DE0001262152 | 2002 | 9 | -0.103 |  |  |  |  |  | 10 | 0 | -0.1903 | 0.0082 | -0.1435 | -0.3256
DE0001262152 | 2002 | 10 | 0.1148 |  |  |  |  |  | 11 | -0.0139 | -0.1148 | 0.1093 | 0.0133 | -0.006100000000000015
DE0001262152 | 2002 | 11 | -0.0244 |  |  |  |  |  | 12 | 0.0076 | 0.1296 | 0.2117 | 0.0378 | 0.3867
DE0001262152 | 2002 | 12 | -0.2889 |  |  |  |  |  | Grand Total | 0.3099000000000001 | -1.8009 | 0.04340000000000038 | -0.5141 | -1.9617
DE0001262152 | 2003 | 1 | 0.0703
DE0001262152 | 2003 | 2 | -0.2044
DE0001262152 | 2003 | 3 | -0.0183
DE0001262152 | 2003 | 4 | 0.2804
DE0001262152 | 2003 | 5 | -0.135
DE0001262152 | 2003 | 6 | 0.4768
DE0001262152 | 2003 | 7 | -0.2171
DE0001262152 | 2003 | 8 | 0.0365
DE0001262152 | 2003 | 9 | 0.3979
DE0001262152 | 2003 | 10 | -0.2166
DE0001262152 | 2003 | 11 | -0.1736
DE0001262152 | 2003 | 12 | 0.4163
DE0001262152 | 2004 | 1 | -0.1456
DE0001262152 | 2004 | 2 | 0
DE0001262152 | 2004 | 3 | -0.2058
DE0001262152 | 2004 | 4 | 0.1862
DE0001262152 | 2004 | 5 | -0.0478
DE0001262152 | 2004 | 6 | -0.0466
DE0001262152 | 2004 | 7 | 0.0414
DE0001262152 | 2004 | 8 | -0.1444
DE0001262152 | 2004 | 9 | -0.0464
DE0001262152 | 2004 | 10 | -0.1903
DE0001262152 | 2004 | 11 | -0.1148
DE0001262152 | 2004 | 12 | 0.1296
DE0001262186 | 2000 | 7 | 0.0807
DE0001262186 | 2000 | 8 | 0.0276
DE0001262186 | 2000 | 9 | -0.2338
DE0001262186 | 2000 | 10 | -0.1664
DE0001262186 | 2000 | 11 | -0.5272
DE0001262186 | 2000 | 12 | -0.2814
DE0001262186 | 2001 | 1 | 0.4949
DE0001262186 | 2001 | 2 | -0.6103
DE0001262186 | 2001 | 3 | 0.0443
DE0001262186 | 2001 | 4 | -0.3562
DE0001262186 | 2001 | 5 | 0.1187
DE0001262186 | 2001 | 6 | -0.2822
DE0001262186 | 2001 | 7 | 0.0325
DE0001262186 | 2003 | 4 | 0.3068
DE0001262186 | 2003 | 5 | 0.0652
DE0001262186 | 2003 | 6 | 0.1878
DE0001262186 | 2003 | 7 | -0.0653
DE0001262186 | 2003 | 8 | 0.0588
DE0001262186 | 2003 | 9 | 0.7326
DE0001262186 | 2003 | 10 | -0.3928
DE0001262186 | 2003 | 11 | -0.6898
DE0001262186 | 2003 | 12 | 0.0213
DE0001262186 | 2004 | 1 | 0.3021
DE0001262186 | 2004 | 2 | 0.384
DE0001262186 | 2004 | 3 | 0.5087
DE0001262186 | 2004 | 4 | -0.0651
DE0001262186 | 2004 | 5 | 0.0984
DE0001262186 | 2004 | 6 | -0.0336
DE0001262186 | 2004 | 7 | -0.112
DE0001262186 | 2004 | 8 | -0.0087
DE0001262186 | 2004 | 9 | 0.0746
DE0001262186 | 2004 | 10 | 0.0082
DE0001262186 | 2004 | 11 | 0.1093
DE0001262186 | 2004 | 12 | 0.2117
DE0003304002 | 2000 | 7 | -0.0777
DE0003304002 | 2000 | 8 | 0.236
DE0003304002 | 2000 | 9 | -0.0618
DE0003304002 | 2000 | 10 | -0.1715
DE0003304002 | 2000 | 11 | -0.2807
DE0003304002 | 2000 | 12 | 0.335
DE0003304002 | 2001 | 1 | -0.1754
DE0003304002 | 2001 | 2 | -0.1049
DE0003304002 | 2001 | 3 | 0.0149
DE0003304002 | 2001 | 4 | 0.1038
DE0003304002 | 2001 | 5 | 0.1111
DE0003304002 | 2001 | 6 | 0.0133
DE0003304002 | 2001 | 7 | -0.1368
DE0003304002 | 2001 | 8 | -0.1722
DE0003304002 | 2001 | 9 | -0.2266
DE0003304002 | 2001 | 10 | 0.0476
DE0003304002 | 2001 | 11 | 0.0909
DE0003304002 | 2001 | 12 | -0.1146
DE0003304002 | 2002 | 1 | -0.1423
DE0003304002 | 2002 | 2 | -0.1605
DE0003304002 | 2002 | 3 | -0.3366
DE0003304002 | 2002 | 4 | -0.3472
DE0003304002 | 2002 | 5 | 0.2472
DE0003304002 | 2002 | 6 | -0.1501
DE0003304002 | 2002 | 7 | -0.0587
DE0003304002 | 2002 | 8 | -0.0383
DE0003304002 | 2002 | 9 | -0.2852
DE0003304002 | 2002 | 10 | 0.4203
DE0003304002 | 2002 | 11 | -0.0638
DE0003304002 | 2002 | 12 | -0.2248
DE0003304002 | 2003 | 1 | -0.0299
DE0003304002 | 2003 | 2 | 0.0455
DE0003304002 | 2003 | 3 | 0.2392
DE0003304002 | 2003 | 4 | -0.1316
DE0003304002 | 2003 | 5 | 0.0908
DE0003304002 | 2003 | 6 | 0.1019
DE0003304002 | 2003 | 7 | 0.3404
DE0003304002 | 2003 | 8 | -0.0282
DE0003304002 | 2003 | 9 | -0.0193
DE0003304002 | 2003 | 10 | 0.3091
DE0003304002 | 2003 | 11 | -0.0954
DE0003304002 | 2003 | 12 | -0.0861
DE0003304002 | 2004 | 1 | 0.0935
DE0003304002 | 2004 | 2 | 0.2508
DE0003304002 | 2004 | 3 | -0.0622
DE0003304002 | 2004 | 4 | 0.1162
DE0003304002 | 2004 | 5 | -0.0616
DE0003304002 | 2004 | 6 | 0.0408
DE0003304002 | 2004 | 7 | 0.2217
DE0003304002 | 2004 | 8 | -0.1228
DE0003304002 | 2004 | 9 | 0.0751
DE0003304002 | 2004 | 10 | -0.1435
DE0003304002 | 2004 | 11 | 0.0133
DE0003304002 | 2004 | 12 | 0.0378