SFC Licensed Persons
Hong Kong SFC licensed financial intermediaries directory
sfc_licences
- Rows
- 144,401
- Coverage
- April 2003 to October 2026
- Columns
- 14
- Latest data
- 2026-10-22
Sample
8 rows shown
500 SFC licensees stratified across entity kind, active status, and AMLO.
| ceref | entity_name | entity_name_chi | entity_kind | regulated_activity_types | licence_info | is_active | has_amlo_licence | has_licence_info | licence_valid_from | licence_valid_to | source_url | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AAW523 | CHAN Pak Chi | 陳伯志 | Individual | 1; 4; 9 | Dealing in securities; Advising on securities; Asset management | 1 | 0 | 1 | 2026-10-22 | — | https://apps.sfc.hk/publicregWeb/indi/AAW523/licenceRecord | 2026-10-23 03:17:13.549000 | a0d5d17683a1a7dd4b2ac9ea255145fe |
| BKN718 | LEUNG Chi Yung | 梁志勇 | Individual | 1; 2; 4 | Dealing in securities; Dealing in futures contracts; Advising on securities | 1 | 0 | 1 | 2026-10-22 | — | https://apps.sfc.hk/publicregWeb/indi/BKN718/licenceRecord | 2026-10-23 03:17:13.549000 | d3966dc19431c7fef27487cce75046fe |
| BQF048 | CHEN YANG | 陳陽 | Individual | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-10-22 | — | https://apps.sfc.hk/publicregWeb/indi/BQF048/licenceRecord | 2026-10-23 03:17:13.549000 | 95c8088d30da222fb844675447847625 |
| BVX469 | CHAN Ying Shen | 陳穎生 | Individual | 9 | Asset management | 1 | 0 | 1 | 2026-10-22 | — | https://apps.sfc.hk/publicregWeb/indi/BVX469/licenceRecord | 2026-10-23 03:17:13.549000 | d9231a498e8a92e7b0073157d722ca88 |
| BWB927 | LIN Yayun | 林雅芸 | Individual | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-10-22 | — | https://apps.sfc.hk/publicregWeb/indi/BWB927/licenceRecord | 2026-10-23 03:17:13.549000 | 9f70c7b9f27d7a672ca9f32f15e2ce00 |
| BXF442 | Blue Horizon Partners Capital Management Company Limited | 深藍視界資本管理有限公司 | Corporation | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-10-22 | — | https://apps.sfc.hk/publicregWeb/corp/BXF442/details | 2026-10-23 03:17:13.549000 | ab2edbf0571723bbeb77f17eeb5c9865 |
| BXF443 | YUAN Zhongyi | 袁中一 | Individual | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-10-22 | — | https://apps.sfc.hk/publicregWeb/indi/BXF443/licenceRecord | 2026-10-23 03:17:13.549000 | a0b8c31a6de93f8f040582db737e30e3 |
| BXN191 | ZHAO Weice | 趙韋策 | Individual | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-10-22 | — | https://apps.sfc.hk/publicregWeb/indi/BXN191/licenceRecord | 2026-10-23 03:17:13.549000 | c94eb5046e1648743d19cf8526438626 |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
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 10Ways to get this table
One-off archive
SFC Licensed Persons — Snapshot
All current + historical licensees
US$49 one-off
Buy the archive SFC Licensed Persons — SnapshotSubscription
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.