| WORD | NAME | DESCRIPTION | |
| Abs() | Absolute value | Evaluates to the absolute value of expr | Full Description |
| 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() | Directional Movement | Returns the Average Directional movement Index as defined by Welles Wilder. An offset can be specified to find trends in the ADX. | 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) |