Support Board

Date/Time: Sun, 19 May 2024 09:17:02 +0000

Post From: Using Spreadsheet Studies with Alerts

[2021-10-21 22:52:10] Link To Thread - Link To Post [Go To First Post]
John - SC Support - Posts: 31704
1. Can I get rid of my Spreadsheet Study and use only Spreadsheet System/Alert study for both tasks? Yes, you can do this. It is really a personal preference, but it would allow you to have a single spreadsheet using multiple sheets for the different charts. 2. Which value in fact indicates a true condition? 1 or any nonzero value? Zero is false. Any other value is true (i.e. any nonzero value is true). 3. If I will use columns other than K-N in the Spreadsheet System/Alert study to plot pivots lines on the chart, the return values of the formulas will be nonzero for some rows, including the last bar in the chart. These values will be considered as true conditions too, which will create alerts? Just do not set any alerts sounds on the Inputs for the Spreadsheet System/Alerts for those columns for which you do not want to be alerted, and vice versa. Refer to the following Inputs: https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#ColumnKLMNAlert For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing