Login Page - Create Account

Support Board


Date/Time: Wed, 26 Feb 2020 01:15:12 +0000



[Programming Help] - SpreadSheet Formula for Close below then back above a level

[2020-01-22 02:40:42]
User355030 - Posts: 16 | Ending Date: 2020-03-27
I'm looking for an example of a spreadsheet formula that would trigger an entry when a price bar closes below a level and then the next bar closes above the level.
[2020-01-22 20:13:44]
tomgilb - Posts: 2383 | Ending Date: 2020-02-29
Try something like this:
=AND(E4<ID1.SG1@4,E3>ID1.SG1@3)
where ID1 is a moving average.

This also works:
=CROSSFROMBELOW(E3:E4,ID1.SG1@3:ID1.SG1@4)
[2020-01-23 13:54:37]
User355030 - Posts: 16 | Ending Date: 2020-03-27
I need price to close below then above, will the example you provided work for that?
[2020-01-23 14:21:15]
tomgilb - Posts: 2383 | Ending Date: 2020-02-29
I need price to close below then above, will the example you provided work for that?
Yes. And you might want to set 'Signal Only On Bar Close (Columns K, M)' to Yes.
[2020-01-23 14:50:58]
User355030 - Posts: 16 | Ending Date: 2020-03-27
Thank you

To post a message in this thread, you need to login with your Sierra Chart account:

Login

Login Page - Create Account