Support Board
Date/Time: Sun, 24 Nov 2024 18:48:50 +0000
Using SMALL() for a set of bars
View Count: 189
| [2024-05-06 21:08:25] |
| funbun - Posts: 90 |
|
I'm trying to spot the lowest volume for the 100 most recent bars on the chart, and flag it - AND( V <= SMALL( V[-1:-100]) ) Reading the docs I couldn't find where's the issue... Date Time Of Last Edit: 2024-05-06 21:31:28
|
| [2024-05-06 23:14:10] |
| John - SC Support - Posts: 36238 |
|
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: