FORMULA FUNCTIONS / CROSS SECTIONAL
ZScore("formula" [, scope, outlier_trim , na_value, max_zscore])
Full Description
Calculates how many standard deviations the value from the formula is from the mean for each group specified by the 'scope' parameter. The output is bounded by default to values from -3.5 to +3.5, with N/A values being assigned to 0.
Parameters
scope: determines how stocks are grouped (see below)
outlier_trim: outlier trim percent from each side. Defaults to 7.5%
na_value: value assigned to NA's. Defaults to 0.
max_zscore: maximum value returned (+/- max). Defaults to +/- 3.5
Scope Parameter
| Values | Stocks | ETFs | Description |
| #All | Y | Y | Operates on current universe |
| #Previous1 | Y | Y | Operates on the results from previous rules |
| #GroupVar1 | Y | Y | Operates on groups based on value of variable @Group |
| --------------------------- For Stocks Only --------------------------- | |||
| #Sector | Y | Operates within each Sector of current universe | |
| #SubSector | Y | Operates within each SubSector of current universe | |
| #Industry | Y | Operates within each Industry of current universe | |
| #SubIndustry | Y | Operates within each SubIndustry of current universe | |
| --------------------------- For ETFs Only ------------------------------ | |||
| #Family | Y | Operates within each ETF Family | |
| #AssetClass | Y | Operates within each ETF Class | |
| #Region | Y | Operates within each ETF Region | |
| #Country | Y | Operates within each ETF Country | |
| #Method | Y | Operates within each ETF Method | |
| #Style | Y | Operates within each ETF Style | |
| #Size | Y | Operates within each ETF Size | |
| #ETFSector | Y | Operates within each ETF Sector | |