Login Page - Create Account

Support Board


Date/Time: Sat, 30 Nov 2024 06:28:11 +0000



Reference prev bar study values in alert formula

View Count: 324

[2022-12-09 15:45:10]
rondawes - Posts: 39
Is it possible to reference the ending bar value of a previous bar of a study in an alert condition? i.e. =and(ID13:SG1[-1]<0,ID13:SG1>0) where ID13 references a Numbers Bars Calculated Values study in the same chart. This formula produces log error messages of #VALUE!. Or do I have the format wrong? I'm using it a Color Background Based on Alert Condition study. Thanks.
Date Time Of Last Edit: 2022-12-09 15:46:26
[2022-12-09 17:47:43]
John - SC Support - Posts: 36350
You have your format wrong. You have a colon (:) between the ID and the SG when it should be a period (.). In other words, your formula should be the following:
=and(ID13.SG1[-1]<0,ID13.SG1>0)
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account