Login Page - Create Account

Support Board


Date/Time: Sat, 27 Jul 2024 05:09:48 +0000



Post From: Swing High and Low

[2014-10-25 00:43:34]
Sawtooth - Posts: 4051
Yes, because Simple Alerts are only T/F.

Use a formula like this in a Formula Column on the spreadsheet, e.g. in cell M3:
=IF(AA3>0,C3,M4)

This will grab the High when there is a new swing high in column AA, and repeat it until the next swing high.