Support Board
Date/Time: Mon, 20 Jan 2025 20:53:49 +0000
Alerts: If Then Else Construct?
View Count: 2363
| [2018-06-29 16:36:08] |
| gayer2428 - Posts: 89 |
|
Is it possible to have or simulate a IF-THEN-ELSE construct in the Alerts (without ACSIL)? Thank you. |
| [2018-06-29 17:12:55] |
| Xfanman1 - Posts: 320 |
|
Here's the list of available spreadsheet functions available for use with the Spreadsheet trading system. Spreadsheet Functions: Available Functions -- Scott |
| [2018-06-29 17:36:35] |
| gayer2428 - Posts: 89 |
|
Thank you. I am aware of the spreadsheet functions; my question is, is this possible with simple Alerts (without the use of spreadsheet)? Thanks. |
| [2018-06-29 18:08:18] |
| |
|
Yes, you just have to string multiple IF statements together. This is the same way you would do it in Excel. For example, if A > B then 1, else if B > C, then 2, else 0 would be written as: =IF(A > B, 1, IF(B > C, 2, 0)) 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 |
| [2018-06-29 19:47:02] |
| Xfanman1 - Posts: 320 |
|
es, you just have to string multiple IF statements together. This is the same way you would do it in Excel.
For example, if A > B then 1, else if B > C, then 2, else 0 would be written as: =IF(A > B, 1, IF(B > C, 2, 0)) All this time I've been under the mistaken impression I couldn't use IF statements in Simple Alerts. Good to know going forward. -- Scott Date Time Of Last Edit: 2018-06-29 19:47:13
|
To post a message in this thread, you need to log in with your Sierra Chart account: