Login Page - Create Account

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:

Login

Login Page - Create Account