Support Board
Date/Time: Mon, 21 Apr 2025 13:11:41 +0000
Daily Range in Numbers Bars Calculated Values output in ticks
View Count: 74
[2025-02-25 17:07:00] |
User480109 - Posts: 49 |
the daily range value in numbers bars outputs the difference between high and low in float. I would like to use that value and divide by tick increment and have it displayed that way. How can I achieve this?
|
[2025-02-25 21:23:28] |
John - SC Support - Posts: 39362 |
The "Spreadsheet Formula" despite its name, uses the Alerts syntax, and the TICKSIZE is an alert variable that specifies the Tick Size for the chart. So you can use the "Spreadsheet Formula" to get what you want by entering a formula like the following: =ID1.SG31 / TICKSIZE Where ID1 is the ID of the Numbers Bars Calculated Values Study and SG31 is the "Daily Range" subgraph of the Numbers Bars Calculated Values. There are numerous ways to display this information, depending on what you want to do, including the "Text Display for Study" and the "Numeric Information Reference" studies. Refer to the following: Spreadsheet Formula Text Display For Study Numeric Information Reference 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: