Support Board
Date/Time: Thu, 23 Jan 2025 21:22:50 +0000
Post From: New Bar formation
| [2018-12-07 15:53:42] |
| Sawtooth - Posts: 4162 |
|
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. Spreadsheet Example Formulas and Usage: Using Date Time Date Time Of Last Edit: 2018-12-07 16:04:33
|