Quali dati finanziari sono disponibili su Pine?

Tutti i dati finanziari disponibili su Pine sono elencati qui sotto.

Nella prima colonna di ogni tabella ci sono i nomi delle varie metriche di riferimento. Nella seconda la frequenza con cui questi dati sono disponibili: TTM - ("Trailing Twelve Months", ultimi 12 mesi), FY - ("Fiscal Year", anno fiscale), FQ - ("Financial Quarter", trimestre fiscale). Nella terza le sigle identificative con cui richiamare ogni input nel codice.

Al fine di ottenere un valore di un dato finanziario, devi usare la funzione request.financial():

request.financial(simbolo, financial_id, periodo).

Il primo argomento è simile a quello utilizzato comunemente nella funzione request.security, e corrisponde al nome dello strumento finanziario a cui deve fare riferimento il dato (es, ”NASDAQ:AAPL”).

Il secondo argomento è la sigla identificativa per scegliere la metrica in esame, come elencata nella terza colonna della tabella sottostante.

Il terzo argomento indica il periodo da prendere in considerazione, e può essere selezionato in base alle opzioni presenti nella seconda colonna.

Il quarto e ultimo argomento (opzionale) è simile al gaps già noto per la funzione security: se gaps = true, i valori sono mostrati solo nelle barre in corrispondenza della data di pubblicazione del dato.

La funzione restituisce i valori per la metrica richiesta.

Ad esempio:

f = request.financial ("NASDAQ:AAPL", "ACCOUNTS_PAYABLE", "FQ")

Java

Per maggiori informazioni generali sui dati finanziari, consulta questa soluzione.

Tieni a mente che richiedendo i dati finanziari tramite le funzioni request.dividends() e request.earnings(), questi saranno restituiti in corrispondenza della barra durante la quale sono stati rilasciati al pubblico, mentre con la funzione financial si ottiene un nuovo valore in corrispondenza della barra in cui comincia il successivo periodo fiscale.

Indici basati sul prezzo di mercato

Alcuni degli indicatori finanziari presenti nel menù dedicato non sono inclusi nella tabella sottostante perché sono frutto di un calcolo aritmetico tra un valore finanziario ed il prezzo corrente, e come tali non possono essere ottenuti direttamente nella forma finale ma semmai tramite il suddetto calcolo (per cui sono sufficienti poche linee di codice):

Capitalizzazione di mercato

La capitalizzazione di mercato è uguale al prezzo di un'azione moltiplicato per il numero di azioni circolanti (TOTAL_SHARES_OUTSTANDING, FQ).

TSO = request.financial(syminfo.tickerid, "TOTAL_SHARES_OUTSTANDING", "FQ")

MarketCap = TSO * close

Rendimento utili (Earnings Yield)

Il rendimento degli utili è calcolato dividendo gli utili per azione (EARNINGS_PER_SHARE) negli ultimi 12 mesi per il prezzo corrente di un'azione, e poi moltiplicando il tutto per 100 al fine di ottenere il valore percentuale.

EPS = request.financial(syminfo.tickerid, "EARNINGS_PER_SHARE", "TTM")EarningsYield = (EPS / close) * 100

Java

Rapporto prezzo / valore contabile (Price Book Ratio)

Il rapporto tra prezzo e valore contabile si ottiene dividendo il prezzo corrente di un'azione per il suo valore contabile del patrimonio netto (BOOK_VALUE_PER_SHARE).

BVPS = request.financial(syminfo.tickerid, "BOOK_VALUE_PER_SHARE", "FQ")

PriceBookRatio = close / BVPS

Rapporto prezzo / flusso di cassa (Price to Cash Flow Ratio)

Il rapporto tra prezzo e flusso di cassa è calcolato moltiplicando il prezzo corrente per le azioni diluite in circolazione e dividendo il risultato per la liquidità derivante dalle attività operative.

DSO = request.financial(syminfo.tickerid, "DILUTED_SHARES_OUTSTANDING", "FQ")

CFOA = request.financial(syminfo.tickerid, "CASH_F_OPERATING_ACTIVITIES", "TTM") PriceToCashFlowRatio = close * DSO / CFOA

plot(PriceToCashFlowRatio)

Rapporto prezzo / utili (Price Earnings Ratio)

Il rapporto tra prezzo e utili si calcola dividendo il prezzo corrente di un'azione per gli utili generati negli ultimi 12 mesi (EARNINGS_PER_SHARE).

EPS = request.financial(syminfo.tickerid, "EARNINGS_PER_SHARE", "TTM")

PriceEarningsRatio = close / EPS

Rapporto prezzo / flusso di cassa libero (Price to Free Cash Flow Ratio)

Il rapporto tra prezzo e flusso di cassa libero è calcolato dividendo il prezzo corrente per il flusso di cassa libero per azione.

FCFPS = request.financial(syminfo.tickerid, "FREE_CASH_FLOW_PER_SHARE", "TTM") PriceToFreeCashFlowRatio = close / FCFPS

plot(PriceToFreeCashFlowRatio)

Rapporto prezzo / vendite (Price Sales Ratio)

Tale rapporto si ottiene dividendo la capitalizzazione di mercato della società per il fatturato totale accumulato nell'arco degli ultimi 12 mesi.

TSO = request.financial(syminfo.tickerid, "TOTAL_SHARES_OUTSTANDING", "FQ")

TR = request.financial(syminfo.tickerid, "TOTAL_REVENUE", "TTM")

MarketCap = TSO * close

PriseSalesRatio = MarketCap / TR

Rapporto prezzo / valore contabile tangibile (Price to Tangible Book Ratio)

Il rapporto tra prezzo e valore contabile tangibile è calcolato dividendo il prezzo per azione per il valore contabile tangibile per azione.

BTPS = request.financial(syminfo.tickerid, "BOOK_TANGIBLE_PER_SHARE", "FQ")

PriceToTangibleBookRatio = close / BTPS

CONTI ECONOMICI

Dato finanziario	Periodo di riferimento	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

BILANCIO

Dato finanziario	Periodo di riferimento	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

FLUSSO DI CASSA

Dato finanziario	Periodo di riferimento	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

STATISTICHE

Dato finanziario	Periodo di riferimento	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

STATISCHE SPECIFICHE PER ETF

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

Come si può mettere a commento più linee?

Come ottengo i parametri per la funzione integrata quandl?