Tag Info

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.

I got it: just leave the year out. Solution: =(GOOGLEFINANCE(C5,"price")/INDEX(GOOGLEFINANCE(C5,"close","01/01", today()),2,2))-1

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: docs.google....