Login Page - Create Account

Support Board


Date/Time: Thu, 25 Apr 2024 23:54:25 +0000



[User Discussion] - Help Help on Stop Loss Code in Spreadsheet

View Count: 1134

[2015-07-14 00:18:19]
djcurcio - Posts: 236
I'm trying to set an ES stop loss at -50 for any trade, long or short. I assume dollars.
My code in Buy Exit cell L3 and Sell Entry M3 is:
=or(and($J$8<>0,$J$10<=-50),or(EJ3=1,EJ3=2))
J71:73 are all M Market
but I keep getting losses much very greater than $50
Changing J71:73 to S yields the same problem.
Help please

BTW, It would be much easier to have two new spreadsheet rows, Long Trade Stop Loss Amount and Short Trade Stop Loss Amount, as this would eliminate some of the complex logical code. This is a Suggestion Please.

Thanks
[2015-07-14 02:39:51]
Sawtooth - Posts: 3976
If 'Signal Only On Bar Close' is set to Yes, J10 could exceed -50 before the bar closes.

If you set J71:J74 to anything other than M, you must also set its corresponding price in J22:J25.

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

Login

Login Page - Create Account