Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 26 Apr 2024 13:12:28 +0000
Single Orders - Exit Triggers. Spreadsheet System for Trading - Autotrade Backtest
View Count: 1302
| [2017-12-20 19:49:07] |
| Mooshu22 - Posts: 25 |
|
I am using the "spreadsheet system for trading study" along with the "Autotrade System Bar Based Backtest." I am trying to figure out how to trigger automated exits for single buy or sell orders that have a set take profit and stop loss. Is this possible or do I need to use attached orders and set the targets for the main and child order separately? I have tried to set the exit condition in the BUY Exit and SELL Exit columns to trigger when the "Open Profit/Loss" cell, J10, hits my targets and that didn't work either.
|
| [2017-12-21 05:33:50] |
| |
|
Refer to this section here about this: Spreadsheet Systems, Alerts and Automated Trading: Initiating Trades with Auto-Trading and Using Manual or Attached Orders Exits 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 |
| [2017-12-21 15:17:03] |
| Mooshu22 - Posts: 25 |
|
Thank you for the help. I worked it out. I also didn't realize that setting the target order- tick size in the trade window was not the right size for the a pip in Forex. 20 ticks = 10 pips. Not sure where I missed on understanding that; but I was able to adjust the ticks and now the take profit and stop loss are triggering on the right levels. I attempted to use the textbook formula provided in the link for formula triggered exits: =OR( AND( $J$8 > 0, ID0.SG4@$3 <= $J$9-1), AND( $J$8 > 0, ID0.SG4@$3 >= $J$9+2)) for the Buy Exit (Sell) column and the system is erasing the formula in the Buy Exit (sell) cell during Backtesting. I tried several variations of the code and the result was the same. I didn't see any setting I needed to enable for that to work. Are there other settings that need to be enabled to get the Buy Exit (Sell) formulas to work? Thank you again for your time. |
| [2017-12-21 18:32:21] |
| |
|
and the system is erasing the formula in the Buy Exit (sell) cell during Backtesting. This must be because the Formula Source Sheet Number Input is set to a different Sheet. Refer to:http://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#FormulaSourceSheetNumber 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: