Support Board
Date/Time: Fri, 04 Jul 2025 20:53:44 +0000
[Programming Help] - Automated Trading
View Count: 668
| [2019-07-24 23:19:47] |
| User334484 - Posts: 6 |
|
Hello I've been trying to write an automated system on Sierra Charts. One thing I'm not understanding is that how to tell the system to buy or sell. Either I haven't found it in the Doc's I was sent last time I asked for help. I've gone so far as to write the most basic of formulas, still nothing. Well I should say nothing it did make a trade but even though there were more trades available it didn't take another trade. Darn if I can figure it out. = CROSSFROMBELOW( AS$3:AS$5,AU$3:AU$5) Buy Entry = CROSSFROMABOVE( AU$3:AU$5,AW$3:AW$5) Sell Entry Thanks for any advice Mark Grimes |
| [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. |
To post a message in this thread, you need to log in with your Sierra Chart account: