Support Board
Date/Time: Wed, 12 Mar 2025 03:50:10 +0000
Post From: Need Help With Spreadsheet Formula
| [2014-11-25 18:42:35] |
| |
|
In response to post #4, this is correct. You do need to use the row numbers and we had not noticed that was missing from the cell references. Also, this formula is not valid to be used as a Simple Alert: Alert Formula Error - Chart: SNSS [M] 5 Min #1 Error: #NAME? Formula: =AND(AB > 5, AD > 10, AG > 10) Only directly within a Spreadsheet cell. This also requires proper cell references which includes the Row number: =AND(ID1.SG1 > 5, ID2.SG1 > 10, ID7.SG1 > 10) Refer to the documentation for this here: http://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#ReferencesStudySubgraphColumnsSpreadsheetStudy 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: 2014-11-25 18:43:01
|