Pandas

Unit 4 Homework Assignment: A Whale Off the Port(folio)

First part (#Conduct-Quantitative-Analysis) seems to be ok. In second part (#Create-a-Custom-Portfolio) I had some issues, especially - "Calculate and Plot Rolling 60-day Beta for Your Portfolio compared to the S&P 500" plot looks starange to me, but I couldn't figure out myself. Please, see picture bellow:

Result:

Background

Harold's company has been investing in algorithmic trading strategies. Some of the investment managers love them, some hate them, but they all think their way is best.

You just learned these quantitative analysis techniques with Python and Pandas, so Harold has come to you with a challenge—to help him determine which portfolio is performing the best across multiple areas: volatility, returns, risk, and Sharpe ratios.

You need to create a tool (an analysis notebook) that analyzes and visualizes the major metrics of the portfolios across all of these areas, and determine which portfolio outperformed the others. You will be given the historical daily returns of several portfolios: some from the firm's algorithmic portfolios, some that represent the portfolios of famous "whale" investors like Warren Buffett, and some from the big hedge and mutual funds. You will then use this analysis to create a custom portfolio of stocks and compare its performance to that of the other portfolios, as well as the larger market (S&P 500 Index).

For this homework assignment, you have three main tasks:

1. Read in and Wrangle Returns Data

2. Determine Success of Each Portfolio

3. Choose and Evaluate a Custom Portfolio

---

Instructions

File: Whale Analysis Starter Code

Prepare the Data

First, read and clean several CSV files for analysis. The CSV files include whale portfolio returns, algorithmic trading portfolio returns, and S&P 500 historical prices. Use the Whale Analysis Starter Code to complete the following steps:

1. Use Pandas to read the following CSV files as a DataFrame. Be sure to convert the dates to a DateTimeIndex.

   • whale_returns.csv: Contains returns of some famous "whale" investors' portfolios.

   • algo_returns.csv: Contains returns from the in-house trading algorithms from Harold's company.

   • sp500_history.csv: Contains historical closing prices of the S&P 500 Index.

2. Detect and remove null values.

3. If any columns have dollar signs or characters other than numeric values, remove those characters and convert the data types as needed.

4. The whale portfolios and algorithmic portfolio CSV files contain daily returns, but the S&P 500 CSV file contains closing prices. Convert the S&P 500 closing prices to daily returns.

5. Join Whale Returns, Algorithmic Returns, and the S&P 500 Returns into a single DataFrame with columns for each portfolio's returns.

Conduct Quantitative Analysis

Analyze the data to see if any of the portfolios outperform the stock market (i.e., the S&P 500).

Performance Analysis

1. Calculate and plot daily returns of all portfolios.

2. Calculate and plot cumulative returns for all portfolios. Does any portfolio outperform the S&P 500?

Risk Analysis

1. Create a box plot for each of the returns.

2. Calculate the standard deviation for each portfolio.

3. Determine which portfolios are riskier than the S&P 500.

4. Calculate the Annualized Standard Deviation.

Rolling Statistics

1. Calculate and plot the rolling standard deviation for all portfolios using a 21-day window.

2. Calculate and plot the correlation between each stock to determine which portfolios may mimick the S&P 500.

3. Choose one portfolio, then calculate and plot the 60-day rolling beta between it and the S&P 500.

Rolling Statistics Challenge: Exponentially Weighted Average

An alternative method to calculate a rolling window is to take the exponentially weighted moving average. This is like a moving window average, but it assigns greater importance to more recent observations. Try calculating the ewm with a 21-day half-life.

Sharpe Ratios

Investment managers and their institutional investors look at the return-to-risk ratio, not just the returns. After all, if you have two portfolios that each offer a 10% return, yet one is lower risk, you would invest in the lower-risk portfolio, right?

1. Using the daily returns, calculate and visualize the Sharpe ratios using a bar plot.

2. Determine whether the algorithmic strategies outperform both the market (S&P 500) and the whales portfolios.

Create a Custom Portfolio

Harold is ecstatic that you were able to help him prove that the algorithmic trading portfolios are doing so well compared to the market and whales portfolios. However, now you are wondering whether you can choose your own portfolio that performs just as well as the algorithmic portfolios. Investigate by doing the following:

1. Visit Google Sheets and use the built-in Google Finance function to choose 3-5 stocks for your portfolio.

2. Download the data as CSV files and calculate the portfolio returns.

3. Calculate the weighted returns for your portfolio, assuming equal number of shares per stock.

4. Add your portfolio returns to the DataFrame with the other portfolios.

5. Run the following analyses:

   • Calculate the Annualized Standard Deviation.
   • Calculate and plot rolling std with a 21-day window.
   • Calculate and plot the correlation.
   • Calculate and plot beta for your portfolio compared to the S&P 60 TSX.
   • Calculate the Sharpe ratios and generate a bar plot.

6. How does your portfolio do?

---

Resources

• Pandas API Docs

• Exponential weighted function in Pandas

• GOOGLEFINANCE function help

• Supplemental Guide: Fetching Stock Data Using Google Sheets

---

Hints

• After reading each CSV file, don't forget to sort each DataFrame in ascending order by the Date using sort_index. This is especially important when working with time series data, as we want to make sure Date indexes go from earliest to latest.

• The Pandas functions used in class this week will be useful for this assignment.

• Be sure to use head() or tail() when you want to look at your data, but don't want to print to a large DataFrame.

---

Submission

1. Use the provided starter Jupyter Notebook to house the code for your data preparation, analysis, and visualizations. Put any analysis or answers to assignment questions in raw text (markdown) cells in the report.

2. Submit your notebook to a new GitHub repository.

3. Add the URL of your GitHub repository to your assignment when submitting via Bootcamp Spot.

---

© 2020 Trilogy Education Services, a 2U, Inc. brand. All Rights Reserved.