Support Board

Date/Time: Thu, 25 Apr 2024 15:21:49 +0000

Post From: Automated Trading

[2019-03-06 23:50:00] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3976
When referencing study outputs, you really should use this method: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study So the formula in post #56 would look like this: P3: =IF(AND(E3>=ID2.SG2@3-2$J$21,ID2.SG1@3<ID2.SG2@3,ID2.SG1@3>ID2.SG3@3),1,IF(AND(E3<=ID2.SG3@3+2$J$21,ID2.SG1@3<ID2.SG2@3,ID2.SG1@3>ID2.SG3@3),0,P4)) Reasons for using this format: - You can insert/delete Formula Columns on the spreadsheet while retaining the correct references. - You can add/remove/rearrange studies in the Studies to Graph list while retaining the correct references. - You can increase/decrease the Number of Formula Columns while retaining the correct references. 1. Try this: - Don't use the P3 formula. Q3: =IF(AND(ID2.SG2@3<ID3.SG2@4,ID2.SG3@3>ID3.SG3@4),1,IF(OR(ID2.SG2@3>ID3.SG2@4,ID2.SG3@3<ID3.SG3@4),0,Q4)) R3: =AND(Q3,E3>=ID2.SG2@3-2$J$21,ID2.SG1@3<ID2.SG2@3,ID2.SG1@3>ID2.SG3@3) S3: =IF(AND(Q3,R3),1,IF(OR(Q3=0,AND(E3<=ID2.SG3@3+2$J$21,ID2.SG1@3<ID2.SG2@3,ID2.SG1@3>ID2.SG3@3)),0,S4)) T3: =AND(Q3,E3<=ID2.SG3@3+2$J$21,ID2.SG1@3<ID2.SG2@3,ID2.SG1@3>ID2.SG3@3) U3: =IF(AND(Q3,T3),1,IF(OR(Q3=0,AND(E3>=ID2.SG2@3-2$J$21,ID2.SG1@3<ID2.SG2@3,ID2.SG1@3>ID2.SG3@3)),0,U4)) K3: =AND(S3,S4=0) M3: =AND(U3,U4=0) I don't mind helping out with basic questions but the answers to your requests are becoming more complex than a forum post can accommodate.