Get 40% Off
🤯 This Tech Portfolio is up 29% YTD! Join Now to Get April’s Top PicksGet The Picks – Just 99 USD

Cutting Through Market Noise With Boxplots

Published 11/05/2013, 07:33 AM
Updated 07/09/2023, 06:31 AM

Separating the noise from the signal is the bane of modern investment analytics. An excess of opinion and data confound and complicate our capacity to focus on the key decisions for designing and managing investment portfolios. One of my favorite tools for cutting through the clutter is a graphical tool known as boxplots. If I could only choose one charting methodology for analyzing performance data, I’d go with boxplots. Here’s why.

Let’s say you’re managing a portfolio that’s comprised of the major asset classes via a set of ETFs to represent the various markets. One possibility might look like this
Major Asset Classes via ETFs
One way to review performance is by comparing the ETFs in relative terms. For instance, here’s how the returns stack up so far this year after rebasing all the ETFs to 100 at the close of 2012:
YTD Total Returns: Major Asset Classes
This chart above provides a quick summary of returns, but it’s not all that useful for making decisions. Boxplots offer a better way to analyze the performance data. For example, here’s how the ETF list compares in terms of the range of rolling 1-year returns, including the current 1-year percentage change through yesterday, November 4 (indicated by the red dot).
Boxplot: Rolling 1 Year Historical Returns
For those who are unfamiliar with boxplots, here’s what the chart above is telling us. The rectangles show the core set of historical returns--the range of returns (in this case 1-year performance data) from the first to the third quartiles (or the 25th to 75th percentiles, if you prefer). The horizontal line inside the the rectangles is the median return. The vertical lines that extend from the top and bottom of the rectangles, up to the "whiskers" (the horizontal lines), reflect the returns above and beyond the interquartile range (IQR), i.e., returns that fall between the first and third performance quartiles, as shown by the rectangles. To be precise, the vertical lines above and below the rectangles, up to the whiskers, are the returns that are calculated as beyond the IQR up to 1.5 times the outer edges of the IQR returns. The black dots at the outer reaches, beyond the whiskers, are the so-called outliers. (Note that some ETFs don't have outliers, based on the sample data.)

The value in looking at boxplots is that we have a visual aid that quickly and efficiently summarizes the performance data across a spectrum of assets. In one graph we can easily review the return distributions and determine those asset classes that appear to be overvalued or undervalued in terms of their current performance record vs. history. We can also see when the returns are within their “normal” ranges, as shown by the red dots inside the rectangles.

In some cases, the current return looks extreme. The implication is that the rebalancing possibilities look relatively compelling with extreme returns. At the very least, the instances of extreme returns alerts us to take a closer look at the asset class as a possible rebalancing candidate. Yes, all the usual caveats apply. There’s no law that says an extreme return can’t remain extreme for an extended period, or even become more extreme. But at some point reversion to the mean kicks in. This is especially relevant through time and across a broad set of assets, even if there are exceptions at times.

Meanwhile, don’t forget that you’ll get different results depending on your preferences on asset class definitions and the historical performance window to analyze. Keep in mind too that the historical record on ETFs varies quite a bit and so it's not always possible to generate an apples-to-apples comparison. For example, the data for the iShares Global ex-US$ High Yield Corp Bond ETF (HYXU) in the boxplot above is limited, based on the fund’s start date in April 2012.

Nonetheless, boxplots offer a powerful tool for comparing and contrasting assets in the all-important business of analyzing rebalancing opportunities. Looking at data in this format on a regular basis dispenses a powerful dose of market intelligence with minimal effort. Should you rely exclusively on boxplots that use performance data? No, of course not. As usual in money management, a variety of perspectives and techniques is crucial. We could, for instance, look at volatility histories with boxplots for a portfolio-wide review of historical risk.

Yes, the sky’s the limit when it comes to the possibilities for portfolio analytics in the 21st century. But if you’re wondering where you might start, boxplots are on my short list these days. (You can create boxplots in Excel, but the computations are much easier in R, the statistical software environment. In the example above, I used the ggplot2 package to create the boxplots.)

Latest comments

Risk Disclosure: Trading in financial instruments and/or cryptocurrencies involves high risks including the risk of losing some, or all, of your investment amount, and may not be suitable for all investors. Prices of cryptocurrencies are extremely volatile and may be affected by external factors such as financial, regulatory or political events. Trading on margin increases the financial risks.
Before deciding to trade in financial instrument or cryptocurrencies you should be fully informed of the risks and costs associated with trading the financial markets, carefully consider your investment objectives, level of experience, and risk appetite, and seek professional advice where needed.
Fusion Media would like to remind you that the data contained in this website is not necessarily real-time nor accurate. The data and prices on the website are not necessarily provided by any market or exchange, but may be provided by market makers, and so prices may not be accurate and may differ from the actual price at any given market, meaning prices are indicative and not appropriate for trading purposes. Fusion Media and any provider of the data contained in this website will not accept liability for any loss or damage as a result of your trading, or your reliance on the information contained within this website.
It is prohibited to use, store, reproduce, display, modify, transmit or distribute the data contained in this website without the explicit prior written permission of Fusion Media and/or the data provider. All intellectual property rights are reserved by the providers and/or the exchange providing the data contained in this website.
Fusion Media may be compensated by the advertisers that appear on the website, based on your interaction with the advertisements or advertisers.
© 2007-2024 - Fusion Media Limited. All Rights Reserved.