Support Board
Date/Time: Mon, 25 Nov 2024 07:33:06 +0000
Needing Help with Spreadsheet Formula's for Auto Trading System
View Count: 246
| [2024-03-27 02:27:57] |
| Derek Benton - Posts: 9 |
|
Hi, I have an auto trading system I am using and I am wanting to add one more step into the Buy Entry/Sell Entry formula Cell's. How could write it to where it won't trigger a trade unless the 9EMA is at least 5 points away from the high of the current candle for a Buy and the low of current candle for a short? Example: Buy Entry =AND(C3>C4, F4>4000, AA>C3byX?) C3 Is current candle's high, C4 is previous candle's high, F4 is previous candle's volume must be greater that 4000, and AA is my 9EMA. Not sure if there's away I can write it like I am wanting, Meaning it won't trigger unless C3 is 5 points (or more) away from AA. Don't care which direction either. AA can be above or below C3. If someone could write that out for me, it would help me out tremendously! |
| [2024-03-27 13:29:00] |
| Sawtooth - Posts: 4120 |
|
Try this: =AND(C3>C4, F4>4000, ABS(AA3-C3)>5) |
To post a message in this thread, you need to log in with your Sierra Chart account: