파인에서는 어떤 파이낸셜 데이터가 있나요?

파인의 모든 파이낸셜 데이터 리스트가 아래 있습니다.

각 테이블의 첫 컬럼에는 각 메트릭이 네임이 있습니다. 두번째 컬럼은 얼마나 자주 해당 데이터가 퍼블리쉬되는지를 말합니다: TTM - Trailing Twelve Months, FY - Financial Year, and FQ - Financial Quarter. 세번째 컬럼은 파이낸셜 데이터의 아이디 입니다.

어떤 파이낸셜 메트릭 밸류를 얻으려면 다음 function 을 써야 합니다: financial(symbol, financial_id, period, gaps)

첫 아규먼트는 security 펑크션의 첫번째 아규먼트와 비슷하며 메트릭을 구하고자 하는 심볼 네임입니다. 보기: ”NASDAQ:AAPL”.

두 번째 아규먼트는 요구되는 메트릭의 아이디입니다: 테이블 세번째 컬럼 밸류.

세 번째 아규먼트는 얼마나 자주 이 메트릭이 퍼블리쉬되는 지를 나타냅니다: 두 번째 컬럼 밸류 가운데 하나.

네 번째 아규먼트는 옵셔널이며 security 펑크션의 gaps 아규먼트와 비슷합니다. gaps = true이면, 데이터의 퍼블리케이션 날짜에 해당되는 바에만 디스플레이됩니다.

이 펑크션은 요구된 파이낸셜 데이터의 밸류를 리턴합니다.

보기:

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

Java

여기에 파이낸셜 데이터에 관해 자세히 나와 있습니다.

디비든드 및 어닝즈 펑크션을 써서 파이낸셜 데이터를 구하면 해당 리포트가 퍼블리쉬되었던 곳의 바에서 새 밸류가 리턴됩니다. 이들 펑크션으로 다음 회계 기간이 시작될 때 바에 대한 새로운 밸류를 얻을 수 있습니다.

마켓 프라이스 기반 레이쇼

파이낸셜 메뉴에 나오는 몇몇 파이낸셜 인디케이터는 아래 테이블에는 없는데 그런 인디케이터들은 파이낸셜 메트릭과 차트의 커런트 프라이스를 써서 셈하기 때문입니다. 이 말은 그런 인디케이터들의 밸류를 직접 요청할 수 없다는 뜻이 되지만 두세 줄의 파인 코드로 셈을 할 수 있습니다.

시가 총액 (Market Capitalization)

시가 총액은 주가에 발행 주식수를 곱한 것과 같습니다 (FQ).

TSO = financial(syminfo.tickerid, "TOTAL_SHARES_OUTSTANDING", "FQ")MarketCap = TSO*close

Java

이율 (Earnings Yield)

이율은 지난 12 달 동안의 주당 순익 (earnings per share) 을 주당 현재가로 나눠 셈합니다. 그 값에 100 을 곱하면 주당 순익 % (Earnings Yield %) 밸류가 나옵니다.

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

Java

주가순자산비율 (Price Book Ratio)

주가순자산비율은 주가를 장부가로 나눠 셈합니다.

BVPS = financial(syminfo.tickerid, "BOOK_VALUE_PER_SHARE", "FQ")PriceBookRatio = close/BVPS

Java

주가수익율 (Price Earnings Ratio)

주가수익율은 현재 주가를 지난 12달 주당 순익 ( earnings per share) 로 나눈 값입니다.

EPS = financial(syminfo.tickerid, "EARNINGS_PER_SHARE", "TTM")PriceEarningsRatio = close/EPS

Java

주가매상비율 (Price Sales Ratio)

주가매상비율은 회사 시가 총액 (market capitalization) 울 지난 12달 총수입 (total revenue) 으로 나눈 값입니다.

TSO = financial(syminfo.tickerid, "TOTAL_SHARES_OUTSTANDING", "FQ")TR = financial(syminfo.tickerid, "TOTAL_REVENUE", "TTM")MarketCap = TSO*closePriseSalesRatio = MarketCap/TR

Java

손익 계산서 (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