Support Board

Date/Time: Thu, 28 Nov 2024 12:56:39 +0000

Post From: Help With Spreadsheet System for Trading

[2023-05-07 23:04:01] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4120
I think you'll need to reference the previous bar of the Daily Range Band in your persistent TRUE formulas. Try this: P3: =IF(AND(E3<ID3.SG2@4,FRACTIME($J$41)>=TIME(6,30,0),FRACTIME($J$41)<TIME(15,0,0)),1,IF(INT(A3)>INT(A4),0,P4)) Q3: =IF(AND(E3>ID3.SG1@4,FRACTIME($J$41)>=TIME(6,30,0),FRACTIME($J$41)<TIME(15,0,0)),1,IF(INT(A3)>INT(A4),0,Q4))