Support Board
Date/Time: Sat, 30 Nov 2024 02:41:29 +0000
SMALL() function example usage
View Count: 417
| [2022-12-22 22:47:09] |
| User562383 - Posts: 10 |
|
I am trying to use the spreadsheet formula study to find the second smallest value of four values using the small() spreadsheet formula function https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#SMALL_Function but I keep getting 0 as the output Examples I've tried SMALL(ID11.SG1,ID10.SG1,ID9.SG1,ID13.SG1,2) SMALL([ID11.SG1,ID10.SG1,ID9.SG1,ID13.SG1],2) SMALL((ID11.SG1,ID10.SG1,ID9.SG1,ID13.SG1),2) How do I input an array as the first argument? |
| [2022-12-23 15:00:48] |
| John - SC Support - Posts: 36350 |
|
To use a range for a study in the Spreadsheet it is best to use the following format: ID1.SG1@3:ID1.SG1@200 The above is the range from row 3 in the Spreadsheet Study to Row 200 in the Spreadsheet Study for the study with ID of 1 and Subgraph 1. Keep in mind that the data from the studies are contained in the Spreadsheet starting at the first non-calculation column (typically AA). But rather than reference the studies by the Spreadsheet column, it best to use the above format, this way if the studies move around in the spreadsheet you do not need to rework your calculations. Refer to the following regarding this format: Working with Spreadsheets: References to Study Subgraph Columns when 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 |
| [2022-12-23 21:53:58] |
| User562383 - Posts: 10 |
|
I appreciate the response, but that does not answer my question. How do I input an array of 4 cells into the first argument of the small command without using the ":" syntax. The cells I want to select are not next to each other. This works "=small(B3:B6,2)" But how would I rewrite it inputting each cell separately eg "=small([B3,B4,B5,B6],2)" |
| [2022-12-23 22:02:15] |
| John - SC Support - Posts: 36350 |
|
You can not enter disparate data for the SMALL() function. You would need to get the data aligned together such that you can reference it in a single range.
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: