Support Board
Date/Time: Thu, 26 Dec 2024 20:14:31 +0000
AND FUNCTION NESTING
View Count: 976
| [2015-12-08 03:57:08] |
| AP - Posts: 117 |
|
If using the AND() function for chart alerts - I see that nesting and AND() withing another AND() is not working. For instance - I was using - =AND(ID2.SG1>0,AND(id5.sg1<id5.sg4,C<ID17.SG1)) and clearly it gives effect to the first 2 expressions but not to the last one when firing alerts - e.g. C<ID17.SG1 condition is not fulfilled while firing that alert - qs - 1. is nesting allowed in such cases? 2. is there a work around? 3. am I using the above condition rightly in the first place? |
| [2015-12-08 07:03:34] |
| |
|
1, 2. This is allowed but unnecessary in this way. You should use a single AND function and separate all of the expressions with commas. If you refer to the Spreadsheet Functions page it explains this: http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html 3. We do not know. This is something you need to determine. From our perspective as long as you do not get an error from the formula, then it is correct. However, whether it does what you need, we do not know. 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 |
| [2015-12-18 21:13:21] |
| AP - Posts: 117 |
|
So, on this one - looks like AND function does not accommodate more than 2 arguments within it and neither does it give effect to Nested AND functions use (ones like - AND(.....AND()) 1. Can you confirm is above is true? You said earlier on - it is allowed but does not work realy. 2. If not possible, do you have any work around to propose? |
| [2015-12-18 21:30:21] |
| |
|
looks like AND function does not accommodate more than 2 arguments How do you come to this conclusion? Did you refer to the documentation for it here: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html 1. No, that is not true. 2. This is not relevant because the function does what you require. You can verify this by using this formula: =AND(true,true,true,true) 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: