Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 15:03:10 +0000



candle's minimum and maximum values

View Count: 299

[2023-03-23 11:21:06]
Naderi - Posts: 4
How can I use a candle's minimum and maximum values in the spreadsheet or trade based on alert conditions?

In this case, Ask vol Bid vol difference.
I couldn't find SG in the Number bars calculated values.
image2023-03-23 15_47_51-Settings.png / V - Attached On 2023-03-23 11:18:24 UTC - Size: 47.41 KB - 71 views
Attachment Deleted.
[2023-03-23 15:24:02]
John - SC Support - Posts: 30459
Each of the items that is displayed in the Numbers Bars Calculated Values has a Subgraph associated with it. You had to enable the subgraph to get the specific item you have shown. As such, you reference that subgraph to get the value you want. For items like Max Delta and Min Delta, you can access the data directly in a Spreadsheet Study or Alert (IDx.SGy for Alert or IDx.SGy@n for spreadsheets). Just be aware that some items in the Numbers Bars Calculated Values require special attention in order to access the data. Refer to the following:
Numbers Bars: Referencing Numbers Bars Calculated Values Subgraphs in Alert Formulas

Also refer to the following for referencing a subgraph in an alert:
Study/Chart Alerts And Scanning: Referencing Other Studies on the Chart

And refer to the following for referencing a subgraph in a Spreadsheet Study:
Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-03-25 18:06:05]
Naderi - Posts: 4
I want to reference to highest value and lowest value in a candle with the NumberBars study.
there is no SG for referencing it with alert condition.

As you see in the attached screenshot, I'm showing the Ask vol Bid vol difference.
in the last candle, I highlighted the highest value(17) and lowest(-88) I want to can reference this data in Alert Condition. but there isn't any subgraph in Numbers Bars or Numbers Bars Value showing this data.

Max Delta and Min Delta are not what I wanted. I want the highest value and lowest value in a candle.
[2023-03-27 14:54:02]
John - SC Support - Posts: 30459
You do not have direct access to the Numbers Bars values. So you are correct, there is not a way to reference this directly like with studies.

But, Alert Conditions do have access to the Total Volume at Price, Bid Volume at Price, and Ask Volume at Price. Refer to the following:
Study/Chart Alerts And Scanning: Special Functions

You can also combine the other Main Price Graph Identifiers to get data at a specific position relative to the High, Open, Low, or Close of the bar. Refer to the information here:
Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables

As such, to get what you want, we recommend using the Spreadsheet Formula, which actually uses the Alert syntax, and setup a formula that would look like the following to get the Ask/Bid Difference at the High of a bar:
=AVAP(H, 0) - BVAP(H, 0)

Refer to the following for the Spreadsheet Study:
Spreadsheet Formula

We are not sure how you want to display this, but you could use the Study Subgraph Above/Below Bar As Text. Refer to the following:
Study Subgraph Above/Below Bar as Text
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-04-02 19:43:44]
Naderi - Posts: 4
So is it possible to ask the Developer's team to add these subgraphs to the Numbers Bars values study?
I think it should not be hard cause you are already showing it with Numbers Bars Study in:65 and in:68.
I need direct access to this information for my alert condition.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account