# gScript for static date
**URL:** https://community.glideapps.com/t/gscript-for-static-date/37144
**Category:** Ask for Help
**Created:** [January 14, 2022, 2:41am UTC](https://community.glideapps.com/t/gscript-for-static-date/37144 "2022-01-14T02:41:30Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@gp9293](https://community.glideapps.com/u/gp9293)
#### Post date: [January 14, 2022, 2:41am UTC](https://community.glideapps.com/t/gscript-for-static-date/37144/1 "2022-01-14T02:41:30Z")
I received some good ideas on this before but closed the topic as solved, when I should not have. The issue is the following: my sheet receives updates from an external stock price database (think Yahoo Finance). Prices are updated every 15 minutes. When the price exceeds a target value (hard-coded in another field), I would like write a datetime stamp to a third field. But the datetime stamp cannot change even if the price moves below and above the target. during the course of the day/week. Once the target is hit, game over, static timestamp. Appreciate any help.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 14, 2022, 2:45am UTC](https://community.glideapps.com/t/gscript-for-static-date/37144/2 "2022-01-14T02:45:48Z")
I remember this. Can you describe the solution that you implemented, and in what way it’s falling down?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 14, 2022, 3:15am UTC](https://community.glideapps.com/t/gscript-for-static-date/37144/3 "2022-01-14T03:15:37Z")
Here… imagine that your sheet looks like this:
Then the following code should do what you want:
```auto
function check_stock_targets() {
// Replace each of the below with actual column/sheet names
const SHEET_NAME = 'Stocks';
const SYMBOL = 'Symbol';
const CURRENT = 'Current Price';
const LAST_UPDATE = 'Last Update';
const TARGET = 'Target';
const TIME_LOCK = 'Target Hit At';
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(SHEET_NAME);
var headers = sheet.getRange(1,1,1,sheet.getLastColumn()).getValues().shift();
var symbol_index = headers.indexOf(SYMBOL);
var current_index = headers.indexOf(CURRENT);
var last_update_index = headers.indexOf(LAST_UPDATE);
var target_index = headers.indexOf(TARGET);
var time_lock_index = headers.indexOf(TIME_LOCK);
var data = sheet.getRange(2,1,sheet.getLastRow()-1,sheet.getLastColumn()).getValues();
var current_row = 2;
data.forEach(function (row) {
var time_lock = row[time_lock_index];
if (time_lock === '') {
var current = row[current_index];
var target = row[target_index];
if (current >= target) {
var last_update = row[last_update_index];
var symbol = row[symbol_index];
console.log("Target for %s hit at %s, locking", symbol, last_update);
sheet.getRange(current_row,time_lock_index+1).setValue(last_update).setNumberFormat("yyyy-mm-dd hh:mm");
}
}
current_row++;
});
}
```
I would run that as a timed trigger, perhaps once every 5 minutes.
---
### Author:  [@gp9293](https://community.glideapps.com/u/gp9293)
#### Post date: [January 14, 2022, 3:42am UTC](https://community.glideapps.com/t/gscript-for-static-date/37144/4 "2022-01-14T03:42:45Z")
Looks good. I will try
---
### Author:  [@gp9293](https://community.glideapps.com/u/gp9293)
#### Post date: [January 14, 2022, 6:03pm UTC](https://community.glideapps.com/t/gscript-for-static-date/37144/5 "2022-01-14T18:03:39Z")
Well, I am not surprised Darren. It works perfectly. Thank you.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [January 15, 2022, 6:03pm UTC](https://community.glideapps.com/t/gscript-for-static-date/37144/6 "2022-01-15T18:03:54Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.