Question

Calculate the monthly returns for 08/01/2015 – 08/31/2019 period for

(i) S&P 500:

Date	Adj Close
8/1/2015	1972.18
9/1/2015	1920.03
########	2079.36
########	2080.41
########	2043.94
1/1/2016	1940.24
2/1/2016	1932.23
3/1/2016	2059.74
4/1/2016	2065.3
5/1/2016	2096.95
6/1/2016	2098.86
7/1/2016	2173.6
8/1/2016	2170.95
9/1/2016	2168.27
########	2126.15
########	2198.81
########	2238.83
1/1/2017	2278.87
2/1/2017	2363.64
3/1/2017	2362.72
4/1/2017	2384.2
5/1/2017	2411.8
6/1/2017	2423.41
7/1/2017	2470.3
8/1/2017	2471.65
9/1/2017	2519.36
########	2575.26
########	2584.84
########	2673.61
1/1/2018	2823.81
2/1/2018	2713.83
3/1/2018	2640.87
4/1/2018	2648.05
5/1/2018	2705.27
6/1/2018	2718.37
7/1/2018	2816.29
8/1/2018	2901.52
9/1/2018	2913.98
########	2711.74
########	2760.17
########	2506.85
1/1/2019	2704.1
2/1/2019	2784.49
3/1/2019	2834.4
4/1/2019	2945.83
5/1/2019	2752.06
6/1/2019	2941.76
7/1/2019	2980.38
8/1/2019	2926.46

Answer 1

Date	Adj Close	Monthly return
08-01-2015	1972.18
09-01-2015	1920.03	-2.64%
10-01-2015	2079.36	8.30%
11-01-2015	2080.41	0.05%
12-01-2015	2043.94	-1.75%
01-01-2016	1940.24	-5.07%
02-01-2016	1932.23	-0.41%
03-01-2016	2059.74	6.60%
04-01-2016	2065.3	0.27%
05-01-2016	2096.95	1.53%
06-01-2016	2098.86	0.09%
07-01-2016	2173.6	3.56%
08-01-2016	2170.95	-0.12%
09-01-2016	2168.27	-0.12%
10-01-2016	2126.15	-1.94%
11-01-2016	2198.81	3.42%
12-01-2016	2238.83	1.82%
01-01-2017	2278.87	1.79%
02-01-2017	2363.64	3.72%
03-01-2017	2362.72	-0.04%
04-01-2017	2384.2	0.91%
05-01-2017	2411.8	1.16%
06-01-2017	2423.41	0.48%
07-01-2017	2470.3	1.93%
08-01-2017	2471.65	0.05%
09-01-2017	2519.36	1.93%
10-01-2017	2575.26	2.22%
11-01-2017	2584.84	0.37%
12-01-2017	2673.61	3.43%
01-01-2018	2823.81	5.62%
02-01-2018	2713.83	-3.89%
03-01-2018	2640.87	-2.69%
04-01-2018	2648.05	0.27%
05-01-2018	2705.27	2.16%
06-01-2018	2718.37	0.48%
07-01-2018	2816.29	3.60%
08-01-2018	2901.52	3.03%
09-01-2018	2913.98	0.43%
10-01-2018	2711.74	-6.94%
11-01-2018	2760.17	1.79%
12-01-2018	2506.85	-9.18%
01-01-2019	2704.1	7.87%
02-01-2019	2784.49	2.97%
03-01-2019	2834.4	1.79%
04-01-2019	2945.83	3.93%
05-01-2019	2752.06	-6.58%
06-01-2019	2941.76	6.89%
07-01-2019	2980.38	1.31%
08-01-2019	2926.46	-1.81%

And So On...

Please do rate me and mention doubts, if any, in the comments section.