Spreadsheet: 582626d1531967339-monthly-return-average-return-variance-of-returns-standard-deviation-of-returns-monthly-return-average-return-variance-of-returns-standard-deviation-of-returns
Sheet: Sheet1

Date | AORD | CBA | myer | BHP | TLSFLT | WBC | OTHER? | Month? |  | Month | AORD | CBA | myer | BHP | TLSFLT | WBC | OTHER?
2010-01-04 00:00:00 | 4596.9 | 29.02 | 1.41 | 25.21 | 1.65 | 13.26 | 12.76 |  |  | 1
2010-02-01 00:00:00 | 4651.1 | 30.4 | 1.47 | 26.3 | 1.57 | 12.59 | 13.97 |  |  | 2
2010-03-01 00:00:00 | 4893.1 | 31.73 | 1.55 | 28.38 | 1.58 | 14.26 | 14.89 |  |  | 3
2010-04-01 00:00:00 | 4833.9 | 32.98 | 1.5 | 26.53 | 1.68 | 13.5 | 14.55 |  |  | 4
2010-05-03 00:00:00 | 4453.6 | 28.96 | 1.46 | 24.9 | 1.55 | 11.37 | 12.75 |  |  | 5
2010-06-01 00:00:00 | 4324.8 | 27.42 | 1.46 | 24.52 | 1.72 | 11.31 | 11.8 |  |  | 6
2010-07-01 00:00:00 | 4507.4 | 29.63 | 1.59 | 26.12 | 1.7 | 12.62 | 13.33 |  |  | 7
2010-08-02 00:00:00 | 4438.8 | 29.77 | 1.7 | 24.13 | 1.56 | 13.35 | 12.06 |  |  | 8
2010-09-01 00:00:00 | 4636.9 | 30.28 | 1.82 | 25.84 | 1.48 | 15.74 | 12.91 |  |  | 9
2010-10-01 00:00:00 | 4733.4 | 28.94 | 1.86 | 27.84 | 1.51 | 15.97 | 12.61 |  |  | 10
2010-11-01 00:00:00 | 4676.4 | 28.65 | 1.76 | 28.38 | 1.59 | 15.92 | 12.48 |  |  | 11
2010-12-01 00:00:00 | 4846.9 | 30.05 | 1.72 | 30.05 | 1.58 | 17.34 | 12.93 |  |  | 12
2011-01-04 00:00:00 | 4850 | 31.03 | 1.76 | 29.38 | 1.59 | 16.41 | 13.4
2011-02-01 00:00:00 | 4923.6 | 32.55 | 1.58 | 30.62 | 1.69 | 15.46 | 13.7 |  |  | Month | AORD | CBA | myer | BHP | TLSFLT | WBC | OTHER?
2011-03-01 00:00:00 | 4928.6 | 32.11 | 1.64 | 31.38 | 1.71 | 15.95 | 14.17 |  |  | 1
2011-04-01 00:00:00 | 4899 | 32.92 | 1.61 | 30.89 | 1.77 | 16.83 | 14.46 |  |  | 2
2011-05-02 00:00:00 | 4788.9 | 31.02 | 1.46 | 29.9 | 1.83 | 15.81 | 13.51 |  |  | 3
2011-06-01 00:00:00 | 4659.8 | 32.05 | 1.35 | 29.52 | 1.76 | 15.48 | 13.59 |  |  | 4
2011-07-01 00:00:00 | 4500.5 | 30.2 | 1.18 | 27.92 | 1.82 | 15.4 | 12.46 |  |  | 5
2011-08-01 00:00:00 | 4369.9 | 31.29 | 1.09 | 26.79 | 1.97 | 14.21 | 12.57 |  |  | 6
2011-09-01 00:00:00 | 4070.1 | 29.56 | 1.13 | 24.1 | 2.01 | 12.62 | 12.41 |  |  | 7
2011-10-03 00:00:00 | 4360.5 | 31.97 | 1.45 | 26.01 | 2.01 | 14.75 | 13.62 |  |  | 8
2011-11-01 00:00:00 | 4184.7 | 30.76 | 1.32 | 24.03 | 2.05 | 14.01 | 13.24 |  |  | 9
2011-12-01 00:00:00 | 4111 | 31.94 | 1.08 | 23.68 | 2.16 | 11.96 | 12.88 |  |  | 10
2012-01-03 00:00:00 | 4325.7 | 32.88 | 1.19 | 25.79 | 2.16 | 14.32 | 13.62 |  |  | 11
2012-02-01 00:00:00 | 4388.1 | 33.4 | 1.25 | 25.38 | 2.28 | 16.58 | 13.46 |  |  | 12
2012-03-01 00:00:00 | 4420 | 33.85 | 1.39 | 24.33 | 2.27 | 16.78 | 14.09
2012-04-02 00:00:00 | 4467.2 | 35.12 | 1.4 | 24.99 | 2.44 | 16.11 | 14.64 |  |  | Month | AORD | CBA | myer | BHP | TLSFLT | WBC | OTHER?
2012-05-01 00:00:00 | 4133.7 | 33.38 | 1.15 | 22.48 | 2.45 | 13.88 | 13.78 |  |  | 1
2012-06-01 00:00:00 | 4135.5 | 35.88 | 0.96 | 22.11 | 2.55 | 14.44 | 14.35 |  |  | 2
2012-07-02 00:00:00 | 4289.4 | 38.87 | 1.09 | 22.45 | 2.76 | 16.19 | 15.76 |  |  | 3
2012-08-01 00:00:00 | 4339 | 38.91 | 1.19 | 22.35 | 2.8 | 18.23 | 16.82 |  |  | 4
2012-09-03 00:00:00 | 4406.3 | 39.64 | 1.12 | 23.86 | 2.85 | 18.75 | 16.88 |  |  | 5
2012-10-01 00:00:00 | 4535.4 | 41.05 | 1.26 | 24.74 | 3.01 | 21.15 | 17.32 |  |  | 6
2012-11-01 00:00:00 | 4518 | 42.43 | 1.39 | 24.84 | 3.14 | 21.46 | 18.16 |  |  | 7
2012-12-03 00:00:00 | 4664.6 | 44.2 | 1.39 | 26.79 | 3.18 | 21.46 | 18.55 |  |  | 8
2013-01-02 00:00:00 | 4901 | 45.81 | 1.6 | 27.07 | 3.35 | 24.13 | 19.97 |  |  | 9
2013-02-01 00:00:00 | 5120.4 | 49.56 | 1.79 | 26.77 | 3.49 | 25.84 | 21.92 |  |  | 10
2013-03-01 00:00:00 | 4979.9 | 50.1 | 1.99 | 24.22 | 3.43 | 27.25 | 21.91 |  |  | 11
2013-04-02 00:00:00 | 5168.6 | 54.11 | 2.17 | 24.17 | 3.79 | 30.95 | 24.08 |  |  | 12
2013-05-01 00:00:00 | 4914 | 49.25 | 1.66 | 25.79 | 3.6 | 31.84 | 21.14
2013-06-03 00:00:00 | 4775.4 | 50.96 | 1.61 | 23.19 | 3.63 | 31.89 | 21.47 |  |  | Month | AORD | CBA | myer | BHP | TLSFLT | WBC | OTHER?
2013-07-01 00:00:00 | 5035.7 | 54.67 | 1.81 | 25.61 | 3.79 | 36.78 | 22.97 |  |  | 1
2013-08-01 00:00:00 | 5125.3 | 55.85 | 1.86 | 26.43 | 3.88 | 38.11 | 23.34 |  |  | 2
2013-09-02 00:00:00 | 5217.7 | 54.6 | 1.85 | 27.17 | 3.93 | 40.22 | 24.33 |  |  | 3
2013-10-01 00:00:00 | 5420.3 | 58.33 | 1.77 | 28.63 | 4.1 | 43.23 | 25.49 |  |  | 4
2013-11-01 00:00:00 | 5314.3 | 59.67 | 2.02 | 28.42 | 4 | 40.55 | 25.5 |  |  | 5
2013-12-02 00:00:00 | 5353.1 | 59.65 | 1.95 | 28.88 | 4.15 | 39.6 | 25.11 |  |  | 6
2014-01-02 00:00:00 | 5205.1 | 56.91 | 1.79 | 27.8 | 4.07 | 39.53 | 23.94 |  |  | 7
2014-02-03 00:00:00 | 5415.4 | 59.3 | 1.85 | 29.18 | 4.16 | 43.18 | 25.95 |  |  | 8
2014-03-03 00:00:00 | 5403 | 61.5 | 1.67 | 28.46 | 4.19 | 44.37 | 26.8 |  |  | 9
2014-04-01 00:00:00 | 5470.8 | 62.66 | 1.66 | 29.46 | 4.3 | 45.44 | 27.23 |  |  | 10
2014-05-01 00:00:00 | 5473.8 | 64.8 | 1.61 | 28.88 | 4.4 | 42.08 | 27.71 |  |  | 11
2014-06-02 00:00:00 | 5382 | 64.24 | 1.59 | 28.01 | 4.29 | 37.57 | 27.28 |  |  | 12
2014-07-01 00:00:00 | 5623.1 | 66.51 | 1.71 | 30.18 | 4.52 | 40.15 | 27.86
2014-08-01 00:00:00 | 5624.6 | 67.17 | 1.81 | 28.61 | 4.76 | 39.64 | 28.21
2014-09-01 00:00:00 | 5296.8 | 62.19 | 1.53 | 27.17 | 4.54 | 37.25 | 25.87
2014-10-01 00:00:00 | 5505 | 66.47 | 1.52 | 27.25 | 4.82 | 36.53 | 28
2014-11-03 00:00:00 | 5298.1 | 66.67 | 1.27 | 24.81 | 4.87 | 35.23 | 27.24
2014-12-01 00:00:00 | 5388.6 | 70.75 | 1.1 | 23.56 | 5.11 | 28.42 | 27.75
2015-01-02 00:00:00 | 5551.6 | 73.78 | 1.22 | 23.48 | 5.56 | 32.94 | 28.84
2015-02-02 00:00:00 | 5898.5 | 78.31 | 1.45 | 27 | 5.63 | 35.95 | 31.8
2015-03-02 00:00:00 | 5861.9 | 79.57 | 1.15 | 25.9 | 5.58 | 35.23 | 32.96
2015-04-01 00:00:00 | 5773.7 | 75.71 | 1.17 | 26.68 | 5.51 | 38.59 | 30.51
2015-05-01 00:00:00 | 5774.9 | 72.49 | 1.27 | 26.43 | 5.5 | 41.36 | 29.23
2015-06-01 00:00:00 | 5451.2 | 72.52 | 1.04 | 24.16 | 5.43 | 30.31 | 28
2015-07-01 00:00:00 | 5681.7 | 74.59 | 1.07 | 23.62 | 5.74 | 31.65 | 30.37
2015-08-03 00:00:00 | 5222.1 | 66.92 | 1.02 | 22.49 | 5.3 | 32.88 | 27.09
2015-09-01 00:00:00 | 5058.6 | 64.82 | 0.8 | 20.91 | 5.16 | 33.35 | 25.87
2015-10-01 00:00:00 | 5288.6 | 68.39 | 0.87 | 21.66 | 4.96 | 35.06 | 27.52
2015-11-02 00:00:00 | 5218.2 | 70.8 | 1 | 17.02 | 4.93 | 33.24 | 29.48
2015-12-01 00:00:00 | 5344.6 | 76.23 | 1.08 | 16.81 | 5.16 | 36.85 | 30.77
2016-01-01 00:00:00 | 5056.6 | 70.12 | 0.94 | 14.44 | 5.18 | 36.1 | 28.28
2016-02-01 00:00:00 | 4947.9 | 64.99 | 1.04 | 14.65 | 4.83 | 38.24 | 26.36
2016-03-01 00:00:00 | 5151.8 | 69.42 | 1.09 | 16.14 | 5.12 | 40.74 | 27.83
2016-04-01 00:00:00 | 5316 | 68.46 | 0.96 | 19.8 | 5.14 | 37.05 | 28.47
2016-05-02 00:00:00 | 5447.8 | 71.74 | 1.04 | 18.27 | 5.36 | 29.79 | 29.41
2016-06-01 00:00:00 | 5310.4 | 68.91 | 1.04 | 17.85 | 5.34 | 29.76 | 28.16
2016-07-01 00:00:00 | 5644 | 71.67 | 1.24 | 18.69 | 5.54 | 30.34 | 29.78
2016-08-01 00:00:00 | 5529.4 | 69.43 | 1.26 | 19.56 | 5.26 | 34.73 | 28.22
2016-09-01 00:00:00 | 5525.2 | 70.01 | 1.12 | 21.71 | 5.18 | 35.57 | 28.27
2016-10-03 00:00:00 | 5402.4 | 70.96 | 1.13 | 22.38 | 4.98 | 33.12 | 29.19
2016-11-01 00:00:00 | 5502.4 | 76.05 | 1.22 | 23.67 | 5.05 | 32.66 | 31.27
2016-12-01 00:00:00 | 5719.1 | 79.68 | 1.32 | 24.31 | 5.1 | 30.6 | 32.6