Support Board
Date/Time: Mon, 17 Mar 2025 10:47:35 +0000
Access calculated values background color for Numbers Bars in spreadsheet or ACSIL
View Count: 362
| [2022-08-12 03:52:54] |
| JTW1979 - Posts: 7 |
|
I'm using the Volume per Second calculated values in the Numbers Bars study. As is typical, the values have their background color changed according to where each value falls along that day's range. Is there a way to access the range percentage or background color using a spreadsheet function or ACSIL? Date Time Of Last Edit: 2022-08-12 04:00:45
|
| [2022-08-12 16:33:01] |
| John - SC Support - Posts: 38678 |
|
The underlying issue is that you do not have programmatic access to the Maximum daily value that defines the percentages for the rest of the cells. You can always look through the data to find it, but it is not available to a spreadsheet or any other internal tool. Therefore, the only way you could do this would be to create a custom study and search through the numbers to find the highest value and then determine the actual percentage that any particular bar is relative to that. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: