Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 04:03:39 +0000
Spreadsheet Study for Trading - Buy Exits, Sell Exits
View Count: 1463
| [2016-07-23 18:12:15] |
| sigmadict - Posts: 95 |
|
Hello, I wanted to know if it is possible to put a Condition (Function to choose the type of order) inside the Cells J72 & J74 of the Spreadsheet Study for Trading, which are Buy Exits and Sell Exits ? In other words, the Cells that are beein used to Exit the market when Target is reached or Stop is Reached. The Types of Orders available to choose in those two Cells are M,L,S,SL,MIT, etc.. If I choose L for Limit for example, from my understanding, I will Exit the market on Limit Orders if my Target or my Stop is Reached. Both, Target and Stop will execute with Limit Order. So I tryed to put a condition in the Exit Sells as the following : =if($J$10>=$S$3,L,if($J$10<=$T$3,S,L)) to generate a different order for Targets and Stops, but I get an error code. Is it possible to assign a Condition to the Exit Cells to be able to choose different Order Types for Targets and Stops, because it makes a big difference to the Backtest ? I may be looking at the wrong place, but I would like to know if : 1- Is it possible to put a Condition in Cells J72 and J74 ? 2- Is it possible to assign a different Order Type to the different type of Exits, Targets and Stops with the Spreadsheet for Automated Trading? Thanks Regards Date Time Of Last Edit: 2016-07-23 18:13:35
|
| [2016-07-23 21:49:46] |
| |
|
1. The order type can be programmatically set with a formula in the Order Type cells. Here is an example: =IF($J$5 > 0, "L", "M"). 2. Yes you can do what you want but you have to work out the formula logic. We do not provide programming help. 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: 2016-07-23 21:50:00
|
To post a message in this thread, you need to log in with your Sierra Chart account: