Support Board

Date/Time: Fri, 25 Sep 2026 21:56:04 +0000

Post From: Automated Trading System AND logic

[2023-08-18 23:49:33] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4354
Despite its name, the Spreadsheet Formula study is not a spreadsheet study, and it uses Alert syntax. The formula in post #11 is in spreadsheet syntax. The following is it, converted to Alert syntax: =IF(AND(ID2.SG1<=H[-1],C>=ID2.SG1),1,IF(AND(ID2.SG1>=L[-1],C<=ID2.SG1),-1,ID3.SG1[-1])) where ID3 is this Spreadsheet Formula study.