Support Board
Date/Time: Sat, 30 Nov 2024 04:48:11 +0000
Post From: SMALL() function example usage
| [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 |