Support Board

Date/Time: Sat, 18 May 2024 10:42:11 +0000

Post From: Alert/Spreadsheet behavior does not match

[2019-11-11 15:47:34] Link To Thread - Link To Post [Go To First Post]
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 - 214 views