Quant Mashup - Portfolio Optimizer

Index Tracking: Reproducing the Performance of a Financial Market Index (and more) [Portfolio Optimizer]

An index tracking portfolio1 is a portfolio designed to track as closely2 as possible a financial market index when its exact replication3 is either impractical or impossible due to various reasons4 (transaction costs, liquidity issues, licensing requirements…). In this blog post, after reviewing

*- 1 month ago, 1 Nov 2023, 02:15am -*

Volatility Forecasting: Simple and Exponentially Weighted Moving Average Models [Portfolio Optimizer]

One of the simplest and most pragmatic approach to volatility forecasting is to model the volatility of an asset as a weighted moving average of its past squared returns1. Two weighting schemes widely used by practitioners23 are the constant weighting scheme and the exponentially decreasing

*- 1 month ago, 20 Oct 2023, 02:18am -*

Range-Based Volatility Estimators: Overview and Examples of Usage [Portfolio Optimizer]

Volatility estimation and forecasting plays a crucial role in many areas of finance. For example, standard risk-based portfolio allocation methods (minimum variance, equal risk contributions, hierarchical risk parity…) critically depend on the ability to build accurate volatility forecasts1.

*- 2 months ago, 20 Sep 2023, 09:45pm -*

Correlation Matrix Stress Testing: Random Perturbations of a Correlation Matrix [Portfolio Optimizer]

In the previous posts of this series, I detailed a methodology to perform stress tests on a correlation matrix by linearly shrinking a baseline correlation matrix toward an equicorrelation matrix or, more generally, toward the lower and upper bounds of its coefficients. This methodology allows to

*- 3 months ago, 23 Aug 2023, 05:34pm -*

Managing Missing Asset Returns in Portfolio Analysis: Backfilling through Residuals Recycling [Portfolio Optimizer]

In a multi-asset portfolio, it is usual that some assets have shorter return histories than others1. Problem is, the presence of assets whose return histories differ in length makes it nearly impossible to use standard portfolio analysis and optimization methods… Estimating the historical

*- 4 months ago, 26 Jul 2023, 06:06pm -*

Simulation from a Multivariate Normal Distribution with Exact Sample Mean Vector and Sample Covariance Matrix [Portfolio Optimizer]

In the research report Random rotations and multivariate normal simulation1, Robert Wedderburn introduced an algorithm to simulate i.i.d. samples from a multivariate normal (Gaussian) distribution when the desired sample mean vector and sample covariance matrix are known in advance2. Wedderburn

*- 4 months ago, 6 Jul 2023, 05:50pm -*

The Bogle Model for Bonds: Predicting the Returns of Constant Maturity Government Bond ETFs [Portfolio Optimizer]

In his original 1991 article Investing in the 1990s1, John Bogle described a simple model to help investors setting reasonable expectations for long-term U.S. government bond returns. This model relies on what Bogle describes as the single most important factor in forecasting future total returns

*- 5 months ago, 9 Jun 2023, 03:27am -*

The Single Greatest Predictor of Future Stock Market Returns, Ten Years After [Portfolio Optimizer]

In his 2013 post The Single Greatest Predictor of Future Stock Market Returns, Jesse Livermore1 from the blog Philosophical Economics introduced an indicator to forecast long-term U.S. stock market returns and empirically demonstrated that it outperformed all the commonly used stock market valuation

*- 6 months ago, 22 May 2023, 08:59am -*

The Gerber Statistic: A Robust Co-Movement Measure for Correlation Matrix Estimation [Portfolio Optimizer]

The Gerber statistic is a measure of co-movement similar in spirit to the Kendall’s Tau coefficient that has been introduced in Gerber et al.1 to estimate correlation matrices within the Markowitz’s mean-variance framework. In this post, after providing the necessary definitions, I will

*- 6 months ago, 8 May 2023, 11:06pm -*

Corrected Cornish-Fisher Expansion: Improving the Accuracy of Modified Value-at-Risk [Portfolio Optimizer]

Modified Value-at-Risk (mVaR) is a parametric approach to computing Value-at-Risk introduced by Zangari1 that adjusts Gaussian Value-at-Risk for asymmetry and fat tails present in financial asset returns2 through a mathematical technique called Cornish–Fisher expansion. Since its publication, mVaR

*- 7 months ago, 13 Apr 2023, 10:17pm -*

The Mathematics of Bonds: Simulating the Returns of Constant Maturity Government Bond ETFs [Portfolio Optimizer]

With more than $1.2 trillion under management in the U.S. as of mid-July 20221, investors are more and more using bond ETFs as building blocks in their asset allocation. One issue with such instruments, though, is that their price history dates back to at best 20021, which is problematic in some

*- 8 months ago, 20 Mar 2023, 05:31am -*

The Turbulence Index: Regime-based Partitioning of Asset Returns [Portfolio Optimizer]

The turbulence index, introduced in the previous blog post, is a measure of statistical unusualness of asset returns popularized by Kritzman and Li1. It provides a way to measure how much the behavior of a group of assets differs from its historical pattern. In this post, based on the paper Optimal

*- 8 months ago, 7 Mar 2023, 09:02pm -*

The Diversification Ratio: Measuring Portfolio Diversification [Portfolio Optimizer]

Continuing the series of blog posts on diversification indicators, I describe in this post a correlation-based measure of portfolio diversification called the diversification ratio, initially introduced by Yves Choueffaty and Yves Coignard in their paper Toward maximum diversification1 and later

*- 10 months ago, 17 Jan 2023, 03:10pm -*

The Informativeness: Measuring the Homogeneity of a Universe of Assets [Portfolio Optimizer]

In this post, I will describe a measure of the homogeneity of a universe of assets, called the informativeness, introduced by Brockmeier et al.1 in their paper Quantifying the Informativeness of Similarity Measurements. After quickly going through the associated mathematics, I will present two

*- 11 months ago, 16 Dec 2022, 08:40pm -*

Trading Strategy Monitoring: Modeling PnL as Geometric Brownian Motion [Portfolio Optimizer]

Systematic trading strategies have the unfortunate habit of exhibiting worse performances in real-life than in backtests, partially due to backtest overfitting1. Monitoring their behavior once they are deployed in production is then very important to be able to detect as early as possible any

*- 1 year ago, 9 Nov 2022, 10:03am -*

Correlation Matrices Denoising: Results from Random Matrix Theory [Portfolio Optimizer]

The estimation of empirical correlation matrices in finance is known to be affected by noise, in the form of measurement error, due in part to the short length of the time series of asset returns typically used in their computation1. Worse, large empirical correlation matrices have been shown to be

*- 1 year ago, 21 Oct 2022, 11:06am -*

The Probabilistic Sharpe Ratio: Hypothesis Testing and Min Track Record Length [Portfolio Optimizer]

In the first post of this series about the Sharpe ratio considered as a statistical estimator, I introduced a probabilistic framework to answer the question What is the probability that an estimated Sharpe ratio is statistically significantly greater than a reference Sharpe ratio? In this second

*- 1 year ago, 27 Sep 2022, 01:46am -*

The Probabilistic Sharpe Ratio [Portfolio Optimizer]

The Sharpe ratio1 is one of the most commonly used measure of financial portfolio performance, but because it is deeply rooted in mean-variance theory, its usage with return distributions deviating from normality (e.g. hedge funds, cryptocurrencies) is frequently questioned2. One solution to this

*- 1 year ago, 16 Sep 2022, 07:07am -*

Bootstrap Simulation with Portfolio Optimizer: Usage for Financial Planning [Portfolio Optimizer]

In statistics, a bootstrap method, also called bootstrapping, is a compute-intensive procedure that allows to estimate the distribution of a statistic through repeated resampling from a single observed sample of data1. Bootstrapping has several applications in quantitative finance, for example to

*- 1 year ago, 8 Sep 2022, 10:01am -*

Computation of Theory-Implied Correlation Matrices [Portfolio Optimizer]

In this short post, I will provide an overview of the TIC algorithm1 introduced by Marcos Lopez de Prado in his paper Estimation of Theory-Implied Correlation Matrices2, which aims to compute a forward-looking asset correlation matrix blending both empirical and theoretical inputs. I will also

*- 1 year ago, 24 Aug 2022, 11:13pm -*

The Effective Number of Bets: Measuring Portfolio Diversification [Portfolio Optimizer]

Many different measures of portfolio diversification have been developed in the financial literature, from asset weights-based diversification measures like the Herfindahl Index1 to risk-based diversification measures like the Diversification Ratio of Choueifaty and Coignard2 to other more complex

*- 1 year ago, 2 Aug 2022, 10:20am -*

Correlation Matrix Stress Testing: Shrinkage Toward the Lower and Upper Bounds of a Correlation Matrix [Portfolio Optimizer]

I previously described on this blog an intuitive way of performing stress tests on a correlation matrix, which consists in shrinking a baseline correlation matrix toward an equicorrelation matrix12. A limitation of this method, though, is that it alters all the correlation coefficients of the

*- 1 year ago, 18 Jul 2022, 11:39pm -*

Mean-Variance Optimization in Practice: Subset Resampling-based Efficient Portfolios [Portfolio Optimizer]

In a previous post, I introduced near efficient portfolios, which are portfolios equivalent to mean-variance efficient portfolios in terms of risk-return but more diversified in terms of asset weights. Such near efficient portfolios might be used to moderate the tendency of efficient portfolios to

*- 1 year ago, 7 Jun 2022, 09:36pm -*

Selecting a Stock Market Data (Web) API: Not So Simple [Portfolio Optimizer]

I am sometimes asked if I recommend any stock market data (web) API for a personal use, especially because I mention Alpha Vantage in a couple of previous posts1. I will describe in this post part of the thought process and of the due diligence which led me to select this financial market data

*- 1 year ago, 11 May 2022, 10:11am -*

The Absorption Ratio: Measuring Financial Risk, Part 2 [Portfolio Optimizer]

In the previous post, I reviewed the turbulence index, an indicator of financial market stress periods based on the Mahalanobis distance, introduced by Chow and al.1 and Kritzman and Li2. In this post, I will review the absorption ratio, a measure of financial market fragility based on principal

*- 1 year ago, 29 Apr 2022, 04:17am -*

The Turbulence Index: Measuring Financial Risk [Portfolio Optimizer]

One of the challenges in portfolio management is the timely detection of financial market stress periods, typically characterized by an increase in volatility and a breakdown in asset correlations1. Chow and al.2 propose to detect such periods through the usage of the caste distance, a measure

*- 1 year ago, 18 Apr 2022, 10:31am -*

Mean-Variance Optimization: Well Diversified (Near) Efficient Portfolios [Portfolio Optimizer]

One well-known stylized fact of the Markowitz’s mean-variance framework is that, irrespective of the quality of the estimates of asset returns and (co)variances, efficient portfolios are concentrated in a very few assets1. From a practitioner’s perspective, this has always been a problem12. In

*- 1 year ago, 1 Apr 2022, 12:38pm -*

Ulcer Performance Index Portfolio Optimization [Portfolio Optimizer]

The Ulcer Performance Index1 (UPI) is a portfolio reward-risk measure introduced by G. Martin2 similar in spirit to the Sharpe Ratio, but using the Ulcer Index (UI) as a risk measure instead of the standard deviation. In this blog post, I will present the mathematics behind the Ulcer Performance

*- 1 year ago, 4 Feb 2022, 10:12am -*

The matrix effective rank: measuring the dimensionality of a universe of assets [Portfolio Optimizer]

Quantifying how diversified is a universe of assets is an open problem in quantitative finance, partly because there is no definite formula for diversification1. Let’s make the (reasonable) assumption that the way assets are moving together within a universe is important for its diversification.

*- 1 year ago, 7 Jan 2022, 10:16am -*

Beyond Hierarchical Risk Parity: Hierarchical Clustering-Based Risk Parity [Portfolio Optimizer]

In a previous post, I introduced the Hierarchical Risk Parity portfolio optimization algorithm1. In this post, I will present one of its variations, called Hierarchical Clustering-Based Risk Parity, first described in Papenbrock2 and then generalized in Raffinot34 and in Lohre et al.5, from which

*- 2 years ago, 19 Oct 2021, 11:34am -*

Hierarchical Risk Parity: Introducing Graph Theory and Machine Learning in Portfolio Optimizer [Portfolio Optimizer]

In this short post, I will introduce the Hierarchical Risk Parity portfolio optimization algorithm, initially described by Marcos Lopez de Prado1, and recently implemented in Portfolio Optimizer. I will not go into the details of this algorithm, though, but simply describe some of its general ideas

*- 2 years ago, 7 Sep 2021, 11:35am -*

Correlation Matrix Stress Testing: Shrinkage Toward an Equicorrelation Matrix [Portfolio Optimizer]

Financial research has consistently shown that correlations between assets tend to increase during crises and tend to decrease during recoveries1. The recent COVID-19 market crash was no exception, as illustrated on Alvarez Quant Trading blog post Correlations go to One for both the individual

*- 2 years ago, 23 Aug 2021, 10:35pm -*

Residualization of Risk Factors: Examples and Pitfalls [Portfolio Optimizer]

The most common approach to measuring portfolio (risk) factor exposures is linear regression analysis, which describes the relationship between a dependent variable - portfolio returns - and explanatory variables - factors - as linear. One of the outputs of this analysis are the partial regression

*- 2 years ago, 27 Jul 2021, 10:58am -*

Replicating the J.P. Morgan Efficiente Index [Portfolio Optimizer]

The J.P. Morgan Efficiente 5 Index is a tactical asset allocation strategy designed by J.P. Morgan based on a broad universe of 13 ETFs. This post will illustrate how to replicate this strategy with Google Sheets. Notes: A fully functional spreadsheet corresponding to this post is available here.

*- 2 years ago, 23 Jun 2021, 11:11am -*

When a correlation matrix is not a correlation matrix and what can be done about it [Portfolio Optimizer]

Estimating how individual assets are moving together is an important part of many financial applications1 and the most commonly used measure for this is the Pearson correlation. Unfortunately, for a variety of reasons, what sometimes appears to be a correlation matrix is actually not a valid

*- 2 years ago, 2 Feb 2021, 08:10pm -*