Spreadsheet: 720941d1614377789-turning-monthly-returns-based-on-a-stock-id-number-into-annualized-returns-for-each-stock-test_sheet
Sheet: Sheet1

ISIN | Year | Month number | RET
[NAME] | 2002 | 5 | 0.3088
[NAME] | 2002 | 6 | -0.3333
[NAME] | 2002 | 7 | -0.375
[NAME] | 2002 | 8 | -0.0837
[NAME] | 2002 | 9 | -0.2183
[NAME] | 2002 | 10 | 0.2339
[NAME] | 2002 | 11 | -0.3593
[NAME] | 2002 | 12 | 0.1766
[NAME] | 2003 | 1 | -0.2251
[NAME] | 2003 | 2 | 0
[NAME] | 2003 | 3 | 0
[NAME] | 2003 | 4 | 0.2276
[NAME] | 2003 | 5 | 0.1045
[NAME] | 2003 | 6 | 0.0482
[NAME] | 2003 | 7 | -0.3646
[NAME] | 2003 | 8 | 0.1448
[NAME] | 2003 | 9 | 0.4684
[NAME] | 2003 | 10 | -0.2456
[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