I'm looking to run a query in GoogleSheets using the
GOOGLEFINANCE function to pull down a list of stocks reaching new 26-week highs (limited to US companies or perhaps more simply US stock markets).
A previous question resolved the issue of computing a specified stock's 26-week high price. I'm seeking to create lists throughout the day of stocks creating new 26-week highs for the day.
I've looked for an
ImportHTML function solution but Google Finance Stock Screener does not have produce such lists.
Can anyone advise how to create such a stock-screen query or any other function in GoogleSheets using Google Finance's data to get the results?