Que dados financeiros estão disponíveis em Pine?
Todos os dados financeiros disponíveis no Pine estão listados abaixo.
Na primeira coluna de cada tabela estão os nomes de cada métrica. A segunda coluna lista a frequência com que os dados correspondentes são publicados: TTM - Trailing Twelve Months, FY - Financial Year, e FQ - Financial Quarter. A terceira coluna lista os identificadores dos dados financeiros.
Para obter o valor de uma determinada métrica financeira, é necessário utilizar a request.financial() function:
financial(symbol, financial_id, period, gaps)
O primeiro argumento aqui é semelhante ao primeiro argumento da função request.security() , e é o nome do símbolo para o qual a métrica é solicitada. Por exemplo, o nome do símbolo para o qual a métrica é solicitada: "NASDAQ:AAPL".
O segundo argumento é o identificador da métrica requerida: o valor da terceira coluna da tabela.
O terceiro argumento indica a frequência com que esta métrica é publicada: um dos valores das células correspondentes na segunda coluna.
O quarto argumento é opcional e é semelhante ao argumento dos gaps da função de segurança. Se gaps = true, os valores são exibidos apenas em barras correspondentes à data de publicação dos dados.
A função retorna os valores dos dados financeiros solicitados.
Por exemplo:
f = financial ("NASDAQ:AAPL", "ACCOUNTS_PAYABLE", "FQ")Você pode ler mais sobre os dados financeiros aqui.
Observe que quando você solicita dados financeiros usando as funções request.dividends() e request.earnings(), o novo valor é devolvido na barra onde o relatório foi publicado. Usando a função financeira, você obtém um novo valor na barra onde começa o próximo período fiscal.
Índices baseados no preço de mercado
Alguns dos indicadores financeiros no menu Financeiro não estão na tabela abaixo porque são calculados usando uma métrica financeira e o preço atual no gráfico. Isto implica que você não pode solicitar seus valores diretamente, mas você pode calculá-los com algumas linhas de código Pine.
Capitalização de mercado
A capitalização de mercado é igual ao preço da ação multiplicado pelo número de ações em circulação (FQ).
TSO = financial(syminfo.tickerid, "TOTAL_SHARES_OUTSTANDING", "FQ")
MarketCap = TSO*closeRendimento de Ganhos (Earnings Yield)
O rendimento de ganhos é calculado dividindo os ganhos por ação para o último período de 12 meses pelo preço atual de mercado por ação. Multiplicando o resultado por 100 o valor da % de rendimento de ganhos.
EPS = financial(syminfo.tickerid, "EARNINGS_PER_SHARE", "TTM")
EarningsYield = (EPS/close)*100
Preço sobre Valor Patrimonial por Ação
O Preço sobre Valor Patrimonial por Ação é calculado dividindo o preço por ação pelo valor contábil por ação.
BVPS = financial(syminfo.tickerid, "BOOK_VALUE_PER_SHARE", "FQ")
PriceBookRatio = close/BVPSÍndice Preço/Fluxo de Caixa
O índice Preço sobre Fluxo de Caixa é calculado ao multiplicar o preço atual pelas ações diluídas em circulação e dividindo o resultado pelo fluxo de caixa das atividades operacionais.
DSO = request.financial(syminfo.tickerid, "DILUTED_SHARES_OUTSTANDING", "FQ")CFOA = request.financial(syminfo.tickerid, "CASH_F_OPERATING_ACTIVITIES", "TTM")PriceToCashFlowRatio = close * DSO / CFOAplot(PriceToCashFlowRatio)Índice Preço/Lucro
O Índice Preço/Lucro é calculado dividindo o preço atual de mercado por ação pelos ganhos por ação do último período de 12 meses.
EPS = financial(syminfo.tickerid, "EARNINGS_PER_SHARE", "TTM")
PriceEarningsRatio = close/EPSÍndice Preço sobre Fluxo de Caixa Livre
O Índice Preço sobre Fluxo de Caixa Livre é calculado ao dividir o preço atual pelo fluxo de caixa livre por ação.
FCFPS = request.financial(syminfo.tickerid, "FREE_CASH_FLOW_PER_SHARE", "TTM")PriceToFreeCashFlowRatio = close / FCFPSplot(PriceToFreeCashFlowRatio)JavaÍndice de Preços sobre Vendas
O Índice de Preços sobre Vendas é calculado dividindo a capitalização de mercado da empresa por sua receita total durante os últimos doze meses.
TSO = financial(syminfo.tickerid, "TOTAL_SHARES_OUTSTANDING", "FQ")
TR = financial(syminfo.tickerid, "TOTAL_REVENUE", "TTM")
MarketCap = TSO*close
PriseSalesRatio = MarketCap/TRÍndice Preço sobre Valor Contábil Tangível
O Índice Preço sobre o Valor Contábil Tangível é calculado ao dividir o preço por ação pelo valor contábil tangível por ação.
BTPS = request.financial(syminfo.tickerid, "BOOK_TANGIBLE_PER_SHARE", "FQ")PriceToTangibleBookRatio = close / BTPSJavaIncome statements
Financial | Available periods | fin_id |
| After tax other income/expense | FH, FQ, FY | AFTER_TAX_OTHER_INCOME |
| Amortization of deferred charges | FY | AMORTIZATION_OF_DEFERRED_CHARGES |
| Amortization of intangibles | FY | AMORTIZATION_OF_INTANGIBLES |
| Average basic shares outstanding | FH, FQ, FY | BASIC_SHARES_OUTSTANDING |
| Other cost of goods sold | FH, FQ, FY | COST_OF_GOODS_EXCL_DEP_AMORT |
| Cost of goods sold | FH, FQ, FY, TTM | COST_OF_GOODS |
| Deprecation and amortization | FH, FQ, FY, TTM | DEP_AMORT_EXP_INCOME_S |
| Depreciation | FY | DEPRECIATION |
| Diluted net income available to common stockholders | FH, FQ, FY | DILUTED_NET_INCOME |
| Diluted shares outstanding | FH, FQ, FY | DILUTED_SHARES_OUTSTANDING |
| Dilution adjustment | FH, FQ, FY | DILUTION_ADJUSTMENT |
| Discontinued operations | FH, FQ, FY | DISCONTINUED_OPERATIONS |
| Basic earnings per share (Basic EPS) | FH, FQ, FY, TTM | EARNINGS_PER_SHARE_BASIC |
| Diluted earnings per share (Diluted EPS) | FH, FQ, FY, TTM | EARNINGS_PER_SHARE_DILUTED |
| EBIT | FH, FQ, FY, TTM | EBIT |
| EBITDA | FH, FQ, FY, TTM | EBITDA |
| Equity in earnings | FH, FQ, FY | EQUITY_IN_EARNINGS |
| Gross profit | FH, FQ, FY, TTM | GROSS_PROFIT |
| Impairments | FY | IMPAIRMENTS |
| Income Tax Credits | FY | INCOME_TAX_CREDITS |
| Income tax, current - domestic | FY | INCOME_TAX_CURRENT_DOMESTIC |
| Income Tax, current - foreign | FY | INCOME_TAX_CURRENT_FOREIGN |
| Income tax, current | FY | INCOME_TAX_CURRENT |
| Income tax, deferred - domestic | FY | INCOME_TAX_DEFERRED_DOMESTIC |
| Income tax, deferred - foreign | FY | INCOME_TAX_DEFERRED_FOREIGN |
| Income tax, deferred | FY | INCOME_TAX_DEFERRED |
| Taxes | FH, FQ, FY, TTM | INCOME_TAX |
| Interest capitalized | FH, FQ, FY | INTEREST_CAPITALIZED |
| Interest expense on debt | FH, FQ, FY | INTEREST_EXPENSE_ON_DEBT |
| Legal claim expense | FY | LEGAL_CLAIM_EXPENSE |
| Non-controlling/minority interest | FH, FQ, FY | MINORITY_INTEREST_EXP |
| Net income before discontinued operations | FH, FQ, FY | NET_INCOME_BEF_DISC_OPER |
| Net income | FH, FQ, FY, TTM | NET_INCOME |
| Non-operating income, excl. interest expenses | FH, FQ, FY | NON_OPER_INCOME |
| Interest expense, net of interest capitalized | FH, FQ, FY | NON_OPER_INTEREST_EXP |
| Non-operating interest income | FH, FQ, FY | NON_OPER_INTEREST_INCOME |
| Operating income | FH, FQ, FY, TTM | OPER_INCOME |
| Operating expenses (excl. COGS) | FH, FQ, FY | OPERATING_EXPENSES |
| Other exceptional charges | FY | OTHER_EXCEPTIONAL_CHARGES |
| Miscellaneous non-operating expense | FH, FQ, FY | OTHER_INCOME |
| Other operating expenses, total | FH, FQ, FY | OTHER_OPER_EXPENSE_TOTAL |
| Preferred dividends | FH, FQ, FY | PREFERRED_DIVIDENDS |
| Pretax equity in earnings | FH, FQ, FY | PRETAX_EQUITY_IN_EARNINGS |
| Pretax income | FH, FQ, FY, TTM | PRETAX_INCOME |
| Research & development | FH, FQ, FY | RESEARCH_AND_DEV |
| Restructuring charge | FY | RESTRUCTURING_CHARGE |
| Selling/general/admin expenses, other | FH, FQ, FY | SELL_GEN_ADMIN_EXP_OTHER |
| Selling/general/admin expenses, total | FH, FQ, FY | SELL_GEN_ADMIN_EXP_TOTAL |
| Non-operating income, total | FH, FQ, FY, TTM | TOTAL_NON_OPER_INCOME |
| Total operating expenses | FH, FQ, FY, TTM | TOTAL_OPER_EXPENSE |
| Total revenue | FH, FQ, FY, TTM | TOTAL_REVENUE |
| Unrealized gain/loss | FY | UNREALIZED_GAIN_LOSS |
| Unusual income/expense | FH, FQ, FY | UNUSUAL_EXPENSE_INC |
Balance sheet
Financial | Available periods | fin_id |
| Accounts payable | FH, FQ, FY | ACCOUNTS_PAYABLE |
| Accounts receivables, gross | FY | ACCOUNTS_RECEIVABLES_GROSS |
| Accounts receivable - trade, net | FH, FQ, FY | ACCOUNTS_RECEIVABLES_NET |
| Accrued payroll | FH, FQ, FY | ACCRUED_PAYROLL |
| Accumulated depreciation - Buildings | FY | ACCUM_DEPREC_BUILDINGS |
| Accumulated depreciation - Computer software and equipment | FY | ACCUM_DEPREC_COMP_SOFT |
| Accumulated depreciation - Construction in progress | FY | ACCUM_DEPREC_CONSTRUCTION |
| Accumulated depreciation - Land & improvement | FY | ACCUM_DEPREC_LAND |
| Accumulated depreciation - Leased property | FY | ACCUM_DEPREC_LEASED_PROP |
| Accumulated depreciation - Leases | FY | ACCUM_DEPREC_LEASES |
| Accumulated depreciation - Machinery & equipment | FY | ACCUM_DEPREC_MACHINERY |
| Accumulated depreciation - Other | FY | ACCUM_DEPREC_OTHER |
| Accumulated amortization of other intangibles | FY | ACCUM_DEPREC_OTHER_INTANG |
| Accumulated depreciation, total | FH, FQ, FY | ACCUM_DEPREC_TOTAL |
| Accumulated depreciation - Transportation equipment | FY | ACCUM_DEPREC_TRANS_EQUIP |
| Additional paid-in capital/Capital surplus | FH, FQ, FY | ADDITIONAL_PAID_IN_CAPITAL |
| Tangible book value per share | FH, FQ, FY | BOOK_TANGIBLE_PER_SHARE |
| Book value per share | FH, FQ, FY | BOOK_VALUE_PER_SHARE |
| Capitalized lease obligations | FH, FQ, FY | CAPITAL_LEASE_OBLIGATIONS |
| Capital and operating lease obligations | FH, FQ, FY | CAPITAL_OPERATING_LEASE_OBLIGATIONS |
| Cash & equivalents | FH, FQ, FY | CASH_N_EQUIVALENTS |
| Cash and short term investments | FH, FQ, FY | CASH_N_SHORT_TERM_INVEST |
| Common equity, total | FH, FQ, FY | COMMON_EQUITY_TOTAL |
| Common stock par/Carrying value | FH, FQ, FY | COMMON_STOCK_PAR |
| Current portion of LT debt and capital leases | FH, FQ, FY | CURRENT_PORT_DEBT_CAPITAL_LEASES |
| Deferred charges | FH, FQ, FY | DEFERRED_CHARGES |
| Deferred income, current | FH, FQ, FY | DEFERRED_INCOME_CURRENT |
| Deferred income, non-current | FH, FQ, FY | DEFERRED_INCOME_NON_CURRENT |
| Deferred tax assets | FH, FQ, FY | DEFERRED_TAX_ASSESTS |
| Deferred tax liabilities | FH, FQ, FY | DEFERRED_TAX_LIABILITIES |
| Dividends payable | FY | DIVIDENDS_PAYABLE |
| Bad debt / Doubtful accounts | FY | DOUBTFUL_ACCOUNTS |
| Accumulated goodwill amortization | FY | GOODWILL_AMORTIZATION |
| Goodwill, net | FH, FQ, FY | GOODWILL |
| Goodwill, gross | FY | GOODWILL_GROSS |
| Income tax payable | FH, FQ, FY | INCOME_TAX_PAYABLE |
| Net intangible assets | FH, FQ, FY | INTANGIBLES_NET |
| Inventories - finished goods | FH, FQ, FY | INVENTORY_FINISHED_GOODS |
| Inventories - progress payments & other | FH, FQ, FY | INVENTORY_PROGRESS_PAYMENTS |
| Inventories - raw materials | FH, FQ, FY | INVENTORY_RAW_MATERIALS |
| Inventories - work in progress | FH, FQ, FY | INVENTORY_WORK_IN_PROGRESS |
| Investments in unconsolidated subsidiaries | FH, FQ, FY | INVESTMENTS_IN_UNCONCSOLIDATE |
| Long term debt excl. lease liabilities | FH, FQ, FY | LONG_TERM_DEBT_EXCL_CAPITAL_LEASE |
| Long term debt | FH, FQ, FY | LONG_TERM_DEBT |
| Long term investments | FH, FQ, FY | LONG_TERM_INVESTMENTS |
| Note receivable - long term | FH, FQ, FY | LONG_TERM_NOTE_RECEIVABLE |
| Other long term assets, total | FH, FQ, FY | LONG_TERM_OTHER_ASSETS_TOTAL |
| Minority interest | FH, FQ, FY | MINORITY_INTEREST |
| Net debt | FH, FQ, FY | NET_DEBT |
| Notes payable | FY | NOTES_PAYABLE_SHORT_TERM_DEBT |
| Operating lease liabilities | FH, FQ, FY | OPERATING_LEASE_LIABILITIES |
| Other common equity | FH, FQ, FY | OTHER_COMMON_EQUITY |
| Other current assets, total | FH, FQ, FY | OTHER_CURRENT_ASSETS_TOTAL |
| Other current liabilities | FH, FQ, FY | OTHER_CURRENT_LIABILITIES |
| Other intangibles, gross | FY | OTHER_INTANGIBLES_GROSS |
| Other intangibles, net | FH, FQ, FY | OTHER_INTANGIBLES_NET |
| Other investments | FH, FQ, FY | OTHER_INVESTMENTS |
| Other non-current liabilities, total | FH, FQ, FY | OTHER_LIABILITIES_TOTAL |
| Other receivables | FQ, FY | OTHER_RECEIVABLES |
| Other short term debt | FY | OTHER_SHORT_TERM_DEBT |
| Paid in capital | FH, FQ, FY | PAID_IN_CAPITAL |
| Property/plant/equipment - Buildings | FY | PPE_GROSS_BUILDINGS |
| Property/plant/equipment - Computer software and equipment | FY | PPE_GROSS_COMP_SOFT |
| Property/plant/equipment - Construction in progress | FY | PPE_GROSS_CONSTRUCTION |
| Property/plant/equipment - Land & improvement | FY | PPE_GROSS_LAND |
| Property/plant/equipment - Leased property | FY | PPE_GROSS_LEASED_PROP |
| Property/plant/equipment - Leases | FY | PPE_GROSS_LEASES |
| Property/plant/equipment - Machinery & equipment | FY | PPE_GROSS_MACHINERY |
| Property/plant/equipment - Other | FY | PPE_GROSS_OTHER |
| Property/plant/equipment - Transportation equipment | FY | PPE_GROSS_TRANS_EQUIP |
| Gross property/plant/equipment | FH, FQ, FY | PPE_TOTAL_GROSS |
| Net property/plant/equipment | FH, FQ, FY | PPE_TOTAL_NET |
| Preferred stock, carrying value | FH, FQ, FY | PREFERRED_STOCK_CARRYING_VALUE |
| Prepaid expenses | FH, FQ, FY | PREPAID_EXPENSES |
| Provision for risks & charge | FH, FQ, FY | PROVISION_F_RISKS |
| Retained earnings | FH, FQ, FY | RETAINED_EARNINGS |
| Short term debt excl. current portion of LT debt | FH, FQ, FY | SHORT_TERM_DEBT_EXCL_CURRENT_PORT |
| Short term debt | FH, FQ, FY | SHORT_TERM_DEBT |
| Short term investments | FH, FQ, FY | SHORT_TERM_INVEST |
| Shareholders' equity | FH, FQ, FY | SHRHLDRS_EQUITY |
| Total assets | FH, FQ, FY | TOTAL_ASSETS |
| Total current assets | FH, FQ, FY | TOTAL_CURRENT_ASSETS |
| Total current liabilities | FH, FQ, FY | TOTAL_CURRENT_LIABILITIES |
| Total debt | FH, FQ, FY | TOTAL_DEBT |
| Total equity | FH, FQ, FY | TOTAL_EQUITY |
| Total inventory | FH, FQ, FY | TOTAL_INVENTORY |
| Total liabilities | FH, FQ, FY | TOTAL_LIABILITIES |
| Total liabilities & shareholders' equities | FH, FQ, FY | TOTAL_LIABILITIES_SHRHLDRS_EQUITY |
| Total non-current assets | FH, FQ, FY | TOTAL_NON_CURRENT_ASSETS |
| Total non-current liabilities | FH, FQ, FY | TOTAL_NON_CURRENT_LIABILITIES |
| Total receivables, net | FH, FQ, FY | TOTAL_RECEIVABLES_NET |
| Treasury stock - common | FH, FQ, FY | TREASURY_STOCK_COMMON |
Cash flow
Financial | Available periods | fin_id |
| Amortization | FH, FQ, FY | AMORTIZATION |
| Capital expenditures | FH, FQ, FY | CAPITAL_EXPENDITURES |
| Capital expenditures - fixed assets | FH, FQ, FY | CAPITAL_EXPENDITURES_FIXED_ASSETS |
| Capital expenditures - other assets | FH, FQ, FY | CAPITAL_EXPENDITURES_OTHER_ASSETS |
| Cash from financing activities | FH, FQ, FY, TTM | CASH_F_FINANCING_ACTIVITIES |
| Cash from investing activities | FH, FQ, FY, TTM | CASH_F_INVESTING_ACTIVITIES |
| Cash from operating activities | FH, FQ, FY, TTM | CASH_F_OPERATING_ACTIVITIES |
| Deferred taxes (cash flow) | FH, FQ, FY | CASH_FLOW_DEFERRED_TAXES |
| Depreciation & amortization (cash flow) | FH, FQ, FY | CASH_FLOW_DEPRECATION_N_AMORTIZATION |
| Change in accounts payable | FH, FQ, FY | CHANGE_IN_ACCOUNTS_PAYABLE |
| Change in accounts receivable | FH, FQ, FY | CHANGE_IN_ACCOUNTS_RECEIVABLE |
| Change in accrued expenses | FH, FQ, FY | CHANGE_IN_ACCRUED_EXPENSES |
| Change in inventories | FH, FQ, FY | CHANGE_IN_INVENTORIES |
| Change in other assets/liabilities | FH, FQ, FY | CHANGE_IN_OTHER_ASSETS |
| Change in taxes payable | FH, FQ, FY | CHANGE_IN_TAXES_PAYABLE |
| Changes in working capital | FH, FQ, FY | CHANGES_IN_WORKING_CAPITAL |
| Common dividends paid | FH, FQ, FY | COMMON_DIVIDENDS_CASH_FLOW |
| Depreciation/depletion | FH, FQ, FY | DEPRECIATION_DEPLETION |
| Free cash flow | FH, FQ, FY, TTM | FREE_CASH_FLOW |
| Funds from operations | FH, FQ, FY | FUNDS_F_OPERATIONS |
| Issuance/retirement of debt, net | FH, FQ, FY | ISSUANCE_OF_DEBT_NET |
| Issuance/retirement of long term debt | FH, FQ, FY | ISSUANCE_OF_LONG_TERM_DEBT |
| Issuance/retirement of other debt | FH, FQ, FY | ISSUANCE_OF_OTHER_DEBT |
| Issuance/retirement of short term debt | FH, FQ, FY | ISSUANCE_OF_SHORT_TERM_DEBT |
| Issuance/retirement of stock, net | FH, FQ, FY | ISSUANCE_OF_STOCK_NET |
| Net income (cash flow) | FH, FQ, FY | NET_INCOME_STARTING_LINE |
| Non-cash items | FH, FQ, FY | NON_CASH_ITEMS |
| Other financing cash flow items, total | FH, FQ, FY | OTHER_FINANCING_CASH_FLOW_ITEMS_TOTAL |
| Financing activities - other sources | FH, FQ, FY | OTHER_FINANCING_CASH_FLOW_SOURCES |
| Financing activities - other uses | FH, FQ, FY | OTHER_FINANCING_CASH_FLOW_USES |
| Other investing cash flow items, total | FH, FQ, FY | OTHER_INVESTING_CASH_FLOW_ITEMS_TOTAL |
| Investing activities - other sources | FH, FQ, FY | OTHER_INVESTING_CASH_FLOW_SOURCES |
| Investing activities - other uses | FH, FQ, FY | OTHER_INVESTING_CASH_FLOW_USES |
| Preferred dividends paid | FH, FQ, FY | PREFERRED_DIVIDENDS_CASH_FLOW |
| Purchase/acquisition of business | FH, FQ, FY | PURCHASE_OF_BUSINESS |
| Purchase of investments | FH, FQ, FY | PURCHASE_OF_INVESTMENTS |
| Repurchase of common & preferred stock | FH, FQ, FY | PURCHASE_OF_STOCK |
| Purchase/sale of business, net | FH, FQ, FY | PURCHASE_SALE_BUSINESS |
| Purchase/sale of investments, net | FH, FQ, FY | PURCHASE_SALE_INVESTMENTS |
| Reduction of long term debt | FH, FQ, FY | REDUCTION_OF_LONG_TERM_DEBT |
| Sale of common & preferred stock | FH, FQ, FY | SALE_OF_STOCK |
| Sale of fixed assets & businesses | FH, FQ, FY | SALES_OF_BUSINESS |
| Sale/maturity of investments | FH, FQ, FY | SALES_OF_INVESTMENTS |
| Issuance of long term debt | FH, FQ, FY | SUPPLYING_OF_LONG_TERM_DEBT |
| Total cash dividends paid | FH, FQ, FY | TOTAL_CASH_DIVIDENDS_PAID |
Statistics
Financial | Available periods | fin_id |
| Accruals | FH, FQ, FY | ACCRUALS_RATIO |
| Altman Z-score | FH, FQ, FY | ALTMAN_Z_SCORE |
| Asset turnover | FH, FQ, FY | ASSET_TURNOVER |
| Beneish M-score | FQ, FY | BENEISH_M_SCORE |
| Buyback yield % | FH, FQ, FY | BUYBACK_YIELD |
| Cash conversion cycle | FQ, FY | CASH_CONVERSION_CYCLE |
| Cash to debt ratio | FH, FQ, FY | CASH_TO_DEBT |
| COGS to revenue ratio | FH, FQ, FY | COGS_TO_REVENUE |
| Current ratio | FH, FQ, FY | CURRENT_RATIO |
| Days sales outstanding | FQ, FY | DAY_SALES_OUT |
| Days inventory | FQ, FY | DAYS_INVENT |
| Days payable | FQ, FY | DAYS_PAY |
| Debt to assets ratio | FH, FQ, FY | DEBT_TO_ASSET |
| Debt to EBITDA ratio | FH, FQ, FY | DEBT_TO_EBITDA |
| Debt to equity ratio | FH, FQ, FY | DEBT_TO_EQUITY |
| Debt to revenue ratio | FH, FQ, FY | DEBT_TO_REVENUE |
| Dividend payout ratio % | FH, FQ, FY, TTM | DIVIDEND_PAYOUT_RATIO |
| Dividend yield % | FH, FQ, FY | DIVIDENDS_YIELD |
| Dividends per share - common stock primary issue | FH, FQ, FY, TTM | DPS_COMMON_STOCK_PRIM_ISSUE |
| EPS estimates | FH, FQ, FY | EARNINGS_ESTIMATE |
| EPS basic one year growth % | FH, FQ, FY, TTM | EARNINGS_PER_SHARE_BASIC_ONE_YEAR_GROWTH |
| EPS diluted one year growth % | FH, FQ, FY | EARNINGS_PER_SHARE_DILUTED_ONE_YEAR_GROWTH |
| EBITDA margin % | FH, FQ, FY, TTM | EBITDA_MARGIN |
| EBITDA per employee | FY | EBITDA_PER_EMPLOYEE |
| Effective interest rate on debt % | FH, FQ, FY | EFFECTIVE_INTEREST_RATE_ON_DEBT |
| Enterprise value to EBITDA ratio | FH, FQ, FY | ENTERPRISE_VALUE_EBITDA |
| Enterprise value | FH, FQ, FY | ENTERPRISE_VALUE |
| Equity to assets ratio | FH, FQ, FY | EQUITY_TO_ASSET |
| Enterprise value to EBIT ratio | FH, FQ, FY | EV_EBIT |
| Enterprise value to revenue ratio | FH, FQ, FY | EV_REVENUE |
| Float shares outstanding | FY | FLOAT_SHARES_OUTSTANDING |
| Free cash flow margin % | FH, FQ, FY | FREE_CASH_FLOW_MARGIN |
| Free cash flow per employee | FY | FREE_CASH_FLOW_PER_EMPLOYEE |
| Fulmer H factor | FQ, FY | FULMER_H_FACTOR |
| Goodwill to assets ratio | FH, FQ, FY | GOODWILL_TO_ASSET |
| Graham's number | FQ, FY | GRAHAM_NUMBERS |
| Gross margin % | FH, FQ, FY, TTM | GROSS_MARGIN |
| Gross profit to assets ratio | FQ, FY | GROSS_PROFIT_TO_ASSET |
| Interest coverage | FH, FQ, FY | INTERST_COVER |
| Inventory to revenue ratio | FH, FQ, FY | INVENT_TO_REVENUE |
| Inventory turnover | FH, FQ, FY | INVENT_TURNOVER |
| KZ index | FY | KZ_INDEX |
| Long term debt to total assets ratio | FH, FQ, FY | LONG_TERM_DEBT_TO_ASSETS |
| Long term debt to total equity ratio | FH, FQ, FY | LONG_TERM_DEBT_TO_EQUITY |
| Net current asset value per share | FQ, FY | NCAVPS_RATIO |
| Net debt to EBITDA ratio | FH, FQ, FY | NET_DEBT_TO_EBITDA |
| Net income per employee | FY | NET_INCOME_PER_EMPLOYEE |
| Net margin % | FH, FQ, FY, TTM | NET_MARGIN |
| Number of employees | FY | NUMBER_OF_EMPLOYEES |
| Operationg income per employee | FY | OPER_INCOME_PER_EMPLOYEE |
| Operating earnings yield % | FH, FQ, FY | OPERATING_EARNINGS_YIELD |
| Operating margin % | FH, FQ, FY | OPERATING_MARGIN |
| Piotroski F-score | FH, FQ, FY | PIOTROSKI_F_SCORE |
| Price earnings ratio forward | FQ, FY | PRICE_EARNINGS_FORWARD |
| Price sales ratio forward | FQ, FY | PRICE_SALES_FORWARD |
| Quality ratio | FH, FQ, FY | QUALITY_RATIO |
| Quick ratio | FH, FQ, FY | QUICK_RATIO |
| Research & development per employee | FY | RESEARCH_AND_DEV_PER_EMPLOYEE |
| Research & development to revenue ratio % | FH, FQ, FY | RESEARCH_AND_DEVELOP_TO_REVENUE |
| Return on assets % | FH, FQ, FY | RETURN_ON_ASSETS |
| Return on common equity % | FH, FQ, FY | RETURN_ON_COMMON_EQUITY |
| Return on equity adjusted to book value % | FH, FQ, FY | RETURN_ON_EQUITY_ADJUST_TO_BOOK |
| Return on equity % | FH, FQ, FY | RETURN_ON_EQUITY |
| Return on invested capital % | FH, FQ, FY | RETURN_ON_INVESTED_CAPITAL |
| Return on tangible assets % | FH, FQ, FY | RETURN_ON_TANG_ASSETS |
| Return on tangible equity % | FH, FQ, FY | RETURN_ON_TANG_EQUITY |
| Revenue one year growth % | FH, FQ, FY, TTM | REVENUE_ONE_YEAR_GROWTH |
| Revenue per employee | FY | REVENUE_PER_EMPLOYEE |
| Revenue estimates | FH, FQ, FY | SALES_ESTIMATES |
| Shares buyback ratio % | FH, FQ, FY | SHARE_BUYBACK_RATIO |
| Sloan ratio % | FH, FQ, FY | SLOAN_RATIO |
| Springate score | FQ, FY | SPRINGATE_SCORE |
| Sustainable growth rate | FQ, FY | SUSTAINABLE_GROWTH_RATE |
| Tangible common equity ratio | FH, FQ, FY | TANGIBLE_COMMON_EQUITY_RATIO |
| Tobin's Q (approximate) | FH, FQ, FY | TOBIN_Q_RATIO |
| Total assets per employee | FY | TOTAL_ASSETS_PER_EMPLOYEE |
| Total debt per employee | FY | TOTAL_DEBT_PER_EMPLOYEE |
| Total common shares outstanding | FH, FQ, FY | TOTAL_SHARES_OUTSTANDING |
| Zmijewski score | FQ, FY | ZMIJEWSKI_SCORE |
STATISTICS - ETF-specific
Financial | Available periods | fin_id |
| Net Asset Value | D | NAV |
| Net Asset Value All | D | NAV_ALL |
| Fund Flows | D | FUND_FLOWS |
| Assets under Management | D | AUM |