Support Board
Date/Time: Mon, 25 Nov 2024 07:36:53 +0000
Alert on the previous candle don't works
View Count: 318
| [2024-03-20 05:26:51] |
| Hopeman - Posts: 166 |
|
Hello, I am trying to create an alert for the study volume at price trheshold alert V2. The alert would be that if it is not in the current candle, it is in the previous candle and I am doing it with the following formula =AND(ID1.SG49@3:ID1.SG50@3, OR(ID1.SG49@4:ID1.SG50@3) =AND(OR(ID1.SG49@3:ID1.SG50@3,ID1.SG49@4:ID1.SG50@3)) None of these formulas work if I have an alert on the subsequent candle. Do you know if setting an alert on the subsequent candle is possible? thank you |
| [2024-03-20 16:04:31] |
| John - SC Support - Posts: 36238 |
|
Where are you adding this alert? The format you are using (ID1.SG49@3) is a Spreadsheet Study format - it does not work in Alerts. If you are using one of the Spreadsheet Studies (not the Spreadsheet Formula) then you reference a prior bar by the row number, so instead of ID1.SG49@3, which is the current bar, you would use ID1.SG49@4. Refer to the following: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study For an alert (and also the Spreadsheet Formula study) the format is to use a [-1] to reference the bar prior to the current one. Refer to the following: Study/Chart Alerts And Scanning: Referencing Data Other Than on the Last Bar/Column In the Chart For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-03-22 15:45:29] |
| Hopeman - Posts: 166 |
|
I am using the spreadsheet system of trading and I need to make a reference to the previous candle the formula SG49@4 with the study of imbalances volume at price trhesjold alert v2 The reference to the previous candle does work if I put it alone, in any case if I combine it with the following formula, it does not work AND(ID1.SG49@3:ID1.SG50@3, OR(ID1.SG49@4:ID1.SG50@4) In any case, the brackets in the calculation sheets do not work as I understand Date Time Of Last Edit: 2024-03-22 16:00:01
|
| [2024-03-22 16:34:48] |
| John - SC Support - Posts: 36238 |
|
You are setting a range by the use of the colon (:) so it is trying to check the range of values, which isn't what you really want to do in this case. For example, you have the following: OR(ID1.SG49@4:ID1.SG50@4) Having the colon (:) in between the two items is a range reference. What is it exactly that you want to accomplish? For instance, from what you are trying to do and what you initially stated, it looks like you want to check to see if a stacked imbalance exists in the previous bar and not in the current bar. If you just want to know if this is the case, regardless of price, then use the following =AND(ID1.SG50@4, ID1.SG50@3 = 0) SG49 is always set to a value, but SG50 will be 0 if there is not at least 1 set of adjacent cells. But the issue is that just testing the status of the "Adjacent Alerts" will only tell you if it exists, but does not tell you anything about the price levels at which it occurs. If you want to do something along these lines, then you would need to actually check the values against each other, so something like the following: =ID1.SG50@4 <> ID1.SG50@3 This will then be true if the adjacent alerts end at the same price levels. If you still need more help, then let us know exactly what you are trying to accomplish. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-03-22 16:42:11] |
| Hopeman - Posts: 166 |
|
I am trying to create an alert about price imbalance in the previous candle and if there is none in the previous candle, mark it in the current candle so create this formula =AND(ID2.SG49@3,ID2.SG50 @3, OR(ID2.SG49@4,ID2.SG50@4))
|
| [2024-03-22 17:08:48] |
| John - SC Support - Posts: 36238 |
|
To have a True/False signal in the Spreadsheet when the current candle has at least one Stacked Imbalance and the previous candle does not have any use the following formula: =AND(ID2.SG50@3, ID2.SG50@4 = 0) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-03-22 18:26:44] |
| Hopeman - Posts: 166 |
|
Do you know if it is possible that in the previous candle there is an imbalance but not the current candle?
|
| [2024-03-22 19:36:27] |
| John - SC Support - Posts: 36238 |
|
We gave you that in post 4
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-03-23 06:54:34] |
| Hopeman - Posts: 166 |
|
Thank you for your attention and patience, best regards
|
To post a message in this thread, you need to log in with your Sierra Chart account: