Support Board
Date/Time: Sun, 22 Dec 2024 21:59:24 +0000
Correct spreadsheet formula for multiple AND's
View Count: 1551
| [2015-05-08 00:26:54] |
| User911705 - Posts: 89 |
|
Hello, I'm new to SC and very excited to use the spreadsheet autotrading funtionality. My system has roughly 10 conditions which I need to string together with AND's. It's not clear how to do this. It looks like the AND() function only supports two arguments. Could you please provide an example of a formula containing several AND's? The conditions could just be pseudo conditions, eg. a>b. Thank you. EDIT: upon further research, it appears more than 2 arguments can be employed inside logical operators (AND, OR). Can you please tell me if using around 10 arguments would be okay? I plan on trading between 10 and 20 instruments using the spreadsheet automation. Date Time Of Last Edit: 2015-05-08 00:37:46
|
| [2015-05-08 01:41:06] |
| |
|
You can include more than two arguments/conditions in an AND or OR function. Example: =AND( Condition1, condition2, condition3) 10 or even more should be just fine. 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: