Login Page - Create Account

Support Board


Date/Time: Sat, 04 May 2024 05:02:39 +0000



Post From: Spreadsheet Trading - synthetic take profit stop loss

[2015-07-24 04:46:12]
djcurcio - Posts: 236
I want an answer to this ONLY from a Sierra Chart direct employee. Not a 3rd party.

I have coded a synthetic Take Profit / Stop Loss using cell J10.
Here is the code:
=or(or($J$10>=49.1,$J$10<=-49.1),($ED$3=2))
The Stop Loss (-49.1) works fine.
The Take Profit (49.1) does NOT work.

I have tested it with every order type in cells J71 to J74. The take profit always FAILS.

In the enclosed screen shot of the spreadsheet you can clearly see that J10 Open P/L is greater than 49.1 as it is already at 112.5. Yet, the Take Profit code NEVER EXECUTED!
Why?
Help ASAP Please
imageSpreadsht NG.PNG / V - Attached On 2015-07-24 04:45:41 UTC - Size: 49.34 KB - 358 views