Support Board
Date/Time: Fri, 07 Feb 2025 14:55:36 +0000
Post From: How to Create this Indicator?
| [2021-05-24 20:34:23] |
| John - SC Support - Posts: 37808 |
|
You can't. Think about what you are asking for, you want to display both Positive and Negative values as Positive values. But, to do what you want, you would need to do two things, 1) flip the negative values to positive, and 2) color the bars based on the original values. To do this, do the following: 1. Use the Spreadsheet Formula to convert the data. Use a formula that looks like the following: = IF(ID1.SG1 < 0, ID1.SG1 * -1, ID1.SG1) where ID1.SG1 is the Study ID and Subgraph number for the data you want. Then use you Study Subgraph Reference on the Spreadsheet Formula study. 2. To get the coloring, you would need to use the Color Bar Based on Alert Condition study. If you do not have the coloring for either up or down bars, then you would need two copies of the study, otherwise, if you already have the positive values being colored the way you want, then just one copy of the study is needed. For the Color Bar Based on Alert Condition, you would use the following condition: = ID1.SG1 < 0 Again, the same ID and SG as above are used to know if it was originally negative. Refer to the following for the Spreadsheet Formula Study: Spreadsheet Formula Then it is just a matter of setting up the rest of the Color Bar Based on Alert Condition study to get what you want out of it. To do this, refer to this section: Color Bar Based on Alert Condition: Coloring Subgraphs of Other Studies For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |