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   Aug 25, 2013
user Andrew Sallans (!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?