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.
No comments:
Post a Comment