You cannot create a permanent snapshot of a cell value with a spreadsheet formula, so you will have to use a script.
See the appendValuesToArchiveSheet script for one possible solution. You can use it to copy the value in the cell in another sheet in a log file of sorts on an hourly or daily basis and then apply min() function to get the lowest value.
You want to know if any stocks from a list have reached 26-week highs in the last 4 days.
You should refer to How to Run a Query in GoogleSheets for New 26-Week Highs Using GOOGLEFINANCE Function and How to Create a Google Sheets Script for Reporting 26-Week New Highs using GOOGLEFINANCE Function?, as well as any source regarding "filtering dates in a ...
For Brave users, you don't have to install AdBlock separately.
From the How do I block additional page elements? article:
On the Brave://adblock page, you will see a Custom Filters section at the bottom of the page where the blocked elements will be displayed. Below is the element I blocked above on reddit.com:
Type the following in the box: