Support Board
Date/Time: Thu, 28 Nov 2024 00:27:05 +0000
Numbers Bars highlighting
View Count: 941
| [2022-10-07 13:25:06] |
| Richie1 - Posts: 5 |
|
Hello How can numbers bars with a zero value at the high/low of bar (finished auction) be highlighted? Is it possible to set an audible alert for the above? Thank You! |
| [2022-10-07 16:02:06] |
| John - SC Support - Posts: 36350 |
|
There is not a way to highlight the High/Low when there is a zero value. In terms of an alert, this can be done by using the functions for BVAP and AVAP in combination with the Main price Identifiers of H (high) and L (Low). For example, to check if the Bid Volume at the High is zero, you would enter the following for the alert: =BVAP(H,0) = 0 Refer to the following: Study/Chart Alerts And Scanning: BVAP For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-05-13 20:34:44] |
| User954471 - Posts: 7 |
|
Hi, Is there a way to extend this please to stipulate that there's an ask of at least 500 on the opposite side? Example: at high of bar it would looks like 0x500 Thanks P Date Time Of Last Edit: 2023-05-14 19:21:22
|
| [2023-05-15 14:31:42] |
| John - SC Support - Posts: 36350 |
|
That alert would be the following: =AND(BVAP(H, 0) = 0, AVAP(H, 0) > 500) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-14 09:09:28] |
| User185210 - Posts: 64 |
|
Hello, Is there a way to do the same but for the previous bar@4 and diplay the alert in a spreadsheet as a result =1 to be able to automate a behaviour resulting from that event? Thanks, Paul |
| [2023-06-14 14:13:25] |
| John - SC Support - Posts: 36350 |
|
There is not a way to test the previous bar at a relative position (such as High or Low). When you use the Offset option within the BVAP and AVAP functions, it gives you the volume at the price set for the current bar. For example, if the current bar High is 4321.00 then when you ask for the Bid or Ask volume for the High from a previous bar, it will give you the volume from that bar at a price of 4321.00 (not at the High for that previous bar). Refer to the information here: Study/Chart Alerts And Scanning: BVAP But in order to use the condition in another study, you would want to use the "Spreadsheet Formula" and put the condition into the formula for that study. The Spreadsheet Formula uses the Alert syntax, so it would give you the True/False (1, 0) results you could use elsewhere. Refer to the following: Spreadsheet Formula For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-14 15:54:04] |
| User185210 - Posts: 64 |
|
Might have found a way to display the completed auction @4: spreadsheet Formula (SF): example: and(BVAP(H,0)=0,AVAP(H,0)>0) + study price overlay (SPO) of (SF) + spreadsheet study for trading computing the SPO with results @3,4,5... |
| [2023-06-14 18:32:55] |
| John - SC Support - Posts: 36350 |
|
Yes, that would a good way to do it.
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: