ezyquant.reader.SETDataReader.get_data_symbol_yearly#

SETDataReader.get_data_symbol_yearly(field: str, symbol_list: List[str] | None = None, start_date: str | None = None, end_date: str | None = None) → DataFrame#

Data from table FINANCIAL_STAT_STD and FINANCIAL_SCREEN. If field is in both table, the data from FINANCIAL_STAT_STD will be used.

FINANCIAL_STAT_STD filter by “I_QUARTER”=’9’ and using data from column M_ACCOUNT multiply 1000. FINANCIAL_SCREEN filter by I_PERIOD_TYPE=’QY’ and I_PERIOD=’YE’.

Index date is trade date (DAILY_STOCK_STAT.D_TRADE). Data is showing at first trade date which join on D_AS_OF.

Parameters:

  • field (str) –

    • account_payable

    • account_receivable

    • accrued_int_receive

    • accumulate

    • allowance

    • ap_turnover

    • ar_turnover

    • as_of

    • asset_turnover

    • bad_debt

    • broker_fee

    • cap_paidin

    • cap_paidup

    • cash

    • cash_cycle

    • change_ppe

    • common_share

    • cos

    • current_asset

    • current_liability

    • current_ratio

    • de

    • deposit

    • dividend

    • dp

    • dscr

    • earning_asset

    • ebit

    • ebitda

    • ebt

    • eps

    • fix_asset_turnover

    • gross_profit_margin

    • ibde

    • int_bearing_debt

    • int_dvd_income

    • interest_coverage

    • interest_expense

    • interest_income

    • inventory

    • inventory_turnover

    • invest_asset

    • invest_sec_rev

    • invest_security

    • investment

    • loan

    • loan_deposit_revenue

    • loan_from_relatedparty

    • loan_revenue

    • loan_to_relatedparty

    • longterm_liability_currentportion

    • longterm_liability_net_currentportion

    • minority_interest

    • net_cash_flow

    • net_cashflow

    • net_financing

    • net_investing

    • net_operating

    • net_premium

    • net_profit

    • net_profit_incl_minority

    • net_profit_margin

    • net_profit_ordinary

    • operating_expense

    • operating_revenue

    • period

    • period_type

    • pl_other_activities

    • ppe

    • preferred_share

    • quarter

    • quick_ratio

    • retain_earning

    • retain_earning_unappropriate

    • roa

    • roe

    • sale

    • selling_admin

    • selling_admin_exc_renumuration

    • shld_equity

    • short_invest

    • total_asset

    • total_equity

    • total_expense

    • total_liability

    • total_revenue

    • year

  • symbol_list (Optional[List[str]] = None) – N_SECURITY in symbol_list, must be unique.

  • start_date (Optional[str] = None) – start of trade date (DAILY_STOCK_STAT.D_TRADE).

  • end_date (Optional[str] = None) – end of trade date (DAILY_STOCK_STAT.D_TRADE).

Returns:

  • symbol(N_SECURITY): str as column

  • trade date(DAILY_STOCK_STAT.D_TRADE): date as index

Return type:

pd.DataFrame

Examples

>>> from ezyquant import SETDataReader
>>> from ezyquant import fields as fld
>>> sdr = SETDataReader()
>>> sdr.get_data_symbol_yearly(
...     field=fld.Y_TOTAL_REVENUE,
...     symbol_list=["COM7", "MALEE"],
...     start_date="2022-02-01",
...     end_date=None,
... )
                   COM7       MALEE
2022-03-01          NaN  3488690.79
2022-03-04  51154660.73         NaN