Support Board
Date/Time: Sun, 06 Jul 2025 17:19:42 +0000
Post From: Using SMALL() for a set of bars
| [2024-05-06 23:14:10] |
| John - SC Support - Posts: 40745 |
|
To start with, you do not want to use SMALL, or you are not using it correctly, as it needs two arguments. But, SMALL() will also not work with an Alert condition - it is strictly a Spreadsheet function. If you just want the lowest value, then use MIN(). But, the other issue is that you can not specify a range in an alert formula. So you would need to use a Spreadsheet Study to get what you want. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#SMALL_Function https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MIN_Function Using the Spreadsheet Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |