Login Page - Create Account

Support Board


Date/Time: Sun, 19 May 2024 12:15:36 +0000



Post From: Using Spreadsheet Studies with Alerts

[2021-10-26 23:36:34]
John - SC Support - Posts: 31704
But that would also mean that each cell in the column containing condition formula will return the same TRUE or FALSE values

This depends on your formula and whether there is a dependency on values that are located at each bar. If you are not using Absolute References, then each row will return True or False based on the calculation using the data at the time of that bar.

Do I get it right, that now there is no way to check all existing closed bars on the chart at any moment for condition until the last bar closes and receive an alert for the last closed bar, if condition formula returns TRUE for it?

No, this is not true. As noted above, it depends on how your formula is setup.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing