Hey guys any idea how to answer this? Convert the month-end values into data ranges showing monthly percentage gain/loss
Date | Last Price |
31/01/2000 | 125.5055 |
29/02/2000 | 126.0993 |
31/03/2000 | 126.7455 |
28/04/2000 | 127.343 |
31/05/2000 | 128.0868 |
30/06/2000 | 128.7973 |
31/07/2000 | 129.5336 |
31/08/2000 | 130.2718 |
29/09/2000 | 130.9673 |
31/10/2000 | 131.7381 |
30/11/2000 | 132.4567 |
29/12/2000 | 133.1839 |
31/01/2001 | 133.9608 |
28/02/2001 | 134.556 |
30/03/2001 | 135.1384 |
30/04/2001 | 135.7356 |
31/05/2001 | 136.2422 |
29/06/2001 | 136.6828 |
31/07/2001 | 137.1529 |
31/08/2001 | 137.5915 |
28/09/2001 | 137.9855 |
31/10/2001 | 138.319 |
30/11/2001 | 138.5735 |
31/12/2001 | 138.8205 |
31/01/2002 | 139.0378 |
28/02/2002 | 139.2364 |
29/03/2002 | 139.4482 |
30/04/2002 | 139.6808 |
31/05/2002 | 139.9019 |
28/06/2002 | 140.1024 |
31/07/2002 | 140.339 |
30/08/2002 | 140.5493 |
30/09/2002 | 140.7696 |
31/10/2002 | 140.9939 |
29/11/2002 | 141.1737 |
31/12/2002 | 141.3553 |
31/01/2003 | 141.5235 |
28/02/2003 | 141.671 |
31/03/2003 | 141.8323 |
30/04/2003 | 141.9864 |
30/05/2003 | 142.142 |
30/06/2003 | 142.2962 |
31/07/2003 | 142.4328 |
29/08/2003 | 142.5591 |
30/09/2003 | 142.701 |
31/10/2003 | 142.8386 |
28/11/2003 | 142.9605 |
31/12/2003 | 143.1144 |
30/01/2004 | 143.2474 |
27/02/2004 | 143.3696 |
31/03/2004 | 143.5136 |
30/04/2004 | 143.6445 |
31/05/2004 | 143.78 |
30/06/2004 | 143.9153 |
30/07/2004 | 144.0764 |
31/08/2004 | 144.2711 |
30/09/2004 | 144.4758 |
29/10/2004 | 144.6871 |
30/11/2004 | 144.9438 |
31/12/2004 | 145.236 |
31/01/2005 | 145.5363 |
28/02/2005 | 145.8248 |
31/03/2005 | 146.1692 |
29/04/2005 | 146.5061 |
31/05/2005 | 146.9067 |
30/06/2005 | 147.2921 |
29/07/2005 | 147.6863 |
31/08/2005 | 148.1632 |
30/09/2005 | 148.62 |
31/10/2005 | 149.1171 |
30/11/2005 | 149.6211 |
30/12/2005 | 150.1593 |
31/01/2006 | 150.7467 |
28/02/2006 | 151.2798 |
31/03/2006 | 151.8878 |
28/04/2006 | 152.4551 |
31/05/2006 | 153.1607 |
30/06/2006 | 153.816 |
31/07/2006 | 154.5241 |
31/08/2006 | 155.2392 |
29/09/2006 | 155.9061 |
31/10/2006 | 156.6437 |
30/11/2006 | 157.3367 |
29/12/2006 | 158.0164 |
31/01/2007 | 158.7874 |
28/02/2007 | 159.4444 |
30/03/2007 | 160.1514 |
30/04/2007 | 160.8852 |
31/05/2007 | 161.6224 |
29/06/2007 | 162.3151 |
31/07/2007 | 163.0829 |
31/08/2007 | 163.828 |
28/09/2007 | 164.57 |
31/10/2007 | 165.3503 |
30/11/2007 | 165.9697 |
31/12/2007 | 166.7273 |
31/01/2008 | 167.3917 |
29/02/2008 | 167.8166 |
31/03/2008 | 168.249 |
30/04/2008 | 168.6338 |
30/05/2008 | 169.0125 |
30/06/2008 | 169.3731 |
31/07/2008 | 169.7322 |
29/08/2008 | 170.0679 |
30/09/2008 | 170.4071 |
31/10/2008 | 171.072 |
28/11/2008 | 171.3327 |
31/12/2008 | 171.6113 |
30/01/2009 | 171.6638 |
27/02/2009 | 171.7194 |
31/03/2009 | 171.7994 |
30/04/2009 | 171.8697 |
29/05/2009 | 171.9193 |
30/06/2009 | 171.9661 |
31/07/2009 | 172.01 |
31/08/2009 | 172.0508 |
30/09/2009 | 172.0868 |
30/10/2009 | 172.1222 |
30/11/2009 | 172.1579 |
31/12/2009 | 172.1927 |
29/01/2010 | 172.225 |
26/02/2010 | 172.2557 |
31/03/2010 | 172.2919 |
30/04/2010 | 172.3272 |
31/05/2010 | 172.3725 |
30/06/2010 | 172.4228 |
30/07/2010 | 172.4736 |
31/08/2010 | 172.5181 |
30/09/2010 | 172.5551 |
29/10/2010 | 172.5908 |
30/11/2010 | 172.6295 |
31/12/2010 | 172.6684 |
31/01/2011 | 172.7073 |
28/02/2011 | 172.7426 |
31/03/2011 | 172.7816 |
29/04/2011 | 172.8147 |