Stock Drawdown

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.

Verelq News |
24.04.2024

alexistogel macau

alexistogel

link alexistogel

situs alexistogel

alexistogel rtp

situs alexistogel

link alternatif alexistogel

alexistogel gacor

bandar alexistogel

alexistogel

alexistogel

alexistogel terpercaya

alexistogel gacor

alexistogel

alexistogel 4d

alexistogel

alexistogel

alexistogel gacor

alexistogel terpercaya

agen togel online

link alexistogel

alexistogel toto

alexistogel

alexistogel rtp

situs alexistogel

bandar alexistogel

alexistogel

link alexistogel

alexistogel

alexistogel togel slot

alexistogel

alexistogel online

alexistogel

alexistogel gampang menang

alexistogel 4d

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

slot gacor alexistogel

alexistogel

شرط بندی پرسپولیس شرط بندی استقلال شرط بندی روی تراکتورسازی تبریز شرط بندی روی سپاهان شرط بندی رئال مادرید بارسلونا شرط بندی شرط بندی psg سایت شرط بندی جام جهانی شرط بندی جام جهانی 2026 سایت شرط بندی جام جهانی 2026 بازی انفجار رایگان سایت انفجار ضریب بالا بهترین سایت شرط بندی فارسی شرط بندی بدون فیلتر شرط بندی بازی رولت شرط بندی پوکر شرط بندی مونتی شرط بندی سنگ کاغذ قیچی شرط بندی بلک جک کرش رویال بت پاسور شرط شرط بندی تخته نرد آنلاین انفجار 2 بت شرط بندی بازی اسلات شرط بندی بازی پوپ سایت سامان بت ریور پوکر 2024 سایت 4030bet ورود به بازی انفجار دنس بت شرط بندی انفجار دنس آموزش بازی پوکر سایت شرط بندی 123 بهترین شرط بندی بهترین سایت شرط بندی انفجار اپلیکیشن بازی انفجار دانلود بازی انفجار انفجار بازی ربات بازی انفجار کازینو آنلاین ایرانی انفجار پولساز ورود به بازی انفجار بازی انفجار با شارژ 10 تومن سایت bet betyek وان ایکس برو آدرس سایت بت یک سایت دوست دختر اونلی فنز فارسی پیدا کردن دوست دختر ورود به ریور پوکر پدرام مختاری پویان مختاری نازنین همدانی مونتیگو داوود هزینه بیوگرافی آیسان اسلامی بیوگرافی دنیا جهانبخت سایت رسمی حسین تهی بیوگرافی کوروش وانتونز سایت آرتا وانتونز رها وانتونز بیوگرافی ربکا قادری سحر قریشی بیوگرافی تتلو بیوگرافی مهدی طارمی الناز شاکردوست سایت عادل فردوسی پور بیوگرافی نیلی افشار بیوگرافی محمدرضا گلزار سایت armin2afm بیوگرافی شادمهر عقیلی بیوگرافی سردارآزمون بیوگرافی علیرضا بیرانوند بیوگرافی رامین رضاییان وریا غفوری بیوگرافی علی دایی بیوگرافی پوریا پوتک مدگل سایت حصین بیوگرافی صدف طاهریان فرشاد سایلنت بیوگرافی آریا کئوکسر بیوگرافی sogang بیوگرافی میا پلیز بیوگرافی مهراد هیدن سایت رسمی سهراب ام جی بیوگرافی علیرضا جی جی بیوگرافی بهزاد لیتو اشکان فدایی بیوگرافی رضا پیشرو بیوگرافی گلشیفته بیوگرافی هیپ هاپولوژیست بیوگرافی سارن بیوگرافی آدام مرادی بیوگرافی محمد هلاکویی بیوگرافی علی حسنی سایت رسمی علی حسنی بیوگرافی ساسی خواننده بیوگرافی ابی باربد معصومی حسینی فایننس بیوگرافی امیرحسین نام آور بیوگرافی امین فردین بیوگرافی فرزاد وجیهی سایت سیب بت سایت jetbet آدرس جدید بت فوروارد وان ایکس بت سایت abt90 بازی انفجار سایت شرط بندی فاز بت بهترین سایت شرط بندی انفجار ورود به آلپاری آلپاری فارکس آدرس بروکر آلپاری بدون فیلتر ثبت نام در بروکر آلپاری فارسی صرافی کوکوین ربات فارکس بهترین سایت تتر

alexistogel toto online

bandar alexistogel

alexistogel bandar gacor

alexistogel link

alexistogel online

alexistogel bandar togel

link alternatif alexistogel

alexistogel

alexistogel

alexistogel

alexistogel daftar

alexistogel toto macau

alexistogel bandar macau

alexistogel slot

alexistogel agen slot

alexistogel

situs alexistogel

alexistogel

alexistogel slot

alexistogel

alexistogel

alexistogel

alexistogel bandar slot

alexistogel

Alexistogel Toto Macau

alexistogel

bandar alexistogel

alexistogel slot

alexistogel link alternatif

alexistogel macau

alexistogel

alexistogel toto macau

slot alexistogel

alexistogel bandar togel

alexistogel

alexistogel rtp

alexistogel

alexistogel slot

alexistogel

alexistogel

alexistogel

alexistogel terpercaya

daftar alexistogel

alexistogel online

rtp alexistogel

alexistogel slot

alexistogel gacor

link alternatif alexistogel

alexistogel login

alexistogel

alexistogel slot dana

agen togel online

bandar togel online

alexistogel rtp

alexistogel slot

alexistogel daftar

alexistogel daftar

slot online dana

bandar togel slot

togel online terpercaya

slot pragmatic gacor

link situs slot resmi

situs slot online

link daftar togel slot

bandar slot gacor hari ini

bocoran pola slot

situs slot online

bandar slot online

bandar togel online

slot online terpercaya

togel slot online

slot deposit qris

agen slot online gacor

rtp live slot online

bandar slot online

bandar slot online gacor

agen slot online

daftar bandar togel slot

bandar togel online

togel slot hari ini

link alternatif togel slot

rtp slot online gacor

slot online gacor

situs slot gacor

rtp slot gacor

slot online gacor

tips slot maxwin

togel slot gacor

prediksi togel

game slot gacor

trik slot online

prediksi togel jitu

game slot online

togel online terpercaya

daftar togel slot online

bandar togel terpercaya

slot online gacor

trik slot bonus

prediksi togel online

rtp slot online

panduan togel online

RTP LIVE

Bandar Toto Macau

Situs Slot Gacor

bandarbola855 resmi

bandarbola855 gacor

bandarbola855 slot

link bandarbola855

bandarbola855 bola slot

bandarbola855 rtp

bandarbola855 slot online

bandarbola855 link

bandarbola855 bandar

bandarbola855 slot terpercaya

bandarbola855

bandarbola855 slot

bandarbola855 terpercaya

bandarbola855 online

slot bandarbola855

bandarbola855 slot

bandarbola855 daftar

bandarbola855 link

bandarbola855

bandarbola855

bandarbola855

bandarbola855 slot

bandarbola855

bandarbola855 rtp

bandarbola855

bandarbola855

bandarbola855

iosbet

iosbet

link iosbet

slot online iosbet

iosbet link login

slot iosbet

iosbet gacor

iosbet slot

iosbet

slot iosbet

agen iosbet

bandar iosbet

iosbet

iosbet link

bandar iosbet gacor

iosbet

iosbet

iosbet

iosbet

liatogel

bandar liatogel

login liatogel

live draw hk liatogel

liatogel slot online gacor

liatogel totomacau

liatogel link

slot gacor

daftar slot online

bandar slot dana

slot ovo

slot gopay