WORD | NAME | DESCRIPTION | |
LargeCount | Market Cap Concentration | Number of positions in the LargeCap group. See Full Description for details and examples. | Full Description |
LargeWeight | Market Cap Concentration | Weight of the LargeCap group as % of total market value. See Full Description for details and examples | Full Description |
LastSellDaysLT() | Recently sold | LastSellDaysLT(days): Returns TRUE or 1 if the stock was sold within the last no. of days, otherwise it returns FALSE or 0 (LT stands for Less Than). Ex: to avoid buying a stock that was sold within the last 30 days, enter the following Buy rule: LastSellDaysLT(30)=FALSE | |
LastSellPrice | Previous sell price for new position | Price the stock was last sold at, or NA. Example: To check that the current price is either above the last sell price, or that the stock was never bought, enter: Eval(LastSellPrice=NA,TRUE,Close(0) > LastSellPrice) | |
LatestActualDays | Actual Latest | Calendar days since analysts actuals for the most recent quarter were available from the data vendor. NOTE: analysts actuals can precede SEC filings | Full Description |
LatestActualPeriodDate | Actual Latest | Period date of latest analysts actuals, represented as a number YYYYMMDD. NOTE: analysts actuals can precede SEC filings | Full Description |
LatestFilingDate | Latest (Any Source) | The date the latest period was first filed by the company with the SEC. This date may be before any data appears for the as-of date of your analysis due to vendor delays in processing the filing. | |
LatestNewsDate | Latest (Any Source) | The earliest date of either the press release from the company or the date any data appears in the database | |
LatestPeriodDate | Latest (Any Source) | The latest period that has been announced by the company. This data may not have been processed yet by Compustat and/or may not have been filed with the SEC. | |
LBound() | Constrains to a max and/or a min | Constrains a value to a minimum. When returnNA is set to TRUE the function returns NA if expression exceeds the minimum. | |
LiabCur() LiabCurQ LiabCurPQ LiabCurPYQ LiabCurTTM LiabCurPTM LiabCurA LiabCurPY LiabCurGr%PQ LiabCurGr%PYQ LiabCurGr%TTM LiabCurGr%PQTTM LiabCurGr%A LiabCurGr%3Y LiabCurGr%5Y LiabCurGr%10Y LiabCurRSD%ANN LiabCurRSD%TTM LiabCurRegEstANN LiabCurRegEstTTM LiabCurRegGr%ANN LiabCurRegGr%TTM LiabCurPSQ LiabCurPSA LiabCur%AssetsQ LiabCur%AssetsA LiabCur3YAvg LiabCur5YAvg | Current Liabilities Total | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
LiabCurOther() LiabCurOtherQ LiabCurOtherPQ LiabCurOtherPYQ LiabCurOtherTTM LiabCurOtherPTM LiabCurOtherA LiabCurOtherPY LiabCurOtherGr%PQ LiabCurOtherGr%PYQ LiabCurOtherGr%TTM LiabCurOtherGr%PQTTM LiabCurOtherGr%A LiabCurOtherGr%3Y LiabCurOtherGr%5Y LiabCurOtherGr%10Y LiabCurOtherRSD%ANN LiabCurOtherRSD%TTM LiabCurOtherRegEstANN LiabCurOtherRegEstTTM LiabCurOtherRegGr%ANN LiabCurOtherRegGr%TTM LiabCurOtherPSQ LiabCurOtherPSA LiabCurOther%AssetsQ LiabCurOther%AssetsA LiabCurOther3YAvg LiabCurOther5YAvg | Current Liabilities Other | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
LiabNonCurOther() LiabNonCurOtherQ LiabNonCurOtherPQ LiabNonCurOtherPYQ LiabNonCurOtherTTM LiabNonCurOtherPTM LiabNonCurOtherA LiabNonCurOtherPY LiabNonCurOtherGr%PQ LiabNonCurOtherGr%PYQ LiabNonCurOtherGr%TTM LiabNonCurOtherGr%PQTTM LiabNonCurOtherGr%A LiabNonCurOtherGr%3Y LiabNonCurOtherGr%5Y LiabNonCurOtherGr%10Y LiabNonCurOtherRSD%ANN LiabNonCurOtherRSD%TTM LiabNonCurOtherRegEstANN LiabNonCurOtherRegEstTTM LiabNonCurOtherRegGr%ANN LiabNonCurOtherRegGr%TTM LiabNonCurOtherPSQ LiabNonCurOtherPSA LiabNonCurOther%AssetsQ LiabNonCurOther%AssetsA LiabNonCurOther3YAvg LiabNonCurOther5YAvg | Other Non-current Liabilities | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
LiabTot() LiabTotQ LiabTotPQ LiabTotPYQ LiabTotTTM LiabTotPTM LiabTotA LiabTotPY LiabTotGr%PQ LiabTotGr%PYQ LiabTotGr%TTM LiabTotGr%PQTTM LiabTotGr%A LiabTotGr%3Y LiabTotGr%5Y LiabTotGr%10Y LiabTotRSD%ANN LiabTotRSD%TTM LiabTotRegEstANN LiabTotRegEstTTM LiabTotRegGr%ANN LiabTotRegGr%TTM LiabTotPSQ LiabTotPSA LiabTot%AssetsQ LiabTot%AssetsA LiabTot3YAvg LiabTot5YAvg | Total Liabilities | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
LinReg() | Linear Regression using Loop | Executes the "formula" parameter a number of times and operates a regression on the set of values. A special CTR variable must be used inside "formula". | Full Description |
LinRegVals() | Linear Regressions of Values | Operates a regression on a set of Y values. | Full Description |
LinRegXY() | Linear XY Regression using Loop | Executes the "formula" parameter a number of times and operates a bivariate regression on the set of values. A special CTR variable must be used inside "formula". | Full Description |
LinRegXYVals() | Linear Regression of XY Values | Operates a regression on a set of XY values. | Full Description |
LN() | Natural Log | Returns the natural log of val | |
Log10() | Base 10 log | Returns the base-10 log of val | |
LoopAvg() | Loop Average | Executes the "formula" parameter a number of times and operates on the set of values. A special CTR variable must be used inside "formula". | Full Description |
LoopMax() | Loop Max | Executes the "formula" parameter a number of times and operates on the set of values. A special CTR variable must be used inside "formula". | Full Description |
LoopMedian() | Loop Median | Executes the "formula" parameter a number of times and operates on the set of values. A special CTR variable must be used inside "formula". | Full Description |
LoopMin() | Loop Min | Executes the "formula" parameter a number of times and operates on the set of values. A special CTR variable must be used inside "formula". | Full Description |
LoopProd() | Loop Product | Executes the "formula" parameter a number of times and operates on the set of values. A special CTR variable must be used inside "formula". | Full Description |
LoopRank() | Loop Rank | Returns the rank of most recent value of the Loop formula vs. previous values calculated by iterating the CTR variable. | Full Description |
LoopRel() | Loop Relative | Returns the relative value from 0 to 1 of most recent value of the Loop formula vs. previous minimum and maximum values calculated by iterating the CTR variable. | Full Description |
LoopRelStdDev() | Loop Rel Standard Deviation | Executes the "formula" parameter a number of times and operates on the set of values. A special CTR variable must be used inside "formula". | Full Description |
LoopStdDev() | Loop Standard Deviation | Executes the "formula" parameter a number of times and operates on the set of values. A special CTR variable must be used inside "formula". | Full Description |
LoopStreak() | Loop Streak | Executes the "formula" parameter a number of times and operates on the set of values. A special CTR variable must be used inside "formula". | Full Description |
LoopSum() | Loop Sum | Executes the "formula" parameter a number of times and operates on the set of values. A special CTR variable must be used inside "formula". | Full Description |
LoopZScore() | Loop ZScore | Returns the zscore of most recent value of the Loop formula vs. previous values calculated by iterating the CTR variable. | Full Description |
Low() | Price OHLCV | Historical Low price 'bars' or 'trading days' ago (the length of a bar can be determined by the series used). Use negative values to peek into the future. | Full Description |
Low_D() | Price OHLCV | Historical Low price 'days' ago including holidays. Holidays are filled in with previous day close. | Full Description |
Low_W() | Price OHLCV | Historical weekly Low price. Use 0 for the most recent week, 1 for the week before, etc. | Full Description |
Lower() | Count higher/lower values in a set | Returns the number of times xi < xi+1. For example to find companies that price dropped at least 2 out of 3 days in a row enter: Lower(Close(0),Close(1),Close(2),Close(3))>=2 | |
LowPct() | Percent From Hi/Lo | Percent from low in the period (incl div) | |
LowPct_W() | Percent From Hi/Lo | Percent from low in the period using the weekly series (incl div) | |
LowVal() | Price Highest/Lowest | This function returns the lowest value of the series within the specified lookback period. The close prices are used by default. | Full Description |
LowValBar() | Price Highest/Lowest | This function returns bar where lowest value of the series occurred within the specified lookback period. The close prices are used by default. | Full Description |
LTGrthMean LTGrth1WkAgo LTGrth4WkAgo LTGrth8WkAgo LTGrth13WkAgo LTGrthHigh LTGrthLow LTGrthStdDev | Long Term EPS Growth | Long Term EPS Growth Rate (%) |