Spreadsheet: 815108d1674747428-how-do-i-quickly-search-through-monthly-data-and-turn-it-into-yearly-data
Sheet: data

Date | Return
1995-12-01 00:00:00 | 0.1451 |  | 1995
1996-01-01 00:00:00 | 0.0168 |  | 1996
1996-02-01 00:00:00 | -0.085 |  | 1997
1996-03-01 00:00:00 | 0.1162 |  | 1998 | quick way to continue?
1996-04-01 00:00:00 | 0.0618 |  | 1999
1996-05-01 00:00:00 | -0.0946 |  | 2000
1996-06-01 00:00:00 | -0.0014 |  | 2001
1996-07-01 00:00:00 | -0.0723 |  | 2002
1996-08-01 00:00:00 | 0.0019 |  | 2003
1996-09-01 00:00:00 | -0.0152 |  | 2004
1996-10-01 00:00:00 | 0.1514 |  | 2005
1996-11-01 00:00:00 | 0.0505 |  | 2006
1996-12-01 00:00:00 | 0.0464 |  | 2007
1997-01-01 00:00:00 | 0.0222 |  | 2008
1997-02-01 00:00:00 | 0.0457 |  | 2009
1997-03-01 00:00:00 | 0.0271 |  | 2010
1997-04-01 00:00:00 | -0.0544 |  | 2011
1997-05-01 00:00:00 | 0.0556 |  | 2012
1997-06-01 00:00:00 | -0.0332 |  | 2013
1997-07-01 00:00:00 | 0.0275 |  | 2014
1997-08-01 00:00:00 | -0.0571 |  | 2015
1997-09-01 00:00:00 | -0.0283 |  | 2016
1997-10-01 00:00:00 | 0.0402 |  | 2017
1997-11-01 00:00:00 | -0.0125 |  | 2018
1997-12-01 00:00:00 | 0.0756 |  | 2019
1998-01-01 00:00:00 | 0.0356 |  | 2020
1998-02-01 00:00:00 | 0.0269 |  | 2021
1998-03-01 00:00:00 | -0.0073 |  | 2022
1998-04-01 00:00:00 | -0.0802
1998-05-01 00:00:00 | -0.0135
1998-06-01 00:00:00 | 0.0372
1998-07-01 00:00:00 | -0.0222
1998-08-01 00:00:00 | 0.1543
1998-09-01 00:00:00 | 0.0251
1998-10-01 00:00:00 | -0.0151
1998-11-01 00:00:00 | 0.0296
1998-12-01 00:00:00 | 0.0569
1999-01-01 00:00:00 | -0.0769
1999-02-01 00:00:00 | 0.0179
1999-03-01 00:00:00 | -0.0335
1999-04-01 00:00:00 | 0.0592
1999-05-01 00:00:00 | -0.0075
1999-06-01 00:00:00 | 0.0354
1999-07-01 00:00:00 | 0.0051
1999-08-01 00:00:00 | 0.0174
1999-09-01 00:00:00 | 0.0002
1999-10-01 00:00:00 | -0.055
1999-11-01 00:00:00 | 0.0681
1999-12-01 00:00:00 | 0.0201
2000-01-01 00:00:00 | -0.0038
2000-02-01 00:00:00 | -0.004
2000-03-01 00:00:00 | -0.0177
2000-04-01 00:00:00 | -0.0252
2000-05-01 00:00:00 | 0.0246
2000-06-01 00:00:00 | -0.0118
2000-07-01 00:00:00 | -0.03
2000-08-01 00:00:00 | 0.0264
2000-09-01 00:00:00 | -0.0034
2000-10-01 00:00:00 | 0.0194
2000-11-01 00:00:00 | 0.0581
2000-12-01 00:00:00 | 0.0412
2001-01-01 00:00:00 | -0.0042
2001-02-01 00:00:00 | 0.0252
2001-03-01 00:00:00 | 0.1051
2001-04-01 00:00:00 | -0.0688
2001-05-01 00:00:00 | -0.0027
2001-06-01 00:00:00 | -0.0092
2001-07-01 00:00:00 | -0.0052
2001-08-01 00:00:00 | 0.0185
2001-09-01 00:00:00 | 0.0984
2001-10-01 00:00:00 | 0.0535
2001-11-01 00:00:00 | -0.0316
2001-12-01 00:00:00 | 0.0049
2002-01-01 00:00:00 | -0.0249
2002-02-01 00:00:00 | -0.0654
2002-03-01 00:00:00 | 0.057
2002-04-01 00:00:00 | -0.0843
2002-05-01 00:00:00 | 0.0134
2002-06-01 00:00:00 | 0.0693
2002-07-01 00:00:00 | 0.049
2002-08-01 00:00:00 | 0.0426
2002-09-01 00:00:00 | 0.0692
2002-10-01 00:00:00 | -0.0711
2002-11-01 00:00:00 | -0.0549
2002-12-01 00:00:00 | 0.075
2003-01-01 00:00:00 | 0.0418
2003-02-01 00:00:00 | 0.0444
2003-03-01 00:00:00 | -0.0297
2003-04-01 00:00:00 | -0.016
2003-05-01 00:00:00 | 0.1074
2003-06-01 00:00:00 | -0.0356
2003-07-01 00:00:00 | -0.0046
2003-08-01 00:00:00 | -0.0147
2003-09-01 00:00:00 | 0.0032
2003-10-01 00:00:00 | 0.097
2003-11-01 00:00:00 | -0.0089
2003-12-01 00:00:00 | 0.0499
2004-01-01 00:00:00 | 0.0082
2004-02-01 00:00:00 | 0.0733
2004-03-01 00:00:00 | -0.0239
2004-04-01 00:00:00 | -0.0353
2004-05-01 00:00:00 | -0.0298
2004-06-01 00:00:00 | -0.0502
2004-07-01 00:00:00 | 0.0089
2004-08-01 00:00:00 | -0.0637
2004-09-01 00:00:00 | -0.0097
2004-10-01 00:00:00 | 0.0224
2004-11-01 00:00:00 | 0.0461
2004-12-01 00:00:00 | -0.039
2005-01-01 00:00:00 | -0.0436
2005-02-01 00:00:00 | 0.0049
2005-03-01 00:00:00 | 0.0285
2005-04-01 00:00:00 | 0.0234
2005-05-01 00:00:00 | 0.0258
2005-06-01 00:00:00 | 0.0764
2005-07-01 00:00:00 | -0.0412
2005-08-01 00:00:00 | 0.0893
2005-09-01 00:00:00 | -0.0065
2005-10-01 00:00:00 | -0.0914
2005-11-01 00:00:00 | 0.0736
2005-12-01 00:00:00 | 0.0761
2006-01-01 00:00:00 | 0.1216
2006-02-01 00:00:00 | -0.05
2006-03-01 00:00:00 | 0.0511
2006-04-01 00:00:00 | 0.1683
2006-05-01 00:00:00 | -0.0246
2006-06-01 00:00:00 | -0.0013
2006-07-01 00:00:00 | -0.0663
2006-08-01 00:00:00 | -0.0045
2006-09-01 00:00:00 | 0.0042
2006-10-01 00:00:00 | 0.1039
2006-11-01 00:00:00 | 0.0441
2006-12-01 00:00:00 | -0.0154
2007-01-01 00:00:00 | -0.0589
2007-02-01 00:00:00 | 0.0005
2007-03-01 00:00:00 | -0.0516
2007-04-01 00:00:00 | 0.0813
2007-05-01 00:00:00 | -0.0012
2007-06-01 00:00:00 | -0.0022
2007-07-01 00:00:00 | -0.0316
2007-08-01 00:00:00 | -0.0653
2007-09-01 00:00:00 | 0.2056
2007-10-01 00:00:00 | 0.0733
2007-11-01 00:00:00 | 0.004
2007-12-01 00:00:00 | 0.0381
2008-01-01 00:00:00 | 0.0921
2008-02-01 00:00:00 | 0.2002
2008-03-01 00:00:00 | -0.0628
2008-04-01 00:00:00 | 0.0211
2008-05-01 00:00:00 | 0.02
2008-06-01 00:00:00 | 0.0765
2008-07-01 00:00:00 | -0.1233
2008-08-01 00:00:00 | -0.0314
2008-09-01 00:00:00 | -0.0843
2008-10-01 00:00:00 | 0.1377
2008-11-01 00:00:00 | 0.161
2008-12-01 00:00:00 | 0.1276
2009-01-01 00:00:00 | -0.0615
2009-02-01 00:00:00 | -0.0312
2009-03-01 00:00:00 | -0.0463
2009-04-01 00:00:00 | -0.0434
2009-05-01 00:00:00 | 0.0701
2009-06-01 00:00:00 | -0.033
2009-07-01 00:00:00 | -0.0143
2009-08-01 00:00:00 | 0.0495
2009-09-01 00:00:00 | 0.0169
2009-10-01 00:00:00 | -0.0353
2009-11-01 00:00:00 | 0.0871
2009-12-01 00:00:00 | -0.0702
2010-01-01 00:00:00 | -0.102
2010-02-01 00:00:00 | -0.0012
2010-03-01 00:00:00 | 0.0737
2010-04-01 00:00:00 | 0.0119
2010-05-01 00:00:00 | -0.0599
2010-06-01 00:00:00 | -0.0054
2010-07-01 00:00:00 | 0.019
2010-08-01 00:00:00 | 0.0561
2010-09-01 00:00:00 | 0.0357
2010-10-01 00:00:00 | 0.0638
2010-11-01 00:00:00 | -0.0069
2010-12-01 00:00:00 | 0.0836
2011-01-01 00:00:00 | -0.0052
2011-02-01 00:00:00 | 0.0209
2011-03-01 00:00:00 | -0.0285
2011-04-01 00:00:00 | 0.0504
2011-05-01 00:00:00 | -0.0494
2011-06-01 00:00:00 | -0.0398
2011-07-01 00:00:00 | 0.0362
2011-08-01 00:00:00 | -0.0326
2011-09-01 00:00:00 | -0.0958
2011-10-01 00:00:00 | -0.031
2011-11-01 00:00:00 | -0.04
2011-12-01 00:00:00 | -0.009
2012-01-01 00:00:00 | 0.0258
2012-02-01 00:00:00 | 0.04
2012-03-01 00:00:00 | -0.0144
2012-04-01 00:00:00 | -0.0035
2012-05-01 00:00:00 | -0.0124
2012-06-01 00:00:00 | -0.0333
2012-07-01 00:00:00 | 0.0683
2012-08-01 00:00:00 | 0.0154
2012-09-01 00:00:00 | -0.0031
2012-10-01 00:00:00 | -0.1091
2012-11-01 00:00:00 | 0.0088
2012-12-01 00:00:00 | -0.0076
2013-01-01 00:00:00 | 0.0512
2013-02-01 00:00:00 | -0.0325
2013-03-01 00:00:00 | -0.0123
2013-04-01 00:00:00 | 0.026
2013-05-01 00:00:00 | -0.0354
2013-06-01 00:00:00 | -0.1009
2013-07-01 00:00:00 | -0.0099
2013-08-01 00:00:00 | -0.0362
2013-09-01 00:00:00 | -0.004
2013-10-01 00:00:00 | 0.033
2013-11-01 00:00:00 | 0.0229
2013-12-01 00:00:00 | -0.0216
2014-01-01 00:00:00 | -0.0478
2014-02-01 00:00:00 | 0.0226
2014-03-01 00:00:00 | -0.027
2014-04-01 00:00:00 | 0.0231
2014-05-01 00:00:00 | 0.0492
2014-06-01 00:00:00 | 0.0105
2014-07-01 00:00:00 | -0.0307
2014-08-01 00:00:00 | 0.0512
2014-09-01 00:00:00 | -0.0189
2014-10-01 00:00:00 | -0.0372
2014-11-01 00:00:00 | 0.1194
2014-12-01 00:00:00 | 0.0174
2015-01-01 00:00:00 | 0.1351
2015-02-01 00:00:00 | 0.0168
2015-03-01 00:00:00 | 0.031
2015-04-01 00:00:00 | -0.0934
2015-05-01 00:00:00 | -0.0096
2015-06-01 00:00:00 | -0.079
2015-07-01 00:00:00 | 0.0235
2015-08-01 00:00:00 | -0.093
2015-09-01 00:00:00 | 0.0055
2015-10-01 00:00:00 | -0.0045
2015-11-01 00:00:00 | 0.0135
2015-12-01 00:00:00 | -0.0393
2016-01-01 00:00:00 | 0.0263
2016-02-01 00:00:00 | 0.0256
2016-03-01 00:00:00 | -0.0529
2016-04-01 00:00:00 | -0.0107
2016-05-01 00:00:00 | -0.0015
2016-06-01 00:00:00 | 0.0437
2016-07-01 00:00:00 | 0.008
2016-08-01 00:00:00 | -0.0278
2016-09-01 00:00:00 | 0.0179
2016-10-01 00:00:00 | -0.0594
2016-11-01 00:00:00 | -0.0252
2016-12-01 00:00:00 | 0.021
2017-01-01 00:00:00 | -0.013
2017-02-01 00:00:00 | 0.0465
2017-03-01 00:00:00 | -0.0131
2017-04-01 00:00:00 | -0.0085
2017-05-01 00:00:00 | 0.0039
2017-06-01 00:00:00 | -0.0865
2017-07-01 00:00:00 | 0.0125
2017-08-01 00:00:00 | 0.0114
2017-09-01 00:00:00 | -0.0329
2017-10-01 00:00:00 | 0.0677
2017-11-01 00:00:00 | -0.0138
2017-12-01 00:00:00 | -0.0039
2018-01-01 00:00:00 | 0.0438
2018-02-01 00:00:00 | -0.0772
2018-03-01 00:00:00 | -0.0543
2018-04-01 00:00:00 | -0.0376
2018-05-01 00:00:00 | -0.0209
2018-06-01 00:00:00 | -0.0098
2018-07-01 00:00:00 | -0.0128
2018-08-01 00:00:00 | 0.007
2018-09-01 00:00:00 | -0.0215
2018-10-01 00:00:00 | -0.0195
2018-11-01 00:00:00 | -0.0436
2018-12-01 00:00:00 | 0.1105
2019-01-01 00:00:00 | -0.0206
2019-02-01 00:00:00 | 0.0361
2019-03-01 00:00:00 | 0.1026
2019-04-01 00:00:00 | 0.0599
2019-05-01 00:00:00 | 0.0936
2019-06-01 00:00:00 | 0.0273
2019-07-01 00:00:00 | 0.0092
2019-08-01 00:00:00 | 0.0292
2019-09-01 00:00:00 | -0.0218
2019-10-01 00:00:00 | -0.0743
2019-11-01 00:00:00 | 0.0131
2019-12-01 00:00:00 | -0.0495
2020-01-01 00:00:00 | 0.0415
2020-02-01 00:00:00 | 0.0875
2020-03-01 00:00:00 | 0.108
2020-04-01 00:00:00 | 0.0084
2020-05-01 00:00:00 | -0.0101
2020-06-01 00:00:00 | 0.0048
2020-07-01 00:00:00 | 0.0353
2020-08-01 00:00:00 | -0.0091
2020-09-01 00:00:00 | -0.0791
2020-10-01 00:00:00 | -0.0386
2020-11-01 00:00:00 | 0.0584
2020-12-01 00:00:00 | 0.0312
2021-01-01 00:00:00 | -0.0186
2021-02-01 00:00:00 | 0.0723
2021-03-01 00:00:00 | -0.0112
2021-04-01 00:00:00 | 0.0576
2021-05-01 00:00:00 | 0.0223
2021-06-01 00:00:00 | -0.0199
2021-07-01 00:00:00 | -0.0406
2021-08-01 00:00:00 | -0.0089
2021-09-01 00:00:00 | -0.0382
2021-10-01 00:00:00 | 0.0555
2021-11-01 00:00:00 | -0.0744
2021-12-01 00:00:00 | -0.0501
2022-01-01 00:00:00 | 0.0559
2022-02-01 00:00:00 | 0.0017
2022-03-01 00:00:00 | 0.0695
2022-04-01 00:00:00 | 0.0131
2022-05-01 00:00:00 | -0.0136
2022-06-01 00:00:00 | 0.0484
2022-07-01 00:00:00 | 0.0189
2022-08-01 00:00:00 | -0.0208
2022-09-01 00:00:00 | 0.0274
2022-10-01 00:00:00 | -0.0455
2022-11-01 00:00:00 | -0.0047
2022-12-01 00:00:00 | -0.0338