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

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

각 테이블의 첫 컬럼에는 각 메트릭이 네임이 있습니다. 두번째 컬럼은 얼마나 자주 해당 데이터가 퍼블리쉬되는지를 말합니다: 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/ExpenseFQ, FYAFTER_TAX_OTHER_INCOME
Average Basic Shares OutstandingFQ, FYBASIC_SHARES_OUTSTANDING
Other COGSFQ, FYCOST_OF_GOODS_EXCL_DEP_AMORT
Cost of GoodsFQ, FYCOST_OF_GOODS
Deprecation and AmortizationFQ, FYDEP_AMORT_EXP_INCOME_S
Diluted Net Income Available to Common StockholdersFQ, FYDILUTED_NET_INCOME
Diluted Shares OutstandingFQ, FYDILUTED_SHARES_OUTSTANDING
Dilution AdjustmentFQ, FYDILUTION_ADJUSTMENT
Discontinued OperationsFQ, FYDISCONTINUED_OPERATIONS
Basic EPSFQ, FY, TTMEARNINGS_PER_SHARE_BASIC
Diluted EPSFQ, FY, TTMEARNINGS_PER_SHARE
EBITDAFQ, FY, TTMEBITDA
Equity In EarningsFQ, FYEQUITY_IN_EARNINGS
Gross ProfitFQ, FYGROSS_PROFIT
TaxesFQ, FYINCOME_TAX
Non-Controlling/Minority interestFQ, FYMINORITY_INTEREST_EXP
Net Income Before Discontinued OperationsFQ, FYNET_INCOME_BEF_DISC_OPER
Net IncomeFQ, FYNET_INCOME
Non-Operating Income, excl. Interest ExpensesFQ, FYNON_OPER_INCOME
Interest Expense, Net of Interest CapitalizedFQ, FYNON_OPER_INTEREST_EXP
Non-Operating Interest IncomeFQ, FYNON_OPER_INTEREST_INCOME
Operating IncomeFQ, FYOPER_INCOME
Operating Expenses (excl. COGS)FQ, FYOPERATING_EXPENSES
Miscellaneous Non-Operating ExpenseFQ, FYOTHER_INCOME
Other Operating Expenses, TotalFQ, FYOTHER_OPER_EXPENSE_TOTAL
Preferred DividendsFQ, FYPREFERRED_DIVIDENDS
Pretax Equity In EarningsFQ, FYPRETAX_EQUITY_IN_EARNINGS
Pretax IncomeFQ, FYPRETAX_INCOME
Research & DevelopmentFQ, FYRESEARCH_AND_DEV
Selling/General/Admin Expenses, OtherFQ, FYSELL_GEN_ADMIN_EXP_OTHER
Selling/General/Admin Expenses, TotalFQ, FYSELL_GEN_ADMIN_EXP_TOTAL
Non-Operating Income, TotalFQ, FYTOTAL_NON_OPER_INCOME
Total Operating ExpensesFQ, FYTOTAL_OPER_EXPENSE
Total RevenueFQ, FYTOTAL_REVENUE
Unusual Expense (Income)FQ, FYUNUSUAL_EXPENSE_INC
대차대조표 (BALANCE SHEET)

Financial

Available periods

financial_id

Accounts PayableFQ, FYACCOUNTS_PAYABLE
Accounts Receivable - Trade, NetFQ, FYACCOUNTS_RECEIVABLES_NET
Accrued PayrollFQ, FYACCRUED_PAYROLL
Accumulated Depreciation, TotalFQ, FYACCUM_DEPREC_TOTAL
Book Value Per ShareFQ, FYBOOK_VALUE_PER_SHARE
Capital and Operating Lease ObligationsFQ, FYCAPITAL_OPERATING_LEASE_OBLIGATIONS
Cash & EquivalentsFQ, FYCASH_N_EQUIVALENTS
Cash and Short Term InvestmentsFQ, FYCASH_N_SHORT_TERM_INVEST
Common Equity, TotalFQ, FYCOMMON_EQUITY_TOTAL
Current Port. of LT Debt/Capital LeasesFQ, FYCURRENT_PORT_DEBT_CAPITAL_LEASES
Deferred Income, CurrentFQ, FYDEFERRED_INCOME_CURRENT
Deferred Income, Non-CurrentFQ, FYDEFERRED_INCOME_NON_CURRENT
Deferred Tax AssetsFQ, FYDEFERRED_TAX_ASSESTS
Deferred Tax LiabilitiesFQ, FYDEFERRED_TAX_LIABILITIES
Dividends PayableFYDIVIDENDS_PAYABLE
Goodwill, NetFQ, FYGOODWILL
Income Tax PayableFQ, FYINCOME_TAX_PAYABLE
Net Intangible AssetsFQ, FYINTANGIBLES_NET
Inventories - Finished GoodsFQ, FYINVENTORY_FINISHED_GOODS
Inventories - Progress Payments & OtherFQ, FYINVENTORY_PROGRESS_PAYMENTS
Inventories - Raw MaterialsFQ, FYINVENTORY_RAW_MATERIALS
Inventories - Work In ProgressFQ, FYINVENTORY_WORK_IN_PROGRESS
Investments in Unconsolidated SubsidiariesFQ, FYINVESTMENTS_IN_UNCONCSOLIDATE
Long Term Debt Excluding Lease LiabilitiesFQ, FYLONG_TERM_DEBT_EXCL_CAPITAL_LEASE
Long Term DebtFQ, FYLONG_TERM_DEBT
Long Term InvestmentsFQ, FYLONG_TERM_INVESTMENTS
Note Receivable - Long TermFQ, FYLONG_TERM_NOTE_RECEIVABLE
Other Long Term Assets, TotalFQ, FYLONG_TERM_OTHER_ASSETS_TOTAL
Minority InterestFQ, FYMINORITY_INTEREST
Other Common EquityFQ, FYOTHER_COMMON_EQUITY
Other Current Assets, TotalFQ, FYOTHER_CURRENT_ASSETS_TOTAL
Other Current LiabilitiesFQ, FYOTHER_CURRENT_LIABILITIES
Net Other IntangiblesFQ, FYOTHER_INTANGIBLES_NET
Other InvestmentsFQ, FYOTHER_INVESTMENTS
Other Liabilities, TotalFQ, FYOTHER_LIABILITIES_TOTAL
Other ReceivablesFQ, FYOTHER_RECEIVABLES
Paid in CapitalFQ, FYPAID_IN_CAPITAL
Gross Property/Plant/EquipmentFQ, FYPPE_TOTAL_GROSS
Net Property/Plant/EquipmentFQ, FYPPE_TOTAL_NET
Preferred Stock, Carrying ValueFQ, FYPREFERRED_STOCK_CARRYING_VALUE
Prepaid ExpensesFQ, FYPREPAID_EXPENSES
Provision for Risks & ChargeFQ, FYPROVISION_F_RISKS
Retained EarningsFQ, FYRETAINED_EARNINGS
Short Term Debt excl. Current Portion of LT DebtFQ, FYSHORT_TERM_DEBT_EXCL_CURRENT_PORT
Short Term DebtFQ, FYSHORT_TERM_DEBT
Short Term InvestmentsFQ, FYSHORT_TERM_INVEST
Shareholders' EquityFQ, FYSHRHLDRS_EQUITY
Total AssetsFQ, FYTOTAL_ASSETS
Total Current AssetsFQ, FYTOTAL_CURRENT_ASSETS
Total Current LiabilitiesFQ, FYTOTAL_CURRENT_LIABILITIES
Total DebtFQ, FYTOTAL_DEBT
Total EquityFQ, FYTOTAL_EQUITY
Total InventoryFQ, FYTOTAL_INVENTORY
Total LiabilitiesFQ, FYTOTAL_LIABILITIES
Total Liabilities & Shareholders' equitiesFQ, FYTOTAL_LIABILITIES_SHRHLDRS_EQUITY
Total Non-Current AssetsFQ, FYTOTAL_NON_CURRENT_ASSETS
Total Non-Current LiabilitiesFQ, FYTOTAL_NON_CURRENT_LIABILITIES
Total Receivables, NetFQ, FYTOTAL_RECEIVABLES_NET
Total Common Shares OutstandingFQ, FYTOTAL_SHARES_OUTSTANDING
캐쉬 플로우 (CASH FLOW)

Financial

Available periods

financial_id

AmortizationFQ, FYAMORTIZATION
Capital Expenditures - Fixed AssetsFQ, FYCAPITAL_EXPENDITURES_FIXED_ASSETS
Capital ExpendituresFQ, FYCAPITAL_EXPENDITURES
Capital Expenditures - Other AssetsFQ, FYCAPITAL_EXPENDITURES_OTHER_ASSETS
Cash From Financing ActivitiesFQ, FYCASH_F_FINANCING_ACTIVITIES
Cash From Investing ActivitiesFQ, FYCASH_F_INVESTING_ACTIVITIES
Cash From Operating ActivitiesFQ, FYCASH_F_OPERATING_ACTIVITIES
Deferred Taxes (Cash Flow)FQ, FYCASH_FLOW_DEFERRED_TAXES
Depreciation & Amortization (Cash Flow)FQ, FYCASH_FLOW_DEPRECATION_N_AMORTIZATION
Change in Accounts PayableFQ, FYCHANGE_IN_ACCOUNTS_PAYABLE
Change in Accounts ReceivableFQ, FYCHANGE_IN_ACCOUNTS_RECEIVABLE
Change in Accrued ExpensesFQ, FYCHANGE_IN_ACCRUED_EXPENSES
Change in InventoriesFQ, FYCHANGE_IN_INVENTORIES
Change in Other Assets/LiabilitiesFQ, FYCHANGE_IN_OTHER_ASSETS
Change in Taxes PayableFQ, FYCHANGE_IN_TAXES_PAYABLE
Changes in Working CapitalFQ, FYCHANGES_IN_WORKING_CAPITAL
Common Dividends PaidFQ, FYCOMMON_DIVIDENDS_CASH_FLOW
Depreciation/DepletionFQ, FYDEPRECIATION_DEPLETION
Free Cash FlowFQ, FYFREE_CASH_FLOW
Funds From OperationsFQ, FYFUNDS_F_OPERATIONS
Issuance (Retirement) of Debt, NetFQ, FYISSUANCE_OF_DEBT_NET
Issuance (Retirement) of Long Term DebtFQ, FYISSUANCE_OF_LONG_TERM_DEBT
Issuance (Retirement) of Other DebtFQ, FYISSUANCE_OF_OTHER_DEBT
Issuance (Retirement) of Short Term DebtFQ, FYISSUANCE_OF_SHORT_TERM_DEBT
Issuance (Retirement) of Stock, NetFQ, FYISSUANCE_OF_STOCK_NET
Net Income (Cash Flow)FQ, FYNET_INCOME_STARTING_LINE
Non-Cash ItemsFQ, FYNON_CASH_ITEMS
Other Financing Cash Flow Items, TotalFQ, FYOTHER_FINANCING_CASH_FLOW_ITEMS_TOTAL
Financing Activities - Other SourcesFQ, FYOTHER_FINANCING_CASH_FLOW_SOURCES
Financing Activities - Other UsesFQ, FYOTHER_FINANCING_CASH_FLOW_USES
Other Investing Cash Flow Items, TotalFQ, FYOTHER_INVESTING_CASH_FLOW_ITEMS_TOTAL
Investing Activities - Other SourcesFQ, FYOTHER_INVESTING_CASH_FLOW_SOURCES
Investing Activities - Other UsesFQ, FYOTHER_INVESTING_CASH_FLOW_USES
Preferred Dividends PaidFQ, FYPREFERRED_DIVIDENDS_CASH_FLOW
Purchase/Acquisition of BusinessFQ, FYPURCHASE_OF_BUSINESS
Purchase of InvestmentsFQ, FYPURCHASE_OF_INVESTMENTS
Repurchase of Common & Preferred StockFQ, FYPURCHASE_OF_STOCK
Purchase/Sale of Business, NetFQ, FYPURCHASE_SALE_BUSINESS
Purchase/Sale of Investments, NetFQ, FYPURCHASE_SALE_INVESTMENTS
Reduction of Long Term DebtFQ, FYREDUCTION_OF_LONG_TERM_DEBT
Sale of Common & Preferred StockFQ, FYSALE_OF_STOCK
Sale of Fixed Assets & BusinessesFQ, FYSALES_OF_BUSINESS
Sale/Maturity of InvestmentsFQ, FYSALES_OF_INVESTMENTS
Issuance of Long Term DebtFQ, FYSUPPLYING_OF_LONG_TERM_DEBT
Total Cash Dividends PaidFQ, FYTOTAL_CASH_DIVIDENDS_PAID
Extraordinary ItemFQ, FYTOTAL_EXTRA_ITEMS
레이쇼 (RATIOS)

Financial

Available periods

financial_id

AccrualsFQ, FYACCRUALS_RATIO
Altman Z-ScoreFQ, FYALTMAN_Z_SCORE
Asset TurnoverFQ, FYASSET_TURNOVER
Beneish M-ScoreFQ, FYBENEISH_M_SCORE
Tangible Book Value Per ShareFQ, FYBOOK_TANGIBLE_PER_SHARE
Buyback Yield %FQ, FYBUYBACK_YIELD
Cash Conversion CycleFQ, FYCASH_CONVERSION_CYCLE
Cash to DebtFQ, FYCASH_TO_DEBT
COGS to RevenueFQ, FYCOGS_TO_REVENUE
Current RatioFQ, FYCURRENT_RATIO
Days Sales OutstandingFQ, FYDAY_SALES_OUT
Days InventoryFQ, FYDAYS_INVENT
Days PayableFQ, FYDAYS_PAY
Debt to AssetFQ, FYDEBT_TO_ASSET
Debt to EBITDAFQ, FYDEBT_TO_EBITDA
Debt to Equity RatioFQ, FYDEBT_TO_EQUITY
Debt to RevenueFQ, FYDEBT_TO_REVENUE
Dividend Payout Ratio %FQ, FYDIVIDEND_PAYOUT_RATIO
Dividend YieldFQ, FYDIVIDENDS_YIELD
EPS EstimatesFQ, FYEARNINGS_ESTIMATE
EPS Basic One Year GrowthFQ, FYEARNINGS_PER_SHARE_BASIC_ONE_YEAR_GROWTH
EPS Diluted One Year GrowthFQ, FYEARNINGS_PER_SHARE_DILUTED_ONE_YEAR_GROWTH
EBITDA MarginFQ, FYEBITDA_MARGIN
Effective Interest Rate on Debt %FQ, FYEF_INTEREST_DEBT
Enterprise ValueFQ, FYENTERPRISE_VALUE
Equity to AssetFQ, FYEQUITY_TO_ASSET
EV to EBITFQ, FYEV_EBIT
EV to EBITDAFQ, FYEV_EBITDA
EV to RevenueFQ, FYEV_REVENUE
FCF Margin %FQ, FYFCF_MARGIN
Fulmer H FactorFQ, FYFULMER_H_FACTOR
Goodwill to AssetFQ, FYGOODWILL_TO_ASSET
Graham's NumberFQ, FYGRAHAM_NUMBERS
Gross Margin %FQ, FYGROSS_MARGIN
Gross Profit to Asset %FQ, FYGROSS_PROFIT_TO_ASSET
Interest CoverageFQ, FYINTERST_COVER
Inventory to RevenueFQ, FYINVENT_TO_REVENUE
Inventory TurnoverFQ, FYINVENT_TURNOVER
KZ IndexFYKZ_INDEX
LT Debt to Total AssetFQ, FYLT_DEBT_ASSET
Net Current Asset Value Per ShareFQ, FYNCAVPS_RATIO
Net MarginFQ, FYNET_INCOME_MGN_ONE_YEAR_GROWTH
Net Income Per EmployeeFYNET_INCOME_PER_EMPLOYEE
Total EmployeesFYNUMBER_OF_EMPLOYEES
Operating Earnings YieldFQ, FYOPERATING_EARNINGS_YIELD
Operating MarginFQ, FYOPERATING_MARGIN
Operating PE RatioFQ, FYOPERATING_PE_RATIO
PEG RatioFQ, FYPEG_RATIO
Piotroski F-ScoreFQ, FYPIOTROSKI_F_SCORE
Price Earnings Ratio ForwardFQ, FYPRICE_EARNINGS_FORWARD
Price Sales Ratio ForwardFQ, FYPRICE_SALES_FORWARD
Price to Free Cash FlowFQ, FYPRICE_TO_FREE_CASH_FLOW
Price to Operating Cash FlowFQ, FYPRICE_TO_OPERATING_CASH_FLOW
Price to Tangible BookFQ, FYPRICE_TO_TANGIBLE_BOOK
Quality RatioFQ, FYQUALITY_RATIO
Quick RatioFQ, FYQUICK_RATIO
Research & Development to RevenueFQ, FYRESEARCH_AND_DEVELOP_TO_REVENUE
Return on EquityFQ, FYRETURN_ON_EQUITY
Return on Tangible-AssetFQ, FYRETURN_TANG_ASSET
Return on Tangible-EquityFQ, FYRETURN_TANG_EQUITY
Revenue One Year GrowthFQ, FYREVENUE_ONE_YEAR_GROWTH
Revenue Per EmployeeFYREVENUE_PER_EMPLOYEE
ROA %FQ, FYROA_PERC
ROE % Adjusted to Book ValueFQ, FYROE_ADJUST
ROIC %FQ, FYROIC_PERC
Revenue EstimatesFQ, FYSALES_ESTIMATES
Shares Buyback Ratio %FQ, FYSHARE_BUYBACK_RATIO
Sloan Ratio %FQ, FYSLOAN_RATIO
Springate ScoreFQ, FYSPRINGATE_SCORE
Sustainable Growth RateFQ, FYSUSTAINABLE_GROWTH_RATE
Tangible Common Equity RatioFQ, FYTANGIBLE_COMMON_EQUITY_RATIO
Tobin's Q (Approximate)FQ, FYTOBIN_Q_RATIO
Zmijewski ScoreFQ, FYZMIJEWSKI_SCORE
홈으로 스탁 스크리너 포렉스 스크리너 크립토 스크리너 이코노믹 캘린더 정보 차트 특징 프라이싱 프렌드 리퍼하기 하우스룰(내부규정) 헬프 센터 웹사이트 & 브로커 솔루션 위젯 차팅 솔루션 라이트웨이트 차팅 라이브러리 블로그 & 뉴스 트위터