Support Board
Date/Time: Tue, 04 Nov 2025 03:22:32 +0000
Post From: Colour Based on Alert Condition
|   [2022-04-09 14:21:12]     |  
| Sawtooth - Posts: 4285 | 
| 
                 Short arrow when price is same or lower than Top band 
How do I only show 1 entry rather than multiple? 
Try this:CROSSFROMBELOW(H,ID2.SG1) How do I program it for reversal trade? (I only want the signal if it comes from either a)bottom band or b) middle band) 
Try this:1. Add the Spreadsheet Formula study - Move it above your Color Bar study in the Studies to Graph list. - Set 'Draw Zero Values' to No - Check 'Hide Study' - Use a formula like this in its Formula field: =IF(OR(CROSSFROMBELOW(L,ID2.SG2),CROSSFROMABOVE(L,ID2.SG3)),1,IF(CROSSFROMBELOW(H,ID2.SG1),0,ID4.SG1[-1])) -where ID4 is the Spreadsheet Formula study. This creates a persistent True when the Low crosses either the bottom or middle bands, then releases it when the High crosses the upper band. 2. Use a formula like this on the Alerts tab of your Color Bar study: =AND(CROSSFROMBELOW(H,ID2.SG1),ID4.SG1[-1]=1) -where ID4 is the Spreadsheet Formula study.  | 
        
