Support Board
Date/Time: Thu, 23 Jan 2025 09:35:35 +0000
[Programming Help] - Spreadsheet programming some of various Signals
View Count: 846
| [2018-11-26 13:01:06] |
| sierrasimon - Posts: 51 |
|
Hi, I have a lot of signals and I want to send an order if 3 of 15 signals in the last 3 Bars happen. My only solution is, to put toghether a variety of all possible combinations with AND and OR formulas. But it would be a very long formula. If there would be a loop or repeat formula, i could imagine some short programing and easier handling. Does anybody have a better idea? Thanks!
Date Time Of Last Edit: 2018-11-26 13:02:52
|
| [2018-11-26 13:07:53] |
| Sawtooth - Posts: 4162 |
|
You will probably need to create persistent variables of each signal (to 'remember' the signal in the last 3 bars), using a Formula Column for each, then combine the results in K3/M3. It's all possible, and manageable. Here are some spreadsheet examples of persistent variables: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables |
To post a message in this thread, you need to log in with your Sierra Chart account: