=Max(A1:A27). Yeah, but what I'm looking for is actually "=max(since previous peak)".I know, the strict definition is " max(from beginning of time : now)" --- but nobody actually USES it that way. In usage, everybody treats it as the most recent peak. Nobody cares about a drawdown from a peak that happened 50 years ago. They care about the peak that happened in the last few years or less. Heck, the thing that most people only look at is the current price vs. the 52-week high.Or maybe I'm overthinking it. Anyway, 12-month drawdown is Good Enough for my purposes. The bear markets of 2001 & 2008 kinda swamp out any older peaks.The other drawdown that I personally look at is "drawdown since Sept 2006 when I walked out the door and retired early".
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar. Earnings Estimates, Analyst Ra