Support Board
Date/Time: Thu, 27 Feb 2025 22:34:51 +0000
Post From: Running Clock that starts from a trigger and resets with another trigger [SPREADSHEET]
| [2021-07-23 16:04:18] |
| Sawtooth - Posts: 4177 |
|
Here is an example that you'd need to modify: Spreadsheet Example Formulas and Usage: Cancel Unfilled Working Order n Minutes After Entry Spreadsheet Example Formulas and Usage: Cancel an Unfilled Order After n Bars You'll need to create a persistent value of the time at the first trigger, then reset it at the second trigger. You can only use FRACTIME(A3) because it's not possible with a spreadsheet study to capture an intrabar time from J41. You would then compare the persistent FRACTIME at the first trigger with the current FRACTIME of J41. |