Login Page - Create Account

Support Board


Date/Time: Sun, 26 May 2019 16:31:14 +0000



Post From: New Bar formation

[2018-12-07 15:53:42]
tomgilb - Posts: 2162
Try this:
=AND($J$41>A3,$J$41<A3+30/86400)

The timing accuracy of this depends on how often J41 updates.
IOW, it would go TRUE more quickly at a new bar in a fast market, and possibly be late in a slow market.

You could use a shorter window than 30 seconds to look for a TRUE, but J41 might not update in a very short window, and a TRUE would be missed for that new bar. Using 30 seconds will at least give you a TRUE/FALSE transition in most cases.

30/86400 = 30 seconds in Serial DateTime Value.
https://www.sierrachart.com/index.php?page=doc/SpreadsheetExampleFormulasAndUsage.php#UsingDateTime
Date Time Of Last Edit: 2018-12-07 16:04:33