Support Board

Date/Time: Wed, 27 Nov 2024 12:30:25 +0000

Post From: How to syntax PERCENTILE using built in spreadsheet formula indicator

[2022-12-12 14:29:17] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4120
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)