Support Board
Date/Time: Sun, 02 Feb 2025 18:05:12 +0000
Post From: Zig Zag Alerts
| [2019-09-13 22:48:22] |
| Chris_uk - Posts: 89 |
|
Hi, I am using the Spreadsheet System/Alert Study to create alerts based off the Zig Zag Study. I am not sure if what I am experiencing is normal behaviour, or if It's an error on my part. Zig Zag Study = ID8 Column R = Reversal Price =IF(ID8.SG3@3>0,ID8.SG3@3,R4) Column S = Reversal Price -1 =IF(ID8.SG3@3>0,R4,S4) Column T = Reversal Price -2 =IF(ID8.SG3@3>0,S4,T4) Column U = Text Labels =IF(ID8.SG2@3>0,ID8.SG2@3,U4) Column V = Text Labels -1 =IF(ID8.SG2@3>0,U4,V4) Column W = Text Labels -2 =IF(ID8.SG2@3>0,V4,W4) Column K(row 3)Buy Entry =AND(W3=2, E3 > T3) So I would like an alert when: Text label[-2] = 2(HH) Current Bars close > Reversal Price[-2] This does work some of the time, at other times alerts are displayed and then later disappear, their values in the spreadsheet change from TRUE TO FALSE. I have read this, but it only explains some of what I am seeing in this case. Spreadsheet Systems, Alerts and Automated Trading: Disappearing Arrows or Signals After watching the spreadsheet during many replays I have identified what I believe to be the cause. Values in prior cells are changing at a later time (This is happening when a new swing has not started) Example: 1 Minute Chart 18:44:00 = New Swing Starts 18:44:00 = W3 =2 (TEXT LABEL[-2]) 18:44:00 = T3 = 3019.25 (Reversal price[-2]) Close Above T3 Alert Triggered 18:45:00 = W3 =2 18:45:00 = T3 = 3019.25 Close Above T3 Alert Triggered 18:46:00 = Both prior cells change values (Now cell 4 and 5) with a new text label and reversal price and the Alerts disappear. A new swing has not started.(Even if it did, surely these previous values should not change?) Any help in explaining what is happening would be very much appreciated. I have tried many formulas and this always seems to be the case. I have attached 4 screenshots, spreadsheet before and after values change and charts reflecting the same. Many Thanks Date Time Of Last Edit: 2019-09-13 22:58:09
|
 Spreadsheet before values change.png / V - Attached On 2019-09-13 22:47:16 UTC - Size: 26.75 KB - 359 views Spreadsheet After Values Change.png / V - Attached On 2019-09-13 22:47:32 UTC - Size: 31.17 KB - 345 views Chart Alerts Displayed.png / V - Attached On 2019-09-13 22:47:50 UTC - Size: 14.76 KB - 365 views |