A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | Name | Metric Slug | Premium | Category | Statement Type | Periods | Default Period | Description |
2 | Accrued Interest Payable | accr_int_pay | Yes | Financials | Balance Sheet | FY, Q | Q | This item represents the amount of interest accrued in the accounts of banks in respect of interest payable to its customers on its deposits. |
3 | Accrued Interest Receivable | accr_int_receiv | Yes | Financials | Balance Sheet | FY, Q | Q | This item represents interest accrued (i.e. earned but not yet due) on loans, securities, certificates of deposit, or other investments. This item is available only in Banks and Thrifts. |
4 | Accumulated Depreciation | accum_dep | Yes | Financials | Balance Sheet | FY, Q | Q | This item represents the year-end accumulated balance of amounts provided as depreciation on property, plant and equipment till the current year. |
5 | Additional Paid In Capital | add_paid_in | Yes | Financials | Balance Sheet | FY, Q | Q | The excess over par value paid for common securities. |
6 | Accrued Expenses | ae | Yes | Financials | Balance Sheet | FY, Q | Q | Expenses that have been incurred but not paid. |
7 | Accrued Expenses (Bank) | ae_bnk | Yes | Bank | Balance Sheet | FY, Q | Q | Metric adjusted for considerations applicable to structure and operations of banks. |
8 | Adjusted Funds from Operations | affo | Yes | Financials | Computed | FY, Q, LTM, YTD | LTM | Funds from operations (FFO) with adjustments made for recurring capital expenditures used to maintain the underlying assets. Typically used to evaluate REITs. |
9 | Consensus AFFO, Actual | affo_actual | Yes | Forecast | Estimated | FY, Q | FY | Reported AFFO including any adjustments for unusual items proposed by management. This metric is useful for analyst forecast vs actual analysis since deciding which add backs are truly "unusual" is subjective. Consider using "affo" slug instead for other analysis. |
10 | Adjusted Funds From Operations Growth | affo_growth | Yes | Growth | Computed | FY, Q, LTM, YTD | LTM | Period over prior period growth in adjusted funds from operations (AFFO). |
11 | Adjusted Funds From Operations Margin | affo_margin | Yes | Efficiency | Computed | FY, Q, LTM, YTD | LTM | Adjusted funds from operations (AFFO) expressed as a percent of revenue. |
12 | AFFO Payout Ratio (REIT) | affo_payout_ratio | Yes | Efficiency | Computed | FY, Q, LTM, YTD | LTM | AFFO payout ratio that is calculated as total dividends paid divided by adjusted funds from operations over the same period. |
13 | AFFO Forecast | affo_proj | Yes | Forecast | Estimated | FY, Q | FY+1 | Projected adjusted funds from operations for the company. |
14 | AFFO Forecast CAGR (10y) | affo_proj_cagr_10y | Yes | Growth | Estimated | Ten year compound annual growth rate in forecasted adjusted funds from operations. | ||
15 | AFFO Forecast CAGR (2y) | affo_proj_cagr_2y | Yes | Growth | Computed | Two year compound annual growth rate in forecasted adjusted funds from operations (AFFO). | ||
16 | AFFO Forecast CAGR (3y) | affo_proj_cagr_3y | Yes | Growth | Computed | Three year compound annual growth rate in forecasted adjusted funds from operations (AFFO). | ||
17 | AFFO Forecast CAGR (5y) | affo_proj_cagr_5y | Yes | Growth | Estimated | Five year compound annual growth rate in forecasted adjusted funds from operations. | ||
18 | AFFO Forecast Count of Estimates | affo_proj_count | Yes | Forecast | Estimated | FY, Q | FY+1 | The number of analysts publishing an AFFO Forecast for the stock. |
19 | AFFO Growth Forecast | affo_proj_growth | Yes | Growth | Estimated | FY, Q | FY+1 | Period over prior period growth in forecasted adjusted funds from operations. |
20 | AFFO Forecast High Consensus | affo_proj_high_raw | Yes | Forecast | Estimated | FY, Q | FY+1 | The highest AFFO Forecast submitted by any analyst for the company. |
21 | AFFO Forecast Low Consensus | affo_proj_low_raw | Yes | Forecast | Estimated | FY, Q | FY+1 | The lowest AFFO Forecast submitted by any analyst for the company. |
22 | AFFO Margin Forecast | affo_proj_margin | Yes | Forecast | Estimated | FY, Q | FY+1 | Forecasted adjusted funds from operations as a percent of forecasted revenue. |
23 | Avg AFFO Margin Forecast (10y) | affo_proj_margin_avg_10y | Yes | Forecast | Estimated | Ten year average forecasted adjusted funds from operations (AFFO) margin. | ||
24 | Avg AFFO Margin Forecast (5y) | affo_proj_margin_avg_5y | Yes | Forecast | Estimated | Five year average forecasted adjusted funds from operations (AFFO) margin. | ||
25 | AFFO Forecast Mean Consensus | affo_proj_mean_raw | Yes | Forecast | Estimated | FY, Q | FY+1 | The mean or average AFFO Forecast submitted by any analyst for the company. |
26 | AFFO Forecast Median Consensus | affo_proj_median_raw | Yes | Forecast | Estimated | FY, Q | FY+1 | The median AFFO Forecast submitted by any analyst for the company. |
27 | AFFO Forecast Revision Date | affo_proj_revision_date | Yes | Forecast | Forecasts | FY, Q | FY+1 | The date/time at which the current consensus estimate of forecasted AFFO was last updated. |
28 | AFFO Forecast Consensus Standard Deviation | affo_proj_stdev | Yes | Forecast | Estimated | FY, Q | FY+1 | Standard deviation in forecasted adjusted funds from operations. |
29 | Consensus AFFO / Share, Actual | affo_share_actual | Yes | Forecast | Estimated | FY, Q | FY | Reported AFFO per share including any adjustments for unusual items proposed by management. This metric is useful for analyst forecast vs actual analysis since deciding which add backs are truly "unusual" is subjective. |
30 | AFFO / Share Forecast Count of Estimates | affo_share_proj_count | Yes | Forecast | Estimated | FY, Q | FY+1 | The number of analysts publishing an AFFO / share Forecast for the stock. |
31 | AFFO / Share Forecast High Consensus | affo_share_proj_high_raw | Yes | Forecast | Estimated | FY, Q | FY+1 | The highest AFFO / share Forecast submitted by any analyst for the company. |
32 | AFFO / Share Forecast Low Consensus | affo_share_proj_low_raw | Yes | Forecast | Estimated | FY, Q | FY+1 | The lowest AFFO / share Forecast submitted by any analyst for the company. |
33 | AFFO / Share Forecast Mean Consensus | affo_share_proj_mean_raw | Yes | Forecast | Estimated | FY, Q | FY+1 | The mean or average AFFO / share Forecast submitted by any analyst for the company. |
34 | AFFO / Share Forecast Median Consensus | affo_share_proj_median_raw | Yes | Forecast | Estimated | FY, Q | FY+1 | The median AFFO / share Forecast submitted by any analyst for the company. |
35 | AFFO / Share Forecast Revision Date | affo_share_proj_revision_date | Yes | Forecast | Forecasts | FY, Q | FY+1 | The date/time at which the current consensus estimate of forecasted AFFO per share was last updated. |
36 | AFFO / Share Forecast Consensus Standard Deviation | affo_share_proj_stdev | Yes | Forecast | Estimated | FY, Q | FY+1 | Standard deviation in forecasted AFFO / share. |
37 | AFFO Yield (Adjusted Funds From Operations) | affo_yield_ltm | Yes | Valuation | Computed | FY, LTM | LTM | Funds from operations (FFO) with adjustments made for recurring capital expenditures used to maintain the underlying assets. Typically used to evaluate REITs. |
38 | Accumulated Allowance for Doubtful Accounts | allow_doubt_acct | Yes | Financials | Balance Sheet | FY, Q | Q | The calculated value of receivables that are deemed to be uncollectible. |
39 | Allowance for Loan Losses | allow_ll | Yes | Bank | Balance Sheet | FY, Q | Q | This item represents allowance for loan losses, which are provided to absorb possible future losses from loans. The allowances are made after a review of the recoverability of the loans made. This item is available only for banks. This item includes 1. Allowance for loan losses and 2. Valuation allowance. This item excludes 1. Undisbursed portion of loans in process, 2. Unearned premiums, 3. Unearned discounts, 4. Net Deferred Loan Origination Fees, and 5. Documented Interest. |
40 | Altman Z-Score | altman_z_score | Yes | Risk | Computed | FY, LTM | LTM | A formula used to predict the probability that a firm will go into bankruptcy within two years. |
41 | Advertising Expense | am | Yes | Financials | Income Statement | FY, Q, LTM, YTD | LTM | This item represents expenditure incurred towards advertising, marketing, promotional and publicity. This data item is extracted for 10Ks only. |
42 | Amortization of Deferred Charges (CF) | amort_def_charges | Yes | Financials | Cash Flow Statement | FY, Q, LTM, YTD | LTM | This item represents both amortization and write-off of deferred expenses. Deferred charges result from prepayment of expenses of capital nature (not represented by tangible assets) whose benefit, usually will extend over a period of years from the time of incurrence and so is carried forward for expenses in future years. |
43 | Amortization Of Film Costs | amort_film_costs | Yes | Financials | Cash Flow Statement | FY, Q, LTM, YTD | LTM | This item represents amortization of costs incurred for film production. This type of expenditure is very common for companies which are in film production and media businesses. |
44 | Amortization of Intangible Assets | amort_intangibles | Yes | Financials | Cash Flow Statement | FY, Q, LTM, YTD | LTM | This item represents the amortization of intangible assets. The amortization returned by this data item reflects the amortization included in the depreciation and amortization used to calculate EBITDA. |
45 | Number of Buy Recommendations | analyst_buy_rec_count | Yes | Valuation | Computed | D | D | The number of analysts publishing a Buy recommendation for the stock. |
46 | Number of Hold Recommendations | analyst_hold_rec_count | Yes | Valuation | Computed | D | D | The number of analysts publishing a Hold recommendation for the stock. |
47 | Count Of Negative EPS Revisions, Last 30 Days | analyst_neg_eps_revisions_30d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a count of analysts that have revised EPS forecasts downwards in the last 30 days (can be 0). |
48 | Count Of Negative EPS Revisions, Last 60 Days | analyst_neg_eps_revisions_60d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a count of analysts that have revised EPS forecasts downwards in the last 60 days (can be 0). |
49 | Count Of Negative EPS Revisions, Last 90 Days | analyst_neg_eps_revisions_90d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a count of analysts that have revised EPS forecasts downwards in the last 90 days (can be 0). |
50 | Negative EPS Revisions Ratio, Last 30 Days | analyst_neg_eps_revisions_ratio_30d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a ratio of analysts that have revised EPS forecasts downwards divided by a count of all analysts covering the company in the last 30 days (can be 0). |
51 | Negative EPS Revisions Ratio, Last 60 Days | analyst_neg_eps_revisions_ratio_60d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a ratio of analysts that have revised EPS forecasts downwards divided by a count of all analysts covering the company in the last 60 days (can be 0). |
52 | Negative EPS Revisions Ratio, Last 90 Days | analyst_neg_eps_revisions_ratio_90d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a ratio of analysts that have revised EPS forecasts downwards divided by a count of all analysts covering the company in the last 90 days (can be 0). |
53 | Number of No Opinion Recommendations | analyst_no_opinion_rec_count | Yes | Valuation | Computed | D | D | The number of analysts publishing a No Opinion recommendation for the stock. |
54 | Number of Outperform Recommendations | analyst_outperform_rec_count | Yes | Valuation | Computed | D | D | The number of analysts publishing an Outperform recommendation for the stock. |
55 | Count Of Positive EPS Revisions, Last 30 Days | analyst_pos_eps_revisions_30d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a count of analysts that have revised EPS forecasts upwards in the last 30 days (can be 0). |
56 | Count Of Positive EPS Revisions, Last 60 Days | analyst_pos_eps_revisions_60d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a count of analysts that have revised EPS forecasts upwards in the last 60 days (can be 0). |
57 | Count Of Positive EPS Revisions, Last 90 Days | analyst_pos_eps_revisions_90d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a count of analysts that have revised EPS forecasts upwards in the last 90 days (can be 0). |
58 | Positive EPS Revisions Ratio, Last 30 Days | analyst_pos_eps_revisions_ratio_30d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a ratio of analysts that have revised EPS forecasts upwards divided by a count of all analysts covering the company in the last 30 days (can be 0). |
59 | Positive EPS Revisions Ratio, Last 60 Days | analyst_pos_eps_revisions_ratio_60d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a ratio of analysts that have revised EPS forecasts upwards divided by a count of all analysts covering the company in the last 60 days (can be 0). |
60 | Positive EPS Revisions Ratio, Last 90 Days | analyst_pos_eps_revisions_ratio_90d | Yes | Forecast | Estimated | FY, Q | Q+1 | Represents a ratio of analysts that have revised EPS forecasts upwards divided by a count of all analysts covering the company in the last 90 days (can be 0). |
61 | Consensus Recommendation | analyst_rec | Yes | Valuation | Computed | D | D | Represents the opinions expressed by analysts on the stock performance over a short-term period. Recommendations are standardized across analysts on a 1-5 point scale, where 1 represents a Strong Buy, 3 indicates a Hold, and 5 signifies a Sell. |
62 | Number of Sell Recommendations | analyst_sell_rec_count | Yes | Valuation | Computed | D | D | The number of analysts publishing a Sell recommendation for the stock. |
63 | Fair Value (Analyst Target) | analyst_target | Yes | Valuation | Computed | D | D | The average of analyst price targets for a stock. Price targets represent what analysts believe a stock will be worth within the next 12 to 18 months. |
64 | Analyst Price Target Count | analyst_target_count | Yes | Valuation | Computed | D | D | The number of analyst price targets tracked for a stock. Price targets represent what analysts believe a stock will be worth within the next 12 to 18 months. |
65 | Downside (Analyst Target) | analyst_target_downside | Yes | Valuation | Computed | FY, Q, LTM | LTM | The percentage decrease (if positive) or increase (if negative) that professional analysts expect over the current stock price. |
66 | Analyst Price Target High | analyst_target_high | Yes | Valuation | Computed | D | D | The highest analyst price target for a stock. Price targets represent what analysts believe a stock will be worth within the next 12 to 18 months. |
67 | Fair Value Label (Analyst Targets) | analyst_target_label | Yes | Predictions | Computed | Fair Value label assigned based on the percentage upside when compared to analyst targets. Value is one of UNAVAILABLE, BARGAIN, UNDERVALUED, FAIR, OVERVALUED, or EXPENSIVE | ||
68 | Analyst Price Target Low | analyst_target_low | Yes | Valuation | Computed | D | D | The lowest analyst price target for a stock. Price targets represent what analysts believe a stock will be worth within the next 12 to 18 months. |
69 | Analyst Price Target Mean | analyst_target_mean | Yes | Valuation | Estimated | D | D | The mean or average analyst price target for a stock. Price targets represent what analysts believe a stock will be worth within the next 12 to 18 months. |
70 | Analyst Price Target Median | analyst_target_median | Yes | Valuation | Estimated | D | D | The median analyst price target for a stock. Price targets represent what analysts believe a stock will be worth within the next 12 to 18 months. |
71 | Analyst Price Target Standard Deviation | analyst_target_stdev | Yes | Valuation | Estimated | D | D | The standard deviation in the analyst price targets for a stock. Price targets represent what analysts believe a stock will be worth within the next 12 to 18 months. |
72 | Upside (Analyst Target) | analyst_target_upside | Yes | Valuation | Computed | FY, Q, LTM | LTM | The percentage increase (if positive) or decrease (if negative) that professional analysts expect over the current stock price. |
73 | Number of Underperform Recommendations | analyst_underperform_rec_count | Yes | Valuation | Computed | D | D | The number of analysts publishing an Underperform recommendation for the stock. |
74 | Accounts Payable | ap | Yes | Financials | Balance Sheet | FY, Q | Q | Amounts payable to vendors extended as a line of credit for normal business purchases. |
75 | Accounts Receivable, Net | ar | Yes | Financials | Balance Sheet | FY, Q | Q | The total amount of collectibles for a company net of receivables that are deemed to be uncollectible. |
76 | Accounts Receivable, Gross | ar_gross | Yes | Financials | Balance Sheet | FY, Q | Q | The total amount of collectibles for a company. |
77 | Asset Efficiency | asset_efficiency | Yes | Risk | Computed | FY, LTM | LTM | A ratio that measures the amount of cash flow that a company generates from its assets. |
78 | Asset Management Fee | asset_mgmt_fee | Yes | Financials | Misc | FY, Q, LTM, YTD | LTM | This item represents the fees earned from managing the assets of a third party. Also includes fees earned on providing banking services like check writing, credit cards and debit cards, brokerage features like buying securities and making loans on margin & the convenience of having all financial transactions listed on one monthly statement. |
79 | 10 Day Moving Avg | asset_price_avg_10d | Yes | Technical | Computed | D | D | The average price over the last 10 trading days. |
80 | 150 Day Moving Avg | asset_price_avg_150d | Yes | Technical | Computed | D | D | The average price over the last 150 trading days. |
81 | 15 Day Moving Avg | asset_price_avg_15d | Yes | Technical | Computed | D | D | The average price over the last 15 trading days. |
82 | 200 Day Moving Avg | asset_price_avg_200d | No | Technical | Computed | D | D | The average price over the last 200 trading days. |
83 | 20 Day Moving Avg | asset_price_avg_20d | Yes | Technical | Computed | D | D | The average price over the last 20 trading days. |
84 | 255 Day Moving Avg | asset_price_avg_255d | Yes | Technical | Computed | D | D | The average price over the last 255 trading days. |
85 | 50 Day Moving Avg | asset_price_avg_50d | No | Technical | Computed | D | D | The average price over the last 50 trading days. |
86 | 5 Day Moving Avg | asset_price_avg_5d | Yes | Technical | Computed | D | D | The average price over the last 5 trading days. |
87 | 7 Day Moving Avg | asset_price_avg_7d | Yes | Technical | Computed | D | D | The average price over the last 7 trading days. |
88 | 9 Day Moving Avg | asset_price_avg_9d | Yes | Technical | Computed | D | D | The average price over the last 9 trading days. |
89 | Stock Price Close (Split Adjusted) | asset_price_close | No | Valuation | Computed | D | D | The price at the close of the last trading day. Price history is adjusted for stock splits only, as applicable. |
90 | Stock Price Close (Div & Split Adjusted) | asset_price_close_adj | No | Valuation | Computed | D | D | The price at the close of the last trading day. Price history is adjusted for stock splits and dividends, as applicable. |
91 | Stock Price Close (Div & Split Adjusted) (Trading Days Only) | asset_price_close_adj_trading | No | Valuation | Computed | D | D | The price at the close of the last trading day. Price history is adjusted for stock splits and dividends, as applicable. Data is returned for trading days only. |
92 | Stock Price Close Date | asset_price_close_date | No | Valuation | Misc | D | D | The date of the stock price. |
93 | Stock Price Close Date (Trading Days Only) | asset_price_close_date_trading | No | Valuation | Computed | D | D | The date of the trading price. Data is returned for trading days only. |
94 | Daily Close (Trading Days Only) | asset_price_close_trading | No | Valuation | Computed | D | D | The trading day's adjusted closing price. Only returns data for trading days. |
95 | Stock Price Close (Unadjusted) | asset_price_close_unadj | No | Valuation | Computed | D | D | The price at the close of the trading day that have not been adjusted for splits and cash dividends. |
96 | Stock Price Close (Unadjusted) (Trading Days Only) | asset_price_close_unadj_trading | No | Valuation | Computed | D | D | The price at the close of the last trading day. Price history is not adjusted for splits and dividends. Data is returned for trading days only. |
97 | Daily Stock Price High (Adjusted) | asset_price_high | Yes | Valuation | Computed | D | D | The highest trade price over the trading day. |
98 | 52 Week High | asset_price_high_52w | No | Valuation | Computed | D | D | The highest trade price over the last year adjusted for stock splits. |
99 | 52 Week High (Div & Split Adjusted) | asset_price_high_adj_52w | No | Valuation | Computed | D | D | The highest trade price over the last year adjusted for stock splits and dividends. |
100 | Stock Price High (Div & Split Adjusted) (Trading Days Only) | asset_price_high_adj_trading | No | Valuation | Computed | D | D | The highest price of the last trading day. Price history is adjusted for splits and dividends. Data is returned for trading days only. |