Support Board
Date/Time: Sun, 24 Nov 2024 06:24:50 +0000
Color bar based on Spreadsheet study ?
View Count: 173
| [2024-06-19 21:58:27] |
| User207296 - Posts: 4 |
|
Hi, I have the spreadsheet study on a price graph just now. I now want to color the bars of the graph based on values of a specific column of the spread sheet- is this possible? |
| [2024-06-19 22:35:16] |
| John - SC Support - Posts: 36238 |
|
We need more information on exactly what you are trying to do. Are you wanting to color the bars various colors, or just one color. What are the conditions for the coloring?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-06-19 22:42:08] |
| User207296 - Posts: 4 |
|
Hi, thanks for getting back to me. The spreadsheet column I'm referencing has 4 possible values: 'Bullish', 'Bearish', 'Rebound', 'Correction'. I'm wanting to color the bars based on these 4 states, say for example: Bullish = Green, Bearish = Red, Rebound = Blue, Correction = Yellow. I've attached a sceenshot as well of the graph + spreadsheet. Cheers! |
image.png| [2024-06-20 13:11:24] |
| John - SC Support - Posts: 36238 |
|
You would need 3 or 4 copies of the "Color Bar Based on Alert Condition". You need 3 if you want to set the standard color for the bars to be one of the states, otherwise you would need 4 to do all the coloring for you. Then in each copy of the "Color Bar Based on Alert Condition" you would need to enter the condition that creates the "Bullish", "Bearish", "Rebound", and "Correction" states. Make sure that each condition is exclusive to each situation (i.e. do not do something like "H > 1000" and "H > 1500", you would need "OR(H > 1000, H < 1500)" and "H > 1500" (assuming the H > 1500 is a final condition)). Refer to the following: Color Bar Based on Alert Condition Study/Chart Alerts And Scanning For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-06-20 14:17:37] |
| Sawtooth - Posts: 4118 |
|
If the spreadsheet study is set to Region 1, you can use it to color the bars. In 4 spare Formula Columns: W3: =Q3="Bullish" X3: =Q3="Bearish" Y3: =Q3="Rebound" Z3: =Q3="Correction" Then set the DrawStyle of those subgraphs to Color Bar Date Time Of Last Edit: 2024-06-20 14:32:28
|
To post a message in this thread, you need to log in with your Sierra Chart account: