Thursday, April 28, 2011

yogi_Compute High/Low For A Stock Over A Specified Range Of Dates

Yogi Anand, D.Eng, P.E.                                   Google Spreadsheet                      www.energyefficientbuild.com
wsround said:
I am looking for specific highs and lows for specific dates.
Ie: March 12, 2003 high and low. But not just that date.
I would like to be able to get an array for dates around it such as from march 1, 2003 to december 31, 2009
I can get the open close high and low for that day but not the 52 week high or low for that day
thanks for the help
-------------------------------------------------------------------------------

In the solution shown in Sheet1 I first extract the high/low values for all the dates in the range of interest and then compute the max/min value from those.