Login Page - Create Account

Support Board

Date/Time: Wed, 18 May 2022 13:34:28 +0000

Post From: SC code to define time period during which a spreadsheet alert i

[2013-05-18 18:08:16]
tomgilb - Posts: 3270
If you are using this formula in columns K-AX, you need to use the absolute value of J41, like this:


Using J41 is preferred to A3 because J41 is updated many times intrabar, whereas A3 is only updated at bar open. This is particularly true if your bars are a long duration.
Date Time Of Last Edit: 2013-05-18 18:30:24