파인의 모든 파이낸셜 데이터 리스트가 아래 있습니다.
각 테이블의 첫 컬럼에는 각 메트릭이 네임이 있습니다. 두번째 컬럼은 얼마나 자주 해당 데이터가 퍼블리쉬되는지를 말합니다: 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여기에 파이낸셜 데이터에 관해 자세히 나와 있습니다.
마켓 프라이스 기반 레이쇼
파이낸셜 메뉴에 나오는 몇몇 파이낸셜 인디케이터는 아래 테이블에는 없는데 그런 인디케이터들은 파이낸셜 메트릭과 차트의 커런트 프라이스를 써서 셈하기 때문입니다. 이 말은 그런 인디케이터들의 밸류를 직접 요청할 수 없다는 뜻이 되지만 두세 줄의 파인 코드로 셈을 할 수 있습니다.
시가 총액은 주가에 발행 주식수를 곱한 것과 같습니다 (FQ).
TSO = financial(syminfo.tickerid, "TOTAL_SHARES_OUTSTANDING", "FQ")
MarketCap = TSO*close
Java이율은 지난 12 달 동안의 주당 순익 (earnings per share) 을 주당 현재가로 나눠 셈합니다. 그 값에 100 을 곱하면 주당 순익 % (Earnings Yield %) 밸류가 나옵니다.
EPS = financial(syminfo.tickerid, "EARNINGS_PER_SHARE", "TTM")
EarningsYield = (EPS/close)*100
Java주가순자산비율은 주가를 장부가로 나눠 셈합니다.
BVPS = financial(syminfo.tickerid, "BOOK_VALUE_PER_SHARE", "FQ")
PriceBookRatio = close/BVPS
Java주가수익율은 현재 주가를 지난 12달 주당 순익 ( earnings per share) 로 나눈 값입니다.
EPS = financial(syminfo.tickerid, "EARNINGS_PER_SHARE", "TTM")
PriceEarningsRatio = close/EPS
Java주가매상비율은 회사 시가 총액 (market capitalization) 울 지난 12달 총수입 (total revenue) 으로 나눈 값입니다.
TSO = financial(syminfo.tickerid, "TOTAL_SHARES_OUTSTANDING", "FQ")
TR = financial(syminfo.tickerid, "TOTAL_REVENUE", "TTM")
MarketCap = TSO*close
PriseSalesRatio = MarketCap/TR
Java파이낸셜 (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 |
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 |
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 |
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 |