Support Board
Date/Time: Tue, 26 Nov 2024 08:22:06 +0000
[User Discussion] - Disable Spreadsheet Reversal on Condition
View Count: 175
| [2023-12-21 07:35:33] |
| AzharBasri - Posts: 28 |
|
Is it possible to enable and disable spreadsheet reversal on certain condition? For example, I only want to enable reversal only when the number of bar between the signal is less than 10 bar. If the next signal is more than 10 bar after the first signal, I do not want the reversal to be in effect and ignore the signal. |
| [2023-12-21 14:25:46] |
| Sawtooth - Posts: 4120 |
|
Count the bars from each signal, using this example: Spreadsheet Example Formulas and Usage: Formula to Count Bars Since An Event |
| [2023-12-21 15:16:34] |
| AzharBasri - Posts: 28 |
|
I already use count bars since an event but how to change J68 to 0 if the support reversal setting is already enable? Is there any example to disable and change J68 from 1 to 0 after count bar more than 10? |
| [2023-12-21 15:39:17] |
| Sawtooth - Posts: 4120 |
|
Is there any example to disable and change J68 from 1 to 0 after count bar more than 10?
J68 is read only. It cannot be controlled by the spreadsheet.A reversal can only occur if there is an opposing signal in K3/M3, so disallow that signal if J8<>0, and the bar count is >10. |
| [2023-12-21 15:57:07] |
| AzharBasri - Posts: 28 |
|
Understood! Thanks alot!
|
To post a message in this thread, you need to log in with your Sierra Chart account: