Login Page - Create Account

Support Board


Date/Time: Sun, 16 Mar 2025 13:07:47 +0000



Post From: Access calculated values background color for Numbers Bars in spreadsheet or ACSIL

[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