Support Board
Date/Time: Wed, 27 Nov 2024 13:08:00 +0000
Post From: How to syntax PERCENTILE using built in spreadsheet formula indicator
| [2022-12-07 21:32:02] |
| John - SC Support - Posts: 36309 |
|
And for educational purposes, can you explain this part @3:ID16.SG1@102?
Within the Spreadsheet Study you have a few ways to reference the data for a subgraph from a study on the chart. Keep in mind that the Spreadsheet Study will include other studies' data starting in the first column after the Calculation columns (Column AA by default). As such, you can reference the data by standard spreadsheet reference such as AA3:AA102, but the issue is that if you add a study, or change the order, then the data in column AA may not be for the same study any more. The syntax of IDx.SGy@3 gives a direct reference to the study (by ID) and then the subgraph (by SG) and @3 is the row number. In the Spreadsheet Study the rows for data start at row #3. That is why the reference to starting at row 3 and going to 102 for 100 pieces of data. Refer to the following section for more on the above: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study =PERCENTILE(ID16.SG1@3:ID16.SG1@102,0.9) with auto scaling and value format same as for ID16
Returns no value. ID16 returns any thing between 0.5 to -0.5 pls advise Is this being entered on a Spreadsheet Study? If so, what are you seeing in the cells where you entered this formula? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |