Support Board
Date/Time: Mon, 03 Mar 2025 17:19:06 +0000
[User Discussion] - Number Bars Calculated Values as a histogram
View Count: 857
| [2021-11-02 15:19:13] |
| manfretto - Posts: 117 |
|
Hi, I use Number Bars Calculated Values to show two type of delta. All in figures. What function should I use to change table with figures into histogram chart for two deltas? |
| [2021-11-02 15:33:21] |
| User907968 - Posts: 833 |
|
Study Subgraph Reference Study Subgraphs Reference Spreadsheet Formula |
| [2021-11-02 16:09:05] |
| manfretto - Posts: 117 |
|
I have almost managed with Study Subgraph Reference. How can I show all delta (positive and negative)above zero as a histogram?
|
| [2021-11-02 16:18:32] |
| User907968 - Posts: 833 |
|
You could the spreadsheet formula study mentioned above and invert the negative delta for example: =IF(BV>AV,(AV-BV)/V*-1,(AV-BV)/V) Or If you want different colors for each of pos and neg delta, use two copies of the study, for example: Pos: =IF(AV>=BV,(AV-BV)/V,0) Neg: =IF(BV>AV,(AV-BV)/V*-1,0) |
| [2021-11-02 16:22:47] |
| manfretto - Posts: 117 |
|
I have used study subgraph reference. Can we make it via this?
|
To post a message in this thread, you need to log in with your Sierra Chart account: