Support Board
Date/Time: Sat, 30 Nov 2024 00:44:57 +0000
[User Discussion] - Spreadsheet System for Trading Study - help request for formula
View Count: 274
| [2022-12-29 23:57:23] |
| Shawn J - Posts: 32 |
|
Hi there. In regards to the Spreadsheet System for Trading study, I have AA3 as the specific price level. I want a short entry to trigger when the current candle's last E3 goes above AA3 and then goes below AA3. Would somebody help me with writing a formula for this short entry, please? Thank you very much. Shawn |
| [2022-12-30 15:05:34] |
| Sawtooth - Posts: 4123 |
|
The simplest would be this: =AND(C3>AA3,E3<AA3) You could also require a crossover of the Close from the previous bar: =AND(C3>AA3,CROSSFROMABOVE(E3:E4,AA3:AA4)) |
To post a message in this thread, you need to log in with your Sierra Chart account: