Support Board
Date/Time: Tue, 26 Nov 2024 00:31:09 +0000
Post From: Spreadsheet Formula RTH
| [2024-01-29 07:39:04] |
| bhmacro - Posts: 3 |
|
Hi, I'm using the spreadsheet formula to calculate the number of Zig Zag rotations. I'm getting stuck in using Sawtooth's formula as I can't get this formula to count only between 9:30EST-4:00EST and then reset to zero until the next RTH session IF(BARDATE>BARDATE[-1],0,IF(ID8.SG3>0,ID18.SG1[-1]+1,ID18.SG1[-1])) In this case, ID8 is my ZigZag, SG3 is reversal price and ID18 is the Spreadsheet Formula reference. Thanks! |