That's because I can't figure out how to make Excel find the "most recent high value", since excel searches don't really like to look backwards, only forwards.=Max(A1:A27). Substitute whatever cells you are actually checking for "A1:a27". For what it's worth, I use this on the Case-Schiller housing index spreadsheets to quickly check drop from peak, and use the Vlookup function in conjunction with that to determine the month in which that peak occurred.-synchronicity, spends way too much time in Excel.
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