Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
OthersPortfolio analysis and optimizationTechnical analysis

Stock Drawdown

Written by Nemanja Vujcic
Mon Nov 11 2019
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
 

What is a drawdown?

A drawdown (usually understood as maximum stock drawdown) is an indicator of downside risk over a specified period of time. It is both highly useful when analyzing a potential investment and also easy to understand for professionals and non-professionals alike. A drawdown is defined as a peak-to-trough decline over a specified time period for an investment (a portfolio of stocks, bonds, a fund, or individual stock or bond).

It is typically quoted as the percentage between a peak and the subsequent trough.

Why focus on the downside risk only?

Traditional measures of risk in investing are beta and the Sharpe ratio. The problem with both of these measures is that they treat both positive and negative deviation from the average market return as factors that increase risk. This means that the traditional measures will penalize a stock that has consistently outperformed the market, and they will mark such a stock as “risky”.

We at MarketXLS believe that risk measures, which focus exclusively on the downside, are more relevant to investors.

Apple Inc. as an example

We shall demonstrate how drawdown works by using daily closing prices of AAPL stock, adjusted for stock splits and dividends.

Between the beginning of 2012 and the time of writing this post (November 2019), AAPL stock has experienced three major drawdowns, with the stock price declining 43.8%, 30.4%, and 38.5%, respectively, from the prior peaks.

Drawdown percentage is the answer to the question: if someone had bought this investment at the time of its highest price, and later sold it at the bottom, just before the investment price began to recover, how much had he lost? In other words, a drawdown represents the worst-case scenario which an investor into a particular portfolio, fund, or stock could have experienced, over the defined time period.

Drawdown is measured on a daily level. It is always a negative number unless a new high for the stock is attained, in which case the value of drawdown is zero. Here is a chart of daily drawdowns for AAPL:

While it is measured daily, as investors and/or analysts we are interested in the maximum drawdown (MDD) over the observed period. Our goal is to pick investment opportunities with the least amount of downside risk, for the expected return potential.

How to use Stock drawdown functions in MarketXLS

MarketXLS offers a set of stock drawdown functions, which save you a lot of tedious work which would be needed to calculate MDD for even a single stock. With our add-in capabilities, you can get the results for hundreds of selected stocks in a matter of minutes.

Stock Drawdown

By default, analysts usually look for a 5-year drawdown, as the period is sufficiently long to make estimates about longer trends, yet it is also not too long to have the result be influenced by events that may be irrelevant for the current investment decisions. On the other hand, investors may also want to see how a particular set of stocks performed during the Great Recession.

If we want to find the maximum drawdown which AAPL stock experienced since January 1st, 2007, we will type:

=DrawdownCustomDates(“AAPL“,1-1-2007,TODAY())

On the other end of the strategy spectrum, short-term traders may be interested in maximum drawdowns over shorter time periods.

All returns are not equal

When constructing a portfolio, one must always have his goals, time horizon and personal risk tolerance in mind. Occasional heavy price corrections, or even a market crash or two are to be expected over an investor’s time horizon.

For example, when preparing a retirement portfolio, investment advisors would usually suggest limiting portfolio drawdown risk to -20%. If riskier stocks are included in the portfolio, their downside should be balanced by safer investments, with less downside risk. This is because once retired, the retiree will withdraw a portion from his retirement plan every year.

To keep the principal of the portfolio intact, up until recently investment advisors suggested that a retiree could annually withdraw 4% of their portfolio market value. (As of late, they have been talking about 3%.) If a portfolio experiences a significant drawdown, while an investor withdraws funds out of it, it will cut into the principal and it will create funding problems over the course of the retirement.

Even if you are a young investor and are creating a more aggressive, growth-oriented portfolio, you would do yourself a favor in being mindful of the downside risk, and we at MarketXLS are providing you with the tools that you need for it.

For a basic illustration of the information you can uncover with our drawdown functions, we will take a look at the performance of two companies’ stocks, Applied Materials (AMAT) and Home Depot (HD).

Stock Drawdown

Over the past five years, AMAT delivered a slightly higher total return to shareholders than HD. However, in the periods of price correction, HD stock drawdown was only half as severe as AMAT drawdown. On a risk-adjusted basis, HD has actually outperformed AMAT.

Calculating the risk-adjusted rate of return

The most practical way to use drawdown to compare historical performance and risk between potential investments is the return over maximum stock drawdown (RoMaD).

RoMaD = total return of an investment / absolute value of maximum drawdown

Using our example of AMAT and HD, we can calculate that, for the last five years, their RoMaD ratios were 3.22 and 6.39, respectively. RoMaD can only be interpreted in a relative way, by comparing potential investments between them, where higher RoMaD implies a better investment.

While past performance does not guarantee nor predict future returns, maximum drawdown percent and RoMaD ratios are highly useful to identify which investment opportunities are more prone to risk, whether this risk stems from an inherently riskier company business model, or from market’s overreaction to occasional underperformance of the company.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Dick's Sporting Goods Inc logo

Dick's Sporting Goods Inc

116.74
 
USD
 
6.17
 
(5.58%)
83
Rank
Optionable: Yes
Market Cap: 8,757 M
Industry: Specialty Retail
52 week range    
63.45   
   142.78
Academy Sports and Outdoors Inc logo

Academy Sports and Outdoors Inc

47.63
 
USD
 
2.31
 
(5.10%)
81
Rank
Optionable: Yes
Market Cap: 3,614 M
Industry: Beer, Wine, and Liquor Stores
52 week range    
25.10   
   51.51
Texas Roadhouse Inc. logo

Texas Roadhouse Inc.

89.63
 
USD
 
3.72
 
(4.33%)
79
Rank
Optionable: Yes
Market Cap: 5,743 M
Industry: Restaurants
52 week range    
68.58   
   96.41
Destination XL Group Inc. logo

Destination XL Group Inc.

5.60
 
USD
 
0.10
 
(1.82%)
79
Rank
Optionable: No
Market Cap: 340 M
Industry: Apparel Stores
52 week range    
3.27   
   9.00
Annaly Capital Management Inc logo

Annaly Capital Management Inc

19.42
 
USD
 
0.02
 
(0.10%)
77
Rank
Optionable: Yes
Market Cap: 8,363 M
Industry: REIT - Diversified
52 week range    
5.45   
   22.78
BJ's Wholesale Club Holdings Inc. logo

BJ's Wholesale Club Holdings Inc.

76.06
 
USD
 
0.04
 
(0.05%)
77
Rank
Optionable: Yes
Market Cap: 10,268 M
Industry: Specialty Retail
52 week range    
51.45   
   79.69
Waste Connections Inc. logo

Waste Connections Inc.

139.06
 
USD
 
1.38
 
(1.00%)
76
Rank
Optionable: Yes
Market Cap: 35,409 M
Industry: Waste Management
52 week range    
113.50   
   148.20
STORE Capital Corporation logo

STORE Capital Corporation

31.90
 
USD
 
0.27
 
(0.85%)
75
Rank
Optionable: Yes
Market Cap: 8,941 M
Industry: REIT - Diversified
52 week range    
24.48   
   36.13
Sprouts Farmers Market Inc. logo

Sprouts Farmers Market Inc.

28.58
 
USD
 
1.51
 
(5.58%)
75
Rank
Optionable: Yes
Market Cap: 2,909 M
Industry: Grocery Stores
52 week range    
21.18   
   35.34
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

107.01
 
USD
 
6.17
 
(6.12%)
75
Rank
Optionable: Yes
Market Cap: 7,483 M
Industry: Auto & Truck Dealerships
52 week range    
88.58   
   126.93

More Features