Support Board
Date/Time: Mon, 21 Apr 2025 05:01:38 +0000
Post From: 3 QUESTIONS RE: = if ( id0.sg3 > max(id0.sg3[-1:-30]), 1, 0)
| [2023-01-29 17:22:23] |
| User431178 - Posts: 649 |
|
1.) No 2.) Yes 3.) Because your formula is not correct. ID0.SG3 refers to the lows, so you are alerting when the low is greater than the previod 29 lows. So instead, use: =IF(ID0.SG2>MAX(ID0.SG2[-1:-30]),1,0) Spreadsheet Example Formulas and Usage: Spreadsheet Study Equivalents of Simple Alerts and Main Price Graph Identifiers Date Time Of Last Edit: 2023-01-29 17:23:27
|