I'm looking to use GoogleSheets to display ticker symbols and prices in real-time of stocks that have created new 26-week highs, i.e. today's highest trading price is greater than any trading price during the last 26-week period.
I think GoogleSheets's native GOOGLEFINANCE function allows this to be done for a 52-week trailing period (e.g. a formula comparing attributes "high52" against current day's "high"). The GOOGLEFINANCE function doesn't have an attribute for a 26-week period.
Does anyone have a script or template of one I can apply to retrieve a stock's highest traded price over a trailing 26-week period?