Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 14 May 2024 01:07:29 +0000
Post From: Shortcut for Alert Requiring Multipe Prior Bars in MAX Formula
| [2016-09-06 21:47:21] |
| Sawtooth - Posts: 3995 |
|
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
|