WORD | NAME | DESCRIPTION | |
DaysDiff() | Date | Returns the number of days between the given dates. Dates are numbers in this format YYYYMMDD. | |
DaysFromDivEx | Dividends | Days since the last dividend ex-date. Always a positive number or NA | Full Description |
DaysFromDivPay | Dividends | Days since the last dividend payment date. Always a positive number or NA. If in-between ex-date and pay-date NA is returned. | Full Description |
DaysFromMergerAnn | Corporate Actions (ICE Data) | Returns the days since a M&A (incl spinoff) corporate action has been announced or NA. Equivalent to PendingCorpAct(#MANDA, #ANNCEDAYS) | Full Description |
DaysLate | Earnings Release | Returns 0 or the number of days the filing is late (over 40 days for Q and over 75 for K). If the company has no filing data NA is returned. NOTE: This is an estimate. See the Full Description for more details | Full Description |
DaysSince() | Date | Returns the number of days since the given date. Date is a number in this format YYYYMMDD. | |
DaysToDivEx | Dividends | Days until the next dividend ex-date. Always a positive number or NA. If in-between ex-date and pay-date NA is returned. | Full Description |
DaysToDivPay | Dividends | Days until next dividend payment date. Always a positive number or NA. | Full Description |
DbtLT() DbtLTQ DbtLTPQ DbtLTPYQ DbtLTTTM DbtLTPTM DbtLTA DbtLTPY DbtLTGr%PQ DbtLTGr%PYQ DbtLTGr%TTM DbtLTGr%PQTTM DbtLTGr%A DbtLTGr%3Y DbtLTGr%5Y DbtLTGr%10Y DbtLTRSD%ANN DbtLTRSD%TTM DbtLTRegEstANN DbtLTRegEstTTM DbtLTRegGr%ANN DbtLTRegGr%TTM DbtLTPSQ DbtLTPSA DbtLT%AssetsQ DbtLT%AssetsA DbtLT3YAvg DbtLT5YAvg | Long Term Debt | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DbtLT2Ast() DbtLT2AstQ DbtLT2AstPQ DbtLT2AstPYQ DbtLT2AstTTM DbtLT2AstPTM DbtLT2AstA DbtLT2AstPY DbtLT2AstGr%PQ DbtLT2AstGr%PYQ DbtLT2AstGr%TTM DbtLT2AstGr%PQTTM DbtLT2AstGr%A DbtLT2AstGr%3Y DbtLT2AstGr%5Y DbtLT2AstGr%10Y DbtLT2AstRSD%ANN DbtLT2AstRSD%TTM DbtLT2AstRegEstANN DbtLT2AstRegEstTTM DbtLT2AstRegGr%ANN DbtLT2AstRegGr%TTM DbtLT2Ast3YAvg DbtLT2Ast5YAvg | Long Term Debt to Total Assets | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DbtLT2Cap() DbtLT2CapQ DbtLT2CapPQ DbtLT2CapPYQ DbtLT2CapTTM DbtLT2CapPTM DbtLT2CapA DbtLT2CapPY DbtLT2CapGr%PQ DbtLT2CapGr%PYQ DbtLT2CapGr%TTM DbtLT2CapGr%PQTTM DbtLT2CapGr%A DbtLT2CapGr%3Y DbtLT2CapGr%5Y DbtLT2CapGr%10Y DbtLT2CapRSD%ANN DbtLT2CapRSD%TTM DbtLT2CapRegEstANN DbtLT2CapRegEstTTM DbtLT2CapRegGr%ANN DbtLT2CapRegGr%TTM DbtLT2Cap3YAvg DbtLT2Cap5YAvg | Long Term Debt to Total Capital | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DbtLT2Eq() DbtLT2EqQ DbtLT2EqPQ DbtLT2EqPYQ DbtLT2EqTTM DbtLT2EqPTM DbtLT2EqA DbtLT2EqPY DbtLT2EqGr%PQ DbtLT2EqGr%PYQ DbtLT2EqGr%TTM DbtLT2EqGr%PQTTM DbtLT2EqGr%A DbtLT2EqGr%3Y DbtLT2EqGr%5Y DbtLT2EqGr%10Y DbtLT2EqRSD%ANN DbtLT2EqRSD%TTM DbtLT2EqRegEstANN DbtLT2EqRegEstTTM DbtLT2EqRegGr%ANN DbtLT2EqRegGr%TTM DbtLT2Eq3YAvg DbtLT2Eq5YAvg | Long Term Debt to Total Equity | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DbtLT2EqQInd | Long Term Debt To Total Equity, Industry | Long Term Debt To Total Equity Industry, Quarterly | Full Description |
DbtLTIssued() DbtLTIssuedQ DbtLTIssuedPQ DbtLTIssuedPYQ DbtLTIssuedTTM DbtLTIssuedPTM DbtLTIssuedA DbtLTIssuedPY DbtLTIssuedGr%PQ DbtLTIssuedGr%PYQ DbtLTIssuedGr%TTM DbtLTIssuedGr%PQTTM DbtLTIssuedGr%A DbtLTIssuedGr%3Y DbtLTIssuedGr%5Y DbtLTIssuedGr%10Y DbtLTIssuedRSD%ANN DbtLTIssuedRSD%TTM DbtLTIssuedRegEstANN DbtLTIssuedRegEstTTM DbtLTIssuedRegGr%ANN DbtLTIssuedRegGr%TTM DbtLTIssuedPSQ DbtLTIssuedPSA DbtLTIssued%SalesQ DbtLTIssued%SalesA DbtLTIssued%AssetsQ DbtLTIssued%AssetsA DbtLTIssued3YAvg DbtLTIssued5YAvg | Long Term Debt Issued | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DbtLTReduced() DbtLTReducedQ DbtLTReducedPQ DbtLTReducedPYQ DbtLTReducedTTM DbtLTReducedPTM DbtLTReducedA DbtLTReducedPY DbtLTReducedGr%PQ DbtLTReducedGr%PYQ DbtLTReducedGr%TTM DbtLTReducedGr%PQTTM DbtLTReducedGr%A DbtLTReducedGr%3Y DbtLTReducedGr%5Y DbtLTReducedGr%10Y DbtLTReducedRSD%ANN DbtLTReducedRSD%TTM DbtLTReducedRegEstANN DbtLTReducedRegEstTTM DbtLTReducedRegGr%ANN DbtLTReducedRegGr%TTM DbtLTReducedPSQ DbtLTReducedPSA DbtLTReduced%SalesQ DbtLTReduced%SalesA DbtLTReduced%AssetsQ DbtLTReduced%AssetsA DbtLTReduced3YAvg DbtLTReduced5YAvg | Long Term Debt Reduced | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DbtS2NI() DbtS2NIQ DbtS2NIPQ DbtS2NIPYQ DbtS2NITTM DbtS2NIPTM DbtS2NIA DbtS2NIPY DbtS2NIGr%PQ DbtS2NIGr%PYQ DbtS2NIGr%TTM DbtS2NIGr%PQTTM DbtS2NIGr%A DbtS2NIGr%3Y DbtS2NIGr%5Y DbtS2NIGr%10Y DbtS2NIRSD%ANN DbtS2NIRSD%TTM DbtS2NIRegEstANN DbtS2NIRegEstTTM DbtS2NIRegGr%ANN DbtS2NIRegGr%TTM DbtS2NI3YAvg DbtS2NI5YAvg | Debt Service to Net 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 |
DbtST() DbtSTQ DbtSTPQ DbtSTPYQ DbtSTTTM DbtSTPTM DbtSTA DbtSTPY DbtSTGr%PQ DbtSTGr%PYQ DbtSTGr%TTM DbtSTGr%PQTTM DbtSTGr%A DbtSTGr%3Y DbtSTGr%5Y DbtSTGr%10Y DbtSTRSD%ANN DbtSTRSD%TTM DbtSTRegEstANN DbtSTRegEstTTM DbtSTRegGr%ANN DbtSTRegGr%TTM DbtSTPSQ DbtSTPSA DbtST%AssetsQ DbtST%AssetsA DbtST3YAvg DbtST5YAvg | Short Term Debt | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DbtTot() DbtTotQ DbtTotPQ DbtTotPYQ DbtTotTTM DbtTotPTM DbtTotA DbtTotPY DbtTotGr%PQ DbtTotGr%PYQ DbtTotGr%TTM DbtTotGr%PQTTM DbtTotGr%A DbtTotGr%3Y DbtTotGr%5Y DbtTotGr%10Y DbtTotRSD%ANN DbtTotRSD%TTM DbtTotRegEstANN DbtTotRegEstTTM DbtTotRegGr%ANN DbtTotRegGr%TTM DbtTotPSQ DbtTotPSA DbtTot%AssetsQ DbtTot%AssetsA DbtTot3YAvg DbtTot5YAvg | Total Debt | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DbtTot2Ast() DbtTot2AstQ DbtTot2AstPQ DbtTot2AstPYQ DbtTot2AstTTM DbtTot2AstPTM DbtTot2AstA DbtTot2AstPY DbtTot2AstGr%PQ DbtTot2AstGr%PYQ DbtTot2AstGr%TTM DbtTot2AstGr%PQTTM DbtTot2AstGr%A DbtTot2AstGr%3Y DbtTot2AstGr%5Y DbtTot2AstGr%10Y DbtTot2AstRSD%ANN DbtTot2AstRSD%TTM DbtTot2AstRegEstANN DbtTot2AstRegEstTTM DbtTot2AstRegGr%ANN DbtTot2AstRegGr%TTM DbtTot2Ast3YAvg DbtTot2Ast5YAvg | Total Debt To Total Assets | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DbtTot2Cap() DbtTot2CapQ DbtTot2CapPQ DbtTot2CapPYQ DbtTot2CapTTM DbtTot2CapPTM DbtTot2CapA DbtTot2CapPY DbtTot2CapGr%PQ DbtTot2CapGr%PYQ DbtTot2CapGr%TTM DbtTot2CapGr%PQTTM DbtTot2CapGr%A DbtTot2CapGr%3Y DbtTot2CapGr%5Y DbtTot2CapGr%10Y DbtTot2CapRSD%ANN DbtTot2CapRSD%TTM DbtTot2CapRegEstANN DbtTot2CapRegEstTTM DbtTot2CapRegGr%ANN DbtTot2CapRegGr%TTM DbtTot2Cap3YAvg DbtTot2Cap5YAvg | Total Debt to Total Capital | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DbtTot2Eq() DbtTot2EqQ DbtTot2EqPQ DbtTot2EqPYQ DbtTot2EqTTM DbtTot2EqPTM DbtTot2EqA DbtTot2EqPY DbtTot2EqGr%PQ DbtTot2EqGr%PYQ DbtTot2EqGr%TTM DbtTot2EqGr%PQTTM DbtTot2EqGr%A DbtTot2EqGr%3Y DbtTot2EqGr%5Y DbtTot2EqGr%10Y DbtTot2EqRSD%ANN DbtTot2EqRSD%TTM DbtTot2EqRegEstANN DbtTot2EqRegEstTTM DbtTot2EqRegGr%ANN DbtTot2EqRegGr%TTM DbtTot2Eq3YAvg DbtTot2Eq5YAvg | Total Debt to Total Equity | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DbtTot2EqQInd | Total Debt To Total Equity, Industry | Total Debt To Total Equity Industry, Quarterly | Full Description |
DepAmort() DepAmortQ DepAmortPQ DepAmortPYQ DepAmortTTM DepAmortPTM DepAmortA DepAmortPY DepAmortGr%PQ DepAmortGr%PYQ DepAmortGr%TTM DepAmortGr%PQTTM DepAmortGr%A DepAmortGr%3Y DepAmortGr%5Y DepAmortGr%10Y DepAmortRSD%ANN DepAmortRSD%TTM DepAmortRegEstANN DepAmortRegEstTTM DepAmortRegGr%ANN DepAmortRegGr%TTM DepAmortPSQ DepAmortPSA DepAmort%SalesQ DepAmort%SalesA DepAmort3YAvg DepAmort5YAvg | Depreciation and Amortization | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DepAmort2GP() DepAmort2GPQ DepAmort2GPPQ DepAmort2GPPYQ DepAmort2GPTTM DepAmort2GPPTM DepAmort2GPA DepAmort2GPPY DepAmort2GPGr%PQ DepAmort2GPGr%PYQ DepAmort2GPGr%TTM DepAmort2GPGr%PQTTM DepAmort2GPGr%A DepAmort2GPGr%3Y DepAmort2GPGr%5Y DepAmort2GPGr%10Y DepAmort2GPRSD%ANN DepAmort2GPRSD%TTM DepAmort2GPRegEstANN DepAmort2GPRegEstTTM DepAmort2GPRegGr%ANN DepAmort2GPRegGr%TTM DepAmort2GPPSQ DepAmort2GPPSA DepAmort2GP%SalesQ DepAmort2GP%SalesA DepAmort2GP%AssetsQ DepAmort2GP%AssetsA DepAmort2GP3YAvg DepAmort2GP5YAvg | Depreciation And Amort to Gross Profit | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DepAmortCF() DepAmortCFQ DepAmortCFPQ DepAmortCFPYQ DepAmortCFTTM DepAmortCFPTM DepAmortCFA DepAmortCFPY DepAmortCFGr%PQ DepAmortCFGr%PYQ DepAmortCFGr%TTM DepAmortCFGr%PQTTM DepAmortCFGr%A DepAmortCFGr%3Y DepAmortCFGr%5Y DepAmortCFGr%10Y DepAmortCFRSD%ANN DepAmortCFRSD%TTM DepAmortCFRegEstANN DepAmortCFRegEstTTM DepAmortCFRegGr%ANN DepAmortCFRegGr%TTM DepAmortCFPSQ DepAmortCFPSA DepAmortCF%SalesQ DepAmortCF%SalesA DepAmortCF%AssetsQ DepAmortCF%AssetsA DepAmortCF3YAvg DepAmortCF5YAvg | Depreciation and Amort, 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 |
Div%ChgA | Dividend Growth | Dividend Percent Change, Year Over Year (%) | Full Description |
Div%ChgAInd | Industry Growth | Dividend Percent Change Industry, Year Over Year (%) | Full Description |
Div%ChgPYQ | Dividend Growth | Dividend Percent Change, Quarter vs Quarter a year ago (%) | Full Description |
Div%ChgTTM | Dividend Growth | Dividend Percent Change, TTM (%) | Full Description |
Div3YCGr% | Dividend Growth | Dividend Growth Rate, 3 Years (uses corporate action data) | Full Description |
Div3YCGr%Ind | Industry Growth | Dividend Growth Rate Industry, 3 Years (uses corporate action data) | |
Div5YCGr% | Dividend Growth | Dividend, 5 Year Growth Rate (uses corporate action data) | Full Description |
Div5YCGr%Ind | Industry Growth | Dividend Industry, 5 Year Growth Rate (uses corporate action data) | |
Divest() DivestQ DivestPQ DivestPYQ DivestTTM DivestPTM DivestA DivestPY DivestGr%PQ DivestGr%PYQ DivestGr%TTM DivestGr%PQTTM DivestGr%A DivestGr%3Y DivestGr%5Y DivestGr%10Y DivestRSD%ANN DivestRSD%TTM DivestRegEstANN DivestRegEstTTM DivestRegGr%ANN DivestRegGr%TTM DivestPSQ DivestPSA Divest%SalesQ Divest%SalesA Divest%AssetsQ Divest%AssetsA Divest3YAvg Divest5YAvg | Divestitures | Function parameters (see Full Description for more): offset: 0-20 (interim) 0-10 (annual) type: QTR,ANN,TTM NAHandling: FALLBACK,KEEPNA,ZERONA | Full Description |
DivPaid() DivPaidQ DivPaidPQ DivPaidPYQ DivPaidTTM DivPaidPTM DivPaidA DivPaidPY DivPaidGr%PQ DivPaidGr%PYQ DivPaidGr%TTM DivPaidGr%PQTTM DivPaidGr%A DivPaidGr%3Y DivPaidGr%5Y DivPaidGr%10Y DivPaidRSD%ANN DivPaidRSD%TTM DivPaidRegEstANN DivPaidRegEstTTM DivPaidRegGr%ANN DivPaidRegGr%TTM DivPaidPSQ DivPaidPSA DivPaid%SalesQ DivPaid%SalesA DivPaid%AssetsQ DivPaid%AssetsA DivPaid3YAvg DivPaid5YAvg | Dividends Paid (Total 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 |
DivPS() | Dividends in a Filing Period | Returns the sum (or count) of the dividends per share that were paid in the period specified. By default it returns the sum of REGULAR dividends using EX DATES. See Full description for details. | Full Description |
DivPS52W | Dividends in a Time Period | Returns the sum of all regular dividends with ex-dates in the past calendar year. It's equivalent to DivPSDays(365,0,#Regular,#ExDate) | Full Description |
DivPS5YAvg | Dividends in a Filing Period | Annual average of regular dividends per share for the past 5 fiscal years using ex-dates. | Full Description |
DivPSDays() | Dividends in a Time Period | Sum or count of the dividends paid in the past number of days. By default it sums regular dividends with ex-dates in the period. See the full description for more details. | Full Description |
DivPSNextQ | Dividends in a Filing Period | Sum of all regular dividends with ex-dates falling in the ongoing quarter. If the company has not yet announced the dividends it returns 0 | Full Description |
DivPSNextQCnt | Dividends in a Filing Period | Count of all regular dividends with ex-dates in the ongoing quarter. If the company has not yet announced the dividends it returns 0 | Full Description |
DivPSQ | Dividends in a Filing Period | Sum of all regular dividends with ex-dates in the most recent quarter. This is equivalent to DivPS(0,QTR,#Regular,#ExDate) | Full Description |
DivPSTTM | Dividends in a Filing Period | Sum of all regular dividends with ex-date in the past 4 quarters. It is equivalent to DivPS(0,TTM,#Regular,#ExDate) | Full Description |
DMICrossOver() | Directional Movement Cross | Returns TRUE (or 1) if the DMI+ has crossed over the DMI- in the previous bars. DMI+ and DMI- are component of Welles Wilder DMI. To find stocks whose DMI+ crossed over the DMI- within the last 2 bars enter: DMICrossOver(14,2)=TRUE | Full Description |
DMICrossUnder() | Directional Movement Cross | Returns TRUE (or 1) if the DMI- has crossed over the DMI+ in the previous bars. DMI+ and DMI- are component of Welles Wilder DMI. To find stocks whose DMI- crossed over the DMI+ within the last 2 bars enter: DMICrossUnder(14,2)=TRUE | Full Description |
DMIMinus() | Directional Movement Indicator | Returns the DMI- component of the Directional Movement System developed by Welles Wilder. An offset can be specified to calculate past values. To find stocks with strong negative directional movement enter: DMIMinus(14,0) > DMIPlus(14,0) | Full Description |
DMIPlus() | Directional Movement Indicator | Returns the DMI+ component of the Directional Movement System developed by Welles Wilder. An offset can be specified to calculate past values. To find stocks with strong positive directional movement enter: DMIPlus(14,0) > DMIMinus(14,0) | Full Description |