Support Board
Date/Time: Fri, 12 Sep 2025 21:17:35 +0000
Post From: Shortcut for Alert Requiring Multipe Prior Bars in MAX Formula
| [2016-09-06 21:47:21] |
| Sawtooth - Posts: 4263 |
|
The syntax for Simple Alerts is different than for spreadsheets: The current bar in Simple Alerts is referenced: =ID22.SG1[0] where the [0] is optional for 0 only. The current bar in a spreadsheet is referenced: =ID22.SG1@3 where 3 is row 3. So the spreadsheet formula would be: =MAX(ID22.SG1@3:ID22.SG1@22) Date Time Of Last Edit: 2016-09-06 21:47:40
|