Support Board
Date/Time: Sun, 07 Dec 2025 23:30:02 +0000
Post From: Handling Stop and Limit orders with the Spreadsheet for trading
| [2025-11-07 13:53:42] |
| Fabio - Posts: 136 |
|
Hi @Sawtooth. Thanks for the heads up. I honestly had no idea about that study in the first place. I will definitely look into it. I have another question now :) I have created the system to be semi-automated by design, so I have formulas in cell K3 and M3 that relate to cell O3 (for the buy trigger) and cell P3 (for the sell trigger). What I mean by that is the following. Cell K: IF O3= "xyz" then K3 become TRUE (1) and a limit order is placed based upon conditions. Same thing for cell M3 with cell P3 (P3= "xyz" then M3 become TRUE). So far, everything works as intended. If I remove the conditions from cell O3 or P3, Cell K3 or M3 return to the default (FALSE, or 0) value. And again, all good here. However, the order placed (entry limit order) when the conditions were TRUE (or 1) won't be removed from the chart despite now the cell K3/ M3 are 0. Is this a normal behaviour or am I missing something? Because in my mind the way that should work is as follow: K3/M3 = 1, then Limit order placed. K3/M3 = 0, then the limit order placed (and not filled) is pulled off. What am I missing here? Because I noticed that Cell J39 (on V2 that is "Working orders Exist (read-only)) remains 1 despite cancelling the conditions and Cell J40 ("working orders quantity (read-only) maintain the quantity as well. Then as soon as I cancel the order manually on the chart, those cells return to 0. Shouldn't this behaviour happen when I cancel the conditions? Also, another question that popped in my mind is the following; Is there a formula or something that will allow Cell O3 or cell P3 to reset to "" (empty) once the limit order gets filled? Thanks, Fabio Date Time Of Last Edit: 2025-11-07 14:24:40
|