Support Board
Date/Time: Sat, 19 Apr 2025 10:17:46 +0000
Post From: Calculating a different VOLD ratio
| [2025-03-27 16:45:28] |
| John - SC Support - Posts: 39362 |
|
We see you used the "Study Subgraphs Divide/Ratio", so that gives you a single value. In this case, to change that value to the negative inverse when it is below zero, use the "Spreadsheet Formula" study and enter the following formula: =IF(ID1.SG1 < 1.0, -1/ID1.SG1, ID1.SG1) Where ID1 is the ID of the Study Subgraphs Divide/Ratio study and SG1 is the Ratio Subgraph of the Study Subgraphs Divide study. There is not a way to display a large text item that is colored red for negative and green for positive, as the "Text Display for Study" uses a drawing tool in the end to draw the information to the screen and this does not have the ability to select colors based on value. You can modify the study itself to get what you want if you are comfortable with this. Refer to the following: Text Display For Study How to Build an Advanced Custom Study from Source Code https://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |