Login Page - Create Account

Support Board


Date/Time: Sun, 19 May 2024 16:56:28 +0000



Needing Help with Spreadsheet Formula's for Auto Trading System

View Count: 97

[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: 4000
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:

Login

Login Page - Create Account