Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 05:08:45 +0000



Post From: Help Help on Stop Loss Code in Spreadsheet

[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