WORD | NAME | DESCRIPTION | |
UBound() | Constrains to a max and/or a min | Constrains a value to a maximum. When returnNA is set to TRUE the function returns NA if expression exceeds the maximum. | |
ULTOSC() | Ultimate Oscillator | Ultimate Oscillator. Returns the weighted sum of three oscillators of different time periods as defined by Larry Williams. An offset can be specified to find trends in the ULTOSC to find divergences with the price. | |
UnivAvg() | Universe Average | Calculate the simple average of the values of "formula" for the stocks that pass "criteria" | |
UnivCapAvg() | Universe Cap Average | Calculate the cap-weighted average of the values of "formula" for the stocks that pass "criteria" | |
UnivCnt() | Universe Count | Count stocks that pass "criteria" | |
Universe() | Universe filter | Returns 1 if the stock is in the universe, 0 otherwise. Ex: to only buy S&P 500 stocks enter the following Buy rule: Universe(SP500) To see all universes click on function name | Full Description |
UnivExclude() | Exclude by ticker | Exclude stocks in universe with specific tickers | |
UnivMax() | Universe Maximum | Calculate the maximum value of "formula" for the stocks that pass "criteria" | |
UnivMedian() | Universe Median | Calculate the median of the values of "formula" for the stocks that pass "criteria" | |
UnivMin() | Universe Minimum | Calculate the minimum value of "formula" for the stocks that pass "criteria" | |
UnivRBICS() | Filter by RBICS | Only use stocks in universe with specific RBICS | Full Description |
UnivStdDev() | Universe Standard Deviation | Calculate the standard deviation of the values of "formula" for the stocks that pass "criteria" | |
UnivSubset() | Filter by ticker | Only use stocks in universe with specific tickers | |
UnivSum() | Universe Sum | Calculate the sum of the values of "formula" for the stocks that pass "criteria" | |
UpDownRatio() | Up/Down Volume Ratio | Calculates the Up/Down Volume ratio for a stock. If the ratio exceeds 0.5, it means volume on a stock's up days outweighed downside volume in the specified period. It is calculated as: Sum Up Vol/(Sum Up Vol + Sum Down Vol) | Full Description |