Support Board
Date/Time: Tue, 04 Feb 2025 12:41:45 +0000
[Programming Help] - SpreadSheet Formula for Close below then back above a level
View Count: 562
| [2020-01-22 02:40:42] |
| User355030 - Posts: 163 |
|
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] |
| Sawtooth - Posts: 4166 |
|
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: 163 |
|
I need price to close below then above, will the example you provided work for that?
|
| [2020-01-23 14:21:15] |
| Sawtooth - Posts: 4166 |
|
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: 163 |
|
Thank you
|
To post a message in this thread, you need to log in with your Sierra Chart account: