Analysis of Bitcoin Weekly Returns and Price Fluctuations Project

This project provides an in-depth analysis of Bitcoin's weekly closing prices and returns from 2013 to 2019. The analysis includes the construction of line graphs and histograms to visualize price trends and weekly returns. Descriptive statistics, including mean, median, mode, standard deviation, and confidence intervals, are calculated and interpreted for both Bitcoin and Macquarie Group Limited (MAC) returns. The project explores the location, shape, and spread of the data, along with the construction of 95% confidence intervals. A contingency table is used to analyze the relationship between positive returns for Bitcoin and MAC. The project concludes with a summary of the findings and references relevant sources.

Project about Bitcoin

EXECUTIVE SUMMARY
From the present report assessement has been done about Bitcoin which is one of the famous and
well known cryptocurrency. This report has defined about different calculations which has been
done for determining the weekly closing prices of Bitcoin along with the help of line graph and
histograph. Also, with the help of descriptive statistics analysis has been done about Bitcoin
weekly return in respect of three aspects viz. Location, Shape and Spread.

TABLE OF CONTENTS
EXECUTIVE SUMMARY.........................................................................................................................2
INTRODUCTION.......................................................................................................................................4
ANALYSIS – PART A................................................................................................................................4
1. Line graph presenting the weekly closing price of Bitcoin................................................................4
2. Calculating weekly return for BIT and constructing histogram.........................................................5
3. Calculating & interpreting three aspects of Descriptive Analysis for weekly return: Location, Shape
and Spread.................................................................................................................................................5
4. Constructing 95% confidence interval for BIT return.......................................................................6
5. Reasoning..........................................................................................................................................7
6. Macquarie Group Limited.................................................................................................................7
1. Line graph.....................................................................................................................................8
2. Calculating weekly return for MAC..................................................................................................8
3. Calculating & interpreting Descriptive Analysis for weekly return...................................................9
4. Constructing 95% confidence interval for MAC return.................................................................9
5. Reasoning....................................................................................................................................10
7. Contingency table............................................................................................................................10
CONCLUSION..........................................................................................................................................11
REFERENCES..........................................................................................................................................12
APPENDIX.................................................................................................................................................13

INTRODUCTION
Bitcoin in todays world is known as one of the best as well as popular cryptocurrency which has
become part of most the companies and businesses. For its effective and better use, many
invention has been done in relation to technological advancement. Blockchain technology has
been invented for assisting the functioning of such cryptocurrency which is a form of
decentralized legder depicting about all the transactions through peer to peer network. The
present report is about evaluating the recent prices of Bitcoin. Also, it will form basis on such
pricing evidence of weekly returns that whether individuals should adopt for making investment
in such cryptocurrency i.e. Bitcoin.
ANALYSIS – PART A
1. Line graph presenting the weekly closing price of Bitcoin.
3/11/2013
6/24/2013
10/7/2013
1/20/2014
5/5/2014
8/18/2014
12/1/2014
3/16/2015
6/29/2015
10/12/2015
1/25/2016
5/9/2016
8/22/2016
12/5/2016
3/20/2017
7/3/2017
10/16/2017
1/29/2018
5/14/2018
8/27/2018
12/10/2018
3/25/2019
7/8/2019
0
5000
10000
15000
20000
25000
30000
BIT
As per the line graph drawn above, it can be concluded that the weekly closing price of
Bitcoin from the year 2013 till the year 2019 has been facing fluctuating trends. In year 2013,
there has been a negligible increase in the prices of Bitcoin which has been followed by the
several coming years. It can be interpreted that there has been a very small or no significant
changes in the weekly closing prices of Bitcoin from the time period 2013 till the year 2016. In
the year 2017, there has been a rise in the weekly price of Bitcoin which keeps on increasing at
high phase (Bowden and et.al., 2018). There has been a drastic change in the price of Bitcoin in

2018 as compared to the previous year closing prices when calculated on weekly basis. In 2019, it
can be noticed that a declining trend has come in the price of Bitcoin which again rises with
increasing rate in the coming year.
2. Calculating weekly return for BIT and constructing histogram.
From the above histogram it can be evaluated that there has been declining trend in the weekly
return for Bitcoin price. A fluctuating trend in the value of Bitcoin price has been noticed within a
time frame ranging from the year 2013 to 2019. In the year 2013, the price of Bitcoin was 52.06
which has faced a mix trend of either increasing or decreasing phase till it reaches the price of
15348.8 in the year 2019. There has been a decline in the value of weekly return has been noticed
in a particular time period of every single year. Also, some positivity has been seen in the price of
such crypto currency named as Bitcoin. The most fluctuating trend which has been noticed was in
the year 2019 which has showed both the increase as well as decline in the weeky return value of
Bitcoin as compared to the other time period.
3. Calculating & interpreting three aspects of Descriptive Analysis for weekly return: Location,
Shape and Spread.
Descriptive statistics of weekly return
Particulars Weekly return

Mean 0.027
Standard Error 0.008
Median 0.014
Mode #N/A
Standard Deviation 0.147
Sample Variance 0.022
Kurtosis 6.297
Skewness 1.514
Range 1.255
Minimum -0.398
Maximum 0.857
Sum 8.974
Count 335
Confidence Level (95.0%) 0.016
As per the calculation of descriptive statistics done, the mean value calculated for the
Bitcoin was 0.027. When it come to determining median value, 0.014 is the median value which
has been assessed on the basis of weekly return by considering the location, shape and spread of
Bitcoin. It has been difficult for determining the modal value with present data set therefore, no
mode value has been assessed. In case of standard error done, value determined is 0.008 with
deviation of 0.147 and sample variance of 0.022. The maximum value ascertained with the help of
descriptive statistics is 0.857 with -0.398 as its minimum value. Thus, with the help of highest and
lowest value, Range value has been able to determined i.e. 1.255. At last, at confidence level of
95% 0.016 is the value determined for Bitcoin.
4. Constructing 95% confidence interval for BIT return.
BIT
Confidence Level 95%
Ship A
n 335
Mean 3%

Std Dev 0.147176168
RESULTS
SE 0.008
Z 1.960
Margin of Error 0.016
Lower Limit 1%
Upper Limit 4%
In case of Bit return, at 95% confidence level the limit of lower return is 1% with its upper
limit as 4%.
5. Reasoning
Input hypothetical mean
value 2%
Average return 3%
SQRT N 18.30300522
T -0.34
DOF 334.00
Critical value 1.968
Critical value VS T value
t value is smaller than
critical value (-
0.34<1.968), so the
mean of data set is not
significantly different
from μ0=2%
6. Macquarie Group Limited

1. Line graph
3/11/2013
6/17/2013
9/23/2013
12/30/2013
4/7/2014
7/14/2014
10/20/2014
1/26/2015
5/4/2015
8/10/2015
11/16/2015
2/22/2016
5/30/2016
9/5/2016
12/12/2016
3/20/2017
6/26/2017
10/2/2017
1/8/2018
4/16/2018
7/23/2018
10/29/2018
2/4/2019
5/13/2019
0
20
40
60
80
100
120
140
160
MAC
Above line graph concluded that weekly closing price of MAC from the year 2013 to 2019
has increasing trends. As compared to 2013 significant increase in MAC prices has been
observed. In the year 2013, the weekly price of MAC was which increases to . There has been a
drastic change in the MAC prices in 2019 as compared to previous year closing prices.
2. Calculating weekly return for MAC

From the above histogram it can be interpreted that there is mixed trend in the weekly return
among MAC prices from the year 2013 to 2019. In the year 2013, the price was 37.715 which has
increases to 118.54 in the year 2019. Also, a decline in the value of weekly return has been
noticed in prices of MAC.
3. Calculating & interpreting Descriptive Analysis for weekly return.
Descriptive statistics of weekly return
Particulars Weekly return
Mean 0.004
Standard Error 0.002
Median 0.005
Mode #N/A
Standard Deviation 0.032
Sample Variance 0.001
Kurtosis 1.610
Skewness 0.149
Range 0.245
Minimum -0.110
Maximum 0.135
Sum 1.312
Count 335
Confidence Level (95.0%) 0.003
As per the calculation mean & median value calculated was 0.004 and 0.005. No mode
value has been assessed. Further, standard deviation and error of 0.032 and 0.002 was determined.
The maximum value ascertained was 0.135 with -0.110 as its minimum value from which Range
value calculated is 0.245. Confidence level at 95% determined was 0.003 for MAC.
4. Constructing 95% confidence interval for MAC return.
MAC
Confidence Level 95%

Ship A
n 334
Mean 0.39%
Std Dev 0.03151
RESULTS
SE 0.002
Z 1.960
Margin of Error 0.003
Lower Limit 0.05%
Upper Limit 0.73%
For MAC return, the lower limit will be 0.05% along with 0.73% as its maximum return which
can be earned at the 95% confidence limit.
5. Reasoning
Input hypothetical mean value 2%
Average return 0.39%
SQRT N 18.30300522
T -0.36
DOF 334.00
Critical value 1.968
Critical value VS T value
t value is smaller than
critical value (-
0.36<1.968), so the
mean of data set is not
significantly different
from μ0=2%
7. Contingency table
MAC return
.+ Return .- Return Total
BIT Return .+ Return 313 374 687
.- Return 296 357 653
Total 609 731 1340
Prob (BIT return is positive) 13%
Prob (MAC return is positive) 10%
Prob (positive BIT return conditional on positive 23%

MAC return)
CONCLUSION
From the above file it can be concluded that both the Bitcoin and MAC are having
minimum return of 1% and 0.05%. On the other hand, in case of maximum return the percentage
is 4% and 0.73% for Bitcoin and MAC respectively. Bitcoin has been faciong declining and
fluctuating trend in case of weekly return and weekly closing prices whereas in case of MAC
prices there has been noticed an increasing trend from the year 2013 to year 2019.

REFERENCES
Books and Journals
Bowden, R. and et.al., 2018. Block arrivals in the Bitcoin blockchain. arXiv preprint
arXiv:1801.07447.
Di Crescenzo, A., Martinucci, B. and Mulero, J., 2016. A quantile-based probabilistic mean value
theorem. Probability in the Engineering and Informational Sciences. 30(2). pp.261-280.
Lu, J., Microsoft Technology Licensing LLC, 2015. Iteratively calculating standard deviation for
streamed data. U.S. Patent 9,069,726.
Massmann, C., Woods, R. and Wagener, T., 2018, April. Reducing equifinality by carrying out a
multi-objective evaluation based on the bias, correlation and standard deviation errors.
In EGU General Assembly Conference Abstracts (Vol. 20, p. 11457).
Online
Blockchain technology. 2019. [Online]. Available through: <data61.csiro.au/en/our-work/safety-
and-security/secure-systems-and-platforms/blockchain>.

APPENDIX
1. Bitcoin weekly return table
Date BIT
Weekl
y return
3/11/2013 52.06
3/18/2013 53.84 3.4%
3/25/2013 99.99 85.7%
4/1/2013 139.23 39.2%
4/8/2013 113.07 -18.8%
4/15/2013 123.93 9.6%
4/22/2013 141.36 14.1%
4/29/2013 126.5 -10.5%
5/6/2013 120.39 -4.8%
5/13/2013 125.5 4.2%
5/20/2013 142.52 13.6%
5/27/2013 137.88 -3.3%
6/3/2013 115.66 -16.1%
6/10/2013 120.98 4.6%
6/17/2013 125.28 3.6%
6/24/2013 111.97 -10.6%
7/1/2013 97.54 -12.9%
7/8/2013 114.95 17.8%
7/15/2013 96.5 -16.1%
7/22/2013 92 -4.7%
7/29/2013 99.95 8.6%
8/5/2013 125.49 25.6%
8/12/2013 104.1 -17.0%
8/19/2013 109.53 5.2%
8/26/2013 158.75 44.9%
9/2/2013 136.12 -14.3%
9/9/2013 147.87 8.6%
9/16/2013 143.09 -3.2%
9/23/2013 142.08 -0.7%
9/30/2013 140.24 -1.3%
10/7/2013 151.77 8.2%
10/14/2013 193.52 27.5%
10/21/2013 213.89 10.5%
10/28/2013 233.5 9.2%
11/4/2013 331.05 41.8%

11/11/2013 547.08 65.3%
11/18/2013 974.55 78.1%
11/25/2013
1191.9
9 22.3%
12/2/2013
1016.2
7 -14.7%
12/9/2013
1027.8
2 1.1%
12/16/2013 781.78 -23.9%
12/23/2013 889.11 13.7%
12/30/2013 999 12.4%
1/6/2014
1037.9
2 3.9%
1/13/2014 977.1 -5.9%
1/20/2014 1000 2.3%
1/27/2014 928.99 -7.1%
2/3/2014 850 -8.5%
2/10/2014 740 -12.9%
2/17/2014 728.37 -1.6%
2/24/2014 650 -10.8%
3/3/2014 674.73 3.8%
3/10/2014 669.53 -0.8%
3/17/2014 646.83 -3.4%
3/24/2014 560 -13.4%
3/31/2014 518.31 -7.4%
4/7/2014 475 -8.4%
4/14/2014 567.54 19.5%
4/21/2014 469 -17.4%
4/28/2014 502.16 7.1%
5/5/2014 456 -9.2%
5/12/2014 510.9 12.0%
5/19/2014 648.66 27.0%
5/26/2014 752.71 16.0%
6/2/2014 750 -0.4%
6/9/2014 671.71 -10.4%
6/16/2014 690 2.7%
6/23/2014 665 -3.6%
6/30/2014 661.2 -0.6%
7/7/2014 692.14 4.7%
7/14/2014 614.12 -11.3%
7/21/2014 600.84 -2.2%

7/28/2014 665.93 10.8%
8/4/2014 687.76 3.3%
8/11/2014 584.97 -14.9%
8/18/2014 543 -7.2%
8/25/2014 510.53 -6.0%
9/1/2014 537.92 5.4%
9/8/2014 562.43 4.6%
9/15/2014 424.44 -24.5%
9/22/2014 460.15 8.4%
9/29/2014 353.36 -23.2%
10/6/2014 481.64 36.3%
10/13/2014 485.55 0.8%
10/20/2014 449.98 -7.3%
10/27/2014 419.9 -6.7%
11/3/2014 440.98 5.0%
11/10/2014 463.96 5.2%
11/17/2014 448.09 -3.4%
11/24/2014 471.5 5.2%
12/1/2014 476 1.0%
12/8/2014 419.55 -11.9%
12/15/2014 434.97 3.7%
12/22/2014 443.46 2.0%
12/29/2014 362.8 -18.2%
1/5/2015 350.09 -3.5%
1/12/2015 290.02 -17.2%
1/19/2015 480.51 65.7%
1/26/2015 289.48 -39.8%
2/2/2015 309.59 6.9%
2/9/2015 323.9 4.6%
2/16/2015 323.5 -0.1%
2/23/2015 354.85 9.7%
3/2/2015 351.34 -1.0%
3/9/2015 405.86 15.5%
3/16/2015 349.82 -13.8%
3/23/2015 380 8.6%
3/30/2015 320.56 -15.6%
4/6/2015 379.94 18.5%
4/13/2015 365 -3.9%
4/20/2015 300 -17.8%
4/27/2015 324.68 8.2%
5/4/2015 295.91 -8.9%

5/11/2015 345.03 16.6%
5/18/2015 327.36 -5.1%
5/25/2015 369.69 12.9%
6/1/2015 328.8 -11.1%
6/8/2015 320.5 -2.5%
6/15/2015 312.87 -2.4%
6/22/2015 325.62 4.1%
6/29/2015 362.18 11.2%
7/6/2015 443.58 22.5%
7/13/2015 412.15 -7.1%
7/20/2015 401.96 -2.5%
7/27/2015 415 3.2%
8/3/2015 362.04 -12.8%
8/10/2015 329.08 -9.1%
8/17/2015 357.53 8.6%
8/24/2015 320.4 -10.4%
8/31/2015 349.46 9.1%
9/7/2015 330.8 -5.3%
9/14/2015 323.27 -2.3%
9/21/2015 346.48 7.2%
9/28/2015 350.66 1.2%
10/5/2015 339.59 -3.2%
10/12/2015 373.53 10.0%
10/19/2015 400.01 7.1%
10/26/2015 477.69 19.4%
11/2/2015 551.39 15.4%
11/9/2015 471.79 -14.4%
11/16/2015 476.89 1.1%
11/23/2015 518.39 8.7%
11/30/2015 540.58 4.3%
12/7/2015 605.46 12.0%
12/14/2015 616.24 1.8%
12/21/2015 581.21 -5.7%
12/28/2015 582.38 0.2%
1/4/2016 642.2 10.3%
1/11/2016 554.28 -13.7%
1/18/2016 573.92 3.5%
1/25/2016 532.58 -7.2%
2/1/2016 529.39 -0.6%
2/8/2016 567.05 7.1%
2/15/2016 609.61 7.5%

2/22/2016 606.68 -0.5%
2/29/2016 548.07 -9.7%
3/7/2016 543.69 -0.8%
3/14/2016 584.58 7.5%
3/21/2016 589.97 0.9%
3/28/2016 585.82 -0.7%
4/4/2016 555.66 -5.1%
4/11/2016 574.93 3.5%
4/18/2016 616.19 7.2%
4/25/2016 588.28 -4.5%
5/2/2016 655.87 11.5%
5/9/2016 642.67 -2.0%
5/16/2016 612.75 -4.7%
5/23/2016 701.27 14.4%
5/30/2016 788.69 12.5%
6/6/2016 903.09 14.5%
6/13/2016
1053.0
5 16.6%
6/20/2016 905.65 -14.0%
6/27/2016 897.08 -0.9%
7/4/2016 871.54 -2.8%
7/11/2016 895.01 2.7%
7/18/2016 893.52 -0.2%
7/25/2016 823.18 -7.9%
8/1/2016 787.93 -4.3%
8/8/2016 750.5 -4.8%
8/15/2016 760 1.3%
8/22/2016 770 1.3%
8/29/2016 815.6 5.9%
9/5/2016 814 -0.2%
9/12/2016 834.99 2.6%
9/19/2016 786.2 -5.8%
9/26/2016 819.42 4.2%
10/3/2016 815.57 -0.5%
10/10/2016 854 4.7%
10/17/2016 861.02 0.8%
10/24/2016 925 7.4%
10/31/2016 925.83 0.1%
11/7/2016 931.9 0.7%
11/14/2016
1000.5
2 7.4%

11/21/2016
1002.9
7 0.2%
11/28/2016
1024.2
7 2.1%
12/5/2016 1075.2 5.0%
12/12/2016 1106.2 2.9%
12/19/2016
1235.9
4 11.7%
12/26/2016 1381.4 11.8%
1/2/2017
1244.4
1 -9.9%
1/9/2017
1095.1
6 -12.0%
1/16/2017 1223.2 11.7%
1/23/2017
1238.3
4 1.2%
1/30/2017
1347.7
4 8.8%
2/6/2017
1341.4
8 -0.5%
2/13/2017
1375.9
5 2.6%
2/20/2017
1553.4
6 12.9%
2/27/2017
1690.2
7 8.8%
3/6/2017 1649.1 -2.4%
3/13/2017
1362.2
7 -17.4%
3/20/2017
1277.6
1 -6.2%
3/27/2017
1472.8
8 15.3%
4/3/2017
1612.8
3 9.5%
4/10/2017
1588.7
5 -1.5%
4/17/2017
1683.4
6 6.0%
4/24/2017
1781.7
1 5.8%
5/1/2017
2196.6
7 23.3%
5/8/2017
2595.0
7 18.1%

5/15/2017
2860.8
5 10.2%
5/22/2017
3094.7
9 8.2%
5/29/2017
3493.2
7 12.9%
6/5/2017
3889.4
6 11.3%
6/12/2017
3588.8
6 -7.7%
6/19/2017
3503.3
1 -2.4%
6/26/2017
3342.7
6 -4.6%
7/3/2017
3415.5
1 2.2%
7/10/2017 2510 -26.5%
7/17/2017 3541.5 41.1%
7/24/2017
3529.7
4 -0.3%
7/31/2017
4060.5
3 15.0%
8/7/2017
5318.1
4 31.0%
8/14/2017
5298.7
6 -0.4%
8/21/2017 5620 6.1%
8/28/2017 6018.4 7.1%
9/4/2017
5319.4
6 -11.6%
9/11/2017
4593.0
5 -13.7%
9/18/2017
4625.3
8 0.7%
9/25/2017
5565.3
6 20.3%
10/2/2017
5887.3
5 5.8%
10/9/2017
7226.7
6 22.8%
10/16/2017
7713.9
3 6.7%
10/23/2017
8018.6
5 4.0%
10/30/2017 9692.3 20.9%

9
11/6/2017
7924.8
9 -18.2%
11/13/2017
10693.
5 34.9%
11/20/2017 12298 15.0%
11/27/2017
15024.
2 22.2%
12/4/2017
21184.
9 41.0%
12/11/2017
25986.
6 22.7%
12/18/2017
18939.
8 -27.1%
12/25/2017
19050.
7 0.6%
1/1/2018
22862.
2 20.0%
1/8/2018
19041.
5 -16.7%
1/15/2018
15148.
4 -20.4%
1/22/2018
14445.
1 -4.6%
1/29/2018
10225.
8 -29.2%
2/5/2018
10382.
7 1.5%
2/12/2018
13338.
5 28.5%
2/19/2018
12300.
7 -7.8%
2/26/2018
14763.
9 20.0%
3/5/2018
12143.
7 -17.7%
3/12/2018
10646.
9 -12.3%
3/19/2018
11039.
2 3.7%
3/26/2018
8835.9
8 -20.0%
4/2/2018
9130.3
9 3.3%
4/9/2018 10654. 16.7%

3
4/16/2018
11357.
2 6.6%
4/23/2018
12432.
8 9.5%
4/30/2018
12682.
6 2.0%
5/7/2018 11560 -8.9%
5/14/2018
11318.
5 -2.1%
5/21/2018
9752.0
2 -13.8%
5/28/2018
10233.
1 4.9%
6/4/2018
8956.3
1 -12.5%
6/11/2018
8717.1
9 -2.7%
6/18/2018
8252.9
1 -5.3%
6/25/2018
8489.0
5 2.9%
7/2/2018
8953.6
3 5.5%
7/9/2018
8555.5
2 -4.4%
7/16/2018
9947.2
8 16.3%
7/23/2018
11114.
1 11.7%
7/30/2018
9559.8
1 -14.0%
8/6/2018
8719.7
7 -8.8%
8/13/2018
8920.4
4 2.3%
8/20/2018
9172.4
9 2.8%
8/27/2018
10081.
2 9.9%
9/3/2018
8802.4
3 -12.7%
9/10/2018
9058.8
3 2.9%
9/17/2018 9118.2 0.7%

2
9/24/2018
9139.6
8 0.2%
10/1/2018
9264.6
9 1.4%
10/8/2018
8735.7
4 -5.7%
10/15/2018
9005.4
8 3.1%
10/22/2018
9019.6
1 0.2%
10/29/2018
8908.9
7 -1.2%
11/5/2018
8841.3
9 -0.8%
11/12/2018
7579.2
4 -14.3%
11/19/2018
5435.5
7 -28.3%
11/26/2018
5586.6
5 2.8%
12/3/2018
4914.8
9 -12.0%
12/10/2018
4440.4
4 -9.7%
12/17/2018
5596.1
8 26.0%
12/24/2018
5456.2
6 -2.5%
12/31/2018 5686.6 4.2%
1/7/2019
4908.1
4 -13.7%
1/14/2019
4962.3
4 1.1%
1/21/2019
4942.0
9 -0.4%
1/28/2019
4734.2
4 -4.2%
2/4/2019
5132.3
3 8.4%
2/11/2019 5083.2 -1.0%
2/18/2019
5213.9
9 2.6%
2/25/2019
5340.0
9 2.4%

3/4/2019
5555.1
4 4.0%
3/11/2019
5626.4
5 1.3%
3/18/2019
5617.5
3 -0.2%
3/25/2019
5738.0
9 2.1%
4/1/2019
7253.7
1 26.4%
4/8/2019
7214.6
6 -0.5%
4/15/2019
7437.2
6 3.1%
4/22/2019
7405.2
5 -0.4%
4/29/2019
8120.4
1 9.7%
5/6/2019
9962.3
1 22.7%
5/13/2019
11884.
9 19.3%
5/20/2019
12617.
3 6.2%
5/27/2019
12606.
9 -0.1%
6/3/2019
10983.
8 -12.9%
6/10/2019
12961.
3 18.0%
6/17/2019
15572.
9 20.1%
6/24/2019
15180.
2 -2.5%
7/1/2019 16368 7.8%
7/8/2019
14657.
1 -10.5%
7/15/2019
15057.
7 2.7%
7/22/2019
13891.
6 -7.7%
7/29/2019
16132.
9 16.1%
8/5/2019
17037.
6 5.6%

8/12/2019
15348.
8 -9.9%
2. MAC weekly return table
Date MAC Weekly return
3/11/2013 37.7145
3/18/2013 34.8626 -7.6%
3/25/2013 36.5344 4.8%
4/1/2013 36.023 -1.4%
4/8/2013 37.5375 4.2%
4/15/2013 35.3838 -5.7%
4/22/2013 37.3506 5.6%
4/29/2013 42.3956 13.5%
5/6/2013 45.2082 6.6%
5/13/2013 43.8118 -3.1%
5/20/2013 41.8547 -4.5%
5/27/2013 42.4546 1.4%
6/3/2013 39.6617 -6.6%
6/10/2013 40.8615 3.0%
6/17/2013 41.127 0.6%
6/24/2013 41.1762 0.1%
7/1/2013 41.2647 0.2%
7/8/2013 43.9986 6.6%
7/15/2013 43.3299 -1.5%
7/22/2013 42.2973 -2.4%
7/29/2013 44.451 5.1%
8/5/2013 43.025 -3.2%
8/12/2013 43.6839 1.5%

8/19/2013 43.8904 0.5%
8/26/2013 43.1332 -1.7%
9/2/2013 45.4049 5.3%
9/9/2013 47.9913 5.7%
9/16/2013 49.1715 2.5%
9/23/2013 48.0897 -2.2%
9/30/2013 47.7455 -0.7%
10/7/2013 47.2538 -1.0%
10/14/2013 49.3386 4.4%
10/21/2013 50.3516 2.1%
10/28/2013 52.2201 3.7%
11/4/2013 53.6559 2.7%
11/11/2013 53.6461 0.0%
11/18/2013 53.5969 -0.1%
11/25/2013 53.2822 -0.6%
12/2/2013 50.9908 -4.3%
12/9/2013 51.335 0.7%
12/16/2013 54.8 6.7%
12/23/2013 54.95 0.3%
12/30/2013 55 0.1%
1/6/2014 54.81 -0.3%
1/13/2014 53.96 -1.6%
1/20/2014 55.88 3.6%
1/27/2014 54.09 -3.2%
2/3/2014 54.87 1.4%
2/10/2014 55.36 0.9%
2/17/2014 55.34 0.0%
2/24/2014 56.27 1.7%

3/3/2014 56.84 1.0%
3/10/2014 54.25 -4.6%
3/17/2014 54.83 1.1%
3/24/2014 57.65 5.1%
3/31/2014 57.96 0.5%
4/7/2014 56.37 -2.7%
4/14/2014 55.97 -0.7%
4/21/2014 56.54 1.0%
4/28/2014 58.7 3.8%
5/5/2014 60.12 2.4%
5/12/2014 58.88 -2.1%
5/19/2014 59.3 0.7%
5/26/2014 60.03 1.2%
6/2/2014 60.1 0.1%
6/9/2014 59.98 -0.2%
6/16/2014 60.5 0.9%
6/23/2014 60.46 -0.1%
6/30/2014 60.44 0.0%
7/7/2014 59.26 -2.0%
7/14/2014 60 1.2%
7/21/2014 58.62 -2.3%
7/28/2014 57.71 -1.6%
8/4/2014 55.65 -3.6%
8/11/2014 57.03 2.5%
8/18/2014 58.38 2.4%
8/25/2014 58.3 -0.1%
9/1/2014 57.75 -0.9%

9/8/2014 57.95 0.3%
9/15/2014 58.42 0.8%
9/22/2014 57.79 -1.1%
9/29/2014 57.22 -1.0%
10/6/2014 55.83 -2.4%
10/13/2014 57.49 3.0%
10/20/2014 59.75 3.9%
10/27/2014 61.17 2.4%
11/3/2014 62.36 1.9%
11/10/2014 60.34 -3.2%
11/17/2014 58.45 -3.1%
11/24/2014 58.43 0.0%
12/1/2014 60.4 3.4%
12/8/2014 58.3 -3.5%
12/15/2014 57.82 -0.8%
12/22/2014 58.35 0.9%
12/29/2014 58.54 0.3%
1/5/2015 57.94 -1.0%
1/12/2015 55.29 -4.6%
1/19/2015 61.03 10.4%
1/26/2015 62.15 1.8%
2/2/2015 66.6 7.2%
2/9/2015 68.13 2.3%
2/16/2015 71.2 4.5%
2/23/2015 72.86 2.3%
3/2/2015 75.37 3.4%
3/9/2015 75.39 0.0%

3/16/2015 77.9 3.3%
3/23/2015 77.29 -0.8%
3/30/2015 78.52 1.6%
4/6/2015 80.38 2.4%
4/13/2015 81.21 1.0%
4/20/2015 83.4 2.7%
4/27/2015 78.67 -5.7%
5/4/2015 79.18 0.6%
5/11/2015 82.55 4.3%
5/18/2015 79.64 -3.5%
5/25/2015 81.75 2.6%
6/1/2015 79.13 -3.2%
6/8/2015 79.57 0.6%
6/15/2015 81.33 2.2%
6/22/2015 82.5 1.4%
6/29/2015 82.54 0.0%
7/6/2015 80.6 -2.4%
7/13/2015 83.51 3.6%
7/20/2015 81.5 -2.4%
7/27/2015 82.15 0.8%
8/3/2015 80.08 -2.5%
8/10/2015 78.93 -1.4%
8/17/2015 74.68 -5.4%
8/24/2015 76.92 3.0%
8/31/2015 72.82 -5.3%
9/7/2015 75.8 4.1%
9/14/2015 78.71 3.8%

9/21/2015 77.4 -1.7%
9/28/2015 76.29 -1.4%
10/5/2015 80.94 6.1%
10/12/2015 82.44 1.9%
10/19/2015 83.24 1.0%
10/26/2015 85.7 3.0%
11/2/2015 82.43 -3.8%
11/9/2015 79.76 -3.2%
11/16/2015 83 4.1%
11/23/2015 81.5 -1.8%
11/30/2015 81.83 0.4%
12/7/2015 80.99 -1.0%
12/14/2015 78.3 -3.3%
12/21/2015 80.74 3.1%
12/28/2015 82.77 2.5%
1/4/2016 76.9 -7.1%
1/11/2016 73.52 -4.4%
1/18/2016 73.46 -0.1%
1/25/2016 71.58 -2.6%
2/1/2016 63.74 -11.0%
2/8/2016 58.34 -8.5%
2/15/2016 63.9 9.5%
2/22/2016 63.92 0.0%
2/29/2016 66.33 3.8%
3/7/2016 66.95 0.9%
3/14/2016 68.29 2.0%
3/21/2016 65.81 -3.6%

3/28/2016 64.2 -2.4%
4/4/2016 62.34 -2.9%
4/11/2016 65.54 5.1%
4/18/2016 67.05 2.3%
4/25/2016 63.5 -5.3%
5/2/2016 65.1 2.5%
5/9/2016 71.7 10.1%
5/16/2016 69.65 -2.9%
5/23/2016 73.39 5.4%
5/30/2016 74.6 1.6%
6/6/2016 73.45 -1.5%
6/13/2016 72.72 -1.0%
6/20/2016 71.2 -2.1%
6/27/2016 68.4 -3.9%
7/4/2016 67.2 -1.8%
7/11/2016 71.99 7.1%
7/18/2016 73.8 2.5%
7/25/2016 74.39 0.8%
8/1/2016 75.3 1.2%
8/8/2016 77.54 3.0%
8/15/2016 79.1 2.0%
8/22/2016 79.75 0.8%
8/29/2016 80.61 1.1%
9/5/2016 80.36 -0.3%
9/12/2016 81.39 1.3%
9/19/2016 82.12 0.9%
9/26/2016 81.94 -0.2%

10/3/2016 83.71 2.2%
10/10/2016 81.95 -2.1%
10/17/2016 82.21 0.3%
10/24/2016 81.76 -0.5%
10/31/2016 77.1 -5.7%
11/7/2016 81.97 6.3%
11/14/2016 83.71 2.1%
11/21/2016 83.72 0.0%
11/28/2016 84.23 0.6%
12/5/2016 85.24 1.2%
12/12/2016 87.54 2.7%
12/19/2016 86.93 -0.7%
12/26/2016 87.12 0.2%
1/2/2017 87.8 0.8%
1/9/2017 85.89 -2.2%
1/16/2017 84.83 -1.2%
1/23/2017 85.77 1.1%
1/30/2017 83.51 -2.6%
2/6/2017 85.09 1.9%
2/13/2017 87.06 2.3%
2/20/2017 86.31 -0.9%
2/27/2017 87.72 1.6%
3/6/2017 88.95 1.4%
3/13/2017 88.9 -0.1%
3/20/2017 88.03 -1.0%
3/27/2017 90.2 2.5%
4/3/2017 87.93 -2.5%

4/10/2017 87.9 0.0%
4/17/2017 87.73 -0.2%
4/24/2017 93 6.0%
5/1/2017 94.89 2.0%
5/8/2017 92.63 -2.4%
5/15/2017 87.78 -5.2%
5/22/2017 88.82 1.2%
5/29/2017 89.97 1.3%
6/5/2017 86.51 -3.8%
6/12/2017 90.35 4.4%
6/19/2017 89.4 -1.1%
6/26/2017 88.5 -1.0%
7/3/2017 88.05 -0.5%
7/10/2017 88 -0.1%
7/17/2017 85.5 -2.8%
7/24/2017 85.05 -0.5%
7/31/2017 86.33 1.5%
8/7/2017 86.36 0.0%
8/14/2017 87.39 1.2%
8/21/2017 87.98 0.7%
8/28/2017 86.81 -1.3%
9/4/2017 82.7 -4.7%
9/11/2017 87.51 5.8%
9/18/2017 88.64 1.3%
9/25/2017 90.92 2.6%
10/2/2017 93.02 2.3%
10/9/2017 92.79 -0.2%

10/16/2017 93.86 1.2%
10/23/2017 97.91 4.3%
10/30/2017 99.17 1.3%
11/6/2017 97.94 -1.2%
11/13/2017 98.95 1.0%
11/20/2017 99.34 0.4%
11/27/2017 98.2 -1.1%
12/4/2017 98.65 0.5%
12/11/2017 96.88 -1.8%
12/18/2017 99.93 3.1%
12/25/2017 99.63 -0.3%
1/1/2018 101.34 1.7%
1/8/2018 101.47 0.1%
1/15/2018 102.04 0.6%
1/22/2018 104.96 2.9%
1/29/2018 104.99 0.0%
2/5/2018 100.53 -4.2%
2/12/2018 103.05 2.5%
2/19/2018 101.97 -1.0%
2/26/2018 102.63 0.6%
3/5/2018 105.46 2.8%
3/12/2018 104.9 -0.5%
3/19/2018 103.98 -0.9%
3/26/2018 102.9 -1.0%
4/2/2018 101.35 -1.5%
4/9/2018 104.21 2.8%
4/16/2018 104.8 0.6%

4/23/2018 108.1 3.1%
4/30/2018 108.01 -0.1%
5/7/2018 113.4 5.0%
5/14/2018 114.55 1.0%
5/21/2018 116.88 2.0%
5/28/2018 112.84 -3.5%
6/4/2018 113.07 0.2%
6/11/2018 117.19 3.6%
6/18/2018 122.03 4.1%
6/25/2018 123.65 1.3%
7/2/2018 122.96 -0.6%
7/9/2018 123.01 0.0%
7/16/2018 125.24 1.8%
7/23/2018 124.02 -1.0%
7/30/2018 121.62 -1.9%
8/6/2018 122.29 0.6%
8/13/2018 124.56 1.9%
8/20/2018 125.32 0.6%
8/27/2018 129.4 3.3%
9/3/2018 122.68 -5.2%
9/10/2018 124.43 1.4%
9/17/2018 127.85 2.7%
9/24/2018 126.04 -1.4%
10/1/2018 125.27 -0.6%
10/8/2018 115.53 -7.8%
10/15/2018 116.87 1.2%
10/22/2018 111.17 -4.9%

10/29/2018 122.42 10.1%
11/5/2018 123.64 1.0%
11/12/2018 119 -3.8%
11/19/2018 114.53 -3.8%
11/26/2018 114.42 -0.1%
12/3/2018 113.32 -1.0%
12/10/2018 113.18 -0.1%
12/17/2018 104.82 -7.4%
12/24/2018 108.59 3.6%
12/31/2018 109.41 0.8%
1/7/2019 113.21 3.5%
1/14/2019 118.2 4.4%
1/21/2019 117.81 -0.3%
1/28/2019 116.41 -1.2%
2/4/2019 121.57 4.4%
2/11/2019 124.22 2.2%
2/18/2019 127.64 2.8%
2/25/2019 129.23 1.2%
3/4/2019 128.5 -0.6%
3/11/2019 127.74 -0.6%
3/18/2019 126.97 -0.6%
3/25/2019 129.42 1.9%
4/1/2019 130.7 1.0%
4/8/2019 132 1.0%
4/15/2019 133.17 0.9%
4/22/2019 135.99 2.1%
4/29/2019 128.81 -5.3%