Taiwan Broker Financials API (證券商財務資料・月計表・收支概況)

How much did Yuanta, KGI or Fubon Securities make last month, and how is each Taiwan securities firm's balance sheet put together? This Actor returns the monthly balance sheet and income statement of every Taiwan securities firm back to January 2013, each firm's complete trial balance and income-and-expense accounts for the latest month, and the register of firms and branch offices with headcount — all from the Taiwan Stock Exchange, and checked against each other.

Many Taiwan securities firms are unlisted subsidiaries, so their numbers never show up in a listed-company financial-statement feed — and even for the listed ones, quarterly filings are consolidated and three months apart. The exchange publishes every firm's own figures monthly: a condensed report since 1999, and the full 746-account trial balance as open data. This Actor turns both into one clean dataset.

Output

Five record types in one dataset, told apart by record_type. Real rows:

monthly_financials — condensed balance sheet plus the month's and year-to-date income statement, per firm per month, history from 2013-01 (證券商月報・證券商財務資料)

{
  "record_type": "monthly_financials",
  "report_month": "2026-08",
  "broker_code": "9800",
  "broker_name": "元大",
  "broker_category": "integrated",
  "broker_category_zh": "綜合證券商",
  "unit": "TWD thousand",
  "current_assets": 1122523405,
  "total_assets": 1242133816,
  "total_liabilities": 1040396136,
  "share_capital": 71208897,
  "total_equity": 201737679,
  "month_revenue": 10359015,
  "month_expenses": 6098002,
  "month_operating_income": 4261013,
  "month_pretax_income": 5396371,
  "month_net_income": 4506188,
  "ytd_revenue": 79795572,
  "ytd_net_income": 33834590,
  "ytd_start": "2026-01-01",
  "ytd_end": "2026-08-31",
  "identities_hold": true
}

(Abridged: every row also carries the seven asset lines, four liability lines, other gains and losses and other comprehensive income for both periods, and the source file URL.)

income_statement — every revenue and expense account, month and year to date, per firm (收支概況表, ~312 accounts × 65 firms)

{
  "record_type": "income_statement",
  "issued_on": "2026-09-25",
  "report_month": "2026-08",
  "broker_code": "9800",
  "broker_name": "元大",
  "account_code": "401000",
  "account_name": "經紀手續費收入",
  "month_amount": 3882302932,
  "ytd_amount": 33577200065,
  "unit": "TWD"
}

trial_balance — every account's debits, credits and closing balance, per firm (月計表, 746 accounts × 65 firms ≈ 48,500 rows; opt-in)

{
  "record_type": "trial_balance",
  "issued_on": "2026-09-25",
  "report_month": "2026-08",
  "broker_code": "9800",
  "account_code": "110000",
  "account_name": "流動資產",
  "month_debit_total": 21915236000559,
  "month_credit_total": 21834358438277,
  "balance": 1122523405063,
  "unit": "TWD"
}

firm — the register: capital, licences, chairman, president, headcount (64 firms)

{
  "record_type": "firm",
  "broker_code": "9800",
  "broker_name": "元大",
  "paid_in_capital": 71208897,
  "capital_unit": "TWD thousand",
  "incorporated_on": "2007-08-24",
  "business_lines": ["經紀", "自營", "承銷"],
  "licensed_activities": ["101--在集中交易市場受託買賣有價證券", "…"],
  "chairman": "陳修偉",
  "president": "郭明正",
  "headcount_total": 1343
}

branch — every branch office with address, opening date and headcount (817 branches)

{
  "record_type": "branch",
  "broker_code": "9801",
  "broker_name": "元大-松江",
  "firm_name": "元大",
  "branch_name": "松江",
  "opened_on": "2007-09-26",
  "address": "臺北市中山區松江路106號3樓",
  "headcount_total": 32
}

History

Record type	History	Notes
monthly_financials	2013-01 →	one spreadsheet per firm category per month
income_statement	latest month	open data, no history parameter
trial_balance	latest month	open data, no history parameter
firm, branch	today	register snapshots

The exchange's monthly reports go back to 1999, but before 2013 they use the old ROC GAAP chart of accounts (受託買賣借項, 營業外收入 and so on) in a different layout. Those years are not included rather than forced into IFRS columns they do not match.

Firms are reported in five categories, each its own file: integrated (綜合證券商), broker (專業證券經紀商), futures_firm (期貨兼營證券商), two_business (經營二種業務證券商, from 2017-07) and dealer (專業證券自營商, from 2022-08). A sixth category, 兼營證券商 (banks and others that run a securities business on the side), is published as PDF only and is not included.

A month's report appears on about the 20th trading day of the following month.

Verification

• Every firm's accounts add up. Asset lines sum to total assets, liability lines to total liabilities, assets equal liabilities plus equity, revenue minus expenses equals operating income, and operating income plus other gains equals pre-tax income. The report rounds each printed figure to the thousand, so a sum of n figures may miss its total by up to n/2 thousand — that is the tolerance, derived rather than picked. Across all 651 files from 2013-01 to 2026-08 (11,435 firm-months) asset and liability totals are exact and the balance-sheet equation misses by at most 3 — no breach anywhere. A breach fails the run. The result is on every row as identities_hold.
• The total column is the sum of the firms. Each file closes with a category total; every line of it must equal the sum of the firm columns. The one exception is a known blank: every file from 2019-01 to 2024-09, in every category, prints 0 for the total's right-of-use assets while the firms carry them. That is logged, not treated as a parse error.
• The open data and the monthly report are the same numbers. The trial balance divided by a thousand is the monthly report's current assets, total assets, current liabilities and total liabilities; the income statement's pre-tax income, net income and other comprehensive income are the monthly report's, month and year to date. On the issue of 2026-09-25, 244 of 244 balance-sheet figures and 366 of 366 income figures agreed within rounding; the largest gap was 2 thousand, on a total-assets figure that the monthly report builds by adding seven rounded lines.
• That match is also how the open data is dated. The feeds carry only the date they were issued (issued_on), not the month they describe. The Actor finds report_month by matching the figures to the monthly reports of the preceding months; if nothing matches, report_month is left empty and a warning is logged rather than guessing "the previous month".
• Net income = pre-tax income − income tax inside the income statement feed, exactly, in whole TWD — 65 of 65 firms, month and year to date.
• Headcount adds up: men + women = total for all 867 offices.

Traps in the source that this Actor handles

• The trial balance's "debit balance" is not a debit balance. The column is titled 借方餘額, but liabilities, equity and revenue print positive and contra accounts such as accumulated depreciation print negative: each account is on its own natural side. The field is published as balance and the README says so, rather than inverting signs.
• The year to date is not always from January. The report's footnote lists firms on a non-calendar fiscal year (on the 2026-08 report: 港商麥格理, 港商野村 and 大和國泰, from April). ytd_start and ytd_end are read from that footnote for each firm.
• The line between operating and pre-tax income was renamed. It is 營業外損益 until 2018 and 其他利益及損失 from 2019; both are other_gains_losses, and the identity holds on both. Right-of-use assets appear from 2019 (IFRS 16) and are null before.
• The exchange's CDN challenges fast downloaders. www.twse.com.tw sits behind an anti-DDoS service that answers an address making parallel requests with a challenge page — an HTML page with status 428 instead of the spreadsheet. The Actor downloads one file at a time, checks that every file really is a spreadsheet, and never parses a challenge page as data.
• File formats change mid-history: .xls until 2016, .xlsx from 2017. The listing API names each file, so the format is never guessed from the year.
• Some names use private-use glyphs. 6010 犇亞 is printed with a Big5 extension character in several years; broker_name is null there rather than garbled. The code is always present.

Input

• recordTypes — any of the five. Default: monthly_financials.
• startMonth / endMonth — YYYY-MM. Leave both empty for the latest published month.
• brokerCodes — keep only these firms or branches (9800, 9A00).
• brokerCategories — integrated, broker, dealer, futures_firm, two_business.
• accountCodes — account code prefixes for trial_balance and income_statement, e.g. 1 (assets), 401 (brokerage commissions), 902 (profit lines).
• maxRequests — cap for long backfills (default 250; 2013 to today is about 670).
• useApifyProxy — for a full backfill.

A default run (latest month, all firms) is 61 rows for 2026-08. The full history, 2013-01 to 2026-08, is 11,435 firm-months.

Limitations, stated plainly

• These are the firms' own unaudited figures (自結數), filed monthly. The audited statements are on MOPS and may differ.
• Figures are standalone, not consolidated — a firm's subsidiaries are not in its numbers.
• The trial balance and income statement cover the latest month only. The exchange keeps no history of them; run this Actor monthly to build one.
• The open data covers 65 firms and the 2026-08 monthly report 61: four firms — 0200 遠智, 0250 基富通, 0290 台灣巴克萊 and 0A10 好好 — appear only in the open data, and the PDF-only 兼營 category is in neither. No firm is invented to fill a gap.
• One firm's income accounts in the 2026-09-25 trial balance (0250) are all zero while the income-and-expense feed carries them. Both are published as issued.

Source

Taiwan Stock Exchange (臺灣證券交易所): 證券商月報 — 綜合／專業證券經紀商／專業證券自營商／期貨兼營證券商／經營二種業務證券商財務資料 (AUD402); open data t187ap20 各券商每月月計表, t187ap21 各券商收支概況表, t187ap18 證券商基本資料, OpenData_BRK02 證券商分公司基本資料, OpenData_BRK01 證券商營業員男女人數.

Taiwan Market Data Suite

This Actor is part of a suite of 44 Taiwan market data APIs by chamarix — official sources only, cross-validated against independent official endpoints, clean JSON out. Code samples for the whole suite: GitHub.

Market data:

• taiwan-corporate-bonds — Every corporate, bank & Formosa bond — terms, balance, ratings & ISINs, daily OTC trades since 2005 and USD bond fair values since 2017
• taiwan-securities-lending-balance — Shares on loan for every stock since 2004 by lending channel, every SLB trade with its borrow fee rate, and each firm's lending book
• taiwan-ipo-listings — Every TWSE & TPEx listing application since 2000 from filing to first trading day — review, approval, price, underwriter & withdrawals, plus delistings
• taiwan-board-directors — Every independent director's career and other board seats linked to stock codes, board rosters, chair/CEO duality & director elections
• taiwan-broker-financials — Every securities firm's monthly balance sheet & P&L since 2013, full trial balance, and the register of firms & branches
• taiwan-short-sale-eligibility — Can it be shorted today? Below-close short list, shares available to borrow, borrow fees, margin haircuts & forced cover dates
• taiwan-gold-spot — The Taipei Exchange physical gold board since 2015 — daily VWAP, traded high/low, market-maker spread and every print by firm and price
• taiwan-convertible-bonds — Daily bars for every convertible bond on the Taipei Exchange, with conversion price, conversion window, put date & put price
• taiwan-corporate-action-prices — Capital reductions, par value changes & ETF splits — the official reopening price & adjustment factor for every price discontinuity since 2011
• taiwan-ipo-subscription — Every IPO ballot since 2006 & every competitive auction since 2016 — odds, ticket cost, reserve & bid-to-cover
• taiwan-intraday-5sec-stats — Market-wide order book & all sector indices every 5 seconds since 2004, 3,241 rows a session
• taiwan-stock-daily-quotes — Daily OHLCV, VWAP, P/E, price-to-book & dividend yield for every listed/OTC stock since 2004
• taiwan-index-history — Daily TAIEX & TPEx index history since 1990 with market turnover, the total-return index & all 273 TWSE indices
• twse-institutional-trades — Daily institutional buy/sell (foreign, investment trust, dealer) per stock — TWSE listed
• tpex-institutional-trades — Daily institutional buy/sell per stock — TPEx OTC market
• taiwan-monthly-revenue — Monthly revenue of 1,900+ listed & OTC companies, MoM/YoY
• taiwan-financial-statements — Quarterly income statement, balance sheet & cash flow back to 2013
• taiwan-director-compensation — Board pay for 1,950+ companies, parent vs consolidated scope, with EPS, ROE & profit on the same row
• taiwan-esg-disclosures — 21 ESG topics for 1,950+ companies — Scope 1/2/3 emissions, energy, water, waste, pay, board & climate risk
• taiwan-dividend-calendar — Ex-dividend / ex-rights dates, reference prices & payouts back to 2003
• taiwan-margin-trading — Daily margin trading & short sale balances per stock
• taiwan-sbl-short-sale-balance — Securities-lending short sale balances per stock
• taiwan-short-sale-volume — Daily short sale turnover per stock — margin & borrowed lots, value and implied price, since 2008
• taiwan-day-trading-stats — Day-trading volume, value & ratio per stock since 2014
• taiwan-odd-lot-trading — Both odd-lot sessions per stock — intraday & after-hours, shares, turnover, OHLC & quotes since 2004
• taiwan-broker-rankings — Securities-firm turnover, market share & the top firms in each hot stock on the OTC board since 2007
• tdcc-shareholding-dispersion — Weekly TDCC shareholding dispersion (retail vs whale structure)
• taiwan-foreign-shareholding — Foreign ownership percentage & remaining quota per stock
• taiwan-futures-daily — Daily bars, settlement price & open interest for all 384 TAIFEX futures contracts since 1998, with the large-trader report
• taifex-institutional-derivatives — Institutional futures & options positions (TAIFEX), incl. put/call ratio
• taifex-options-chain — Full options chain by strike & expiry, both sessions, with the exchange's own Delta, since 2001
• taiwan-warrants-daily — Daily quotes, strike, expiry & moneyness for every listed/OTC warrant since 2004
• taiwan-government-bonds — Central government bond benchmark yields, the full yield curve & issuance master, with staleness stated
• taiwan-stock-alerts — Watch-list, disposition & short-sale suspension alerts
• taiwan-insider-share-transfers — Insider share-transfer filings (directors, officers, 10% holders) since 2002
• taiwan-director-shareholdings — Monthly director/officer shareholdings & share-pledge ratio since 1999
• taiwan-block-trades — Every block trade (鉅額交易) with price, size & basket constituents since 2005
• taiwan-shareholder-meetings — Shareholder meeting dates, book closure periods & e-voting since 2005
• taiwan-emerging-stock-quotes — Emerging (興櫃) board quotes, pre-IPO register & history since 2003
• taiwan-etf-regular-investment — Monthly regular savings plan (定期定額) rankings for stocks & ETFs since 2020
• taiwan-treasury-stock-buybacks — Every treasury-stock buyback (庫藏股) filing, plan vs execution, since 2000

Property market:

• taiwan-real-estate-transactions — Actual registered sale, presale & lease prices (實價登錄) for all 22 cities since 2012

Government & civic data:

• taiwan-legislator-monitor — Legislative Yuan bills, legislators & meetings
• taiwan-tender-monitor — Government e-procurement tenders (open calls, awards, failures)