Support Board

Date/Time: Sat, 18 May 2024 21:55:21 +0000

Post From: Alert Condition for Numbers Bars Calculated Values

[2023-10-26 17:14:51] Link To Thread - Link To Post [Go To First Post]
John - SC Support - Posts: 31704
That definitely simplifies things. In this case you will want to use the "Spreadsheet Study" to get the data you need. Add the Spreadsheet Study and set the Input for "Number of Rows" to be more than the number of bars that will be in your chart for the 1 day (for instance, if you use 1 minute bars, then you would have approximately 1440 bars (1440 minutes in one day), but the CME Group is closed for 1 hour per day, so this would cover the full time period). Then enter the following: - Cell K3: =MAX(ID1.SG13@$3:ID1.SG13@$1440) - Cell L3: =MIN(ID1.SG13@$3:ID1.SG13@$1440) - Cell M3: =K3 - L3 - Cell N3: =.25 * M3 + L3 - Cell O3: =.5 * M3 + L3 = Cell P3: =.75 * M3 + L3 Where ID1 is the ID of the Numbers Bars Calculated Values Study. SG13 is the "Total Volume" subgraph of the Numbers Bars Calculated Values study. $3 is the first row of the data in the spreadsheet and $1440 is the last row of the data in the spreadsheet (the 1440 should match whatever you have set for the Number of Rows for the spreadsheet). Column M then gives you the range of the data, and columns N, O, and P give you the values at which the coloring changes (you would need to change the multiplier to whatever you have for your Percent Threshold Values. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing