Login Page - Create Account

Support Board


Date/Time: Mon, 22 Jan 2018 06:39:08 +0000



Single Orders - Exit Triggers. Spreadsheet System for Trading - Autotrade Backtest

Support Request:
[2017-12-20 19:49:07]
Mooshu22 - Posts: 11
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]
Sierra Chart Engineering - Posts: 56346
Refer to this section here about this:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.php#UsingManualOrAttachedOrdersExits
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-12-21 15:17:03]
Mooshu22 - Posts: 11
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]
Sierra Chart Engineering - Posts: 56346
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.

To post a message in this thread, you need to login with your Sierra Chart account:

Login


Login Page - Create Account