Home >> Support Board

Support Board

Date/Time: Wed, 12 Feb 2025 13:18:44 +0000

How to Post a Message for Support

[User Discussion] - Spreadsheet trading: inconsistent execution.

View Count: 474

[2020-10-19 16:08:01] #1 [Go To First Post]
User484096 - Posts: 19
I have the below exit conditions in the spreadsheet. It is a simple trailing by 2 bars after the entry bar is closed. But about half of the time, the trade is closed as soon as the entry bar is closed. Today is an example. My entry was executed on 9:30 bar, but as soon as the 9:30 bar is closed, the trade is closed. Buy Stop =AND(AND(AND($J$8 > 0, A3 > J42), J41 > A3),(E3 < MIN(D4, D5))) Sell Stop =AND(AND(AND($J$8 < 0, A3 > J42), J41 > A3),(E3 > MAX(C4, C5))) I am using version 2175.


Attachment Deleted. NQ.png / V - Attached On 2020-10-19 16:05:12 UTC - Size: 21.19 KB - 193 views Study.png / V - Attached On 2020-10-19 16:07:33 UTC - Size: 35.41 KB - 183 views

[2020-10-19 18:48:42] #2 [Go To First Post]
Sawtooth - Posts: 4173
Just like J8, you need to use absolute references to cells J41 and J42: Buy Stop =AND(AND(AND($J$8 > 0, A3 > $J$42), $J$41 > A3),(E3 < MIN(D4, D5))) Sell Stop =AND(AND(AND($J$8 < 0, A3 > $J$42), $J$41 > A3),(E3 > MAX(C4, C5)))

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