Advanced Financial Modeling
Fall 2021 – Unit 1 Project
Due Date: Sunday, November 28
Instructions:
You can work in groups (≤ 4 people) or individually. All knowledge that is required to com-
plete this assignment can be found in the course materials (slide decks & notebook files).
But if you would like to, feel free to supplement with outside materials.
You will have to submit the Python code (.ipynb or .py files) necessary to generate you
outputs. It is mandatory that you write your code in Python. Each group should submit one
copy of your finished project via Engage and I ask that written answers be given through
commented out text in the Python file. If you would like, you can also write it out in a
separate document.
If you are working in groups, please write down all names on the submission so that all
deserving members receive credit.
We will be reading codes and it will be apparent to us if we see identical codes across groups.
Copied codes will automatically result in a 0 for this project.
1
Total project grades will be out of 50.
1. Warm-Up (5 pts). Write a line of code that prints all even numbers between 0 and
100. Do not use a loop to do so.
2. Fibonacci Sequence (10 pts). The Fibonacci sequence is a set of numbers where
following the first two numbers of the sequence (0 and 1), each successive number is
the sum of the prior 2 numbers. Write a function that prints the first N digits of the
sequence where N is an input into the function. For example, if 10 is provided as an
input {0, 1, 1, 2, 3, 5, 8, 13, 21, 34} is printed.
3. Tech Stocks and March XXXXXXXXXXpts). The purpose of this exercise is to examine
the performance of prominent tech industry stocks over the course of 2020, while bette
understanding indexing in Python.
(a) Start by loading the main dataset into Python, techstocks.xlsx. How many
columns are there / what companies are we looking at?
(b) Convert the date column to a Pandas datetime object as we have done previously
in the live session. Choose either the iloc or loc commands to trim the dataset
such that it starts on Fe
uary 28, 2020.
(c) What is the cumulative performance of each ticker from March till the end of the
dataset? To compute the cumulative performance add 1 to all returns and take
the product of all returns, over the relevant period.
(d) What is the performance of each ticker over March and April combined? Which
companies benefited the most from the shift in work conditions due to COVID?
4. Industry Return Properties (20 pts). The purpose of this exercise is to examine
industry returns on a monthly basis and see which sectors display the greatest risks
overall.
(a) Start by loading the main dataset into Python, indreturns french.xlsx. The
data are monthly returns for 17 industries from Ken French’s website. Make the
index column into a Pandas datetime object. How far does the data set go back?
(b) Compute the mean, standard deviation, and Sharpe ratio of monthly returns
in each industry. You do not need to take into account risk free returns when
computing Sharpes. Which 5 industries display the highest Sharpe ratios? What
are they?
(c) Using only returns starting from January of 1970, re-compute the Sharpe ratios.
Are the industries that display the highest risk-adjusted returns, different than
those identified in part (b)?
2
(d) Sharpe ratios are only one (crude) measure of measuring risk-adjusted returns.
We can also examine how industries perform when the overall market is severely
underperforming. Using data from the S&P 500, one can find that the worst five
performing months (after 1970) are given by:
Date Return
October XXXXXXXXXX%
October XXXXXXXXXX%
August XXXXXXXXXX%
March XXXXXXXXXX%
September XXXXXXXXXX%
Using the loc operator, examine the returns across industry in these 5 months.
Which industry (or industries) seem to be insulated against market crashes?
(e) Explain, in words, why the above form of analysis is a qualitative way of examining
industry beta to the market?
3
MSFT
Date MSFT AMZN AAPL ZM NFLX
1/4/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/5/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/6/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/7/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/8/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/11/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/12/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/13/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/14/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/15/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/19/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/20/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/21/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/22/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/25/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/26/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/27/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/28/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
1/29/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/1/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/2/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/3/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/4/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/5/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/8/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/9/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/10/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/11/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/12/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/16/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/17/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/18/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/19/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/22/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/23/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/24/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/25/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/26/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
2/29/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/1/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/2/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/3/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/4/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/7/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/8/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/9/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/10/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/11/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/14/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/15/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/16/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/17/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/18/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/21/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/22/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/23/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/24/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/28/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/29/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/30/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
3/31/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/1/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/4/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/5/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/6/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/7/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/8/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/11/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/12/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/13/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/14/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/15/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/18/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/19/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/20/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/21/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/22/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/25/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/26/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/27/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/28/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
4/29/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/2/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/3/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/4/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/5/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/6/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/9/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/10/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/11/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/12/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/13/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/16/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/17/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/18/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/19/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/20/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/23/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/24/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/25/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/26/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/27/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
5/31/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/1/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/2/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/3/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/6/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/7/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/8/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/9/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/10/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/13/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/14/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/15/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/16/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/17/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/20/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/21/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/22/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/23/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/24/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/27/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/28/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/29/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
6/30/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/1/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/5/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/6/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/7/16 0 XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/8/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/11/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/12/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/13/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/14/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/15/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/18/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/19/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/20/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/21/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/22/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/25/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/26/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/27/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/28/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
7/29/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/1/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/2/16 0 XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/3/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/4/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/5/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/8/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/9/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/10/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/11/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/12/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/15/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/16/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/17/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/18/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/19/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/22/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/23/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/24/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/25/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/26/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/29/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/30/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
8/31/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA 0
9/1/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/2/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA 0
9/6/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/7/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/8/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/9/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/12/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/13/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/14/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/15/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/16/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/19/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/20/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/21/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/22/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/23/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/26/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/27/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/28/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/29/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
9/30/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/3/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/4/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/5/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/6/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/7/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/10/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/11/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/12/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/13/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/14/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/17/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/18/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/19/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/20/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/21/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/24/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/25/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/26/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/27/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/28/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
10/31/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/1/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/2/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/3/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/4/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/7/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/8/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/9/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/10/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/11/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/14/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/15/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/16/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/17/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/18/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/21/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/22/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/23/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/25/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/28/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/29/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
11/30/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/1/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/2/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/5/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/6/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/7/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/8/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/9/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/12/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/13/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/14/16 XXXXXXXXXX XXXXXXXXXX 0 NA XXXXXXXXXX
12/15/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/16/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/19/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX
12/20/16 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX NA XXXXXXXXXX