Skip to content

SFC Licensed Persons

Hong Kong SFC licensed financial intermediaries directory

sfc_licences

Rows
145,013
Coverage
April 2003 to November 2026
Columns
14
Latest data
2026-11-20

Sample

8 rows shown

500 SFC licensees stratified across entity kind, active status, and AMLO.

SFC Licensed Persons: Sample
cerefentity_nameentity_name_chientity_kindregulated_activity_typeslicence_infois_activehas_amlo_licencehas_licence_infolicence_valid_fromlicence_valid_tosource_urlupdated_atid
BWM012Tsinghua Redbud Capital Investment Limited—Corporation4; 9Advising on securities; Asset management1012026-11-20—https://apps.sfc.hk/publicregWeb/corp/BWM012/details2026-11-21 04:25:44.8930004276b269f544a50aae3d6b1ef0237e5f
BYF864HUO Yuying霍玉瑛Individual1; 6Dealing in securities; Advising on corporate finance1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYF864/licenceRecord2026-11-21 04:25:44.89300066a4886e0e35e42d7e0d4357274adcd8
BYM332XIE Lei謝磊Individual4; 9Advising on securities; Asset management1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYM332/licenceRecord2026-11-21 04:25:44.893000184f5cbc56a50102a92fe3a8c2d4a757
BYQ390WANG Weibiao王维标Individual1Dealing in securities1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYQ390/licenceRecord2026-11-21 04:25:44.8930006bea0e8d0f8fdbbf9ac400b42e6e7d2d
BYR273DENG Guanxian鄧冠賢Individual9Asset management1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYR273/licenceRecord2026-11-21 04:25:44.893000475814df3c9283ee9192c8ff145f5306
BYR898LEUNG Ki Wing梁琪穎Individual1Dealing in securities1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYR898/licenceRecord2026-11-21 04:25:44.8930001ddb7d1f531a0d34b715dcf04dc521bf
BYS092XU Zhaoen徐兆恩Individual1Dealing in securities1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYS092/licenceRecord2026-11-21 04:25:44.89300048351e5ebc35cd4194d9dafc75bb6466
BYT288LIU Huaqiu劉華秋Individual1; 6Dealing in securities; Advising on corporate finance1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYT288/licenceRecord2026-11-21 04:25:44.893000493c4dd3febe20da8e323367ee5c89c0

Both open directly in a spreadsheet.

Also as compressed CSV, JSON

Question about this table? Ask us. (opens in new tab)

Columns

SFC Licensed Persons: Columns
Column Type Description
ceref text Central Entity Reference number — the SFC's unique identifier for every licensed person and registered institution.
entity_name text Licensee name (the individual's name, or the firm's English name). NULL for deregistered entities present only in the historical archive.
entity_name_chi text Licensee name in Chinese, where the SFC register provides one.
entity_kind text Whether the licensee is an 'Individual' or a 'Corporation'. NULL for historical-archive-only entities.
regulated_activity_types text Semicolon-separated SFC regulated-activity Type numbers the entity is currently licensed for (e.g. '1; 4; 9'). Types 1-12 cover dealing in securities/futures, advising, asset management, and other regulated activities. Empty for historical-archive-only entities.
licence_info text Semicolon-separated descriptions of the regulated activities in regulated_activity_types (e.g. 'Dealing in securities; Advising on securities; Asset management').
is_active number 1 if the entity currently holds at least one active SFC licence, 0 if not. NULL for deregistered entities present only in the historical archive.
has_amlo_licence number 1 if the entity holds an active Anti-Money Laundering Ordinance (AMLO) licence (virtual-asset / trust-or-company service providers), 0 otherwise. NULL for historical-archive-only entities.
has_licence_info number 1 if the entity has at least one regulated activity on record.
licence_valid_from date Earliest date the entity held any SFC licence, across all regulated activities. The SFC licensing regime began on 1 April 2003, so most active licensees show 2003-04-01.
licence_valid_to date Latest date the entity's SFC licensing ended; NULL while the entity is currently licensed. Mined from the SFC's per-activity licence history.
source_url text SFC public register URL for the entity.
updated_at date and time Timestamp when the record was last refreshed from the SFC register.
id text Stable unique identifier for this row — the last column of every export. Use it to deduplicate, to key an incremental load, or to reference one specific row. It is additive: the entity and join keys you already use (race_id, horse_id, and the like) are unchanged.

Query it

Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.

SELECT * FROM renavon_exports.sfc_licences LIMIT 10

Get a key on renavon.com (opens in new tab)

Ways to get this table

Free sample

The sample files are free to download.

Free

Download the sample

One-off archive

SFC Licensed Persons — Snapshot

All current + historical licensees

US$49 one-off

Buy the archive SFC Licensed Persons — Snapshot

Subscription

HK Corporate Diligence — Compliance Pass

1,000,000 rows a monthwith 14 other tables

Subscriptions and archives are sold by Renavon, which sets the prices shown here and handles checkout.

See all pricing