SFC Licensed Persons
Hong Kong SFC licensed financial intermediaries directory
sfc_licences
- 行數
- 143,931
- 涵蓋期間
- 2003年4月至2026年9月
- 欄位數目
- 14
- 最新數據
- 2026-09-30
樣本
顯示 8 行
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BVS154 | UOB KAY HIAN INVESTMENT MANAGEMENT (HONG KONG) LIMITED | 大華繼顯投資管理(香港)有限公司 | Corporation | 9 | Asset management | 1 | 0 | 1 | 2026-09-30 | — | https://apps.sfc.hk/publicregWeb/corp/BVS154/details | 2026-10-01 03:16:59.977000 | 12dc9bbbed0ee740a8bd881ac84ff43e |
| BWS315 | LEE Derrick Meow Chan | — | Individual | 9 | Asset management | 1 | 0 | 1 | 2026-09-30 | — | https://apps.sfc.hk/publicregWeb/indi/BWS315/licenceRecord | 2026-10-01 03:16:59.977000 | 057b1fa1c9fbb3aed236ec4e9a58d888 |
| BWW802 | GRAND INTEGRITY ASSET MANAGEMENT LIMITED | 宏譽資產管理有限公司 | Corporation | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-09-30 | — | https://apps.sfc.hk/publicregWeb/corp/BWW802/details | 2026-10-01 03:16:59.977000 | cd9b71c50bd94e125e6025d85b223b07 |
| BXD888 | STILLPOINT CAPITAL LIMITED | — | Corporation | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-09-30 | — | https://apps.sfc.hk/publicregWeb/corp/BXD888/details | 2026-10-01 03:16:59.977000 | 71e4375fcc10d44ea86b40bb4428e242 |
| BXD889 | FAN Wenjing | 范⽂靜 | Individual | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-09-30 | — | https://apps.sfc.hk/publicregWeb/indi/BXD889/licenceRecord | 2026-10-01 03:16:59.977000 | fa837845108a790cc3662cc4bc90b3d5 |
| BXD891 | WANG Yang | 王阳 | Individual | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-09-30 | — | https://apps.sfc.hk/publicregWeb/indi/BXD891/licenceRecord | 2026-10-01 03:16:59.977000 | 205c8ffa319c4e1288b73a1093e91db9 |
| BXH166 | Symmetrix Investments Limited | — | Corporation | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-09-30 | — | https://apps.sfc.hk/publicregWeb/corp/BXH166/details | 2026-10-01 03:16:59.977000 | 3355ac7e3820ace79dfa24a642840b1e |
| BXI580 | CHAMELEON SECURITIES INTERNATIONAL LIMITED | — | Corporation | 1; 4; 9 | Dealing in securities; Advising on securities; Asset management | 1 | 0 | 1 | 2026-09-30 | — | https://apps.sfc.hk/publicregWeb/corp/BXI580/details | 2026-10-01 03:16:59.977000 | 938d4d0fb0bc50eaf1c2adb9a38210fd |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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. |
查詢數據
每個數據表均可透過 Renavon 帳戶，以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.sfc_licences LIMIT 10取得此數據表的方式
一次性存檔
SFC Licensed Persons — Snapshot
All current + historical licensees
一次性 US$49
購買存檔 SFC Licensed Persons — Snapshot （在新分頁開啟）訂閱
HK Corporate Diligence — Compliance Pass
每月 1,000,000 行另包含 14 個數據表