Google Sheets - Track and Log highest and lowest value of other (dynamic) cell
Budget: €30 – €250 EUR
Hi,
I am trying to build a sheet for papertrading Stocks and Crypto , the values in A are refreshed every 5min , in B i have the current date and Time. At the moment i have a workaround that sends a mail if a value meets a certain criteria. But its not ideal. A other workaround would be to log every Api request of a value as historical. But that would take every 5 min 2000 rows. I would like to log the values of a couple specified rows (trades). The Highest Value and Lowest value and the Timestamp of the logged value. Is there a way ? I include a Picture of how i would see it. I tried google and the search within Stack Overflow without any result. The timestamp is a Bonus, the Log is the most important. I think it could be done within the App Script. But not sure.
I am trying to build a sheet for papertrading Stocks and Crypto , the values in A are refreshed every 5min , in B i have the current date and Time. At the moment i have a workaround that sends a mail if a value meets a certain criteria. But its not ideal. A other workaround would be to log every Api request of a value as historical. But that would take every 5 min 2000 rows. I would like to log the values of a couple specified rows (trades). The Highest Value and Lowest value and the Timestamp of the logged value. Is there a way ? I include a Picture of how i would see it. I tried google and the search within Stack Overflow without any result. The timestamp is a Bonus, the Log is the most important. I think it could be done within the App Script. But not sure.