Login Page - Create Account

Support Board


Date/Time: Fri, 01 Mar 2024 23:22:38 +0000



Post From: Automated Trading System AND logic

[2023-08-18 23:49:33]
Sawtooth - Posts: 3933
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.