Support Board

Date/Time: Sat, 04 May 2024 15:04:19 +0000

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

[2022-12-08 14:51:57] Link To Thread - Link To Post [Go To First Post]
John - SC Support - Posts: 31362
We just tested the Spreadsheet Formula for the Percentile function and although it is not giving a syntax error, it is giving a different result from what the Spreadsheet Study gives. Therefore, we can only say that you should only use the function with the Spreadsheet Study, which is where it was developed for use. When using it in the Spreadsheet Study, you will use the syntax that we gave you previously. Keep in mind, even though the Study is called "Spreadsheet Formula" it actually uses the syntax for the Alerts and not for the Spreadsheets. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing