TradingView

What financial data is available in Pine?

All financial data available in Pine is listed below.

In the first column of each table are the names of each metric. The second column lists how frequently the corresponding data is published: TTM - Trailing Twelve Months, FY - Financial Year, and FQ - Financial Quarter. The third column lists the identifiers of the financial data.

In order to get the value of a certain financial metric, you need to use the function:

financial(symbol, financial_id, period, gaps)

The first argument here is similar to the first argument of the security function, and is the name of the symbol for which the metric is requested. For example: ”NASDAQ:AAPL”.

The second argument is the identifier of the required metric: the value from the third column of the table.

The third argument indicates how frequently this metric is published: one of the values from the corresponding cells in the second column.

The fourth argument is optional and is similar to the gaps argument of the security function. If gaps = true, values are displayed only on bars corresponding to the publication date of the data.

The function returns the values of the requested financial data.

For example:

f = financial (“NASDAQ:AAPL”, “ACCOUNTS_PAYABLE”, “FQ”)

You can read more about the financial data here.

Income Statements

Financial	Available periods	financial_id
After Tax Other Income/Expense	FQ, FY	AFTER_TAX_OTHER_INCOME
Average Basic Shares Outstanding	FQ, FY	BASIC_SHARES_OUTSTANDING
Other COGS	FQ, FY	COST_OF_GOODS_EXCL_DEP_AMORT
Cost of Goods	FQ, FY	COST_OF_GOODS
Deprecation and Amortization	FQ, FY	DEP_AMORT_EXP_INCOME_S
Diluted Net Income Available to Common Stockholders	FQ, FY	DILUTED_NET_INCOME
Diluted Shares Outstanding	FQ, FY	DILUTED_SHARES_OUTSTANDING
Dilution Adjustment	FQ, FY	DILUTION_ADJUSTMENT
Discontinued Operations	FQ, FY	DISCONTINUED_OPERATIONS
Basic EPS	FQ, FY, TTM	EARNINGS_PER_SHARE_BASIC
Diluted EPS	FQ, FY, TTM	EARNINGS_PER_SHARE
EBITDA	FQ, FY, TTM	EBITDA
Equity In Earnings	FQ, FY	EQUITY_IN_EARNINGS
Gross Profit	FQ, FY	GROSS_PROFIT
Taxes	FQ, FY	INCOME_TAX
Non-Controlling/Minority interest	FQ, FY	MINORITY_INTEREST_EXP
Net Income Before Discontinued Operations	FQ, FY	NET_INCOME_BEF_DISC_OPER
Net Income	FQ, FY	NET_INCOME
Non-Operating Income, excl. Interest Expenses	FQ, FY	NON_OPER_INCOME
Interest Expense, Net of Interest Capitalized	FQ, FY	NON_OPER_INTEREST_EXP
Non-Operating Interest Income	FQ, FY	NON_OPER_INTEREST_INCOME
Operating Income	FQ, FY	OPER_INCOME
Operating Expenses (excl. COGS)	FQ, FY	OPERATING_EXPENSES
Miscellaneous Non-Operating Expense	FQ, FY	OTHER_INCOME
Other Operating Expenses, Total	FQ, FY	OTHER_OPER_EXPENSE_TOTAL
Preferred Dividends	FQ, FY	PREFERRED_DIVIDENDS
Pretax Equity In Earnings	FQ, FY	PRETAX_EQUITY_IN_EARNINGS
Pretax Income	FQ, FY	PRETAX_INCOME
Research & Development	FQ, FY	RESEARCH_AND_DEV
Selling/General/Admin Expenses, Other	FQ, FY	SELL_GEN_ADMIN_EXP_OTHER
Selling/General/Admin Expenses, Total	FQ, FY	SELL_GEN_ADMIN_EXP_TOTAL
Non-Operating Income, Total	FQ, FY	TOTAL_NON_OPER_INCOME
Total Operating Expenses	FQ, FY	TOTAL_OPER_EXPENSE
Total Revenue	FQ, FY	TOTAL_REVENUE
Unusual Expense (Income)	FQ, FY	UNUSUAL_EXPENSE_INC

Balance Sheet

Financial	Available periods	financial_id
Accounts Payable	FQ, FY	ACCOUNTS_PAYABLE
Accounts Receivable - Trade, Net	FQ, FY	ACCOUNTS_RECEIVABLES_NET
Accrued Payroll	FQ, FY	ACCRUED_PAYROLL
Accumulated Depreciation, Total	FQ, FY	ACCUM_DEPREC_TOTAL
Book Value Per Share	FQ, FY	BOOK_VALUE_PER_SHARE
Capital and Operating Lease Obligations	FQ, FY	CAPITAL_OPERATING_LEASE_OBLIGATIONS
Cash & Equivalents	FQ, FY	CASH_N_EQUIVALENTS
Cash and Short Term Investments	FQ, FY	CASH_N_SHORT_TERM_INVEST
Common Equity, Total	FQ, FY	COMMON_EQUITY_TOTAL
Current Port. of LT Debt/Capital Leases	FQ, FY	CURRENT_PORT_DEBT_CAPITAL_LEASES
Deferred Income, Current	FQ, FY	DEFERRED_INCOME_CURRENT
Deferred Income, Non-Current	FQ, FY	DEFERRED_INCOME_NON_CURRENT
Deferred Tax Assets	FQ, FY	DEFERRED_TAX_ASSESTS
Deferred Tax Liabilities	FQ, FY	DEFERRED_TAX_LIABILITIES
Dividends Payable	FY	DIVIDENDS_PAYABLE
Goodwill, Net	FQ, FY	GOODWILL
Income Tax Payable	FQ, FY	INCOME_TAX_PAYABLE
Net Intangible Assets	FQ, FY	INTANGIBLES_NET
Inventories - Finished Goods	FQ, FY	INVENTORY_FINISHED_GOODS
Inventories - Progress Payments & Other	FQ, FY	INVENTORY_PROGRESS_PAYMENTS
Inventories - Raw Materials	FQ, FY	INVENTORY_RAW_MATERIALS
Inventories - Work In Progress	FQ, FY	INVENTORY_WORK_IN_PROGRESS
Investments in Unconsolidated Subsidiaries	FQ, FY	INVESTMENTS_IN_UNCONCSOLIDATE
Long Term Debt Excluding Lease Liabilities	FQ, FY	LONG_TERM_DEBT_EXCL_CAPITAL_LEASE
Long Term Debt	FQ, FY	LONG_TERM_DEBT
Long Term Investments	FQ, FY	LONG_TERM_INVESTMENTS
Note Receivable - Long Term	FQ, FY	LONG_TERM_NOTE_RECEIVABLE
Other Long Term Assets, Total	FQ, FY	LONG_TERM_OTHER_ASSETS_TOTAL
Minority Interest	FQ, FY	MINORITY_INTEREST
Other Common Equity	FQ, FY	OTHER_COMMON_EQUITY
Other Current Assets, Total	FQ, FY	OTHER_CURRENT_ASSETS_TOTAL
Other Current Liabilities	FQ, FY	OTHER_CURRENT_LIABILITIES
Net Other Intangibles	FQ, FY	OTHER_INTANGIBLES_NET
Other Investments	FQ, FY	OTHER_INVESTMENTS
Other Liabilities, Total	FQ, FY	OTHER_LIABILITIES_TOTAL
Other Receivables	FQ, FY	OTHER_RECEIVABLES
Paid in Capital	FQ, FY	PAID_IN_CAPITAL
Gross Property/Plant/Equipment	FQ, FY	PPE_TOTAL_GROSS
Net Property/Plant/Equipment	FQ, FY	PPE_TOTAL_NET
Preferred Stock, Carrying Value	FQ, FY	PREFERRED_STOCK_CARRYING_VALUE
Prepaid Expenses	FQ, FY	PREPAID_EXPENSES
Provision for Risks & Charge	FQ, FY	PROVISION_F_RISKS
Retained Earnings	FQ, FY	RETAINED_EARNINGS
Short Term Debt excl. Current Portion of LT Debt	FQ, FY	SHORT_TERM_DEBT_EXCL_CURRENT_PORT
Short Term Debt	FQ, FY	SHORT_TERM_DEBT
Short Term Investments	FQ, FY	SHORT_TERM_INVEST
Shareholders' Equity	FQ, FY	SHRHLDRS_EQUITY
Total Assets	FQ, FY	TOTAL_ASSETS
Total Current Assets	FQ, FY	TOTAL_CURRENT_ASSETS
Total Current Liabilities	FQ, FY	TOTAL_CURRENT_LIABILITIES
Total Debt	FQ, FY	TOTAL_DEBT
Total Equity	FQ, FY	TOTAL_EQUITY
Total Inventory	FQ, FY	TOTAL_INVENTORY
Total Liabilities	FQ, FY	TOTAL_LIABILITIES
Total Liabilities & Shareholders' equities	FQ, FY	TOTAL_LIABILITIES_SHRHLDRS_EQUITY
Total Non-Current Assets	FQ, FY	TOTAL_NON_CURRENT_ASSETS
Total Non-Current Liabilities	FQ, FY	TOTAL_NON_CURRENT_LIABILITIES
Total Receivables, Net	FQ, FY	TOTAL_RECEIVABLES_NET
Total Common Shares Outstanding	FQ, FY	TOTAL_SHARES_OUTSTANDING

Cash Flow

Financial	Available periods	financial_id
Amortization	FQ, FY	AMORTIZATION
Capital Expenditures - Fixed Assets	FQ, FY	CAPITAL_EXPENDITURES_FIXED_ASSETS
Capital Expenditures	FQ, FY	CAPITAL_EXPENDITURES
Capital Expenditures - Other Assets	FQ, FY	CAPITAL_EXPENDITURES_OTHER_ASSETS
Cash From Financing Activities	FQ, FY	CASH_F_FINANCING_ACTIVITIES
Cash From Investing Activities	FQ, FY	CASH_F_INVESTING_ACTIVITIES
Cash From Operating Activities	FQ, FY	CASH_F_OPERATING_ACTIVITIES
Deferred Taxes (Cash Flow)	FQ, FY	CASH_FLOW_DEFERRED_TAXES
Depreciation & Amortization (Cash Flow)	FQ, FY	CASH_FLOW_DEPRECATION_N_AMORTIZATION
Change in Accounts Payable	FQ, FY	CHANGE_IN_ACCOUNTS_PAYABLE
Change in Accounts Receivable	FQ, FY	CHANGE_IN_ACCOUNTS_RECEIVABLE
Change in Accrued Expenses	FQ, FY	CHANGE_IN_ACCRUED_EXPENSES
Change in Inventories	FQ, FY	CHANGE_IN_INVENTORIES
Change in Other Assets/Liabilities	FQ, FY	CHANGE_IN_OTHER_ASSETS
Change in Taxes Payable	FQ, FY	CHANGE_IN_TAXES_PAYABLE
Changes in Working Capital	FQ, FY	CHANGES_IN_WORKING_CAPITAL
Common Dividends Paid	FQ, FY	COMMON_DIVIDENDS_CASH_FLOW
Depreciation/Depletion	FQ, FY	DEPRECIATION_DEPLETION
Free Cash Flow	FQ, FY	FREE_CASH_FLOW
Funds From Operations	FQ, FY	FUNDS_F_OPERATIONS
Issuance (Retirement) of Debt, Net	FQ, FY	ISSUANCE_OF_DEBT_NET
Issuance (Retirement) of Long Term Debt	FQ, FY	ISSUANCE_OF_LONG_TERM_DEBT
Issuance (Retirement) of Other Debt	FQ, FY	ISSUANCE_OF_OTHER_DEBT
Issuance (Retirement) of Short Term Debt	FQ, FY	ISSUANCE_OF_SHORT_TERM_DEBT
Issuance (Retirement) of Stock, Net	FQ, FY	ISSUANCE_OF_STOCK_NET
Net Income (Cash Flow)	FQ, FY	NET_INCOME_STARTING_LINE
Non-Cash Items	FQ, FY	NON_CASH_ITEMS
Other Financing Cash Flow Items, Total	FQ, FY	OTHER_FINANCING_CASH_FLOW_ITEMS_TOTAL
Financing Activities - Other Sources	FQ, FY	OTHER_FINANCING_CASH_FLOW_SOURCES
Financing Activities - Other Uses	FQ, FY	OTHER_FINANCING_CASH_FLOW_USES
Other Investing Cash Flow Items, Total	FQ, FY	OTHER_INVESTING_CASH_FLOW_ITEMS_TOTAL
Investing Activities - Other Sources	FQ, FY	OTHER_INVESTING_CASH_FLOW_SOURCES
Investing Activities - Other Uses	FQ, FY	OTHER_INVESTING_CASH_FLOW_USES
Preferred Dividends Paid	FQ, FY	PREFERRED_DIVIDENDS_CASH_FLOW
Purchase/Acquisition of Business	FQ, FY	PURCHASE_OF_BUSINESS
Purchase of Investments	FQ, FY	PURCHASE_OF_INVESTMENTS
Repurchase of Common & Preferred Stock	FQ, FY	PURCHASE_OF_STOCK
Purchase/Sale of Business, Net	FQ, FY	PURCHASE_SALE_BUSINESS
Purchase/Sale of Investments, Net	FQ, FY	PURCHASE_SALE_INVESTMENTS
Reduction of Long Term Debt	FQ, FY	REDUCTION_OF_LONG_TERM_DEBT
Sale of Common & Preferred Stock	FQ, FY	SALE_OF_STOCK
Sale of Fixed Assets & Businesses	FQ, FY	SALES_OF_BUSINESS
Sale/Maturity of Investments	FQ, FY	SALES_OF_INVESTMENTS
Issuance of Long Term Debt	FQ, FY	SUPPLYING_OF_LONG_TERM_DEBT
Total Cash Dividends Paid	FQ, FY	TOTAL_CASH_DIVIDENDS_PAID
Extraordinary Item	FQ, FY	TOTAL_EXTRA_ITEMS

Ratios

Financial	Available periods	financial_id
Accruals	FQ, FY	ACCRUALS_RATIO
Altman Z-Score	FQ, FY	ALTMAN_Z_SCORE
Asset Turnover	FQ, FY	ASSET_TURNOVER
Beneish M-Score	FQ, FY	BENEISH_M_SCORE
Tangible Book Value Per Share	FQ, FY	BOOK_TANGIBLE_PER_SHARE
Buyback Yield %	FQ, FY	BUYBACK_YIELD
Cash Conversion Cycle	FQ, FY	CASH_CONVERSION_CYCLE
Cash to Debt	FQ, FY	CASH_TO_DEBT
COGS to Revenue	FQ, FY	COGS_TO_REVENUE
Current Ratio	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 Asset	FQ, FY	DEBT_TO_ASSET
Debt to EBITDA	FQ, FY	DEBT_TO_EBITDA
Debt to Equity Ratio	FQ, FY	DEBT_TO_EQUITY
Debt to Revenue	FQ, FY	DEBT_TO_REVENUE
Dividend Payout Ratio %	FQ, FY	DIVIDEND_PAYOUT_RATIO
Dividend Yield	FQ, FY	DIVIDENDS_YIELD
EPS Estimates	FQ, FY	EARNINGS_ESTIMATE
EPS Basic One Year Growth	FQ, FY	EARNINGS_PER_SHARE_BASIC_ONE_YEAR_GROWTH
EPS Diluted One Year Growth	FQ, FY	EARNINGS_PER_SHARE_DILUTED_ONE_YEAR_GROWTH
EBITDA Margin	FQ, FY	EBITDA_MARGIN
Effective Interest Rate on Debt %	FQ, FY	EF_INTEREST_DEBT
Enterprise Value	FQ, FY	ENTERPRISE_VALUE
Equity to Asset	FQ, FY	EQUITY_TO_ASSET
EV to EBIT	FQ, FY	EV_EBIT
EV to EBITDA	FQ, FY	EV_EBITDA
EV to Revenue	FQ, FY	EV_REVENUE
FCF Margin %	FQ, FY	FCF_MARGIN
Fulmer H Factor	FQ, FY	FULMER_H_FACTOR
Goodwill to Asset	FQ, FY	GOODWILL_TO_ASSET
Graham's Number	FQ, FY	GRAHAM_NUMBERS
Gross Margin %	FQ, FY	GROSS_MARGIN
Gross Profit to Asset %	FQ, FY	GROSS_PROFIT_TO_ASSET
Interest Coverage	FQ, FY	INTERST_COVER
Inventory to Revenue	FQ, FY	INVENT_TO_REVENUE
Inventory Turnover	FQ, FY	INVENT_TURNOVER
KZ Index	FY	KZ_INDEX
LT Debt to Total Asset	FQ, FY	LT_DEBT_ASSET
Net Current Asset Value Per Share	FQ, FY	NCAVPS_RATIO
Net Margin	FQ, FY	NET_INCOME_MGN_ONE_YEAR_GROWTH
Net Income Per Employee	FY	NET_INCOME_PER_EMPLOYEE
Total Employees	FY	NUMBER_OF_EMPLOYEES
Operating Earnings Yield	FQ, FY	OPERATING_EARNINGS_YIELD
Operating Margin	FQ, FY	OPERATING_MARGIN
Operating PE Ratio	FQ, FY	OPERATING_PE_RATIO
PEG Ratio	FQ, FY	PEG_RATIO
Piotroski F-Score	FQ, FY	PIOTROSKI_F_SCORE
Price Earnings Ratio Forward	FQ, FY	PRICE_EARNINGS_FORWARD
Price Sales Ratio Forward	FQ, FY	PRICE_SALES_FORWARD
Price to Free Cash Flow	FQ, FY	PRICE_TO_FREE_CASH_FLOW
Price to Operating Cash Flow	FQ, FY	PRICE_TO_OPERATING_CASH_FLOW
Price to Tangible Book	FQ, FY	PRICE_TO_TANGIBLE_BOOK
Quality Ratio	FQ, FY	QUALITY_RATIO
Quick Ratio	FQ, FY	QUICK_RATIO
Research & Development to Revenue	FQ, FY	RESEARCH_AND_DEVELOP_TO_REVENUE
Return on Equity	FQ, FY	RETURN_ON_EQUITY
Return on Tangible-Asset	FQ, FY	RETURN_TANG_ASSET
Return on Tangible-Equity	FQ, FY	RETURN_TANG_EQUITY
Revenue One Year Growth	FQ, FY	REVENUE_ONE_YEAR_GROWTH
Revenue Per Employee	FY	REVENUE_PER_EMPLOYEE
ROA %	FQ, FY	ROA_PERC
ROE % Adjusted to Book Value	FQ, FY	ROE_ADJUST
ROIC %	FQ, FY	ROIC_PERC
Revenue Estimates	FQ, FY	SALES_ESTIMATES
Shares Buyback Ratio %	FQ, FY	SHARE_BUYBACK_RATIO
Sloan Ratio %	FQ, FY	SLOAN_RATIO
Springate Score	FQ, FY	SPRINGATE_SCORE
Sustainable Growth Rate	FQ, FY	SUSTAINABLE_GROWTH_RATE
Tangible Common Equity Ratio	FQ, FY	TANGIBLE_COMMON_EQUITY_RATIO
Tobin's Q (Approximate)	FQ, FY	TOBIN_Q_RATIO
Zmijewski Score	FQ, FY	ZMIJEWSKI_SCORE