Support Board

Date/Time: Fri, 03 May 2024 08:18:44 +0000

Post From: Spreadsheet Alert question

[2014-02-26 14:31:43] Link To Thread - Link To Post [Go To First Post]
User23815 - Posts: 209
I have a spreadsheet alert set up. The only issue I would like to change is that it signals on each bar that the conditions are true. I would like it to signal on the first bar where all conditions are true, and then not signal again until at least one of the conditions switches to false, and then all conditions return to true. I thought this was done with the study setting "Reset Condition on New Bar", which I have set to No, but that doesn't work. I also am set to Yes on Alert Only on Bar Close, and Signal Only Once Per Bar. Do I need to change one of the study settings or do I need to alter the spreadsheet formula? Please refer me to the documentation or explain how to get this result if possible. Thanks