Login Page - Create Account

Support Board


Date/Time: Sat, 05 Jul 2025 02:46:09 +0000



Post From: Automated Trading

[2019-07-25 00:46:27]
Sawtooth - Posts: 4232
Using the Spreadsheet System for Trading study, the Buy Entry formula is entered in cell K3, and the Sell Entry in cell M3.

Also, it's best to reference the ID# instead of the column alpha, and you don't need absolute references:
Cell K3:
=CROSSFROMBELOW(ID1.SG1@3:ID1.SG1@4,ID2.SG1@3:ID2.SG1@4)
Cell M3:
=CROSSFROMABOVE(ID2.SG1@3:ID2.SG1@4,ID3.SG1@3:ID3.SG1@4)
where column AS is ID1, column AU is ID2, column AW is ID3; edit the ID# and SG# as needed.
Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study

If you want close-of-bar entries, set 'Signal Only On Bar Close (K,M)' to Yes.