Sunday, August 25, 2013

yogi_Compute Weekly High Using Google Finance For Specified Ticker Symbol

                                          Google Spreadsheet   Post  #1344
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug 25, 2013
user Andrew Sallans (http://productforums.google.com/forum/?zx=duk3bwersepo#!category-topic/docs/spreadsheets/N1J0-ZDJU1Y)
Finding a weekly high in Google Finance
Anybody have any idea how to automatically calculate a weekly high for a given ticker symbol?  I currently have the formula =googlefinance("SYMBOL","high",(today()-30),today()) working to list all high marks per day over the past 30 days, but I now would like them grouped automatically into weeks.  Any ideas?
---------------------------------------------------------------------------------------------------------------------------------------