Support Board
Date/Time: Mon, 25 Nov 2024 22:37:22 +0000
Spreadsheet Formula RTH
View Count: 236
| [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! |
| [2024-01-29 15:34:22] |
| Sawtooth - Posts: 4120 |
|
Try this: =IF(OR(BARTIME>=TIME(16,0,0),BARTIME<TIME(9,30,0)),0,IF(ID8.SG3>0,ID18.SG1[-1]+1,ID18.SG1[-1])) Note: (ln:25) in the Zigzag study settings must be set to Yes. |
| [2024-01-29 16:26:34] |
| bhmacro - Posts: 3 |
|
Amazing this works perfectly thank you Sawtooth!!!
|
To post a message in this thread, you need to log in with your Sierra Chart account: