Support Board
Date/Time: Fri, 29 Nov 2024 08:28:44 +0000
Color Bar Based on Alert Condition Problems
View Count: 490
| [2023-03-01 13:43:47] |
| TopGunTrader - Posts: 172 |
|
Hi, I frequently have this problem, create a data point I want to use in this case range H-L and then a moving avg of it to compare range to the avg but then when putting in the correct ID and SG in this case ID9.SG1 the alert doesn't work. In Chart Values window there's simply no data for my range or moving avg of the range. It's happened dozens of times can't figure it out. |
 Capture.PNG / V - Attached On 2023-03-01 13:43:36 UTC - Size: 206.28 KB - 87 views |
| [2023-03-01 21:24:44] |
| John - SC Support - Posts: 36350 |
|
The subgraphs for the Range and Range Moving Average must be set to not display in the Tool Values Window. Refer to the following setting: Chart Studies: Subgraphs Tab >> Display Name and Value in Chart Values Windows But the real question is what is your Alert formula? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-03-02 01:13:47] |
| TopGunTrader - Posts: 172 |
|
It's just bizarre, loaded Sierra opened saved sample 1 chart workspace, hid all the studies to create a version I could send you, created new color bar based on alert condition with identical ID and SG and today it works. For a study to be used in a color bar by alert are any settings REQUIRED for the color bars for alert to get the data? |
| [2023-03-02 01:25:29] |
| TopGunTrader - Posts: 172 |
|
I take it back when I created a new color bar alert with that ONE rule it showed up, when I added it to previous signal they no longer showed up even though when as a single rule they 'signaled' on most of those bars. I posted pics of all 3 sell signals by themselves without this extra rule, the one rule which works and then lastly adding that rule to original one and there were no signals at all. This has happened to me so many times in the past where I eventually give up on trying to write signals even though I need them. |
| Capture1.PNG / V - Attached On 2023-03-02 01:21:03 UTC - Size: 220.67 KB - 85 views Capture2.PNG / V - Attached On 2023-03-02 01:22:08 UTC - Size: 223.78 KB - 86 views Capture3.PNG / V - Attached On 2023-03-02 01:23:10 UTC - Size: 236.36 KB - 89 views |
| [2023-03-02 17:00:29] |
| John - SC Support - Posts: 36350 |
|
This is too complicated to try and figure out through the images alone. Can you please get us the chart that has this by following these instructions (be sure to leave all the studies on the particular chart and include any other charts that are needed if the are being referenced): Support Board Posting Information: Providing Chartbook with Only a Single Chart For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-03-02 19:07:07] |
| TopGunTrader - Posts: 172 |
|
Hi, Here is sample chart. If you show ID12 the code range>=.6* avg of range shows on every bar. However when its added to ID10 Signal: Heavy Selling all signals go away. So odd thing is it works individually but when added to a signal that was working stops it from working. I've had this same issue at least 6-10 times in past trying to do signals so always gave up. It seems signals that use spreadsheet formulas and especially moving averages or keltners or bollinger bands on spreadsheet studies don't work in alerts. |
 SAMPLE_500v_Signals.Cht - Attached On 2023-03-02 19:04:39 UTC - Size: 6.71 KB - 94 views |
| [2023-03-02 22:22:49] |
| John - SC Support - Posts: 36350 |
|
One issue we found is that in your formula you are missing a reference to the Study ID. Here is what your formula is in the Signal Heavy Selling Color Bar Based on Alert Condition study: =AND(ID1.SG4<=-150,ID5.SG4+ID5.SG5+ID5.SG6<100,ID8.SG1>=.6*ID9.SG1) If you note the last test, which is the following: SG1>=.6*ID9.SG1 You are missing the ID of the study associated with SG1. It is possible to use this nomenclature, which means use SG1 from the study on which this alert is entered, but in this situation, that is the Color Bar subgraph of the Color Bar Based On Alert Condition, which will never be set to any value at the time this formula is being evaluated. It is very hard for us to troubleshoot anymore than this, as you are using a Custom Study for most of the alerts for which we do not have access. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-03-03 00:51:25] |
| TopGunTrader - Posts: 172 |
|
Hi, That's not correct the last test IS ID8.SG1>=.6*ID9.SG1 as you can see in the reply you sent me and also in the alert. By the way over 80% of bars meet 60% of the avg range. There's something wrong because when I loaded this chart I saw the sell signals. I hid them, unhid them and they wouldn't come back but when loading the chart they were initially there. Something has to be wrong. If a ONE item alert finds it true on many of my sell signals then when I add that rule by coping and pasting it most of the trades should still be there. I've never had a problem referencing Sierra's studies only spreadsheet ones I've created or moving avg's of them or bollinger bands/keltners on a spreadsheet formula. |
| Capture.PNG / V - Attached On 2023-03-03 00:49:19 UTC - Size: 93.57 KB - 80 views |
| [2023-03-03 06:45:36] |
| User431178 - Posts: 544 |
|
Your alerts need to be moved down the list, below the studies they are referring to. Spreadsheet formula and color bar based on alert condition both have the same calculation precedence, so if spreadsheet is below CBBOAC in the list of studies the result of the spreadsheet formula is calculated after the CBBOAC condition is evaluated. Date Time Of Last Edit: 2023-03-03 06:46:13
|
| [2023-03-03 11:59:27] |
| TopGunTrader - Posts: 172 |
|
Hi, Sorry I should have figured this out myself! VERY EXCITED now can use your powerful tools in unique ways and find high probability alerts to possible reversals or continuations. |
To post a message in this thread, you need to log in with your Sierra Chart account: