Support Board
Date/Time: Thu, 28 Nov 2024 20:41:27 +0000
Post From: Numbers Bars Calculated Values % compare thresholds to Color bar based on alert condition
| [2023-04-07 20:49:22] |
| John - SC Support - Posts: 36350 |
|
Sorry. I did think you were referencing the Numbers Bars study. And looking back, you did specifically say the Numbers Bars Calculated Values. First of all, there is not a way to direct access the Inputs, so doing something like "ID1.IN18" is a Syntax error and will not do anything. Second, recreating the way the coloring is done for the background coloring of the Numbers Bars Calculated Values is not straightforward, as you would need to know the lowest value and the highest value within the data range you have set to determine the coloring from. You state that you have it set to "Day", so you would have to find the Highest and Lowest values within the past day. You should be able to do this using a Spreadsheet Study to get the high and low for the period using the Large() and Small() functions. You will also need to check the date to ensure the data is within the range you specify (i.e. today). Refer to the following for the Large() function to see how it works: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#LARGE_Function Then refer to the following for how the rest of the calculations are performed: Numbers Bars: Calculated Values Background Coloring Logic For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |