No. of Recommendations: 1
=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".
Print the post  

Announcements

The Retirement Investing Board
This is the board for all discussions related to Investing for and during retirement. To keep the board relevant and Foolish to everyone, please avoid making any posts pertaining to political partisanship. Fool on and Retire on!
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.
Advertisement