Visualizing risk factor correlation

Investment banks heavily invested in mortgage-backed securities (MBS) before and during the financial crisis. This makes MBS a likely risk factor for the investment bank portfolio. You'll assess this using scatterplots between portfolio returns and an MBS risk measure, the 90-day mortgage delinquency rate mort_del.

mort_del is only available as quarterly data. So portfolio_returns first needs to be transformed from daily to quarterly frequency using the DataFrame .resample() method.

Your workspace contains both portfolio_returns for an equal-weighted portfolio and the delinquency rate mort_del variable. For the scatterplots, plot_average and plot_min are plot axes in your workspace--you'll add your scatterplots to them using the .scatter() method.

This exercise is part of the course

Quantitative Risk Management in Python

Exercise instructions

Transform the daily portfolio_returns data into average quarterly data using the .resample() and .mean() methods.
Add a scatterplot between mort_del and portfolio_q_average to plot_average. Is there a strong correlation?
Now create minimum quarterly data using .min() instead of .mean().
Add a scatterplot between mort_del and portfolio_q_min to plot_min.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Transform the daily portfolio_returns into quarterly average returns
portfolio_q_average = portfolio_returns.____('Q').____.dropna()

# Create a scatterplot between delinquency and quarterly average returns
plot_average.____(____, portfolio_q_average)

# Transform daily portfolio_returns returns into quarterly minimum returns
portfolio_q_min = ____.resample('____').____.dropna()

# Create a scatterplot between delinquency and quarterly minimum returns
plot_min.scatter(____, ____)
plt.show()

Edit and Run Code

This exercise is part of the course

Quantitative Risk Management in Python

AdvancedSkill Level

4.8+

Start Course for Free

Risk management begins with an understanding of risk and return. We’ll recap how risk and return are related to each other, identify risk factors, and use them to re-acquaint ourselves with Modern Portfolio Theory applied to the global financial crisis of 2007-2008.

Exercise 1: Welcome!Exercise 2: Portfolio returns during the crisis Exercise 3: Asset covariance and portfolio volatility Exercise 4: Risk factors and the financial crisis Exercise 5: Frequency resampling primer Exercise 6: Visualizing risk factor correlation

Current Exercise

Exercise 7: Least-squares factor model Exercise 8: Modern portfolio theory Exercise 9: Practice with PyPortfolioOpt: returns Exercise 10: Practice with PyPortfolioOpt: covariance Exercise 11: Breaking down the financial crisis Exercise 12: The efficient frontier and the financial crisis

Now it’s time to expand your portfolio optimization toolkit with risk measures such as Value at Risk (VaR) and Conditional Value at Risk (CVaR). To do this you will use specialized Python libraries including pandas, scipy, and pypfopt. You’ll also learn how to mitigate risk exposure using the Black-Scholes model to hedge an options portfolio.

Exercise 1: Measuring Risk Exercise 2: VaR for the Normal distribution Exercise 3: Comparing CVaR and VaR Exercise 4: Which risk measure is "better"?Exercise 5: Risk exposure and loss Exercise 6: What's your risk appetite?Exercise 7: VaR and risk exposure Exercise 8: CVaR and risk exposure Exercise 9: Risk management using VaR & CVaR Exercise 10: VaR from a fitted distribution Exercise 11: Minimizing CVaR Exercise 12: CVaR risk management and the crisis Exercise 13: Portfolio hedging: offsetting risk Exercise 14: Black-Scholes options pricing Exercise 15: Options pricing and the underlying asset Exercise 16: Using options for hedging

In this chapter, you’ll estimate risk measures using parametric estimation and historical real-world data. You'll then discover how Monte Carlo simulation can help you predict uncertainty. Lastly, you’ll learn how the global financial crisis signaled that randomness itself was changing, by understanding structural breaks and how to identify them.

Exercise 1: Parametric Estimation Exercise 2: Parameter estimation: Normal Exercise 3: Parameter estimation: Skewed Normal Exercise 4: Historical and Monte Carlo Simulation Exercise 5: Historical Simulation Exercise 6: Monte Carlo Simulation Exercise 7: Structural breaks Exercise 8: Crisis structural break: I Exercise 9: Crisis structural break: II Exercise 10: Crisis structural break: III Exercise 11: Volatility and extreme values Exercise 12: Volatility and structural breaks Exercise 13: Extreme values and backtesting

It's time to explore more general risk management tools. These advanced techniques are pivotal when attempting to understand extreme events, such as losses incurred during the financial crisis, and complicated loss distributions which may defy traditional estimation techniques. You’ll also discover how neural networks can be implemented to approximate loss distributions and conduct real-time portfolio optimization.

Exercise 1: Extreme value theory Exercise 2: Block maxima Exercise 3: Extreme events during the crisis Exercise 4: GEV risk estimation Exercise 5: Kernel density estimation Exercise 6: KDE of a loss distribution Exercise 7: Which distribution?Exercise 8: CVaR and loss cover selection Exercise 9: Neural network risk management Exercise 10: Single layer neural networks Exercise 11: Asset price prediction Exercise 12: Real-time risk management Exercise 13: Wrap-up and Future Steps