Support Board
Date/Time: Wed, 27 Nov 2024 20:33:43 +0000
Color Specific Numbered bars behind the Current Renko Bar
View Count: 315
[2023-07-10 11:56:56] |
User117222 - Posts: 9 |
Hi I'm using FlexRenko charts. I'd like to colour the 5th, 6th and 7th bars (behind the current forming bar) in Yellow. As new bars get formed, the coloured bars should always be the 5th/6th/7th bars from the current bar, and the previous bars should revert to the original bar colour. This will help me place my Entry Orders quickly (using the Yellow bars as a visual guide) I tried using the Colour Bar based on Alerts study, and inserting this formula in the Alerts section: =ID0.SG1[-5] However, it ends up coloring ALL the previous bars, and not just the 5th bar. Any thoughts on what I'm doing wrong? Many thanks |
[2023-07-10 15:15:40] |
John - SC Support - Posts: 36344 |
We know it sounds silly, but the best way to do this would be to create a custom study. This is due to how the studies in Sierra Chart are calculated, where the system is not recalculating the previous bars, therefore there is nothing forcing the update as new bars are added. With a custom study you can loop through the most recent 7 bars to force an update for these as a new bar is added. Refer to the following regarding custom studies within Sierra Chart: Advanced Custom Study Interface and Language (ACSIL): Introduction -- The other option would be to use a Spreadsheet Study along with the Color Bar Based on Alert Condition and you would have to also use the "Chart Recalculation - Periodic" study to force the studies to fully recalculate. With this, you would enter the following in cell K3 of the Spreadsheet Study: =OR(ROW() = 8, ROW() = 9, ROW() = 10) And then in the Color Bar Based on Alert Condition you would use the following Alert: =ID1.SG1 Where ID1 is the Spreadsheet Study (you may have to change the number depending in your setup). Refer to the following: Using the Spreadsheet Study Color Bar Based on Alert Condition Chart Recalculation - Periodic For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2023-07-11 04:39:10] |
Sawtooth - Posts: 4120 |
You can do what you want using 3 instances of the Color Bar Based On Alert Condition study. See this thread for an example: color bar based on alert condition - formula issue If you need help understanding how to use this example, post again. |
To post a message in this thread, you need to log in with your Sierra Chart account: