Support Board
Date/Time: Sun, 22 Dec 2024 04:51:18 +0000
[User Discussion] - Spreadsheet Trading - synthetic take profit stop loss
View Count: 2139
| [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 |
 Spreadsht NG.PNG / V - Attached On 2015-07-24 04:45:41 UTC - Size: 49.34 KB - 404 views |
| [2015-07-25 10:38:51] |
| |
|
Also include in your formula that the position quantity is greater than or less than 0 depending upon whether this formula is used in Buy Exit or Sell Exit. Clearly the formulas are returning TRUE according to the Sheet you are showing, but they may have been returning TRUE too early. This is explained in detail here: https://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#IgnoredSignals Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2015-07-25 10:39:09
|
| [2015-07-25 14:19:10] |
| djcurcio - Posts: 236 |
|
Attention Sierra: The last response is just another trip down the coding rabbit hole. It is NOT a viable answer! My conclusion is that Spreadsheet for Trading might be a canard and probably can never work to generate profits for both long and short trades. This seems to be confirmed that neither Sierra or any other site on the internet shows even a primitive working trading spreadsheet for both long and short trades. Also, that logically user-friendly, simple spreadsheet functions such as Trade Stop Loss / Take Profit, Daily Drawdown Limit, Daily Profit Limit, Start / Stop Auto Trading at specific times are not available, but rather that Sierra REQUIRES that the user attempt to code these functions with highly complex code. This might be how Sierra hides the truth that Trading Spreadsheets cannot work to generate consistent profits, and / or are nearly impossible to code. So, here are my suggestions to prove that Sierra Spreadsheet Trading is not a CANARD: 1. Post a PROFITABLE, complete, primitive working spreadsheet in Sierra Support and on YouTube that includes both long and short trades, take profit and stop loss entries without using the Order Pad or OCO orders, and includes Daily Drawdown Limit, Daily Profit Limit, Start / Stop Auto Trading at specific times. 2. Add Spreadsheet Functionality for Daily Drawdown Limit, Daily Profit Limit, Start / Stop Auto Trading at specific times. Your move |
| [2015-07-27 17:57:30] |
| |
|
1. Post a PROFITABLE, complete, primitive working spreadsheet in Sierra Support and on YouTube that includes both long and short trades, take profit and stop loss entries without using the Order Pad or OCO orders, and includes Daily Drawdown Limit, Daily Profit Limit, Start / Stop Auto Trading at specific times. You are missing the point. Just because Sierra Chart offers functionality, does not mean that there is an assurance that the functionality can be used in a profitable way. That is up to the user to determine. Also the implementation of Targets and Stops are best done by Attached Orders when using the Spreadsheet study. The next release of Sierra Chart will support flattening positions when a certain Daily Loss has been met. This will be set through Global Settings >> Global Profit/Loss Management. There is currently the capability to flatten positions when a certain daily profit has been met. And we will look into adding starting and stopping times for automated trading including flattening the position at the stop time. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: