Login Page - Create Account

Support Board


Date/Time: Tue, 11 Mar 2025 00:56:21 +0000



Post From: Colour Based on Alert Condition

[2022-04-09 14:21:12]
Sawtooth - Posts: 4181
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.