Support Board
Date/Time: Wed, 04 Dec 2024 19:16:18 +0000
Post From: ADD NUMBERS BOTTOM DATA
| [2024-11-25 15:15:10] |
| John - SC Support - Posts: 36469 |
|
You can do this using the built-in tools. Do the following: - Add the Numbers Bars study. - Set the Input for "Highlight Minimum Value In" to a particular column where you want to have the highlight - Set the Input for "Highlight Maximum Value In" to a particular column where you want to have the highlight - Set the Input for "Highlight Maximum/Minimum Value Based On" to "Bid Volume or Ask Volume" - Set the Input for "Ignore 0 Values for Minimum Highlight" to "Yes" With the above, the Numbers Bars subgraphs for "Price at Minimum Highlight" and "Price at Maximum Highlight" will have the price level for the Minimum/Maximum Bid or Ask. If you want the actual Minimum/Maximum numbers, then do the following: - Add two copies of the "Spreadsheet Formula" study to the chart. Enter the following formulas to get the maximum and minimum numbers (one each into each Spreadsheet Formula): =IF(AVAP(ID1.SG4, 0) <= BVAP(ID1.SG4, 0), AVAP(ID1.SG4, 0), BVAP(ID1.SG4, 0)) =IF(AVAP(ID1.SG5, 0) >= BVAP(ID1.SG5, 0), AVAP(ID1.SG5, 0), BVAP(ID1.SG5, 0)) Where ID1 is the ID of the Numbers Bars study, SG4 is the "Price at Minimum Highlight" subgraph, and SG5 is the "Price at Maximum Highlight". You can then use the "Numeric Information Reference" study to put those values into a numeric table (similar to the "Numbers Bars Calculated Values" study). Refer to the following: Numbers Bars: Highlight Minimum Value In Numbers Bars: Highlight Maximum Value In Numbers Bars: Highlight Maximum/Minimum Value Based On Numbers Bars: Ignore 0 Values for Minimum Highlight Spreadsheet Formula Study/Chart Alerts And Scanning: Special Functions Numeric Information Reference For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |