Support Board
Date/Time: Thu, 06 Nov 2025 13:16:48 +0000
[Programming Help] - Spreadsheet Automated Trading
View Count: 1031
| [2022-08-31 02:12:31] |
| moose - Posts: 2 |
|
Hello, using spread sheets how does one trigger buy and sells once a Simple Moving Average level is broken. For example, a candle closed above the 20SMA to trigger a buy and close the order once it reaches the 50SMA Thank you |
| [2022-09-06 22:09:48] |
| OctoPi - Posts: 47 |
|
This is what the software we created helps you with. See post I created if you are interested in testing: EASY Automated Back-testing. We are licensing the software for $0 for limited time. |
| [2022-09-06 23:53:40] |
| Sawtooth - Posts: 4285 |
|
how does one trigger buy and sells once a Simple Moving Average level is broken
Use the CROSSFROMBELOW function.Like this: =CROSSFROMBELOW(E3:E4, ID2.SG1@3:ID2.SG1@4) where ID2 is the MA. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#CROSSFROMBELOW_Function |
To post a message in this thread, you need to log in with your Sierra Chart account: