Support Board

Date/Time: Sun, 06 Jul 2025 23:38:52 +0000

[Programming Help] - Automated Trading - Spreadsheet

[2017-08-19 21:14:56] #1 [Go To First Post]
User312841 - Posts: 26
Is there any way to have an alert set a varible (ie T/F)during spreadsheet trading? I just want to trade the first reversal after an alert. Any clever work arounds? THanks

[2017-08-20 01:00:12] #2 [Go To First Post]
Sawtooth - Posts: 4236
Try this: In a Formula Column, e.g. in cell P3: =IF(alertcondition,1,IF(reversalcondition,0,P4)) Then find the row where the reversal happened, e.g. cell Q3: =AND(P4=1,P3=0)

To post a message in this thread, you need to log in with your Sierra Chart account: