Support Board
Date/Time: Mon, 21 Apr 2025 14:38:18 +0000
[Programming Help] - SPREADSHEET SYSTEM FOR TRADING MINOR AMENDMENT
View Count: 301
| [2023-02-09 11:35:36] |
| User9890731 - Posts: 47 |
|
HI, I would like to request to have the ''reset condition on new bar'' amended to have an option to reset condition on either new "tick or second" as an option regardless of current bar type. This has become an issue for me whenever I try to program a spreadsheet bot, specifically whenever the conditions on "k3 or M3" are true and I get stopped out or I have an exit formula on "L3 or N3". I would get stopped out but the entry condition will not re-enter a new position (remain 1(true) until bar close or unless k3 or m3 reset to 0. I tried using tick charts with "Study price overlay" but since the spreadsheet is based on tick chart, it's still difficult to have all conditions working in sync to generate an efficient bot. If the condition on M3 or K3 regardless of bar type could reset every second or tick, it would allow one to re-enter a trade after getting stopped out without waiting for bar close or being forced to use tick charts... |
| [2023-02-09 14:11:34] |
| Sawtooth - Posts: 4209 |
|
Your K3/M3 formulas could reset to 0 intrabar after a stop out by comparing J41 to J43: =AND(YourOtherConditions,$J$41-$J$43>3/86400) This will go FALSE for 3 seconds after an exit. |
To post a message in this thread, you need to log in with your Sierra Chart account: