Login Page - Create Account

Support Board


Date/Time: Mon, 17 Mar 2025 11:30:19 +0000



[Programming Help] - Spreadsheet Automated Trading

View Count: 886

[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: 38
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: 4185
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:

Login

Login Page - Create Account