Home >> Support Board

Support Board

Date/Time: Sat, 04 May 2024 05:18:13 +0000

How to Post a Message for Support

Spreadsheet system formula for exit positions l-3 & N-3 HELP!

View Count: 540

[2022-03-24 13:14:07] #1 [Go To First Post]
User9890731 - Posts: 47
What formula must I add to l-3(sell exit) and n-3(buy exit) in order to have the spreadsheet close a trade when a signal no longer appears on k-3 or m-3 on the current bar. Basically if the signal appears on the column then an entry is made, but when the same signal on the same column disappears then the spreadsheet should flatten the position until a new signal is generated. I already have an entry formula for k-3 and m-3; =ID1.SG1@3 > 0 =ID1.SG2@3 > 0

[2022-03-24 13:31:22] #2 [Go To First Post]
Sawtooth - Posts: 3993
Try this: L3: =AND(K4>0,K3=0) N3: =AND(M4>0,M3=0)

[2022-03-24 15:31:31] #3 [Go To First Post]
User9890731 - Posts: 47
Hi Tomgilb, Thanks for the reply, but it still failed to flatten the position, or is there an option in the spreadsheet study settings that I should set to ''yes'' for it to work. I have attached the test.


autotrader 1.png / V - Attached On 2022-03-24 15:29:49 UTC - Size: 137.36 KB - 113 views autotrader 2.png / V - Attached On 2022-03-24 15:29:58 UTC - Size: 144.2 KB - 108 views

[2022-03-24 15:41:59] #4 [Go To First Post]
Sawtooth - Posts: 3993
OK, try this: L3: =ID1.SG1@3 = 0 N3: =ID1.SG2@3 = 0

[2022-03-24 15:57:44] #5 [Go To First Post]
User9890731 - Posts: 47
Awesome! Works perfectly, thanks!

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