Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 06:17:25 +0000
Post From: How to syntax PERCENTILE using built in spreadsheet formula indicator
| [2022-12-12 14:29:17] |
| Sawtooth - Posts: 3993 |
|
This seems to work for me in the Spreadsheet Formula study: =PERCENTILE(ID16.SG1[0:-100],0.9) using this Alert syntax for ranges: Study/Chart Alerts And Scanning: Referencing A Range of Data It produces values that are very close (but not exactly the same) when using this spreadsheet syntax in the Spreadsheet Study study: =PERCENTILE(ID16.SG1@3:ID16.SG1@102,0.9) |