Support Board
Date/Time: Sat, 10 May 2025 20:55:36 +0000
Post From: Spreadsheet Study for Trading - Buy Exits, Sell Exits
| [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
|