456,322 rows

View and edit SQL

Suggested facets: timestamp (date), effDate (date), endDate (date)

Link nameenglish ceref timestamp indieo actType actDesc cactDesc effDate status lcRole princeref princename princenamechin namechinese endDate numberofdays applNo
LAI Chun Ying AAA011 2020-12-24 12:28:24 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 賴進英 2003-11-01 214  
LAI Chun Ying AAA011 2020-12-24 12:28:24 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 賴進英 2003-11-01 214  
LAI Chun Ying AAA011 2020-12-24 12:28:24 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 賴進英 2003-11-01 214  
LAI Chun Ying AAA011 2020-12-24 12:28:24 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 賴進英 2003-11-01 214  
LAI Chun Ying AAA011 2020-12-24 12:28:24 indi 1 Dealing in Securities 證券交易 2003-11-03 00:00:00 R RE ACX624 Elstone Securities Limited 千里碩證券有限公司 賴進英 2012-11-09 3294  
WONG Chung Sing, Xavier AAA012 2020-12-24 22:31:21 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RE AEK771 BNP Paribas Dealing Services Asia Limited 法國巴黎金融交易服務亞洲有限公司 黃仲聖 2007-08-31 1613  
WONG Chung Sing, Xavier AAA012 2020-12-24 22:31:21 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE AEK771 BNP Paribas Dealing Services Asia Limited 法國巴黎金融交易服務亞洲有限公司 黃仲聖 2004-04-20 385  
WONG Chung Sing, Xavier AAA012 2020-12-24 22:31:21 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE AEK771 BNP Paribas Dealing Services Asia Limited 法國巴黎金融交易服務亞洲有限公司 黃仲聖 2004-04-20 385  
WONG Chung Sing, Xavier AAA012 2020-12-24 22:31:21 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE AEK771 BNP Paribas Dealing Services Asia Limited 法國巴黎金融交易服務亞洲有限公司 黃仲聖 2007-08-31 1613  
WONG Chung Sing, Xavier AAA012 2020-12-24 22:31:21 indi 1 Dealing in Securities 證券交易 2007-12-28 00:00:00 R RE AME383 Generali Investments Asia Limited 忠利投資亞洲有限公司 黃仲聖 2008-05-20 144  
WONG Chung Sing, Xavier AAA012 2020-12-24 22:31:21 indi 1 Dealing in Securities 證券交易 2008-08-01 00:00:00 R RE AME383 Generali Investments Asia Limited 忠利投資亞洲有限公司 黃仲聖 2010-08-06 735  
WONG Chung Sing, Xavier AAA012 2020-12-24 22:31:21 indi 9 Asset Management 提供資產管理 2007-11-02 00:00:00 R RE AME383 Generali Investments Asia Limited 忠利投資亞洲有限公司 黃仲聖 2008-05-20 200  
WONG Chung Sing, Xavier AAA012 2020-12-24 22:31:21 indi 9 Asset Management 提供資產管理 2008-08-01 00:00:00 R RE AME383 Generali Investments Asia Limited 忠利投資亞洲有限公司 黃仲聖 2010-08-06 735  
WONG Chung Sing, Xavier AAA012 2020-12-24 22:31:21 indi 1 Dealing in Securities 證券交易 2010-12-15 00:00:00 R RE AOB278 UBP Asset Management Asia Limited 瑞士聯合資產管理亞洲有限公司 黃仲聖 2017-09-19 2470  
WONG Chung Sing, Xavier AAA012 2020-12-24 22:31:21 indi 9 Asset Management 提供資產管理 2010-12-15 00:00:00 R RE AOB278 UBP Asset Management Asia Limited 瑞士聯合資產管理亞洲有限公司 黃仲聖 2017-09-19 2470  
MA Mui Chu AAA013 2021-06-11 17:40:48 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RE ABK353 OnePlatform Securities Limited 環一證券有限公司 馬梅珠 2017-07-15 5219  
MA Mui Chu AAA013 2021-06-11 17:40:48 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE ABK353 OnePlatform Securities Limited 環一證券有限公司 馬梅珠 2004-09-22 540  
MA Mui Chu AAA013 2021-06-11 17:40:48 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE ABK353 OnePlatform Securities Limited 環一證券有限公司 馬梅珠 2004-09-22 540  
MA Mui Chu AAA013 2021-06-11 17:40:48 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE ABK353 OnePlatform Securities Limited 環一證券有限公司 馬梅珠 2004-09-22 540  
MA Mui Chu AAA013 2021-06-11 17:40:48 indi 1 Dealing in Securities 證券交易 2018-10-22 00:00:00 R RE AEJ390 Stellar Securities Limited 恆星證券有限公司 馬梅珠 2021-04-16 907  
NG Siu Wai AAA014 2021-06-11 17:53:55 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 伍兆煒 2005-03-21 720  
NG Siu Wai AAA014 2021-06-11 17:53:55 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 伍兆煒 2005-03-21 720  
NG Siu Wai AAA014 2021-06-11 17:53:55 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 伍兆煒 2004-02-19 324  
NG Siu Wai AAA014 2021-06-11 17:53:55 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 伍兆煒 2004-02-19 324  
NG Siu Wai AAA014 2021-06-11 17:53:55 indi 1 Dealing in Securities 證券交易 2005-03-21 00:00:00 R RE AAG378 Luen Fat Securities Company Limited 聯發證券有限公司 伍兆煒      
TSIEN David AAA015 2020-12-25 00:43:04 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE AAB026 J.P. Morgan Securities (Far East) Limited   錢柏昌 2005-10-05 918  
TSIEN David AAA015 2020-12-25 00:43:04 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE AAB026 J.P. Morgan Securities (Far East) Limited   錢柏昌 2003-12-23 266  
TSIEN David AAA015 2020-12-25 00:43:04 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE AAB026 J.P. Morgan Securities (Far East) Limited   錢柏昌 2003-12-23 266  
TSIEN David AAA015 2020-12-25 00:43:04 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RE AAB027 J.P. Morgan Broking (Hong Kong) Limited   錢柏昌 2006-04-21 1116  
TSIEN David AAA015 2020-12-25 00:43:04 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE AAB027 J.P. Morgan Broking (Hong Kong) Limited   錢柏昌 2006-04-21 1116  
TSIEN David AAA015 2020-12-25 00:43:04 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE AAB027 J.P. Morgan Broking (Hong Kong) Limited   錢柏昌 2003-12-02 245  
TSIEN David AAA015 2020-12-25 00:43:04 indi 7 Providing Automated Trading Services 提供自動化交易服務 2003-04-01 00:00:00 R RE AAB027 J.P. Morgan Broking (Hong Kong) Limited   錢柏昌 2003-12-02 245  
TSIEN David AAA015 2020-12-25 00:43:04 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE AAB027 J.P. Morgan Broking (Hong Kong) Limited   錢柏昌 2003-12-02 245  
TANG Chi Cheung AAA018 2021-06-11 19:04:53 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 鄧志章 2005-03-31 730  
TANG Chi Cheung AAA018 2021-06-11 19:04:53 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 鄧志章 2005-03-17 716  
TANG Chi Cheung AAA018 2021-06-11 19:04:53 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 鄧志章 2005-03-17 716  
TANG Chi Cheung AAA018 2021-06-11 19:04:53 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE AAA022 K. L. Securities Company 淦聯證券投資公司 鄧志章 2005-03-17 716  
TANG Chi Cheung AAA018 2021-06-11 19:04:53 indi 1 Dealing in Securities 證券交易 2005-04-01 00:00:00 R RE AAG378 Luen Fat Securities Company Limited 聯發證券有限公司 鄧志章      
CHONG Kui Wah AAA021 2020-12-24 05:38:20 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RE AAG436 Core Pacific - Yamaichi International (H.K.) Limited 京華山一國際(香港)有限公司   2016-06-30 4839  
CHONG Kui Wah AAA021 2020-12-24 05:38:20 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE AAG436 Core Pacific - Yamaichi International (H.K.) Limited 京華山一國際(香港)有限公司   2004-06-29 455  
CHONG Kui Wah AAA021 2020-12-24 05:38:20 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE AAG436 Core Pacific - Yamaichi International (H.K.) Limited 京華山一國際(香港)有限公司   2004-06-29 455  
CHONG Kui Wah AAA021 2020-12-24 05:38:20 indi 7 Providing Automated Trading Services 提供自動化交易服務 2003-04-01 00:00:00 R RE AAG436 Core Pacific - Yamaichi International (H.K.) Limited 京華山一國際(香港)有限公司   2004-06-29 455  
CHONG Kui Wah AAA021 2020-12-24 05:38:20 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE AAG436 Core Pacific - Yamaichi International (H.K.) Limited 京華山一國際(香港)有限公司   2004-06-29 455  
CHONG Kui Wah AAA021 2020-12-24 05:38:20 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RE ABH177 Core Pacific-Yamaichi Securities (H.K.) Limited 京華山一證券(香港)有限公司   2016-06-30 4839  
CHONG Kui Wah AAA021 2020-12-24 05:38:20 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE ABH177 Core Pacific-Yamaichi Securities (H.K.) Limited 京華山一證券(香港)有限公司   2004-06-29 455  
CHONG Kui Wah AAA021 2020-12-24 05:38:20 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE ABH177 Core Pacific-Yamaichi Securities (H.K.) Limited 京華山一證券(香港)有限公司   2004-06-29 455  
CHONG Kui Wah AAA021 2020-12-24 05:38:20 indi 7 Providing Automated Trading Services 提供自動化交易服務 2003-04-01 00:00:00 R RE ABH177 Core Pacific-Yamaichi Securities (H.K.) Limited 京華山一證券(香港)有限公司   2004-06-29 455  
CHONG Kui Wah AAA021 2020-12-24 05:38:20 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE ABH177 Core Pacific-Yamaichi Securities (H.K.) Limited 京華山一證券(香港)有限公司   2004-06-29 455  
CHONG Kui Wah AAA021 2020-12-24 05:38:20 indi 1 Dealing in Securities 證券交易 2016-07-01 00:00:00 R RE BHM090 Core Pacific - Yamaichi International (H.K.) Limited 京華山一國際(香港)有限公司   2018-12-01 883  
MO Loong Kwong AAA024 2021-06-11 17:40:46 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RO AAA022 K. L. Securities Company 淦聯證券投資公司 繆隆光 2005-03-31 730  
MO Loong Kwong AAA024 2021-06-11 17:40:46 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RO AAA022 K. L. Securities Company 淦聯證券投資公司 繆隆光 2005-03-15 714  
MO Loong Kwong AAA024 2021-06-11 17:40:46 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RO AAA022 K. L. Securities Company 淦聯證券投資公司 繆隆光 2005-03-15 714  
MO Loong Kwong AAA024 2021-06-11 17:40:46 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RO AAA022 K. L. Securities Company 淦聯證券投資公司 繆隆光 2005-03-15 714  
MO Loong Kwong AAA024 2021-06-11 17:40:46 indi 1 Dealing in Securities 證券交易 2005-04-26 00:00:00 R RE AAG378 Luen Fat Securities Company Limited 聯發證券有限公司 繆隆光 2005-07-12 77  
MO Loong Kwong AAA024 2021-06-11 17:40:46 indi 1 Dealing in Securities 證券交易 2005-07-12 00:00:00 R RO AAG378 Luen Fat Securities Company Limited 聯發證券有限公司 繆隆光      
GO Ai Hwa AAA027 2020-12-24 18:04:22 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RE AAK655 Ban Hin Securities Company Limited 萬興證券有限公司 吳媛華 2005-09-06 889  
GO Ai Hwa AAA027 2020-12-24 18:04:22 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE AAK655 Ban Hin Securities Company Limited 萬興證券有限公司 吳媛華 2005-02-21 692  
GO Ai Hwa AAA027 2020-12-24 18:04:22 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE AAK655 Ban Hin Securities Company Limited 萬興證券有限公司 吳媛華 2005-02-21 692  
GO Ai Hwa AAA027 2020-12-24 18:04:22 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE AAK655 Ban Hin Securities Company Limited 萬興證券有限公司 吳媛華 2005-02-21 692  
CHEN Wah Nam AAA030 2021-06-12 02:28:26 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RE ACI593 North Sea Securities Limited 立生證券有限公司 陳華南 2004-12-01 610  
CHEN Wah Nam AAA030 2021-06-12 02:28:26 indi 1 Dealing in Securities 證券交易 2008-06-18 00:00:00 R RE ACI593 North Sea Securities Limited 立生證券有限公司 陳華南      
CHEN Wah Nam AAA030 2021-06-12 02:28:26 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE ACI593 North Sea Securities Limited 立生證券有限公司 陳華南 2004-10-29 577  
CHEN Wah Nam AAA030 2021-06-12 02:28:26 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE ACI593 North Sea Securities Limited 立生證券有限公司 陳華南 2004-10-29 577  
CHEN Wah Nam AAA030 2021-06-12 02:28:26 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE ACI593 North Sea Securities Limited 立生證券有限公司 陳華南 2004-10-29 577  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 1 Dealing in Securities 證券交易 2003-04-01 00:00:00 R RE AAF806 Haitong International Securities Company Limited 海通國際證券有限公司 余華富 2008-10-18 2027  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 3 Leveraged Foreign Exchange Trading 槓桿式外匯交易 2004-03-20 00:00:00 R RE AAF806 Haitong International Securities Company Limited 海通國際證券有限公司 余華富 2008-10-18 1673  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 4 Advising on Securities 就證券提供意見 2003-04-01 00:00:00 R RE AAF806 Haitong International Securities Company Limited 海通國際證券有限公司 余華富 2004-03-20 354  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 6 Advising on Corporate Finance 就機構融資提供意見 2003-04-01 00:00:00 R RE AAF806 Haitong International Securities Company Limited 海通國際證券有限公司 余華富 2003-09-29 181  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 7 Providing Automated Trading Services 提供自動化交易服務 2003-04-01 00:00:00 R RE AAF806 Haitong International Securities Company Limited 海通國際證券有限公司 余華富 2003-09-29 181  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE AAF806 Haitong International Securities Company Limited 海通國際證券有限公司 余華富 2003-09-29 181  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 2 Dealing in Futures Contracts 期貨合約交易 2003-04-01 00:00:00 R RE AAX474 Haitong International Futures Limited 海通國際期貨有限公司 余華富 2003-12-01 244  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 2 Dealing in Futures Contracts 期貨合約交易 2003-12-01 00:00:00 R RO AAX474 Haitong International Futures Limited 海通國際期貨有限公司 余華富 2008-10-18 1783  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 5 Advising on Futures Contracts 就期貨合約提供意見 2003-04-01 00:00:00 R RE AAX474 Haitong International Futures Limited 海通國際期貨有限公司 余華富 2003-12-01 244  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 5 Advising on Futures Contracts 就期貨合約提供意見 2003-12-01 00:00:00 R RO AAX474 Haitong International Futures Limited 海通國際期貨有限公司 余華富 2008-10-18 1783  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 7 Providing Automated Trading Services 提供自動化交易服務 2003-04-01 00:00:00 R RE AAX474 Haitong International Futures Limited 海通國際期貨有限公司 余華富 2003-11-26 239  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 9 Asset Management 提供資產管理 2003-04-01 00:00:00 R RE AAX474 Haitong International Futures Limited 海通國際期貨有限公司 余華富 2004-03-20 354  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 1 Dealing in Securities 證券交易 2016-01-28 00:00:00 R RE ACD026 SinoPac Securities (Asia) Limited 永豐金證券(亞洲)有限公司 余華富 2016-06-15 139  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 1 Dealing in Securities 證券交易 2016-06-15 00:00:00 R RO ACD026 SinoPac Securities (Asia) Limited 永豐金證券(亞洲)有限公司 余華富 2017-02-12 242  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 2 Dealing in Futures Contracts 期貨合約交易 2016-01-28 00:00:00 R RE ACD026 SinoPac Securities (Asia) Limited 永豐金證券(亞洲)有限公司 余華富 2016-06-15 139  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 2 Dealing in Futures Contracts 期貨合約交易 2016-06-15 00:00:00 R RO ACD026 SinoPac Securities (Asia) Limited 永豐金證券(亞洲)有限公司 余華富 2017-02-12 242  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 4 Advising on Securities 就證券提供意見 2016-01-28 00:00:00 R RE ACD026 SinoPac Securities (Asia) Limited 永豐金證券(亞洲)有限公司 余華富 2016-06-15 139  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 4 Advising on Securities 就證券提供意見 2016-06-15 00:00:00 R RO ACD026 SinoPac Securities (Asia) Limited 永豐金證券(亞洲)有限公司 余華富 2017-02-12 242  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 5 Advising on Futures Contracts 就期貨合約提供意見 2016-01-28 00:00:00 R RE ACD026 SinoPac Securities (Asia) Limited 永豐金證券(亞洲)有限公司 余華富 2016-06-15 139  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 5 Advising on Futures Contracts 就期貨合約提供意見 2016-06-15 00:00:00 R RO ACD026 SinoPac Securities (Asia) Limited 永豐金證券(亞洲)有限公司 余華富 2017-02-12 242  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 9 Asset Management 提供資產管理 2016-01-28 00:00:00 R RE ACD026 SinoPac Securities (Asia) Limited 永豐金證券(亞洲)有限公司 余華富 2017-02-12 381  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 1 Dealing in Securities 證券交易 2016-07-20 00:00:00 R RE ACP065 Tung Shing Securities (Brokers) Limited 東盛證券(經紀)有限公司 余華富 2017-02-12 207  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 4 Advising on Securities 就證券提供意見 2003-12-01 00:00:00 R RE AET910 Haitong International Asset Management Limited 海通國際資產管理有限公司 余華富 2008-10-18 1783  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 5 Advising on Futures Contracts 就期貨合約提供意見 2004-07-20 00:00:00 R RO AET910 Haitong International Asset Management Limited 海通國際資產管理有限公司 余華富 2008-10-18 1551  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 9 Asset Management 提供資產管理 2003-12-01 00:00:00 R RE AET910 Haitong International Asset Management Limited 海通國際資產管理有限公司 余華富 2008-10-18 1783  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 2 Dealing in Futures Contracts 期貨合約交易 2016-07-20 00:00:00 R RE AHD071 Tung Shing Futures (Brokers) Limited 東盛期貨(經紀)有限公司 余華富 2017-02-12 207  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 9 Asset Management 提供資產管理 2008-10-27 00:00:00 R RE APH797 BOCOM International Asset Management Limited 交銀國際資產管理有限公司 余華富 2015-12-31 2621  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 1 Dealing in Securities 證券交易 2008-10-27 00:00:00 R RE APJ121 BOCOM International Securities Limited 交銀國際證券有限公司 余華富 2015-01-12 2268  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 1 Dealing in Securities 證券交易 2015-01-12 00:00:00 R RO APJ121 BOCOM International Securities Limited 交銀國際證券有限公司 余華富 2015-12-31 353  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 2 Dealing in Futures Contracts 期貨合約交易 2008-10-27 00:00:00 R RE APJ121 BOCOM International Securities Limited 交銀國際證券有限公司 余華富 2008-12-12 46  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 2 Dealing in Futures Contracts 期貨合約交易 2008-12-12 00:00:00 R RO APJ121 BOCOM International Securities Limited 交銀國際證券有限公司 余華富 2015-12-31 2575  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 4 Advising on Securities 就證券提供意見 2008-10-27 00:00:00 R RE APJ121 BOCOM International Securities Limited 交銀國際證券有限公司 余華富 2015-12-31 2621  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 5 Advising on Futures Contracts 就期貨合約提供意見 2008-10-27 00:00:00 R RE APJ121 BOCOM International Securities Limited 交銀國際證券有限公司 余華富 2008-12-12 46  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 5 Advising on Futures Contracts 就期貨合約提供意見 2008-12-12 00:00:00 R RO APJ121 BOCOM International Securities Limited 交銀國際證券有限公司 余華富 2015-12-31 2575  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 1 Dealing in Securities 證券交易 2017-02-13 00:00:00 R RO BIZ502 SinoPac Securities (Asia) Limited 永豐金證券(亞洲)有限公司 余華富 2021-03-07 1483  
YU Wah Foo, Kevin AAA034 2021-06-11 20:09:51 indi 2 Dealing in Futures Contracts 期貨合約交易 2017-02-13 00:00:00 R RO BIZ502 SinoPac Securities (Asia) Limited 永豐金證券(亞洲)有限公司 余華富 2021-03-07 1483  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [hksfclicences] (
   [nameenglish] TEXT,
   [ceref] TEXT,
   [timestamp] TEXT,
   [indieo] TEXT,
   [actType] INTEGER,
   [actDesc] TEXT,
   [cactDesc] TEXT,
   [effDate] TEXT,
   [status] TEXT,
   [lcRole] TEXT,
   [princeref] TEXT,
   [princename] TEXT,
   [princenamechin] TEXT,
   [namechinese] TEXT,
   [endDate] TEXT,
   [numberofdays] INTEGER, [applNo] INTEGER,
   PRIMARY KEY ([ceref], [indieo], [princeref], [actType], [effDate])
);