Home >> Support Board

Support Board

Date/Time: Sun, 19 May 2024 02:18:42 +0000

How to Post a Message for Support

[Programming Help] - Spreadsheet programming some of various Signals

View Count: 792

[2018-11-26 13:01:06] #1 [Go To First Post]
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] #2 [Go To First Post]
Sawtooth - Posts: 4000
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: