---
title: "SGX Companies Screener"
method: GET
path: "/v2/sgx/companies/"
tags: ["SGX - Company Screener"]
---

# SGX Companies Screener

`GET /v2/sgx/companies/`

High-performance API for filtering and sorting SGX-listed companies. Supports both structured SQL-like queries (`where`, `order_by`) and natural language queries (`q`). Returns a paginated list of companies.

**Query modes** (mutually exclusive — `q` overrides all others):
- `q`: Natural language, e.g. `top 5 SGX banks by market cap`
- `where` + `order_by`: SQL-like structured query

<Note>SGX symbol: 3 characters (letters or digits). E.g. `D05`, `U11`, `Z74`. No suffix.</Note>

<Note>SGX sector column contains duplicate variants (e.g. `Consumer Cyclical` / `Consumer Cyclicals`, `Financial Services` / `Financials`, `Real Estate` / `Properties & Real Estate` / `REIT`) pending upstream cleanup. To capture all matching companies, query with `OR` (e.g. `sector = 'Real Estate' OR sector = 'Properties & Real Estate' OR sector = 'REIT'`).</Note>

<Accordion title="Smart FY Handling">
To account for reporting lags, 'latest year' queries made between January and April default to the previous audited year (e.g. a query in early 2026 uses 2024 data).
</Accordion>

<Accordion title="Syntax and Operators">
**Operators:** `=`, `!=`, `>`, `>=`, `<`, `<=`, `like`, `in`

**Logic:** combine conditions with `and` and `or`

**String values:** use single or double quotes — `sector = 'Technology'`

**Lists (for `in`):** `tags in ['blue-chip', 'dividend']`
</Accordion>

<Accordion title="Yearly Data">
Access historical data using bracket notation: `field[YYYY]`

Examples: `revenue[2023] > 1000000000` or `total_yield[2024] > 0.05`

**Note:** SGX data is annual only — there is no quarterly data.
</Accordion>

<Accordion title="Arithmetic Expressions">
Perform calculations within your query on both sides of a condition.

Examples: `earnings[2024] > earnings[2023] * 1.25` or `revenue[2024] / revenue[2023] > 1.5`
</Accordion>

<Accordion title="SGX-Specific Limitations">
Some IDX screener features are **not available** for SGX due to data scope:

- **No person / entity ownership queries** — no `executives`, `major_shareholders`, or `affiliates` fields.
- **No peer averages** — no `pe_peer_avg`, `pb_peer_avg`, etc.
- **No `free_float` field**.
- **No quarterly data** — only annual fields like `revenue[2024]`.
- **Coverage caveats**: yearly fields marked `[Big caps only]` are populated only for ~22 large-caps; fields marked `[Banks only]` are populated only for DBS / OCBC / UOB.
</Accordion>

<Accordion title="Available Fields">
<AccordionGroup>

<Accordion title="Direct Fields (Top-level columns)">
**How to Use:** Query these fields directly using standard operators (`=`, `!=`, `>`, `<`, `LIKE`, `IN`). String comparisons are case-insensitive.

<Accordion title="Examples">
- `where=market_cap > 500000000000000`
- `where=company_name like '%energi%'`
- `where=sector = 'Financials' and listing_date > '2005-01-01'`
</Accordion>

- **symbol**: SGX ticker symbol (3 characters, e.g. `D05`, `U11`, `Z74`)
- **company_name**: Full registered company name
- **sector**: SGX sector classification. NB: source data contains duplicate labels (e.g. `Consumer Cyclical` vs `Consumer Cyclicals`, `Financial Services` vs `Financials`) — pending upstream cleanup.
- **sub_sector**: SGX sub-sector classification (126 distinct values)
- **market_cap**: Market capitalisation in SGD
- **volume**: Recent average daily trading volume (shares)
- **last_close_price**: Most recent close price in SGD
- **employee_num**: Total number of employees
- **pe**: Price-to-earnings ratio
- **eps**: Earnings per share (SGD)
- **beta**: Beta vs SGX market
- **ps**: Price-to-sales ratio
- **pcf**: Price-to-cash-flow ratio
- **pb**: Price-to-book ratio
- **gross_margin**: Gross profit margin (decimal, e.g. 0.45 = 45%)
- **operating_margin**: Operating profit margin (decimal)
- **net_profit_margin**: Net profit margin (decimal)
- **quick_ratio**: Quick ratio (acid test)
- **current_ratio**: Current ratio
- **debt_to_equity**: Debt-to-equity ratio
- **one_year_eps_growth**: 1-year EPS growth (decimal)
- **one_year_sales_growth**: 1-year sales (revenue) growth (decimal)
- **forward_dividend**: Forward annual dividend per share in SGD
- **forward_dividend_yield**: Forward annual dividend yield (decimal)
- **dividend_ttm**: Trailing-twelve-month dividend per share in SGD
- **dividend_yield_5y_avg**: 5-year average dividend yield (decimal)
- **dividend_growth_rate**: Year-over-year dividend growth rate (decimal)
- **payout_ratio**: Dividend payout ratio (decimal)
- **change_1d**: 1-day price change (decimal)
- **change_7d**: 7-day price change (decimal)
- **change_1m**: 1-month price change (decimal)
- **change_ytd**: Year-to-date price change (decimal)
- **change_1y**: 1-year price change (decimal)
- **change_3y**: 3-year price change (decimal)
</Accordion>

<Accordion title="Array Fields">
**How to Use:** Query using the `in` operator to check if any of the provided values exist in the array.

<Accordion title="Examples">
- `where=indices in ['LQ45', 'IDX30']`
- `where=tags in ['52-w-high', 'public-float-under-25']`
</Accordion>

- **tags**: Analyst sentiment / classification tags
</Accordion>

<Accordion title="JSON Object Fields (Most Recent Data)">
**How to Use:** Query as if they were direct fields — the parser automatically extracts the value from the underlying JSON.

<Accordion title="Examples">
- `where=pe_ttm < 15 and roe_ttm > 0.1`
- `where=last_close_price < all_time_high_price`
- `where=ytd_low_date > '2025-03-01'`
</Accordion>

- **ytd_low_price**: Year-to-date lowest closing price in SGD
- **ytd_low_date**: Date of the year-to-date lowest closing price
- **ytd_high_price**: Year-to-date highest closing price in SGD
- **ytd_high_date**: Date of the year-to-date highest closing price
- **52_w_low_price**: 52-week lowest closing price in SGD
- **52_w_low_date**: Date of the 52-week lowest closing price
- **52_w_high_price**: 52-week highest closing price in SGD
- **52_w_high_date**: Date of the 52-week highest closing price
- **90_d_low_price**: 90-day lowest closing price in SGD
- **90_d_low_date**: Date of the 90-day lowest closing price
- **90_d_high_price**: 90-day highest closing price in SGD
- **90_d_high_date**: Date of the 90-day highest closing price
- **all_time_low_price**: All-time lowest closing price in SGD
- **all_time_low_date**: Date of the all-time lowest closing price
- **all_time_high_price**: All-time highest closing price in SGD
- **all_time_high_date**: Date of the all-time highest closing price
</Accordion>

<Accordion title="Yearly JSON Fields (Historical & Forecast Data)">
**How to Use:** Must use bracket notation `field[YYYY]` to access data for a specific year. Supports all numeric operators, field-to-field comparisons, and arithmetic expressions.

<Accordion title="Examples">
- `where=revenue[2023] > earnings[2023] * 5`
- `where=roe[2023] > 0.15 and roe[2022] > 0.15`
- `where=pe[2024] < pe_peer_avg[2024]`
</Accordion>

- **revenue**: Annual revenue in SGD. Use: `revenue[2024]`.
- **earnings**: Annual net profit/loss in SGD. Use: `earnings[2024]`.
- **total_dividend**: Total dividends paid per share for the year (SGD). Use: `total_dividend[2024]`.
- **total_yield**: Total dividend yield for the year (decimal). Use: `total_yield[2024]`.
- **operating_cash_flow**: Operating cash flow in SGD. Use: `operating_cash_flow[2024]`. _(coverage: Big caps only)_
- **investing_cash_flow**: Investing cash flow in SGD. Use: `investing_cash_flow[2024]`. _(coverage: Big caps only)_
- **financing_cash_flow**: Financing cash flow in SGD. Use: `financing_cash_flow[2024]`. _(coverage: Big caps only)_
- **free_cash_flow**: Free cash flow in SGD. Use: `free_cash_flow[2024]`. _(coverage: Big caps only)_
- **net_cash_flow**: Net cash flow in SGD. Use: `net_cash_flow[2024]`. _(coverage: Big caps only)_
- **capital_expenditure**: Capital expenditure in SGD. Use: `capital_expenditure[2024]`. _(coverage: Big caps only)_
- **ebit**: EBIT (earnings before interest and tax) in SGD. Use: `ebit[2024]`. _(coverage: Big caps only)_
- **ebitda**: EBITDA in SGD. Use: `ebitda[2024]`. _(coverage: Big caps only)_
- **gross_income**: Gross income in SGD. Use: `gross_income[2024]`. _(coverage: Big caps only)_
- **cost_of_revenue**: Cost of revenue in SGD. Use: `cost_of_revenue[2024]`. _(coverage: Big caps only)_
- **operating_income**: Operating income in SGD. Use: `operating_income[2024]`. _(coverage: Big caps only)_
- **operating_expense**: Operating expense in SGD. Use: `operating_expense[2024]`. _(coverage: Big caps only)_
- **pretax_income**: Pre-tax income in SGD. Use: `pretax_income[2024]`. _(coverage: Big caps only)_
- **income_taxes**: Income taxes paid in SGD. Use: `income_taxes[2024]`. _(coverage: Big caps only)_
- **total_asset**: Total assets in SGD. Use: `total_asset[2024]`. _(coverage: Big caps only)_
- **total_equity**: Total equity in SGD. Use: `total_equity[2024]`. _(coverage: Big caps only)_
- **total_liabilities**: Total liabilities in SGD. Use: `total_liabilities[2024]`. _(coverage: Big caps only)_
- **working_capital**: Working capital in SGD. Use: `working_capital[2024]`. _(coverage: Big caps only)_
- **total_current_asset**: Total current assets in SGD. Use: `total_current_asset[2024]`. _(coverage: Big caps only)_
- **total_non_current_asset**: Total non-current assets in SGD. Use: `total_non_current_asset[2024]`. _(coverage: Big caps only)_
- **net_interest_income**: Net interest income in SGD. Use: `net_interest_income[2024]`. _(coverage: Banks only)_
- **interest_income**: Total interest income in SGD. Use: `interest_income[2024]`. _(coverage: Banks only)_
- **interest_expense**: Total interest expense in SGD. Use: `interest_expense[2024]`. _(coverage: Banks only)_
- **net_fee_and_commission_income**: Net fee and commission income in SGD. Use: `net_fee_and_commission_income[2024]`. _(coverage: Banks only)_
- **net_trading_income**: Net trading income in SGD. Use: `net_trading_income[2024]`. _(coverage: Banks only)_
- **net_loan**: Net loans outstanding in SGD. Use: `net_loan[2024]`. _(coverage: Banks only)_
- **gross_loan**: Gross loans outstanding in SGD. Use: `gross_loan[2024]`. _(coverage: Banks only)_
- **total_deposit**: Total customer deposits in SGD. Use: `total_deposit[2024]`. _(coverage: Banks only)_
- **core_capital_tier1**: Core capital (Tier 1) in SGD. Use: `core_capital_tier1[2024]`. _(coverage: Banks only)_
- **total_risk_weighted_asset**: Total risk-weighted assets in SGD. Use: `total_risk_weighted_asset[2024]`. _(coverage: Banks only)_
</Accordion>

<Accordion title="Quarterly Financial Data">
**How to Use:** Must use bracket notation `field[Qi-YYYY]` to access data for a specific quarter.

<Accordion title="Examples">
- `where=revenue_q[Q1-2024] > 1000000000`
- `where=earnings_q[Q4-2023] > earnings_q[Q3-2023]`
</Accordion>


</Accordion>

<Accordion title="JSON List Fields">
**How to Use:** The query checks if **any** object in the list matches the condition. Use `=` or `like` for strings, numeric operators for numbers.

<Accordion title="Examples">
- `where=major_shareholders_name like 'PT%' and major_shareholders_share_percentage > 0.1`
- `where=key_executives_name = 'Prajogo Pangestu'`
</Accordion>


</Accordion>

</AccordionGroup>
</Accordion>

<Info>Costs 1 API credit for structured queries. Using the natural-language `?q=` parameter costs 3 API credits.</Info>

## Query parameters

- `where` string
- `q` string
- `order_by` string
- `desc` boolean
- `limit` integer
- `offset` integer
- `include_query_values` boolean

## Response `200`

Paginated list of SGX companies matching the query.

- SgxCompanyScreenerResponse
  - `results` SgxCompanyScreenerItem[], required
    - `symbol` string, required — SGX symbol (e.g. D05, U11).
    - `company_name` string, required — Full registered company name.
    - `query_values` unknown
  - `pagination` SgxCompanyScreenerPagination, required
    - `total_count` integer, required — Total number of matching results.
    - `showing` integer, required — Number of results in this page.
    - `limit` integer, required — Maximum results per page.
    - `offset` integer, required — Number of results skipped.
    - `has_next` boolean, required — Whether a next page exists.
    - `has_previous` boolean, required — Whether a previous page exists.
    - `next_offset` integer, nullable, required — Offset for the next page, or null.
    - `previous_offset` integer, nullable, required — Offset for the previous page, or null.
  - `llm_translation` SgxLLMTranslation, required
    - `natural_query` string, required — The original natural language query.
    - `translated_params` object, required — Structured query params generated by the LLM.
    - `message` string, required — Explanation of the translation.

## Other responses

- `400` — Bad request — invalid parameters, field names, operators, or query syntax.
- `429` — Rate limit exceeded.

---

[API](https://skmtc.dev/sectors/apis/sectors-api.md) · [All operations](https://skmtc.dev/sectors/apis/sectors-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/sectors/sectors-api/revisions/49e492f19d77/schema)