Support Board
Date/Time: Sat, 05 Apr 2025 01:39:18 +0000
Post From: standardize spreadsheet
| [2024-03-05 21:47:24] |
| John - SC Support - Posts: 39172 |
|
Z-Score is calculated as follows: z = (x - mu) / sigma Where mu is the Mean of the population and sigma is the standard deviation of the population. Therefore, the STANDARDIZE() function is not giving you the z-score. Rather, you should use the following formula instead: = (L3 - $M$3) / $N$3 For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |