| WORD | NAME | DESCRIPTION | |
| Abs() | Absolute value | Evaluates to the absolute value of expr | |
| Account() | Account Holdings | Return TRUE if stock being analyzed is an open position. For the id parameters use either the name in quotes, or the numerical id. | Full Description |
| AccountClose() | Account Holdings | Returns the number of calendar days since the position was last closed for the stock being analyzed, -1 if currently held, or NA if not held within the past 6 months. | Full Description |
| AccountCloseBar() | Account Holdings | Returns the number of bars since the position was last closed for the stock being analyzed, -1 if currently held, or NA if not held within the past 6 months. | Full Description |
| AccountOpen() | Account Holdings | Returns the number of calendar days since the position was first opened for the stock being analyzed, otherwise NA. | Full Description |
| AccountOpenBar() | Account Holdings | Returns the number of bars since the position was first opened for the stock being analyzed, otherwise NA. | Full Description |
| AccruedExp() AccruedExpQ AccruedExpPQ AccruedExpPYQ AccruedExpTTM AccruedExpPTM AccruedExpA AccruedExpPY AccruedExpGr%PQ AccruedExpGr%PYQ AccruedExpGr%TTM AccruedExpGr%PQTTM AccruedExpGr%A AccruedExpGr%3Y AccruedExpGr%5Y AccruedExpGr%10Y AccruedExpRSD%ANN AccruedExpRSD%TTM AccruedExpRegEstANN AccruedExpRegEstTTM AccruedExpRegGr%ANN AccruedExpRegGr%TTM AccruedExpPSQ AccruedExpPSA AccruedExp%SalesQ AccruedExp%SalesA AccruedExp%AssetsQ AccruedExp%AssetsA AccruedExp3YAvg AccruedExp5YAvg | Change to Accrued Liabilities (Accrued Expenses) | Change in accrued liabilities on a company's balance sheet. | Full Description |
| AccumDep() AccumDepQ AccumDepPQ AccumDepPYQ AccumDepTTM AccumDepPTM AccumDepA AccumDepPY AccumDepGr%PQ AccumDepGr%PYQ AccumDepGr%TTM AccumDepGr%PQTTM AccumDepGr%A AccumDepGr%3Y AccumDepGr%5Y AccumDepGr%10Y AccumDepRSD%ANN AccumDepRSD%TTM AccumDepRegEstANN AccumDepRegEstTTM AccumDepRegGr%ANN AccumDepRegGr%TTM AccumDepPSQ AccumDepPSA AccumDep%AssetsQ AccumDep%AssetsA AccumDep3YAvg AccumDep5YAvg | Accumulated Depreciation | Total depreciation recognized on gross property, plant and equipment (GrossPlant). | Full Description |
| Acquis() AcquisQ AcquisPQ AcquisPYQ AcquisTTM AcquisPTM AcquisA AcquisPY AcquisGr%PQ AcquisGr%PYQ AcquisGr%TTM AcquisGr%PQTTM AcquisGr%A AcquisGr%3Y AcquisGr%5Y AcquisGr%10Y AcquisRSD%ANN AcquisRSD%TTM AcquisRegEstANN AcquisRegEstTTM AcquisRegGr%ANN AcquisRegGr%TTM AcquisPSQ AcquisPSA Acquis%SalesQ Acquis%SalesA Acquis%AssetsQ Acquis%AssetsA Acquis3YAvg Acquis5YAvg | Acquisitions | Cash outflows for purchasing companies or equity stakes. | Full Description |
| Actual() | Actual Functions | Retrieve the actual item for a specific period indicated by the offset and period type | Full Description |
| ActualA() | Actual Functions | Retrieve the actual annual item for a specific year indicated by the offset with zero being the most recent | Full Description |
| ActualGr%A() | Actual Functions | Calculates the most recent year growth for a particular actual item | Full Description |
| ActualGr%PQ() | Actual Functions | Calculates the most recent quarter growth for a particular actual item | Full Description |
| ActualGr%PYQ() | Actual Functions | Calculates the most recent quarter vs. prior year quarter growth for a particular actual item | Full Description |
| ActualGr%TTM() | Actual Functions | Calculates the most recent twelve months (TTM) growth for a particular actual item | Full Description |
| ActualInterimDays() | Actual Interim Days | Days in the filing period for the given interim offset. Usually 91 or 92 for quarterly, 182 or 183 for semiannual. | Full Description |
| ActualPQ() | Actual Functions | Retrieve the actual item for the previous quarter | Full Description |
| ActualPTM() | Actual Functions | Retrieve the actual item for the previous twelve months (PTM) | Full Description |
| ActualPY() | Actual Functions | Retrieve the actual item for the previous year | Full Description |
| ActualPYQ() | Actual Functions | Retrieve the actual item for the previous year quarter | Full Description |
| ActualQ() | Actual Functions | Retrieve the actual item for the most recent quarter | Full Description |
| ActualTTM() | Actual Functions | Retrieve the actual item for the most recent twelve months (TTM) | Full Description |
| ADX() | Average Directional Movement | Returns the Average Directional movement Index as defined by Welles Wilder. An offset can be specified to find trends in the ADX. For example to screen for stocks whose ADX increased in the past 10 bars enter: ADX(14,0) > ADX(14,10) | Full Description |
| Aggregate() | Group Average | Returns the average or cap-weighted average for each scope | Full Description |
| AIFactor() | Predictions | Returns the inferences (predictions) of your trained Predictor. Mainly for use to rebalance but it can also be used in backtests with some restrictions. | Full Description |
| AIFactorValidation() | Validation Predictions | Returns the saved inference (prediction) of your model's validation | Full Description |
| AltmanX1 | Altman X Component | Working Capital to Assets | Full Description |
| AltmanX2 | Altman X Component | Retained Earnings to Total Assets | Full Description |
| AltmanX3 | Altman X Component | Earnings before Interest and Taxes/Total Assets | Full Description |
| AltmanX4 | Altman X Component | Market Value of Equity / Book Value of Total Liabilities | Full Description |
| AltmanX4Rev | Altman X Component | Book Value of Equity / Book Value of Total Liabilities | Full Description |
| AltmanX5 | Altman X Component | Sales / Total Assets | Full Description |
| AltmanZNonManu | Altman Z-Score | Z-score for non-manufacturers & emerging markets, recommended cutoff is 1.1 or higher | Full Description |
| AltmanZOrig | Altman Z-Score | Original z-score, recommended cutoff is 1.81 or higher | Full Description |
| AltmanZPriv | Altman Z-Score | Z-score estimated for private firms, recommended cutoff is 1.23 or higher | Full Description |
| Amort() AmortQ AmortPQ AmortPYQ AmortTTM AmortPTM AmortA AmortPY AmortGr%PQ AmortGr%PYQ AmortGr%TTM AmortGr%PQTTM AmortGr%A AmortGr%3Y AmortGr%5Y AmortGr%10Y AmortRSD%ANN AmortRSD%TTM AmortRegEstANN AmortRegEstTTM AmortRegGr%ANN AmortRegGr%TTM AmortPSQ AmortPSA Amort%SalesQ Amort%SalesA Amort%AssetsQ Amort%AssetsA Amort3YAvg Amort5YAvg | Amortization of Intangibles | Write down value of non-physical assets like copyrights, patents, and brands. | Full Description |
| AnnounceDaysPYQ | Latest in Database | Returns the number of days it took the company to announce the Prev Year Q filing (announce date - period end) | |
| AnnounceDaysQ | Latest in Database | Returns the number of days it took the company to announce the latest filing (announce date - period end) | |
| AsOfDate | As-Of Date | Returns the current trading day as a number in the following format YYYYMMDD | |
| AstCur() AstCurQ AstCurPQ AstCurPYQ AstCurTTM AstCurPTM AstCurA AstCurPY AstCurGr%PQ AstCurGr%PYQ AstCurGr%TTM AstCurGr%PQTTM AstCurGr%A AstCurGr%3Y AstCurGr%5Y AstCurGr%10Y AstCurRSD%ANN AstCurRSD%TTM AstCurRegEstANN AstCurRegEstTTM AstCurRegGr%ANN AstCurRegGr%TTM AstCurPSQ AstCurPSA AstCur%AssetsQ AstCur%AssetsA AstCur3YAvg AstCur5YAvg | Current Assets Total | Sum of all assets expected to convert to cash within 12 months. | Full Description |
| AstCurOther() AstCurOtherQ AstCurOtherPQ AstCurOtherPYQ AstCurOtherTTM AstCurOtherPTM AstCurOtherA AstCurOtherPY AstCurOtherGr%PQ AstCurOtherGr%PYQ AstCurOtherGr%TTM AstCurOtherGr%PQTTM AstCurOtherGr%A AstCurOtherGr%3Y AstCurOtherGr%5Y AstCurOtherGr%10Y AstCurOtherRSD%ANN AstCurOtherRSD%TTM AstCurOtherRegEstANN AstCurOtherRegEstTTM AstCurOtherRegGr%ANN AstCurOtherRegGr%TTM AstCurOtherPSQ AstCurOtherPSA AstCurOther%AssetsQ AstCurOther%AssetsA AstCurOther3YAvg AstCurOther5YAvg | Current Assets Other | Sum of all current assets that are not included in cash, cash equivalents, short-term investments, receivables or inventory. | Full Description |
| AstIntan() AstIntanQ AstIntanPQ AstIntanPYQ AstIntanTTM AstIntanPTM AstIntanA AstIntanPY AstIntanGr%PQ AstIntanGr%PYQ AstIntanGr%TTM AstIntanGr%PQTTM AstIntanGr%A AstIntanGr%3Y AstIntanGr%5Y AstIntanGr%10Y AstIntanRSD%ANN AstIntanRSD%TTM AstIntanRegEstANN AstIntanRegEstTTM AstIntanRegGr%ANN AstIntanRegGr%TTM AstIntanPSQ AstIntanPSA AstIntan%AssetsQ AstIntan%AssetsA AstIntan3YAvg AstIntan5YAvg | Intangible Assets | Sum of assets that are not included in the tangible assets of property, plant and equipment. | Full Description |
| AstNonCurOther() AstNonCurOtherQ AstNonCurOtherPQ AstNonCurOtherPYQ AstNonCurOtherTTM AstNonCurOtherPTM AstNonCurOtherA AstNonCurOtherPY AstNonCurOtherGr%PQ AstNonCurOtherGr%PYQ AstNonCurOtherGr%TTM AstNonCurOtherGr%PQTTM AstNonCurOtherGr%A AstNonCurOtherGr%3Y AstNonCurOtherGr%5Y AstNonCurOtherGr%10Y AstNonCurOtherRSD%ANN AstNonCurOtherRSD%TTM AstNonCurOtherRegEstANN AstNonCurOtherRegEstTTM AstNonCurOtherRegGr%ANN AstNonCurOtherRegGr%TTM AstNonCurOtherPSQ AstNonCurOtherPSA AstNonCurOther%AssetsQ AstNonCurOther%AssetsA AstNonCurOther3YAvg AstNonCurOther5YAvg | Non-Current Assets Other | Value of assets that do not fit into either current assets or property plant and equipment. | Full Description |
| AstTot() AstTotQ AstTotPQ AstTotPYQ AstTotTTM AstTotPTM AstTotA AstTotPY AstTotGr%PQ AstTotGr%PYQ AstTotGr%TTM AstTotGr%PQTTM AstTotGr%A AstTotGr%3Y AstTotGr%5Y AstTotGr%10Y AstTotRSD%ANN AstTotRSD%TTM AstTotRegEstANN AstTotRegEstTTM AstTotRegGr%ANN AstTotRegGr%TTM AstTotPSQ AstTotPSA AstTot%AssetsQ AstTot%AssetsA AstTot3YAvg AstTot5YAvg | Total Assets | Total value of assets as reported on the balance sheet. | Full Description |
| AstTurn() AstTurnQ AstTurnPQ AstTurnPYQ AstTurnTTM AstTurnPTM AstTurnA AstTurnPY AstTurnGr%PQ AstTurnGr%PYQ AstTurnGr%TTM AstTurnGr%PQTTM AstTurnGr%A AstTurnGr%3Y AstTurnGr%5Y AstTurnGr%10Y AstTurnRSD%ANN AstTurnRSD%TTM AstTurnRegEstANN AstTurnRegEstTTM AstTurnRegGr%ANN AstTurnRegGr%TTM AstTurnPSQ AstTurnPSA AstTurn%SalesQ AstTurn%SalesA AstTurn%AssetsQ AstTurn%AssetsA AstTurn3YAvg AstTurn5YAvg | Asset Turnover | Revenue divided by the average total assets for the same period. | Full Description |
| AstTurnTTMInd | Asset Turnover, Industry | Asset Turnover Industry, TTM | Full Description |
| ATR() | Average True Range | Returns the Average True Range as defined by Welles Wilder over the specified period. | Full Description |
| ATRN() | Average True Range Normalized | Returns ATR as a percentage of the closing price. ATRN provides a better way to compare stocks with different price magnitude. | Full Description |
| Avg() | Average of a set of values | Returns the average value in list. Up to 20 parameters are allowed and NAs are discarded | |
| AvgDailyTot() | Liquidity | Average daily total amount traded (price * volume) for the past number of bars. You can use the offset to calculate rising avg. For ex: AvgDailyTot(10) > AvgDailyTot(10,10) | |
| AvgRec | Average Recommendation | Average Recommendation on a 1-3 linear scale, where 1 is a strong buy, 3 a sell. For CapitalIQ the range is 1-5. | Full Description |
| AvgRec13WkAgo | Average Recommendation | Average Recommendation 13 Weeks ago on a 1-3 linear scale, where 1 is a strong buy, 3 a sell. For CapitalIQ the range is 1-5. | Full Description |
| AvgRec1WkAgo | Average Recommendation | Average Recommendation 1 Weeks ago on a 1-3 linear scale, where 1 is a strong buy, 3 a sell. For CapitalIQ the range is 1-5. | Full Description |
| AvgRec4WkAgo | Average Recommendation | Average Recommendation 4 Weeks ago on a 1-3 linear scale, where 1 is a strong buy, 3 a sell. For CapitalIQ the range is 1-5. | Full Description |
| AvgRec8WkAgo | Average Recommendation | Average Recommendation 8 Weeks ago on a 1-3 linear scale, where 1 is a strong buy, 3 a sell. For CapitalIQ the range is 1-5. | Full Description |
| AvgVol() | Average Volume | Daily average volume of the past number of bars. | Full Description |
| AvgVol10 | Average Volume | Daily average volume past 10 bars. Equivalent to AvgVol(10) | |
| AvgVol1M | Average Volume | Daily average volume past 21 bars. Equivalent to AvgVol(#Month) | |
| AvgVol3M | Average Volume | Daily average volume past 62 bars. Equivalent to AvgVol(#Month3) | |
| AvgVol5 | Average Volume | Daily average volume past 5 bars. Equivalent to AvgVol(5) | |
| AvgVol6M | Average Volume | Average volume past 125 bars. Equivalent to AvgVol(#Month6) |