Login Page - Create Account

Support Board


Date/Time: Fri, 07 Feb 2025 18:42:42 +0000



Post From: Alert more than once per bar

[2016-04-07 22:06:36]
Sawtooth - Posts: 4173
The intrabar alert is continuously TRUE when the bar is colored, not just when it first goes TRUE.
When it goes TRUE, it initiates the playing of a .wav file, but it may stay TRUE longer than the duration of the .wav file. If it goes FALSE, the bar will stop being colored. If it goes TRUE again in the same bar, it will color the bar again, and initiate another play of the .wav file. If the .wav file is very long, it may play into the time when the formula is FALSE.

If you were to put that formula in a row 3 cell on the spreadsheet, as =E3>E4, you would see it go to a 1 and stay until it was no longer TRUE, the it would go to 0. This is probably what you want.