Skip to main content
GET
https://api.sectors.app
/
v2
/
companies
Companies Screener
curl --request GET \
  --url https://api.sectors.app/v2/companies/ \
  --header 'Authorization: <authorization>'
{
    "results": [
        {
            "symbol": "BBCA.JK",
            "company_name": "Bank Central Asia Tbk"
        },
        {
            "symbol": "BBRI.JK",
            "company_name": "Bank Rakyat Indonesia (Persero) Tbk"
        }
    ],
    "pagination": {
        "total_count": 2,
        "showing": 2,
        "limit": 50,
        "offset": 0,
        "has_next": false,
        "has_previous": false,
        "next_offset": null,
        "previous_offset": null
    },
    "llm_translation": {
        "natural_query": "top 2 banks by market cap in 2024",
        "translated_params": {
            "where": "sub_sector = 'banks'",
            "order_by": "-market_cap",
            "limit": 2,
            "offset": 0
        },
        "message": "Used sub_sector = 'banks' to filter for banking companies."
    }
}
{
    "results": [
        {
            "symbol": "BBCA.JK",
            "company_name": "Bank Central Asia Tbk"
        },
        {
            "symbol": "BBRI.JK",
            "company_name": "Bank Rakyat Indonesia (Persero) Tbk"
        }
    ],
    "pagination": {
        "total_count": 2,
        "showing": 2,
        "limit": 50,
        "offset": 0,
        "has_next": false,
        "has_previous": false,
        "next_offset": null,
        "previous_offset": null
    },
    "llm_translation": {
        "natural_query": "top 2 banks by market cap in 2024",
        "translated_params": {
            "where": "sub_sector = 'banks'",
            "order_by": "-market_cap",
            "limit": 2,
            "offset": 0
        },
        "message": "Used sub_sector = 'banks' to filter for banking companies."
    }
}
Authorization
string
required
Authorization header that should be filled with your Sectors Financial API key.

Query Parameters

q
string
A natural language query (e.g., "top 10 tech companies by revenue in 2023"). When q is provided, all other query parameters (where, order_by, etc.) are ignored, as the LLM will generate them.
  • Smart FY Handling: To account for reporting lags, “latest year” queries made between January to April default to the previous audited year (e.g., 2026 queries use 2024 data).
  • Note for Enhanced Accuracy: For the most precise results, we recommend filtering by specific sectors or industries using our standardized slugs. You can retrieve the complete list of official slugs from Subsectors, Subindustries, or Industries.
where
string
SQL-like conditions for advanced filtering. This parameter is ignored if q is present.
  • Operators: =, !=, >, >=, <, <=, like, in.
  • Logic: Combine conditions with and and or.
  • Values: Use single or double quotes for strings (e.g., sector = 'Technology'), numbers directly (e.g., market_cap > 1000000000000), and lists for the in operator (e.g., tags in ['blue-chip', 'dividend']).
Access historical or forecast data using bracket notation: field[YYYY].
Example: revenue[2023] > 100000000000 or forecast_eps_growth[2025] > 0.15.
Perform calculations within your query on both sides of a condition.
Example: revenue[2024] / total_assets[2024] > 0.5 or revenue[2024] > revenue[2023] * 1.2.
Here is the exhaustive list of all queryable fields.
How to Use: Query these fields directly using standard operators (=, !=, >, <, LIKE, IN). For string fields, LIKE and = are case-insensitive.
  • where=market_cap > 500000000000000
  • where=company_name like '%energi%'
  • where=sector = 'Financials' and listing_date > '2005-01-01'
  • symbol: The unique stock ticker symbol (e.g., BBCA.JK).
  • company_name: The full legal name of the company.
  • listing_board: The stock exchange board where the company is listed (e.g., Main).
  • industry: The company’s primary industry (e.g., Banks).
  • sub_industry: A more specific industry classification.
  • sector: The broader economic sector (e.g., Financials).
  • sub_sector: A more specific sector classification.
  • market_cap: The total market value of the company’s outstanding shares.
  • market_cap_rank: The company’s rank by market capitalization.
  • employee_num: The total number of employees.
  • employee_num_rank: The company’s rank by number of employees.
  • listing_date: The date the company was first listed (YYYY-MM-DD).
  • last_ex_dividend_date: The most recent ex-dividend date (YYYY-MM-DD).
  • last_close_price: The last closing price of the stock.
  • daily_close_change: The percentage change in the stock’s closing price from the previous day.
  • forward_pe: The forward Price-to-Earnings ratio based on future earnings estimates.
  • intrinsic_value: An estimate of the stock’s “true” value based on financial modeling.
  • esg_score: A score representing the company’s Environmental, Social, and Governance performance.
  • yield_ttm: The dividend yield over the Trailing Twelve Months.
  • dividend_ttm: The total dividend per share paid over the Trailing Twelve Months.
  • payout_ratio: The percentage of earnings paid out to shareholders as dividends.
  • cash_payout_ratio: The ratio of cash paid out as dividends to the company’s cash flow.
  • yoy_quarter_earnings_growth: The year-over-year growth of the company’s quarterly earnings.
  • yoy_quarter_revenue_growth: The year-over-year growth of the company’s quarterly revenue.
  • affiliates: A comma-separated string of key affiliated individuals or entities (e.g., ‘Barito, Prajogo Pangestu’).
How to Use: Query these fields using the in operator to check if any of the provided values exist in the array.
  • where=indices in ['LQ45', 'IDX30']
  • where=tags in ['52-w-high', 'public-float-under-25']
  • tags: A list of tags or labels associated with the stock (e.g., insider-1-month-buy).
  • indices: A list of stock market indices the company is a component of (e.g., KOMPAS100).
How to Use: Query these fields as if they were direct fields. The parser automatically handles extracting the value from the underlying JSON data.
  • where=pe_ttm < 15 and roe_ttm > 0.1
  • where=last_close_price < all_time_high_price
  • where=ytd_low_date > '2025-03-01'
  • pe_ttm: Price-to-Earnings ratio (Trailing Twelve Months).
  • pb_mrq: Price-to-Book ratio (Most Recent Quarter).
  • ps_ttm: Price-to-Sales ratio (Trailing Twelve Months).
  • dar_mrq: Debt-to-Asset ratio (Most Recent Quarter).
  • der_mrq: Debt-to-Equity ratio (Most Recent Quarter).
  • roa_ttm: Return on Assets (Trailing Twelve Months).
  • roe_ttm: Return on Equity (Trailing Twelve Months).
  • total_assets_mrq: Total assets (Most Recent Quarter).
  • total_equity_mrq: Total equity (Most Recent Quarter).
  • total_revenue_mrq: Total revenue (Most Recent Quarter).
  • earnings_mrq: Net income or earnings (Most Recent Quarter).
  • total_liabilities_mrq: Total liabilities (Most Recent Quarter).
  • yearly_mcap_change: The percentage change in market cap over the last year.
  • dividend_yield_avg: The average dividend yield.
  • dividend_yield_avg_period: The period used for the average dividend yield calculation.
  • ytd_low_price: Year-to-date low price.
  • ytd_low_date: Date of year-to-date low price.
  • ytd_high_price: Year-to-date high price.
  • ytd_high_date: Date of year-to-date high price.
  • 52_w_low_price: 52-week low price.
  • 52_w_low_date: Date of 52-week low price.
  • 52_w_high_price: 52-week high price.
  • 52_w_high_date: Date of 52-week high price.
  • 90_d_low_price: 90-day low price.
  • 90_d_low_date: Date of 90-day low price.
  • 90_d_high_price: 90-day high price.
  • 90_d_high_date: Date of 90-day high price.
  • all_time_low_price: All-time low price.
  • all_time_low_date: Date of all-time low price.
  • all_time_high_price: All-time high price.
  • all_time_high_date: Date of all-time high price.
How to Use: You must use bracket notation field[YYYY] to access data for a specific year. These fields support all numeric operators, field-to-field comparisons, and arithmetic expressions.
  • where=revenue[2023] > earnings[2023] * 5
  • where=roe[2023] > 0.15 and roe[2022] > 0.15
  • where=pe[2024] < pe_peer_avg[2024]
  • total_dividend[YYYY]: Total dividend for the specified year.
  • total_yield[YYYY]: Dividend yield for the specified year.
  • eps[YYYY]: Earnings Per Share for the specified year.
  • allowance_for_loans[YYYY]: Allowance for loan losses.
  • capital_expenditure[YYYY]: Capital expenditure.
  • cash_and_equivalents[YYYY]: Cash and equivalents.
  • cash_inflow[YYYY]: Total cash inflow.
  • cash_only[YYYY]: Cash balance.
  • cash_outflow[YYYY]: Total cash outflow.
  • core_capital_tier1[YYYY]: Tier 1 core capital (for banks).
  • cost_of_revenue[YYYY]: Cost of revenue.
  • credit_rwa[YYYY]: Credit risk-weighted assets.
  • current_account[YYYY]: Current account balance.
  • current_assets[YYYY]: Total current assets.
  • current_liabilities[YYYY]: Total current liabilities.
  • earnings[YYYY]: Net income or earnings.
  • earnings_before_tax[YYYY]: Earnings before tax (EBT).
  • ebit[YYYY]: Earnings Before Interest and Taxes.
  • ebitda[YYYY]: Earnings Before Interest, Taxes, Depreciation, and Amortization.
  • end_cash_position[YYYY]: Cash position at the end of the period.
  • financing_cash_flow[YYYY]: Cash flow from financing activities.
  • fixed_assets[YYYY]: Total fixed assets.
  • free_cash_flow[YYYY]: Free cash flow.
  • gross_loan[YYYY]: Total gross loans.
  • gross_profit[YYYY]: Gross profit.
  • high_quality_liquid_asset[YYYY]: High-quality liquid assets.
  • interest_expense[YYYY]: Interest expense.
  • interest_expense_non_operating[YYYY]: Non-operating interest expense.
  • interest_income[YYYY]: Interest income.
  • inventories[YYYY]: Value of inventories.
  • investing_cash_flow[YYYY]: Cash flow from investing activities.
  • market_rwa[YYYY]: Market risk-weighted assets.
  • net_cash_flow[YYYY]: Net change in cash.
  • net_interest_income[YYYY]: Net interest income.
  • net_loan[YYYY]: Total net loans.
  • net_premium_income[YYYY]: Net premium income (for insurance).
  • non_current_liabilities[YYYY]: Total non-current liabilities.
  • non_interest_bearing_liabilities[YYYY]: Non-interest bearing liabilities.
  • non_interest_income[YYYY]: Non-interest income.
  • non_loan_assets[YYYY]: Assets other than loans.
  • non_loan_earning_assets[YYYY]: Earning assets other than loans.
  • non_loan_non_earning_assets[YYYY]: Non-earning assets other than loans.
  • non_operating_income_or_loss[YYYY]: Non-operating income or loss.
  • operating_cash_flow[YYYY]: Cash flow from operating activities.
  • operating_expense[YYYY]: Operating expenses.
  • operating_pnl[YYYY]: Operating profit and loss.
  • operational_rwa[YYYY]: Operational risk-weighted assets.
  • other_interest_bearing_liabilities[YYYY]: Other interest-bearing liabilities.
  • outstanding_shares[YYYY]: Number of outstanding shares.
  • prepaid_assets[YYYY]: Prepaid assets.
  • premium_expense[YYYY]: Premium expense (for insurance).
  • premium_income[YYYY]: Premium income (for insurance).
  • provision[YYYY]: Provision for losses.
  • realized_capital_goods_investment[YYYY]: Realized investment in capital goods.
  • retained_earnings[YYYY]: Retained earnings.
  • revenue[YYYY]: Total revenue.
  • savings_account[YYYY]: Savings account balance.
  • supplementary_capital_tier2[YYYY]: Tier 2 supplementary capital (for banks).
  • tax[YYYY]: Income tax expense.
  • time_deposit[YYYY]: Time deposit balance.
  • total_assets[YYYY]: Total assets.
  • total_capital[YYYY]: Total capital.
  • total_cash_and_due_from_banks[YYYY]: Total cash and due from banks.
  • total_debt[YYYY]: Total debt.
  • total_deposit[YYYY]: Total deposits.
  • total_equity[YYYY]: Total equity.
  • total_liabilities[YYYY]: Total liabilities.
  • total_risk_weighted_asset[YYYY]: Total risk-weighted assets.
  • special_mention_loan[YYYY]: Special mention loans.
  • non_performing_loan[YYYY]: Non-performing loans (NPL).
  • restructured_loan_current[YYYY]: Restructured but current loans.
  • forecast_eps_growth[YYYY]: Forecasted EPS growth for a future year.
  • forecast_revenue_growth[YYYY]: Forecasted revenue growth for a future year.
  • forecast_eps_estimate[YYYY]: Forecasted EPS value for a future year.
  • forecast_revenue_estimate[YYYY]: Forecasted revenue value for a future year.
  • pe[YYYY]: Price-to-Earnings ratio.
  • pb[YYYY]: Price-to-Book ratio.
  • ps[YYYY]: Price-to-Sales ratio.
  • pcf[YYYY]: Price-to-Cash Flow ratio.
  • peg[YYYY]: Price/Earnings-to-Growth ratio.
  • enterprise_to_ebitda[YYYY]: EV/EBITDA ratio.
  • enterprise_to_revenue[YYYY]: EV/Revenue ratio.
  • pb_peer_avg[YYYY]: Average peer Price-to-Book ratio.
  • pe_peer_avg[YYYY]: Average peer Price-to-Earnings ratio.
  • ps_peer_avg[YYYY]: Average peer Price-to-Sales ratio.
  • debt_to_asset_ratio[YYYY]: Debt-to-Asset ratio.
  • debt_to_equity_ratio[YYYY]: Debt-to-Equity ratio.
  • cash_flow_to_debt_ratio[YYYY]: Cash Flow-to-Debt ratio.
  • interest_coverage_ratio[YYYY]: Interest Coverage ratio.
  • current_ratio[YYYY]: Current ratio.
  • operating_cash_flow_margin[YYYY]: Operating Cash Flow margin.
  • fixed_asset_turnover[YYYY]: Fixed Asset Turnover ratio.
  • total_asset_turnover[YYYY]: Total Asset Turnover ratio.
  • roa[YYYY]: Return on Assets.
  • roe[YYYY]: Return on Equity.
  • net_profit_margin[YYYY]: Net Profit Margin.
  • gross_profit_margin[YYYY]: Gross Profit Margin.
  • operating_profit_margin[YYYY]: Operating Profit Margin.
  • capital_adequacy_ratio[YYYY]: Capital Adequacy Ratio (CAR).
  • casa_ratio[YYYY]: Current Account Savings Account (CASA) ratio.
  • leverage_ratio[YYYY]: Leverage ratio.
  • loan_to_deposit_ratio[YYYY]: Loan-to-Deposit ratio (LDR).
  • liquidity_coverage_ratio[YYYY]: Liquidity Coverage Ratio (LCR).
  • efficiency_ratio[YYYY]: Efficiency ratio.
  • net_interest_margin[YYYY]: Net Interest Margin (NIM).
  • cost_to_income_ratio[YYYY]: Cost-to-Income ratio.
  • eps_growth[YYYY]: The year-over-year growth of Earnings Per Share for the specified year.
How to Use: You must use bracket notation field[Qi-YYYY] to access data for a specific quarter.
  • where=revenue_q[Q1-2024] > 1000000000
  • where=earnings_q[Q4-2023] > earnings_q[Q3-2023]
  • revenue_q[Period]: Revenue for the specified quarter (e.g., Q1-2024).
  • earnings_q[Period]: Earnings/Net Income for the specified quarter.
  • gross_profit_q[Period]: Gross Profit.
  • ebit_q[Period]: EBIT (Earnings Before Interest and Taxes).
  • ebitda_q[Period]: EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization).
  • earnings_before_tax_q[Period]: Earnings Before Tax (EBT).
  • tax_q[Period]: Tax expense.
  • cost_of_revenue_q[Period]: Cost of revenue.
  • operating_pnl_q[Period]: Operating Profit/Loss.
  • operating_expense_q[Period]: Operating expenses.
  • interest_income_q[Period]: Interest income.
  • interest_expense_q[Period]: Interest expense.
  • non_operating_income_or_loss_q[Period]: Non-operating income or loss.
  • total_assets_q[Period]: Total assets.
  • total_liabilities_q[Period]: Total liabilities.
  • total_equity_q[Period]: Total equity.
  • total_debt_q[Period]: Total debt.
  • cash_only_q[Period]: Cash balance.
  • current_assets_q[Period]: Current assets.
  • current_liabilities_q[Period]: Current liabilities.
  • non_current_liabilities_q[Period]: Non-current liabilities.
  • operating_cash_flow_q[Period]: Operating cash flow.
  • investing_cash_flow_q[Period]: Investing cash flow.
  • financing_cash_flow_q[Period]: Financing cash flow.
  • free_cash_flow_q[Period]: Free cash flow.
  • capital_expenditure_q[Period]: Capital expenditure.
  • net_interest_income_q[Period]: Net interest income (Banks).
  • non_interest_income_q[Period]: Non-interest income (Banks).
  • gross_loan_q[Period]: Gross loans (Banks).
  • net_loan_q[Period]: Net loans (Banks).
  • total_deposit_q[Period]: Total deposits (Banks).
  • time_deposit_q[Period]: Time deposits (Banks).
  • savings_account_q[Period]: Savings accounts (Banks).
  • current_account_q[Period]: Current accounts (Banks).
  • allowance_for_loans_q[Period]: Allowance for loans (Banks).
  • non_interest_bearing_liabilities_q[Period]: Non-interest bearing liabilities.
  • other_interest_bearing_liabilities_q[Period]: Other interest-bearing liabilities.
  • interest_expense_non_operating_q[Period]: Non-operating interest expense.
  • premium_income_q[Period]: Premium income (Insurance).
  • premium_expense_q[Period]: Premium expense (Insurance).
  • net_premium_income_q[Period]: Net premium income (Insurance).
  • realized_capital_goods_investment_q[Period]: Realized capital goods investment.
  • provision_q[Period]: Provisions.
  • total_cash_and_due_from_banks_q[Period]: Total cash and due from banks.
How to Use: The query checks if any object in the list matches the condition. Use = or like for string properties and numeric operators (>, <, etc.) for numeric properties.
  • where=major_shareholders_name like 'PT%' and major_shareholders_share_percentage > 0.1
  • where=key_executives_name = 'Prajogo Pangestu'
  • where=executives_shareholdings_share_percentage > 0.01
  • key_executives_name: The name of a key executive.
  • key_executives_position: The position of a key executive.
  • executives_shareholdings_name: The name of an executive shareholder.
  • executives_shareholdings_share_amount: The number of shares held by an executive.
  • executives_shareholdings_share_percentage: The ownership percentage held by an executive.
  • major_shareholders_name: The name of a major shareholder.
  • major_shareholders_share_value: The value of shares held by a major shareholder.
  • major_shareholders_share_amount: The number of shares held by a major shareholder.
  • major_shareholders_share_percentage: The ownership percentage held by a major shareholder.
order_by
string
default:"symbol"
Field to sort results by.
  • Use - prefix for descending order (e.g., order_by="-market_cap").
  • Use parentheses for arithmetic expressions to avoid ambiguity with the negative sign (e.g., order_by="-(earnings[2024]/earnings[2023])").
  • Use a comma-separated list for multi-level sorting.
This parameter is ignored if q is present.
limit
integer
default:"50"
The maximum number of results to return. Max value is 200. This parameter is ignored if q is present.
offset
integer
default:"0"
The number of results to skip for pagination. This parameter is ignored if q is present.
include_query_values
boolean
default:"false"
If set to true, the response will include a query_values object showing the interpreted values used for the query (e.g., extracted year, country).

Response

query_values
object
results
Company[]
An array of company objects matching the query.
pagination
object
An object containing pagination details.
llm_translation
object | null
Included only for natural language queries (using the q parameter). This object shows how the natural language query was translated into structured API parameters.