Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 16:45:30 +0000
[Programming Help] - Alert/Spreadsheet behavior does not match
View Count: 473
| [2019-11-11 15:47:34] |
| User312841 - Posts: 25 |
|
Cannot get Spreadsheet Autotrade to match Alert in ColorBar behavior. The color bar alert rings True and paints just fine, cannot get the spreadsheet to ring True with the same code. I believe the alert and SS code are exactly the same but the SS does not work. Please help! Thanks //Using Candle Price Volume Bars //ColorBar Alert code =AND(O>=(ID8.SG1+.01),H>=(ID8.SG1+.01),L<=(ID8.SG1+.01),H=C) //Spreadsheet code =AND(B3>=P3,C3>=P3,D3<=P3,C3=E3) Column P P3 => =ROUND(AR3+.01,2) AR3=57.689998626708984 (AR3 = ID8.SG1@3 which is a line) (Formating the study for AR with 0.01 did not truncate) //Spreadsheet study I have tried : Value format = 0.01 Signal on bar close = Y Reset condition on new bar = Y Strict signal on bar close eval = Y //Tried Column P Set Spreadsheet -> Number Format -> 0.01 //Replay log Alert - Chart: Replay 30X: SPXL-STK-SMART 0.05 Range #2 | Study: Purple +0.01 | Formula: =AND(O>=(ID8.SG1+.01),H>=(ID8.SG1+.01),L<=(ID8.SG1+.01),H=C) is TRUE. | Last Price: 57.74 | Bar start date-time: 2019-11-08 09:36:15 | No alert sound/email. |
 Capture.JPG / V - Attached On 2019-11-11 15:46:14 UTC - Size: 59.82 KB - 211 views |
| [2019-11-11 17:43:25] |
| User312841 - Posts: 25 |
|
Got it to work by using: H21 -> =1 / ROUND(1 / J21, 0) P3 -> =MROUND(AR3, $H$21) |
To post a message in this thread, you need to log in with your Sierra Chart account: