Login Page - Create Account

Support Board


Date/Time: Fri, 10 May 2024 07:45:48 +0000



Post From: Time formulas

[2017-05-10 05:19:10]
Sierra Chart Engineering - Posts: 104368
The easiest way to highlight a bar is to use the Time Line study:
https://www.sierrachart.com/index.php?page=doc/StudiesReference.php&ID=181#Time_Line


This is the formula you will want to use:
ABS(BARTIME - TIME( 9, 0, 0)) < TIME(0, 0, 1)

We do not get a syntax error from this:
=AND(BARTIME >= ((09*60)/(24*60)), BARTIME <= ((14*60)/(24*60)))


However, this is not valid to be used on a Spreadsheet if that is where you are trying to enter it. BARTIME is not recognized on a spreadsheet. It can only be used as a Simple Alert Formula:
Study/Chart Alerts And Scanning

Here is the documentation for Spreadsheet functions:
Spreadsheet Functions
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2017-05-10 05:22:49