Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 14:06:57 +0000



Post From: Alert condition with lookback over range t-n bars

[2023-01-17 13:26:13]
Sawtooth - Posts: 3990
This would require using the Spreadsheet System/Alert study.
You'd use one Formula Column to find the bars where the condition is TRUE.
You'd use another Formula Column to count consecutive TRUEs, where it would reset to 0 if no longer consecutive.
You'd use another Formula Columns for the alert when the count exceeded 100.
You'd be able to set the lookback length in a cell on the sheet.
Date Time Of Last Edit: 2023-01-17 20:02:51