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            
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.