Login Page - Create Account

Support Board


Date/Time: Fri, 07 Aug 2020 03:32:25 +0000



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

[2015-07-14 00:18:19]
djcurcio - Posts: 236 | Ending Date: 2013-05-16 [Expired]
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]
tomgilb - Posts: 2633 | Ending Date: 2020-12-03
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 login with your Sierra Chart account:

Login

Login Page - Create Account