| WORD | NAME | DESCRIPTION | |
| IAC() IACQ IACPQ IACPYQ IACTTM IACPTM IACA IACPY IACGr%PQ IACGr%PYQ IACGr%TTM IACGr%PQTTM IACGr%A IACGr%3Y IACGr%5Y IACGr%10Y IACRSD%ANN IACRSD%TTM IACRegEstANN IACRegEstTTM IACRegGr%ANN IACRegGr%TTM IACPSQ IACPSA IAC%SalesQ IAC%SalesA IAC3YAvg IAC5YAvg | Income Available to Common | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| IAD | Indicated Annual Dividend | Indicated Annual Dividend. This is a forward looking number used to calculate yield. It can also be used to find companies increasing their dividends. | |
| IAD13W | Indicated Annual Dividend | Indicated Annual Dividend 3 months ago. It can be used to find companies increasing their dividends. | |
| IAD26W | Indicated Annual Dividend | Indicated Annual Dividend 6 months ago. It can be used to find companies increasing their dividends. | |
| IAD52W | Indicated Annual Dividend | Indicated Annual Dividend 1 year ago. It can be used to find companies increasing their dividends. | |
| IncAftTax() IncAftTaxQ IncAftTaxPQ IncAftTaxPYQ IncAftTaxTTM IncAftTaxPTM IncAftTaxA IncAftTaxPY IncAftTaxGr%PQ IncAftTaxGr%PYQ IncAftTaxGr%TTM IncAftTaxGr%PQTTM IncAftTaxGr%A IncAftTaxGr%3Y IncAftTaxGr%5Y IncAftTaxGr%10Y IncAftTaxRSD%ANN IncAftTaxRSD%TTM IncAftTaxRegEstANN IncAftTaxRegEstTTM IncAftTaxRegGr%ANN IncAftTaxRegGr%TTM IncAftTaxPSQ IncAftTaxPSA IncAftTax%SalesQ IncAftTax%SalesA IncAftTax3YAvg IncAftTax5YAvg | Income After Taxes | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| IncBTax() IncBTaxQ IncBTaxPQ IncBTaxPYQ IncBTaxTTM IncBTaxPTM IncBTaxA IncBTaxPY IncBTaxGr%PQ IncBTaxGr%PYQ IncBTaxGr%TTM IncBTaxGr%PQTTM IncBTaxGr%A IncBTaxGr%3Y IncBTaxGr%5Y IncBTaxGr%10Y IncBTaxRSD%ANN IncBTaxRSD%TTM IncBTaxRegEstANN IncBTaxRegEstTTM IncBTaxRegGr%ANN IncBTaxRegGr%TTM IncBTaxPSQ IncBTaxPSA IncBTax%SalesQ IncBTax%SalesA IncBTax3YAvg IncBTax5YAvg | Income Before Taxes | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| IncBXorAdjCSE() IncBXorAdjCSEQ IncBXorAdjCSEPQ IncBXorAdjCSEPYQ IncBXorAdjCSETTM IncBXorAdjCSEPTM IncBXorAdjCSEA IncBXorAdjCSEPY IncBXorAdjCSEGr%PQ IncBXorAdjCSEGr%PYQ IncBXorAdjCSEGr%TTM IncBXorAdjCSEGr%PQTTM IncBXorAdjCSEGr%A IncBXorAdjCSEGr%3Y IncBXorAdjCSEGr%5Y IncBXorAdjCSEGr%10Y IncBXorAdjCSERSD%ANN IncBXorAdjCSERSD%TTM IncBXorAdjCSERegEstANN IncBXorAdjCSERegEstTTM IncBXorAdjCSERegGr%ANN IncBXorAdjCSERegGr%TTM IncBXorAdjCSEPSQ IncBXorAdjCSEPSA IncBXorAdjCSE%SalesQ IncBXorAdjCSE%SalesA IncBXorAdjCSE3YAvg IncBXorAdjCSE5YAvg | Income Before Xor Items Adj for Common | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| IncBXorForCom() IncBXorForComQ IncBXorForComPQ IncBXorForComPYQ IncBXorForComTTM IncBXorForComPTM IncBXorForComA IncBXorForComPY IncBXorForComGr%PQ IncBXorForComGr%PYQ IncBXorForComGr%TTM IncBXorForComGr%PQTTM IncBXorForComGr%A IncBXorForComGr%3Y IncBXorForComGr%5Y IncBXorForComGr%10Y IncBXorForComRSD%ANN IncBXorForComRSD%TTM IncBXorForComRegEstANN IncBXorForComRegEstTTM IncBXorForComRegGr%ANN IncBXorForComRegGr%TTM IncBXorForComPSQ IncBXorForComPSA IncBXorForCom%SalesQ IncBXorForCom%SalesA IncBXorForCom3YAvg IncBXorForCom5YAvg | Income Before Xor Items Avail for Common | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| IncPerEmp() IncPerEmpQ IncPerEmpPQ IncPerEmpPYQ IncPerEmpTTM IncPerEmpPTM IncPerEmpA IncPerEmpPY IncPerEmpGr%PQ IncPerEmpGr%PYQ IncPerEmpGr%TTM IncPerEmpGr%PQTTM IncPerEmpGr%A IncPerEmpGr%3Y IncPerEmpGr%5Y IncPerEmpGr%10Y IncPerEmpRSD%ANN IncPerEmpRSD%TTM IncPerEmpRegEstANN IncPerEmpRegEstTTM IncPerEmpRegGr%ANN IncPerEmpRegGr%TTM IncPerEmp3YAvg IncPerEmp5YAvg | Income Per Employee | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | |
| IncPerEmpTTMInd | Income per Employee, Industry | Income Per Employee Industry, TTM | Full Description |
| IncTaxExp() IncTaxExpQ IncTaxExpPQ IncTaxExpPYQ IncTaxExpTTM IncTaxExpPTM IncTaxExpA IncTaxExpPY IncTaxExpGr%PQ IncTaxExpGr%PYQ IncTaxExpGr%TTM IncTaxExpGr%PQTTM IncTaxExpGr%A IncTaxExpGr%3Y IncTaxExpGr%5Y IncTaxExpGr%10Y IncTaxExpRSD%ANN IncTaxExpRSD%TTM IncTaxExpRegEstANN IncTaxExpRegEstTTM IncTaxExpRegGr%ANN IncTaxExpRegGr%TTM IncTaxExpPSQ IncTaxExpPSA IncTaxExp%SalesQ IncTaxExp%SalesA IncTaxExp3YAvg IncTaxExp5YAvg | Income Tax Expense | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| IndCode | Industry Code | Industry Code. See Full Description for a complete list of codes | Full Description |
| IndCount IndCount | Industry Count | Running count of stocks in the industry. This rule must be the last rule in the screen. | |
| IndDescr | Industry Description | See Full Description for a complete list of names | Full Description |
| Industry | Industry | Which industry the stock belongs to. For example, to screen for stocks in the leisure products industry use: Industry=LEISURE | Full Description |
| IndWeight | Industry Weight | Weight of the industry as % of total market value. For a buy rule, the weight is checked assuming the stock is purchased. For a sell rule the weight is checked before the sell. | |
| InList() | Stock is in Custom List | Returns 1 if the stock is in your custom list, 0 otherwise. To enter a custom list go to TOOLS->Lists->Custom. Ex: to only buy stocks in your list "MyList" enter the following Buy rule: InList("MyList") | Full Description |
| Ins#ShrPurch | Insider Factors | Insider total shares purchased past 6 months (positive number in millions) | Full Description |
| Ins#ShrSold | Insider Factors | Insider total shares sold in the past 6 months (negative number in millions) | Full Description |
| InsBuyTrans | Insider Factors | Insider number of BUY transactions in the past 6 months | Full Description |
| InSet() | Check if an expression is in a set | Returns TRUE (1) if 'expression' is found in the list of parameters. For example, to screen for stocks in one of three industries you can write: InSet(Industry,ADVERT,CASINO,HOTELS) | |
| Insider#Own | Insider Factors | Common stock in millions held by the officers and directors of the company plus beneficial owners who own more than 5 percent | Full Description |
| Insider%Own | Insider Factors | Percent of common stock held by the officers and directors of the company plus beneficial owners who own more than 5 percent | Full Description |
| InsiderBuySh12M() | Insider Functions | Shares bought by insiders past 12 months (in millions) | Full Description |
| InsiderBuySh1M() | Insider Functions | Shares bought by insiders past 1 month (in millions) | Full Description |
| InsiderBuySh3M() | Insider Functions | Shares bought by insiders past 3 months (in millions) | Full Description |
| InsiderBuySh6M() | Insider Functions | Shares bought by insiders past 6 months (in millions) | Full Description |
| InsiderBuyTran12M() | Insider Functions | Buy transactions by insiders past 12 months (in millions) | Full Description |
| InsiderBuyTran1M() | Insider Functions | Buy transactions by insiders past 1 month (in millions) | Full Description |
| InsiderBuyTran3M() | Insider Functions | Buy transactions by insiders past 3 months (in millions) | Full Description |
| InsiderBuyTran6M() | Insider Functions | Buy transactions by insiders past 6 months (in millions) | Full Description |
| InsiderSellSh12M() | Insider Functions | Shares sold by insiders past 12 months (in millions) | Full Description |
| InsiderSellSh1M() | Insider Functions | Shares sold by insiders past 1 month (in millions) | Full Description |
| InsiderSellSh3M() | Insider Functions | Shares sold by insiders past 3 months (in millions) | Full Description |
| InsiderSellSh6M() | Insider Functions | Shares sold by insiders past 6 months (in millions) | Full Description |
| InsiderSellTran12M() | Insider Functions | Sell transactions by insiders past 12 months | Full Description |
| InsiderSellTran1M() | Insider Functions | Sell transactions by insiders past 1 month | Full Description |
| InsiderSellTran3M() | Insider Functions | Sell transactions by insiders past 3 months | Full Description |
| InsiderSellTran6M() | Insider Functions | Sell transactions by insiders past 6 months | Full Description |
| InsiderUniqBuy1M() | Insider Functions | Unique number of insiders buying past 1 month | Full Description |
| InsiderUniqBuy3M() | Insider Functions | Unique number of insiders buying past 3 months | Full Description |
| InsiderUniqSell1M() | Insider Functions | Unique number of insiders selling past 1 month | Full Description |
| InsiderUniqSell3M() | Insider Functions | Unique number of insiders selling past 3 months | Full Description |
| InsNetShrPurch | Insider Factors | Insider total shares net in the past 6 months (positive or negative number in millions) | Full Description |
| InsNetTrans | Insider Factors | Insider NET number of transactions in the past 6 months | Full Description |
| InsSelTrans | Insider Factors | Insider number of SELL transactions in the past 6 months | Full Description |
| Inst#ShsOwn | Institutional Factors | The number of shares of the company held by investors in the latest period (in millions) | Full Description |
| Inst#ShsOwnPQ | Institutional Factors | The number of shares of the company held by investors in the previous period (in millions) | Full Description |
| Inst#ShsPurch | Institutional Factors | The number of shares of the company purchased by investors during the latest period (in millions) | Full Description |
| Inst#ShsPurchPQ | Institutional Factors | The number of shares of the company purchased by investors during the previous period (in millions) | Full Description |
| Inst#ShsSold | Institutional Factors | The number of shares of the company sold by investors during the latest period (in millions) | Full Description |
| Inst#ShsSoldPQ | Institutional Factors | The number of shares of the company sold by investors during the previous period (in millions) | Full Description |
| Inst%Own | Institutional Factors | The percentage of shares outstanding of the company owned by institutional shareholders in the latest period | Full Description |
| Inst%OwnInd | Institutional % Owned, Industry | Institutional Percent Owned Industry, (%) average | Full Description |
| Inst%OwnPQ | Institutional Factors | The percentage of shares outstanding of the company owned by institutional shareholders in the previous period | Full Description |
| InstitutionalBuyers() | Institutional Functions | The number of investors who purchased shares of the company during the period | Full Description |
| InstitutionalClosed() | Institutional Functions | The number of investors who sold all shares and closed their holding position in the company during the period | Full Description |
| InstitutionalHolders() | Institutional Functions | The total number of investors who own shares of the company | Full Description |
| InstitutionalNewBuyers() | Institutional Functions | The number of investors who opened a new position in the company by purchasing shares during the period | Full Description |
| InstitutionalPctChg() | Institutional Functions | The net shares changed as a percent of shares outstanding | Full Description |
| InstitutionalPctOwn() | Institutional Functions | The percentage of shares outstanding of the company owned by institutional shareholders | Full Description |
| InstitutionalSellers() | Institutional Functions | The number of investors who sold shares of the company during the period | Full Description |
| InstitutionalShsBought() | Institutional Functions | The number of shares of the company purchased by investors during the period (in millions) | Full Description |
| InstitutionalShsHeld() | Institutional Functions | The number of shares of the company held by investors at the end of the period (in millions) | Full Description |
| InstitutionalShsNet() | Institutional Functions | The net number of shares of the company transacted by investors during the period (in millions) | Full Description |
| InstitutionalShsSold() | Institutional Functions | The number of shares of the company sold by investors during the period (in millions) | Full Description |
| InstNetPurch | Institutional Factors | The net number of shares of the company transacted by investors during the latest period (in millions) | Full Description |
| InstNetPurchPQ | Institutional Factors | The net number of shares of the company transacted by investors during the previous period (in millions) | Full Description |
| IntanOther() IntanOtherQ IntanOtherPQ IntanOtherPYQ IntanOtherTTM IntanOtherPTM IntanOtherA IntanOtherPY IntanOtherGr%PQ IntanOtherGr%PYQ IntanOtherGr%TTM IntanOtherGr%PQTTM IntanOtherGr%A IntanOtherGr%3Y IntanOtherGr%5Y IntanOtherGr%10Y IntanOtherRSD%ANN IntanOtherRSD%TTM IntanOtherRegEstANN IntanOtherRegEstTTM IntanOtherRegGr%ANN IntanOtherRegGr%TTM IntanOtherPSQ IntanOtherPSA IntanOther%AssetsQ IntanOther%AssetsA IntanOther3YAvg IntanOther5YAvg | Other Intangibles | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| IntCov() IntCovQ IntCovPQ IntCovPYQ IntCovTTM IntCovPTM IntCovA IntCovPY IntCovGr%PQ IntCovGr%PYQ IntCovGr%TTM IntCovGr%PQTTM IntCovGr%A IntCovGr%3Y IntCovGr%5Y IntCovGr%10Y IntCovRSD%ANN IntCovRSD%TTM IntCovRegEstANN IntCovRegEstTTM IntCovRegGr%ANN IntCovRegGr%TTM IntCov3YAvg IntCov5YAvg | Interest Coverage | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| IntCovTTMInd | Interest Coverage, Industry | Interest Coverage Industry, TTM | Full Description |
| Intercept | Y Intercept | Returns the Y-Intercept for a previously computed regression | Full Description |
| InterceptSE | Y Intercept Standard Error | Returns the Y-Intercept Standard Error for a previously computed regression | Full Description |
| InterimMonths() | Interim Months | Months in the filing period for the given interim offset (the offset parameter is the number of interim periods you want to look back). Always returns either 3 or 6: 3 for stocks that report quarterly, 6 for those that report semiannually. This function will always return 3 for Compustat interims. | |
| IntExp() IntExpQ IntExpPQ IntExpPYQ IntExpTTM IntExpPTM IntExpA IntExpPY IntExpGr%PQ IntExpGr%PYQ IntExpGr%TTM IntExpGr%PQTTM IntExpGr%A IntExpGr%3Y IntExpGr%5Y IntExpGr%10Y IntExpRSD%ANN IntExpRSD%TTM IntExpRegEstANN IntExpRegEstTTM IntExpRegGr%ANN IntExpRegGr%TTM IntExpPSQ IntExpPSA IntExp%SalesQ IntExp%SalesA IntExp3YAvg IntExp5YAvg | Interest Expense | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| IntInc() IntIncQ IntIncPQ IntIncPYQ IntIncTTM IntIncPTM IntIncA IntIncPY IntIncGr%PQ IntIncGr%PYQ IntIncGr%TTM IntIncGr%PQTTM IntIncGr%A IntIncGr%3Y IntIncGr%5Y IntIncGr%10Y IntIncRSD%ANN IntIncRSD%TTM IntIncRegEstANN IntIncRegEstTTM IntIncRegGr%ANN IntIncRegGr%TTM IntIncPSQ IntIncPSA IntInc%SalesQ IntInc%SalesA IntInc3YAvg IntInc5YAvg | Interest Income | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| Inventory() InventoryQ InventoryPQ InventoryPYQ InventoryTTM InventoryPTM InventoryA InventoryPY InventoryGr%PQ InventoryGr%PYQ InventoryGr%TTM InventoryGr%PQTTM InventoryGr%A InventoryGr%3Y InventoryGr%5Y InventoryGr%10Y InventoryRSD%ANN InventoryRSD%TTM InventoryRegEstANN InventoryRegEstTTM InventoryRegGr%ANN InventoryRegGr%TTM InventoryPSQ InventoryPSA Inventory%AssetsQ Inventory%AssetsA Inventory3YAvg Inventory5YAvg | Inventory | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| InvstAdvOther() InvstAdvOtherQ InvstAdvOtherPQ InvstAdvOtherPYQ InvstAdvOtherTTM InvstAdvOtherPTM InvstAdvOtherA InvstAdvOtherPY InvstAdvOtherGr%PQ InvstAdvOtherGr%PYQ InvstAdvOtherGr%TTM InvstAdvOtherGr%PQTTM InvstAdvOtherGr%A InvstAdvOtherGr%3Y InvstAdvOtherGr%5Y InvstAdvOtherGr%10Y InvstAdvOtherRSD%ANN InvstAdvOtherRSD%TTM InvstAdvOtherRegEstANN InvstAdvOtherRegEstTTM InvstAdvOtherRegGr%ANN InvstAdvOtherRegGr%TTM InvstAdvOtherPSQ InvstAdvOtherPSA InvstAdvOther%AssetsQ InvstAdvOther%AssetsA InvstAdvOther3YAvg InvstAdvOther5YAvg | Investments and Advances 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 |
| InvstEq() InvstEqQ InvstEqPQ InvstEqPYQ InvstEqTTM InvstEqPTM InvstEqA InvstEqPY InvstEqGr%PQ InvstEqGr%PYQ InvstEqGr%TTM InvstEqGr%PQTTM InvstEqGr%A InvstEqGr%3Y InvstEqGr%5Y InvstEqGr%10Y InvstEqRSD%ANN InvstEqRSD%TTM InvstEqRegEstANN InvstEqRegEstTTM InvstEqRegGr%ANN InvstEqRegGr%TTM InvstEqPSQ InvstEqPSA InvstEq%AssetsQ InvstEq%AssetsA InvstEq3YAvg InvstEq5YAvg | Equity Investments | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| InvstOther() InvstOtherQ InvstOtherPQ InvstOtherPYQ InvstOtherTTM InvstOtherPTM InvstOtherA InvstOtherPY InvstOtherGr%PQ InvstOtherGr%PYQ InvstOtherGr%TTM InvstOtherGr%PQTTM InvstOtherGr%A InvstOtherGr%3Y InvstOtherGr%5Y InvstOtherGr%10Y InvstOtherRSD%ANN InvstOtherRSD%TTM InvstOtherRegEstANN InvstOtherRegEstTTM InvstOtherRegGr%ANN InvstOtherRegGr%TTM InvstOtherPSQ InvstOtherPSA InvstOther%SalesQ InvstOther%SalesA InvstOther%AssetsQ InvstOther%AssetsA InvstOther3YAvg InvstOther5YAvg | Other Investing Cash Flow | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| InvstST() InvstSTQ InvstSTPQ InvstSTPYQ InvstSTTTM InvstSTPTM InvstSTA InvstSTPY InvstSTGr%PQ InvstSTGr%PYQ InvstSTGr%TTM InvstSTGr%PQTTM InvstSTGr%A InvstSTGr%3Y InvstSTGr%5Y InvstSTGr%10Y InvstSTRSD%ANN InvstSTRSD%TTM InvstSTRegEstANN InvstSTRegEstTTM InvstSTRegGr%ANN InvstSTRegGr%TTM InvstSTPSQ InvstSTPSA InvstST%AssetsQ InvstST%AssetsA InvstST3YAvg InvstST5YAvg | Short Term Investments | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| InvTurn() InvTurnQ InvTurnPQ InvTurnPYQ InvTurnTTM InvTurnPTM InvTurnA InvTurnPY InvTurnGr%PQ InvTurnGr%PYQ InvTurnGr%TTM InvTurnGr%PQTTM InvTurnGr%A InvTurnGr%3Y InvTurnGr%5Y InvTurnGr%10Y InvTurnRSD%ANN InvTurnRSD%TTM InvTurnRegEstANN InvTurnRegEstTTM InvTurnRegGr%ANN InvTurnRegGr%TTM InvTurnPSQ InvTurnPSA InvTurn%SalesQ InvTurn%SalesA InvTurn%AssetsQ InvTurn%AssetsA InvTurn3YAvg InvTurn5YAvg | Inventory Turnover | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| InvTurnTTMInd | Inventory Turnover, Industry | Inventory Turnover Industry, TTM | Full Description |
| InvtyChg() InvtyChgQ InvtyChgPQ InvtyChgPYQ InvtyChgTTM InvtyChgPTM InvtyChgA InvtyChgPY InvtyChgGr%PQ InvtyChgGr%PYQ InvtyChgGr%TTM InvtyChgGr%PQTTM InvtyChgGr%A InvtyChgGr%3Y InvtyChgGr%5Y InvtyChgGr%10Y InvtyChgRSD%ANN InvtyChgRSD%TTM InvtyChgRegEstANN InvtyChgRegEstTTM InvtyChgRegGr%ANN InvtyChgRegGr%TTM InvtyChgPSQ InvtyChgPSA InvtyChg%SalesQ InvtyChg%SalesA InvtyChg%AssetsQ InvtyChg%AssetsA InvtyChg3YAvg InvtyChg5YAvg | Change to Inventory | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
| IsADR | Is ADR | Returns 1 (TRUE) if the stock is an American Depository Receipt (ADR) | Full Description |
| IsMLP | Is MLP | Returns 1 (TRUE) if the stock is a Master Limited Partnership (MLP) in USA or Canada. | Full Description |
| IsNA() | Replace NA Number (Not Available) | Returns the value of expr1 if it's not NA, otherwise it returns expr2 | |
| IsNeg() | Replace Negative Number | Returns the value of expr1 if it's not negative, otherwise it returns expr2 | |
| IsNegOrNA() | Replace Negative or NA Number | Returns the value of expr1 if it's not negative and not NA, otherwise it returns expr2 | |
| IsOTC | Is Over The Counter (OTC) | Returns 1 (TRUE) if the stock trades OTC in the USA. | |
| IsPrimary | Is Primary | Returns 1 (TRUE) if the stock is the primary listing for the company, i.e. not a foreign stock. | |
| IsZero() | Replace Zero Number | Returns the value of expr1 if it's not zero, otherwise it returns expr2 |