Spreadsheet: 271078d1381811947-vlookup-to-categorise-data-groups-for-forum-before
Sheet: Before

 | ODDS Levels | Observations | Running toal Obs | Return
1 | 1.01 | 34 | 34 | -0.3464705882352941
2 | 1.02 | 4 | 38 | -0.49
3 | 1.03 | 6 | 44 | -0.6566666666666667
4 | 1.04 | 5 | 49 | -0.376
5 | 1.05 | 18 | 67 | -0.1249999999999999
6 | 1.06 | 14 | 81 | -0.1671428571428571
7 | 1.07 | 9 | 90 | 0.07000000000000006
8 | 1.08 | 9 | 99 | 0.08000000000000007
9 | 1.09 | 11 | 110 | 0.09000000000000008
10 | 1.1 | 16 | 126 | -0.3125
11 | 1.11 | 10 | 136 | -0.223
12 | 1.12 | 19 | 155 | -0.0568421052631578
13 | 1.13 | 22 | 177 | -0.02409090909090916
14 | 1.14 | 17 | 194 | 0.07294117647058806
15 | 1.15 | 19 | 213 | 0.02894736842105261
16 | 1.16 | 19 | 232 | 0.0378947368421052
17 | 1.17 | 28 | 260 | 0.04464285714285721
18 | 1.18 | 25 | 285 | -0.008800000000000141
19 | 1.19 | 38 | 323 | 0.03342105263157902
20 | 1.2 | 57 | 380 | -0.1157894736842106
21 | 1.21 | 28 | 408 | -0.006071428571428616
22 | 1.22 | 47 | 455 | 0.01234042553191483
23 | 1.23 | 36 | 491 | -0.009166666666666656
24 | 1.24 | 33 | 524 | -0.1357575757575757
25 | 1.25 | 53 | 577 | -0.05660377358490565
26 | 1.26 | 48 | 625 | -0.16
27 | 1.27 | 50 | 675 | -0.1110000000000001
28 | 1.28 | 68 | 743 | -0.002352941176470558
29 | 1.29 | 62 | 805 | -0.04290322580645156
30 | 1.3 | 89 | 894 | -0.1089887640449437
31 | 1.31 | 71 | 965 | 0.03323943661971818
32 | 1.32 | 56 | 1021 | 0.0842857142857143
33 | 1.33 | 79 | 1100 | 0.02696202531645575
34 | 1.34 | 70 | 1170 | 0.07200000000000006
35 | 1.35 | 86 | 1256 | -0.07383720930232551
36 | 1.36 | 72 | 1328 | 0.05777777777777793
37 | 1.37 | 73 | 1401 | -0.08041095890410954
38 | 1.38 | 86 | 1487 | -0.08534883720930242
39 | 1.39 | 107 | 1594 | -0.1036448598130842
40 | 1.4 | 194 | 1788 | 0.02474226804123703
41 | 1.41 | 109 | 1897 | 0.0089908256880733
42 | 1.42 | 88 | 1985 | 0.1940909090909091
43 | 1.43 | 85 | 2070 | 0.07670588235294118
44 | 1.44 | 89 | 2159 | -0.01303370786516855
45 | 1.45 | 142 | 2301 | 0.05176056338028179
46 | 1.46 | 107 | 2408 | 0.02336448598130825
47 | 1.47 | 117 | 2525 | 0.01769230769230767
48 | 1.48 | 107 | 2632 | -0.00411214953271033
49 | 1.49 | 146 | 2778 | -0.02027397260273978
50 | 1.5 | 285 | 3063 | -0.02631578947368418
51 | 1.51 | 138 | 3201 | -0.04804347826086952
52 | 1.52 | 135 | 3336 | 0.08088888888888901
53 | 1.53 | 126 | 3462 | -0.02857142857142858
54 | 1.54 | 122 | 3584 | -0.0659016393442623
55 | 1.55 | 144 | 3728 | -0.009722222222222299
56 | 1.56 | 152 | 3880 | -0.08657894736842109
57 | 1.57 | 110 | 3990 | 0.02763636363636368
58 | 1.58 | 133 | 4123 | -0.1921804511278196
59 | 1.59 | 145 | 4268 | -0.02406896551724136
60 | 1.6 | 299 | 4567 | -0.1277591973244148
61 | 1.61 | 154 | 4721 | -0.1218181818181818
62 | 1.62 | 154 | 4875 | -0.1058441558441557
63 | 1.63 | 159 | 5034 | -0.03635220125786176
64 | 1.64 | 169 | 5203 | -0.06840236686390533
65 | 1.65 | 85.23 | 5288.23 | -0.06328124999999996
65 | 1.65 | 106.77 | 5395 | -0.06328124999999996
66 | 1.66 | 170 | 5565 | -0.04305882352941193
67 | 1.67 | 189 | 5754 | -0.01037037037037047
68 | 1.68 | 172 | 5926 | 0.08418604651162798
69 | 1.69 | 220 | 6146 | 0.006318181818181889
70 | 1.7 | 376 | 6522 | -0.01436170212765964
71 | 1.71 | 212 | 6734 | 0.05665094339622634
72 | 1.72 | 203 | 6937 | -0.04256157635467983
73 | 1.73 | 143 | 7080 | 0.0767132867132867
74 | 1.74 | 176 | 7256 | -0.04102272727272727
75 | 1.75 | 262 | 7518 | -0.04484732824427484
76 | 1.76 | 207 | 7725 | 0.04579710144927529
77 | 1.77 | 205 | 7930 | 0.06200000000000006
78 | 1.78 | 169 | 8099 | 0.07431952662721897
79 | 1.79 | 215 | 8314 | -0.1091627906976744
80 | 1.8 | 418 | 8732 | 0.003349282296650768
81 | 1.81 | 262 | 8994 | -0.05354961832061056
82 | 1.82 | 184 | 9178 | -0.1295652173913043
83 | 1.83 | 181 | 9359 | -0.0698342541436463
84 | 1.84 | 202 | 9561 | -0.1346534653465347
85 | 1.85 | 245 | 9806 | -0.1618367346938775
86 | 1.86 | 191 | 9997 | 0.06146596858638742
87 | 1.87 | 176 | 10173 | -0.03312499999999985
88 | 1.88 | 208 | 10381 | -0.02384615384615385
 | 1.89 | 195.46 | 10576.46 | 0.01432432432432429
89 | 1.89 | 63.54 | 10640 | 0.01432432432432429
90 | 1.9 | 442 | 11082 | -0.08868778280542988
91 | 1.91 | 234 | 11316 | -0.1347863247863248
92 | 1.92 | 203 | 11519 | 0.06876847290640398
93 | 1.93 | 224 | 11743 | -0.09531250000000002
94 | 1.94 | 178 | 11921 | -0.07359550561797756
95 | 1.95 | 267 | 12188 | 0.04438202247191003
96 | 1.96 | 214 | 12402 | -0.1757009345794392
97 | 1.97 | 179 | 12581 | 0.07854748603351958
98 | 1.98 | 187 | 12768 | 0.09058823529411764
99 | 1.99 | 214 | 12982 | 0.08799065420560748
100 | 2 | 1642 | 14624 | -0.09378806333739342
101 | 2.01 | 1 | 14625 | 1.01
102 | 2.02 | 504 | 15129 | -0.0461111111111111
103 | 2.03 | 5 | 15134 | -0.1880000000000001
104 | 2.04 | 415 | 15549 | -0.08568674698795176
105 | 2.05 | 2 | 15551 | 0.02499999999999991
 | 2.06 | 313.69 | 15864.69 | -0.01949656750572071