Support Board
Date/Time: Mon, 25 Nov 2024 13:47:42 +0000
Post From: standardize spreadsheet
| [2024-03-05 21:47:24] |
| John - SC Support - Posts: 36238 |
|
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 |