Support Board
Date/Time: Wed, 12 Mar 2025 06:27:30 +0000
Log the Second lowest value in a SCSS cell
View Count: 497
| [2022-05-07 22:56:55] |
| User773081 - Posts: 26 |
|
I understand =Min(Reference) gets the minimum value. But is it possible to get both the minimum value, and the Second most minimum value in the spreadsheet.scss? Regarding logging price to find the low, and the previous low in a defined range. Thank you
|
| [2022-05-09 14:52:46] |
| John - SC Support - Posts: 38598 |
|
Refer to the information for the function SMALL() here: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#SMALL_Function For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-05-09 23:40:10] |
| User773081 - Posts: 26 |
|
Thank you that solved a whole host of problems for me. Is it then possible to make that an absolute variable? In that when a new low is made the 2nd low will inherently change. but can I 1.tell it to keep the 2nd low the same even after its changed 2. Tell it to keep the 2nd low the same until the buy condition is executed? |
| [2022-05-10 15:19:59] |
| John - SC Support - Posts: 38598 |
|
By default, whenever there is a change to the data, the SMALL() function is going to update and return the nth smallest value. As such, the items you are asking for are not possible unless you capture the information separately somehow. 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: