Spreadsheet: 720983d1614415216-turning-monthly-returns-based-on-a-stock-id-number-into-annualized-returns-for-each-stock-pq-annualised-returns-aligw
Sheet: Sheet1

ISIN | Year | Month number | RET |  | ISIN | Year | RET ANNUAL
[NAME] | 2002 | 5 | 0.3088 |  | DE0001262152 | 1999 | -0.3499
[NAME] | 2002 | 6 | -0.3333 |  | DE0001262186 | 2000 | -1.1005
[NAME] | 2002 | 7 | -0.375 |  | DE0001262152 | 2000 | 0.4930999999999998
[NAME] | 2002 | 8 | -0.0837 |  | DE0003304002 | 2000 | -0.0207
[NAME] | 2002 | 9 | -0.2183 |  | DE0001262186 | 2001 | -0.5583
[NAME] | 2002 | 10 | 0.2339 |  | DE0003304002 | 2001 | -0.5489
[NAME] | 2002 | 11 | -0.3593 |  | DE0001262152 | 2001 | -0.7030000000000001
[NAME] | 2002 | 12 | 0.1766 |  | DE0003304002 | 2002 | -1.14
[NAME] | 2003 | 1 | -0.2251 |  | DE0001262152 | 2002 | -1.3698
[NAME] | 2003 | 2 | 0 |  | [NAME] | 2002 | -0.6503
[NAME] | 2003 | 3 | 0 |  | [NAME] | 2003 | 0.2781
[NAME] | 2003 | 4 | 0.2276 |  | DE0001262152 | 2003 | 0.7132000000000001
[NAME] | 2003 | 5 | 0.1045 |  | DE0003304002 | 2003 | 0.7363999999999999
[NAME] | 2003 | 6 | 0.0482 |  | DE0001262186 | 2003 | 0.2245999999999998
[NAME] | 2003 | 7 | -0.3646 |  | DE0003304002 | 2004 | 0.4591000000000001
[NAME] | 2003 | 8 | 0.1448 |  | [NAME] | 2004 | 0.6821
[NAME] | 2003 | 9 | 0.4684 |  | DE0001262152 | 2004 | -0.5845
[NAME] | 2003 | 10 | -0.2456 |  | DE0001262186 | 2004 | 1.4776
[NAME] | 2003 | 11 | -0.0951
[NAME] | 2003 | 12 | 0.215
[NAME] | 2004 | 1 | 0.4865
[NAME] | 2004 | 2 | -0.0233
[NAME] | 2004 | 3 | 0.1126
[NAME] | 2004 | 4 | 0.1107
[NAME] | 2004 | 5 | 0
[NAME] | 2004 | 6 | 0.015
[NAME] | 2004 | 7 | -0.0285
[NAME] | 2004 | 8 | 0.0435
[NAME] | 2004 | 9 | -0.0281
[NAME] | 2004 | 10 | 0
[NAME] | 2004 | 11 | -0.0139
[NAME] | 2004 | 12 | 0.0076
DE0001262152 | 1999 | 10 | -0.0155
DE0001262152 | 1999 | 11 | -0.3465
DE0001262152 | 1999 | 12 | 0.0121
DE0001262152 | 2000 | 1 | 0.5951
DE0001262152 | 2000 | 2 | 1
DE0001262152 | 2000 | 3 | -0.3982
DE0001262152 | 2000 | 4 | 0.2288
DE0001262152 | 2000 | 5 | -0.1498
DE0001262152 | 2000 | 6 | 0
DE0001262152 | 2000 | 7 | -0.0857
DE0001262152 | 2000 | 8 | 0.0417
DE0001262152 | 2000 | 9 | 0.055
DE0001262152 | 2000 | 10 | 0.019
DE0001262152 | 2000 | 11 | -0.2046
DE0001262152 | 2000 | 12 | -0.6082
DE0001262152 | 2001 | 1 | -0.2612
DE0001262152 | 2001 | 2 | -0.3718
DE0001262152 | 2001 | 3 | 0.1094
DE0001262152 | 2001 | 4 | 0
DE0001262152 | 2001 | 5 | 0.0462
DE0001262152 | 2001 | 6 | -0.202
DE0001262152 | 2001 | 7 | -0.2953
DE0001262152 | 2001 | 8 | 0.0838
DE0001262152 | 2001 | 9 | 0.0365
DE0001262152 | 2001 | 10 | 0.1534
DE0001262152 | 2001 | 11 | 0.2166
DE0001262152 | 2001 | 12 | -0.2186
DE0001262152 | 2002 | 1 | 0.6441
DE0001262152 | 2002 | 2 | -0.2337
DE0001262152 | 2002 | 3 | 0.1429
DE0001262152 | 2002 | 4 | -0.2918
DE0001262152 | 2002 | 5 | 0
DE0001262152 | 2002 | 6 | -0.4157
DE0001262152 | 2002 | 7 | -0.2752
DE0001262152 | 2002 | 8 | -0.6389
DE0001262152 | 2002 | 9 | -0.103
DE0001262152 | 2002 | 10 | 0.1148
DE0001262152 | 2002 | 11 | -0.0244
DE0001262152 | 2002 | 12 | -0.2889
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