Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 07 May 2024 02:00:45 +0000
Post From: Color Bar based on closing price above/below sub graph
| [2020-08-22 13:02:57] |
| Sawtooth - Posts: 3993 |
|
Instead of the color bar study, use the Spreadsheet Formula study, with a formula like this in the Formula field: =IF(CROSSFROMBELOW(C,ID1.SG2),1,IF(CROSSFROMABOVE(C,ID1.SG3),-1,ID2.SG1[-1])) -where the Spreadsheet Formula study is ID2. Set the Chart Region to 1, then on the Subgraphs tab, set the Draw Style to Color Bar, and Auto-Coloring to Based On +/- This creates a value at each crossover that is persistent until the opposite crossover. This is not possible with the color bar study. |