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