Spreadsheet: 96009d1295490517-financial-year-to-date-fytd-automated-calculation-fytd-calculation
Sheet: Sheet1

 |  |  |  | Financial Month |  | index |  | 12month | FYTD
 |  |  |  | 1 | 2007-06-30 00:00:00 | 100
 |  |  |  | 2 | 2007-07-31 00:00:00 | 100.5394 |  |  | 0.5393999999999899
 |  |  |  | 3 | 2007-08-31 00:00:00 | 101.9878711358 |  |  | 1.98787113579999
 |  |  |  | 4 | 2007-09-30 00:00:00 | 103.3185068905088 |  |  | 3.318506890508766
 |  |  |  | 5 | 2007-10-31 00:00:00 | 105.7346101741433 |  |  | 5.734610174143318
 |  |  |  | 6 | 2007-11-30 00:00:00 | 107.3105845387889 |  |  | 7.310584538788922
 |  |  |  | 7 | 2007-12-31 00:00:00 | 110.6190771707043 |  |  | 10.61907717070434
 |  |  |  | 8 | 2008-01-31 00:00:00 | 111.263654533378 |  |  | 11.26365453337803
 |  |  |  | 9 | 2008-02-29 00:00:00 | 112.3178776600818 |  |  | 12.31787766008177
 |  |  |  | 10 | 2008-03-31 00:00:00 | 113.2489928658838 |  |  | 13.24899286588386
 |  |  |  | 11 | 2008-04-30 00:00:00 | 113.7838678591894 |  |  | 13.78386785918944
 |  |  |  | 12 | 2008-05-31 00:00:00 | 114.2417341434548 |  |  | 14.2417341434548
 |  |  |  | 1 | 2008-06-30 00:00:00 | 115.6643864587433 |  | 15.66438645874326 | 15.66438645874326
 |  |  |  | 2 | 2008-07-31 00:00:00 | 116.0375197694592 |  | 15.41497141365391 | 0.3225999999999951
 |  |  |  | 3 | 2008-08-31 00:00:00 | 115.8390956106534 |  | 13.58124679003256 | 0.1510483539999941
 |  |  |  | 4 | 2008-09-30 00:00:00 | 115.9319985653331 |  | 12.20835652241028 | 0.2313694947799094
 |  |  |  | 5 | 2008-10-31 00:00:00 | 115.616779461234 |  | 9.34620108856965 | -0.04115959887640575
 |  |  |  | 6 | 2008-11-30 00:00:00 | 114.5950739811351 |  | 6.78823013932337 | -0.9244958715011298
 |  |  |  | 7 | 2008-12-31 00:00:00 | 112.0129031791181 |  | 1.26002317508298 | -3.156964206028601
 |  |  |  | 8 | 2009-01-31 00:00:00 | 112.3573428563939 |  | 0.9829699802713199 | -2.859171870962141
 |  |  |  | 9 | 2009-02-28 00:00:00 | 111.3126442825152 |  | -0.8949896476933339 | -3.762387290905922
 |  |  |  | 10 | 2009-03-31 00:00:00 | 110.2297948789349 |  | -2.665982195995753 | -4.698586787339987
 |  |  |  | 11 | 2009-04-30 00:00:00 | 106.2141234514953 |  | -6.652739575580169 | -8.170417270677188
 |  |  |  | 12 | 2009-05-31 00:00:00 | 106.023044243406 |  | -7.194122149553895 | -8.33561869000724
 |  |  |  | 1 | 2009-06-30 00:00:00 | 103.080692719563 |  | -10.87948860012215 | -10.87948860012215
 |  |  |  | 2 | 2009-07-31 00:00:00 | 103.4191066337614 |  | -10.87442506593366 | 0.3282999999999925
 |  |  |  | 3 | 2009-08-31 00:00:00 | 103.2852823097773 |  | -10.83728531779177 | 0.198475179799984
 |  |  |  | 4 | 2009-09-30 00:00:00 | 102.3823623718252 |  | -11.68757233652974 | -0.6774598902218321
 |  |  |  | 5 | 2009-10-31 00:00:00 | 102.9801729857143 |  | -10.92973401819821 | -0.09751557852083481
 |  |  |  | 6 | 2009-11-30 00:00:00 | 103.3679963171785 |  | -9.797173014439364 | 0.2787171778104502
 |  |  |  | 7 | 2009-12-31 00:00:00 | 103.9397247048088 |  | -7.207364727793597 | 0.8333587625209082
 |  |  |  | 8 | 2010-01-31 00:00:00 | 104.6876749637846 |  | -6.826138548338657 | 1.558955612176005
 |  |  |  | 9 | 2010-02-28 00:00:00 | 105.4792184741858 |  | -5.240577874984265 | 2.326842875559665
 |  |  |  | 10 | 2010-03-31 00:00:00 | 105.7026234589141 |  | -4.107030612724061 | 2.543571128770106
 |  |  |  | 11 | 2010-04-30 00:00:00 | 106.2964607975063 |  | 0.07752014829607301 | 3.119660911371525
 |  |  |  | 12 | 2010-05-31 00:00:00 | 106.8140182651293 |  | 0.7460397193532531 | 3.621750540349011
 |  |  |  | 1 | 2010-06-30 00:00:00 | 108.4083243017546 |  | 5.168408788914269 | 5.168408788914269
 |  |  |  | 2 | 2010-07-31 00:00:00 | 108.9472220818587 |  | 5.345352157869687 | 0.4971000000000059
 |  |  |  | 3 | 2010-08-31 00:00:00 | 109.5967654199107 |  | 6.11072843002336 | 1.096263710199996
 |  |  |  | 4 | 2010-09-30 00:00:00 | 111.3979882595869 |  | 8.805838895394324 | 2.757780804277132
 |  |  |  | 5 | 2010-10-31 00:00:00 | 112.1522640380926 |  | 8.906657258820804 | 3.453553738102899
 |  |  |  | 6 | 2010-11-30 00:00:00 | 113.6418704090466 |  | 9.939124736773785 | 4.82762383885238
 |  |  |  | 7 | 2010-12-31 00:00:00 | 115.6309440668161 |  | 11.24807612797769 | 6.662421738903834
 |  |  |  | 8 | 2011-01-31 00:00:00 | 116.6309440668161 |  | 11.40847679267225 | 7.584860127690751
 |  |  |  | 9 | 2011-02-28 00:00:00 | 117.6309440668161 |  | 11.52049263201953 | 8.507298516477668
 |  |  |  | 10 | 2011-03-31 00:00:00 | 118.6309440668161 |  | 12.23084175666385 | 9.429736905264585
 |  |  |  | 11 | 2011-04-30 00:00:00 | 119.6309440668161 |  | 12.54461641456899 | 10.3521752940515
 |  |  |  | 12 | 2011-05-31 00:00:00 | 120.6309440668161 |  | 12.93549856666847 | 11.27461368283842
 |  |  |  | 1 | 2011-06-30 00:00:00 | 121.6309440668161 |  | 12.19705207162534 | 12.19705207162534
 |  |  |  | 2 | 2011-07-31 00:00:00 | 122.6309440668161 |  | 12.55995492448263 | 0.8221592027195523
 |  |  |  | 3 | 2011-08-31 00:00:00 | 123.6309440668161 |  | 12.80528544171413 | 1.644318405439105
 |  |  |  | 4 | 2011-09-30 00:00:00 | 124.6309440668161 |  | 11.87898992968604 | 2.466477608158657
 |  |  |  | 5 | 2011-10-31 00:00:00 | 125.6309440668161 |  | 12.01819699702671 | 3.288636810878209
 |  |  |  | 6 | 2011-11-30 00:00:00 | 126.6309440668161 |  | 11.42983093380654 | 4.110796013597762
 |  |  |  | 7 | 2011-12-31 00:00:00 | 127.6309440668161 |  | 10.37784487261986 | 4.932955216317314
 |  |  |  | 8 | 2012-01-31 00:00:00 | 128.6309440668161 |  | 10.28886467139063 | 5.755114419036866
 |  |  |  | 9 | 2012-02-29 00:00:00 | 129.6309440668161 |  | 10.20139734080841 | 6.577273621756419
 |  |  |  | 10 | 2012-03-31 00:00:00 | 130.6309440668161 |  | 10.11540462262634 | 7.399432824475971
 |  |  |  | 11 | 2012-04-30 00:00:00 | 131.6309440668161 |  | 10.03084953780668 | 8.221592027195523
 |  |  |  | 12 | 2012-05-31 00:00:00 | 132.6309440668161 |  | 9.947696333499078 | 9.043751229915076
 |  |  |  | 1 | 2012-06-30 00:00:00 | 133.6309440668161 |  | 9.865910432634628 | 9.865910432634628
 |  |  |  | 2 | 2012-07-31 00:00:00 | 134.6309440668161 |  | 9.785458385985946 | 0.7483296679397844
 |  |  |  | 3 | 2012-08-31 00:00:00 | 135.6309440668161 |  | 9.706307826554017 | 1.496659335879569
 |  |  |  | 4 | 2012-09-30 00:00:00 | 136.6309440668161 |  | 9.628427426150822 | 2.244989003819353
 |  |  |  | 5 | 2012-10-31 00:00:00 | 137.6309440668161 |  | 9.551786854055532 | 2.993318671759115
 |  |  |  | 6 | 2012-11-30 00:00:00 | 138.6309440668161 |  | 9.476356737629832 | 3.7416483396989
 |  |  |  | 7 | 2012-12-31 00:00:00 | 139.6309440668161 |  | 9.4021086247845 | 4.489978007638684