Support Board

Date/Time: Fri, 26 Apr 2024 13:16:26 +0000

Post From: 3 QUESTIONS RE: = if ( id0.sg3 > max(id0.sg3[-1:-30]), 1, 0)

[2023-01-29 17:22:23] Link To Thread - Link To Post [Go To First Post]
User431178 - Posts: 411
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