Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 08:55:06 +0000

How to Post a Message for Support

[Programming Help] - Help with IF statement in SpreadSheet

View Count: 1803

[2017-10-12 16:21:20] #1 [Go To First Post]
User_ML - Posts: 17
Am trying to do an "IF" statement in SpreadSheet "J26" Order Quantity. =IF(ID37.SG8@3>E3) {IF($E$3>ID37.SG13@3,2,1)}) trying to say If open = 2 change to 1 unless price is above/below a certain price. Thank You PS This is driving me nuts.

[2017-10-12 17:04:52] #2 [Go To First Post]
traderacefly - Posts: 57
I'm not able to test this but try it and see: =IF(ABS(J8)=0,2,IF($E$3>ID37.SG13@3,1,0)) Checks J8, if position is 0 sets to 2 else sets to 1 if current price is > than ID37.SG13@3. *You may need to change the last 0 to 2 so that is always defaults to 2. Hope that helps Date Time Of Last Edit: 2017-10-12 17:06:44**

[2017-10-12 17:10:39] #3 [Go To First Post]
User_ML - Posts: 17
Seems to work. Thank You

[2017-10-12 17:27:07] #4 [Go To First Post]
User_ML - Posts: 17
Still not what I am trying to do. Want an IF statement to evaluate the open contracts. 1- if J8==,2 or if J8 =2 then 1 if price is positive to entry, that way if trade is not working stop will hit for 2 not 1. Need to do it for +2 and -2 contracts. The statement works by itself but whe I try to string together a few of the IF's get error??

[2017-10-12 18:51:49] #5 [Go To First Post]
traderacefly - Posts: 57
Sounds like you are talking about the Scaling In/Out feature. Take at look at these: Attached Orders: Scaling In Attached Orders: Scaling Out

[2017-10-12 19:02:20] #6 [Go To First Post]
User_ML - Posts: 17
Thank You, but that is with attached orders. Was trying to program it in spreadsheet. But will go over it to see if it does what I am looking for.

[2017-10-12 19:22:18] #7 [Go To First Post]
traderacefly - Posts: 57
Attached orders can work with the spreadsheet trading. That is what I do. I'm sure Sierra Chart can do whatever you need. Just a matter of figuring out how. tomgilb is the resident spreadsheet expert here. He also has a website where you can contact him: http://www.sawtoothtrade.com

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