1,065,965 rows

View and edit SQL

Link formserialnumber position before_number after_number change_number before_percent after_percent change_percent before_percent_calculated after_percent_calculated change_percent_calculated
BAPEF Investments XIV Limited CS20030401000001 long position 30110204 30110204 0 7.99 7.99 0.0 7.992413210028 7.992413210028 0.0
Southfield Investment Pte Ltd CS20030401000002 long position 46750010 46750010 0 7.7 7.7 0.0 7.726520948589484 7.726520948589484 0.0
Aberdeen Asset Management Asia Ltd CS20030401000004 long position 141208800 141208800 0 9.8 9.8 0.0 9.801208085755404 9.801208085755404 0.0
Aberdeen Asset Management Asia Ltd CS20030401000006 long position 22088000 22088000 0 5.77 5.77 0.0 5.76521234330501 5.76521234330501 0.0
New Goal International Finance Limited CS20030401000008 long position 74070000 74070000 0 6.89 6.89 0.0 6.894540093624839 6.894540093624839 0.0
Cress Limited CS20030401000020 long position 166284498 166284498 0 7.63 7.63 0.0 7.628932460688426 7.628932460688426 0.0
City of London Investment Management Company Limited CS20030401000023 long position 294900 294900 0 5.9 5.9 0.0 5.898 5.898 0.0
Bangkok Bank Public Company Limited CS20030401000025 long position 0 95488236 95488236 0.0 9.03 9.03 0.0 9.025170329537032 9.025170329537032
Swiss Reinsurance Company CS20030401000028 long position 7200000 7200000 0 5.25 5.25 0.0 5.2498796902570986 5.2498796902570986 0.0
Most Choice Limited CS20030401000030 long position 183200000 183200000 0 6.59 6.59 0.0 6.592299388269161 6.592299388269161 0.0
Quartet Assets Limited CS20030401000036 long position 66215250 66215250 0 7.98 7.98 0.0 7.982853712357097 7.982853712357097 0.0
China Merchants Group Limited CS20030402000002 long position 1099493351 1099493351 0 53.39 53.39 0.0 53.38659290709022 53.38659290709022 0.0
Aimstar Investments Limited CS20030402000003 long position 0 85000000 85000000 0.0 9.45 9.45 0.0 9.44549394377153 9.44549394377153
Aberdeen Asset Management Asia Ltd CS20030402000004 long position 141208800 142208800 1000000 9.8 9.87 0.06999999999999851 9.801208085755404 9.870617414959783 0.06940932920437959
Temasek Holdings (Private) Limited CS20030402000007 long position 166284498 166284498 0 7.63 7.63 0.0 7.628932460688426 7.628932460688426 0.0
Victon Investment Limited CS20030402000015 long position 282339312 282339312 0 29.68 29.68 0.0 29.683406802484924 29.683406802484924 0.0
Amerdale Investments Limited CS20030402000016 long position 205271883 205271883 0 21.58 21.58 0.0 21.581014577952537 21.581014577952537 0.0
Greater China Holdings Limited CS20030402000025 long position 82476000 82356000 -120000 6.8 6.79 -0.009999999999999787 6.802665450538315 6.792767785107589 -0.009897665430726121
Greater China Holdings Limited CS20030402000025 short position 20000000 20000000 0 1.65 1.65 0.0 1.6496109051210814 1.6496109051210814 0.0
China Everbright Holdings Company Limited CS20030402000029 long position 108600000 108600000 0 8.28 8.28 0.0 8.27604111147351 8.27604111147351 0.0
Baron Asset Management Limited CS20030402000030 long position 0 64749790 64749790 0.0 6.0 6.0 0.0 5.99601715005371 5.99601715005371
Raymax Time Company Limited CS20030402000033 long position 170992394 170992394 0 8.25 8.25 0.0 8.25233587315511 8.25233587315511 0.0
Continental Mariner Investment Company Limited CS20030402000036 long position 119380000 119380000 0 7.05 7.05 0.0 7.059010010601589 7.059010010601589 0.0
The Grande (Nominees) Limited CS20030403000002 long position 6571795 6571795 0 12.33 10.38 -1.9499999999999993 10.38366106824724 10.38366106824724 0.0
Barrican Investments Corporation CS20030403000003 long position 6571795 6571795 0 12.33 10.38 -1.9499999999999993 10.38366106824724 10.38366106824724 0.0
The Grande Holdings Limited CS20030403000004 long position 6571795 6571795 0 12.33 10.38 -1.9499999999999993 10.38366106824724 10.38366106824724 0.0
CITIC Capital Markets Holdings Limited CS20030403000010 long position 12523000 12523000 0 5.52 5.52 0.0 5.5188552440803305 5.5188552440803305 0.0
Timeless Strategy Limited CS20030403000012 long position 33520000 33520000 0 6.89 6.89 0.0 6.89099401355174 6.89099401355174 0.0
Leader Symbol Holdings Limited CS20030403000014 long position 83902477 83102477 -800000 8.72 8.64 -0.08000000000000007 8.722314952558868 8.639148731351275 -0.08316622120759298
Leader Symbol Holdings Limited (Formerly Known as: Double International Limited) CS20030403000015 long position 83902477 83902477 0 8.72 8.72 0.0 8.722314952558868 8.722314952558868 0.0
Timeless Software Limited CS20030403000016 long position 33520000 33520000 0 6.89 6.89 0.0 6.89099401355174 6.89099401355174 0.0
Digital World Holdings Limited CS20030403000018 long position 28233725 28233725 0 6.8 6.8 0.0 6.803307228915663 6.803307228915663 0.0
Perfect Develop Holding Inc CS20030403000021 long position 630400000 619315370 -11084630 51.36 50.46 -0.8999999999999986 51.36280630886612 50.45966908853705 -0.9031372203290715
Continental Mariner Investment Company Limited CS20030403000025 long position 117636000 117636000 0 9.25 9.25 0.0 9.254206411313668 9.254206411313668 0.0
The Grande International Holdings Limited CS20030403000026 long position 6571795 6571795 0 12.33 10.38 -1.9499999999999993 10.38366106824724 10.38366106824724 0.0
Glory Town Limited CS20030403000027 long position 34504800 34504800 0 5.19 5.19 0.0 5.185482235525941 5.185482235525941 0.0
EK Investment Management Limited CS20030403000032 long position 31692000 31692000 0 5.13 5.13 0.0 5.132046518928166 5.132046518928166 0.0
Man Tong Company Limited CS20030403000033 long position 65989175 65989175 0 6.24 6.24 0.0 6.237035777691262 6.237035777691262 0.0
EK Investment Management Limited CS20030403000034 long position 57135496 57135496 0 9.62 9.62 0.0 9.625679112426656 9.625679112426656 0.0
Grecian Resources Limited CS20030403000035 long position 28103982 28103982 0 7.05 7.05 0.0 7.051817227288879 7.051817227288879 0.0
COFCO (Hong Kong) Limited CS20030403000046 long position 30000000 30000000 0 7.5 7.5 0.0 7.5 7.5 0.0
COFCO (Hong Kong) Limited CS20030403000046 short position 30000000 30000000 0 7.5 7.5 0.0 7.5 7.5 0.0
Sunrise Height Incorporated CS20030403000047 long position 696780000 696780000 0 55.01 55.01 0.0 55.008404290711745 55.008404290711745 0.0
Choice Palace Holdings Limited CS20030403000048 long position 30000000 30000000 0 7.5 7.5 0.0 7.5 7.5 0.0
Choice Palace Holdings Limited CS20030403000048 short position 30000000 30000000 0 7.5 7.5 0.0 7.5 7.5 0.0
Charcon Assets Limited CS20030403000049 long position 2061300782 2061300782 0 9.2 9.2 0.0 9.19907690171879 9.19907690171879 0.0
Kingston Finance Limited CS20030403000050 long position 0 2067722000 2067722000 0.0 23.81 23.81 0.0 23.806182165272926 23.806182165272926
Kingston Finance Limited CS20030403000051 long position 0 865520350 865520350 0.0 22.95 22.95 0.0 22.949297348677117 22.949297348677117
Green Ravine Limited CS20030403000053 long position 201726400 201726400 0 15.93 15.93 0.0 15.92561119336065 15.92561119336065 0.0
Taiwan Cement Corporation CS20030404000002 long position 57736000 57586000 -150000 16.03 15.99 -0.040000000000000924 16.037777777777777 15.99611111111111 -0.041666666666666075
Jamplan (BVI) Limited CS20030404000006 long position 130605000 130605000 0 11.11 11.11 0.0 11.114728810216521 11.114728810216521 0.0
China Gas Holdings Limited CS20030404000007 long position 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0
China Gas Holdings Limited CS20030404000007 short position 12200000 12200000 0 8.84 8.84 0.0 8.841147721852913 8.841147721852913 0.0
Kingboard Investments Limited CS20030404000011 long position 70875000 70875000 0 6.03 6.03 0.0 6.031594536381424 6.031594536381424 0.0
Golden Resources Development International Limited CS20030404000012 long position 256005000 256005000 0 28.45 23.71 -4.739999999999998 28.44816090676742 28.44816090676742 0.0
Martin Currie China Hedge Fund Limited CS20030404000013 long position 19092000 19092000 0 5.33 5.33 0.0 5.325612144136303 5.325612144136303 0.0
Taiwan Cement Corporation CS20030404000014 long position 57736000 57736000 0 16.03 16.03 0.0 16.037777777777777 16.037777777777777 0.0
Golden Resources Development International Limited CS20030404000015 long position 19000000 19000000 0 9.05 9.05 0.0 9.056244041944709 9.056244041944709 0.0
Hallgain Management Limited CS20030404000017 long position 237848800 237848800 0 43.87 43.87 0.0 43.87347687227189 43.87347687227189 0.0
Harris Associates L.P. CS20030404000020 long position 139716700 139716700 0 9.7 9.7 0.0 9.69831233440393 9.69831233440393 0.0
Angel Field Limited CS20030404000022 long position 181986000 306986000 125000000 63.19 74.33 11.14 63.18958333333333 106.59236111111112 43.402777777777786
TGC Holdings Limited CS20030404000038 long position 564000000 662040000 98040000 46.21 54.24 8.030000000000001 46.20657117903956 54.238649615906645 8.032078436867089
Kingboard Investments Limited CS20030404000040 long position 57000000 57000000 0 8.9 8.9 0.0 8.90625 8.90625 0.0
Kingboard Chemical Holdings Limited CS20030404000041 long position 57466000 57466000 0 8.97 8.97 0.0 8.9790625 8.9790625 0.0
CITIC Pacific Limited CS20030404000048 long position 12523000 12523000 0 5.52 5.52 0.0 5.5188552440803305 5.5188552440803305 0.0
Preferable Situation Assets Limited CS20030404000049 long position 25892000 25892000 0 5.06 5.06 0.0 5.063135354116199 5.063135354116199 0.0
Jamplan (BVI) Limited CS20030404000053 long position 57202000 57202000 0 8.93 8.93 0.0 8.9378125 8.9378125 0.0
Digital World Holdings Limited CS20030404000056 long position 28233725 29433725 1200000 6.8 7.1 0.2999999999999998 6.803307228915663 7.092463855421687 0.28915662650602414
GR Investment International Limited CS20030404000059 long position 65957000 65957000 0 5.1 5.1 0.0 5.102777917422003 5.102777917422003 0.0
GR Investment International Limited CS20030404000060 long position 23840733 23840733 0 7.49 7.49 0.0 8.104702341402014 8.104702341402014 0.0
HSBC Holdings plc CS20030407000005 long position 1226032243 1188386548 -37645695 64.13 62.16 -1.9699999999999989 64.12829988125132 62.15922081992836 -1.9690790613229652
HSBC Finance (Netherlands) CS20030407000011 long position 1199197555 1188057371 -11140184 62.72 62.14 -0.5799999999999983 62.724696567301756 62.14200303345453 -0.5826935338472268
HSBC Holdings BV CS20030407000013 long position 1199197555 1188057371 -11140184 62.72 62.14 -0.5799999999999983 62.724696567301756 62.14200303345453 -0.5826935338472268
HSBC Asia Holdings (UK) CS20030407000015 long position 1199197555 1188057371 -11140184 62.72 62.14 -0.5799999999999983 62.724696567301756 62.14200303345453 -0.5826935338472268
Capital Group Companies, Inc. CS20030407000018 long position 241925000 242925000 1000000 15.95 16.02 0.07000000000000028 15.76210605322207 15.827258914866059 0.06515286164398937
HSBC Asia Holdings BV CS20030407000019 long position 1199197555 1188057371 -11140184 62.72 62.14 -0.5799999999999983 62.724696567301756 62.14200303345453 -0.5826935338472268
Capital Group Companies, Inc. CS20030407000020 long position 38944000 39444000 500000 6.92 7.01 0.08999999999999986 6.917274773846865 7.006085306584216 0.08881053273735162
The Hongkong and Shanghai Banking Corporation Limited CS20030407000023 long position 1199197555 1188057371 -11140184 62.72 62.14 -0.5799999999999983 62.724696567301756 62.14200303345453 -0.5826935338472268
Precise Dragon Developments Limited CS20030407000024 long position 0 14343000 14343000 0.0 21.17 21.17 0.0 21.167355371900825 21.167355371900825
Capital Group Companies, Inc. CS20030407000025 long position 20329600 22887600 2558000 8.24 9.28 1.0399999999999991 8.24132427884906 9.278300289459002 1.0369760106099424
B & D Investments Ltd CS20030407000027 long position 5384000 5384000 0 5.23 5.23 0.0 5.227184466019417 5.227184466019417 0.0
Lucky Star Consultants Limited CS20030407000032 long position 35400000 35400000 0 7.45 7.45 0.0 7.44949494949495 7.44949494949495 0.0
Harvest Smart Overseas Limited CS20030407000034 long position 228694000 229774000 1080000 7.59 7.62 0.03000000000000025 7.587724856139847 7.623557640754358 0.035832784614511226
Bayerische Hypo-und Vereinsbank AG CS20030407000035 long position 25662000 25662000 0 5.05 5.05 0.0 5.048196089231617 5.048196089231617 0.0
Smart Extra Holdings Limited CS20030407000047 long position 0 46030962 46030962 0.0 67.93 67.93 0.0 67.93235242030697 67.93235242030697
Tanton Holdings Limited CS20030407000049 long position 30100000 30100000 0 8.26 8.26 0.0 8.255622600109708 8.255622600109708 0.0
Chambray Resources Limited CS20030407000050 long position 25087500 25087500 0 8.36 8.36 0.0 8.3625 8.3625 0.0
HSBC Holdings plc CS20030407000051 long position 88468292 0 -88468292 35.86 0.0 -35.86 35.86375938375118 0.0 -35.86375938375118
Schroder Investment Management North America Inc. CS20030407000052 long position 9703000 9703000 0 6.49 6.49 0.0 6.490301003344482 6.490301003344482 0.0
Allied Group Limited CS20030407000054 long position 3674079379 4444079379 770000000 43.27 52.34 9.07 43.2717843792248 52.34052528951831 9.068740910293513
HSBC Bank plc CS20030407000055 long position 87589236 0 -87589236 35.5 0.0 -35.5 35.5074028614749 0.0 -35.5074028614749
Schroder Investment Management North America Limited CS20030407000057 long position 7956500 7956500 0 5.32 5.32 0.0 5.322073578595318 5.322073578595318 0.0
Toko Inc., Incorporated in Japan (Registered in the name of HKSCC Nominees Limited) CS20030407000058 long position 36785402 36785402 0 5.31 5.31 0.0 5.307918143680177 5.307918143680177 0.0
Midcorp Limited CS20030407000060 long position 87589236 0 -87589236 35.5 0.0 -35.5 35.5074028614749 0.0 -35.5074028614749
Sun Hung Kai & Co. Limited CS20030407000063 long position 3674079379 4444079379 770000000 43.27 52.34 9.07 43.2717843792248 52.34052528951831 9.068740910293513
Griffin International Limited CS20030407000064 long position 87589236 0 -87589236 35.5 0.0 -35.5 35.5074028614749 0.0 -35.5074028614749
HSBC Europe BV CS20030407000070 long position 87589236 0 -87589236 35.5 0.0 -35.5 35.5074028614749 0.0 -35.5074028614749
Leader Symbol Holdings Limited CS20030407000075 long position 82502477 81902477 -600000 8.58 8.51 -0.07000000000000028 8.576774065445578 8.514399399539883 -0.06237466590569518
HSBC Europe (Netherlands) BV CS20030407000076 long position 87589236 0 -87589236 35.5 0.0 -35.5 35.5074028614749 0.0 -35.5074028614749
Leader Symbol Holdings Limited CS20030407000077 long position 83102477 82502477 -600000 8.64 8.58 -0.0600000000000005 8.639148731351275 8.576774065445578 -0.06237466590569696

Next page

Advanced export

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

CSV options:

CREATE TABLE [disclosurespositions] (
   [formserialnumber] TEXT REFERENCES [disclosures]([formserialnumber]),
   [position] TEXT,
   [before_number] INTEGER,
   [after_number] INTEGER,
   [change_number] INTEGER,
   [before_percent] FLOAT,
   [after_percent] FLOAT,
   [change_percent] FLOAT,
   [before_percent_calculated] FLOAT,
   [after_percent_calculated] FLOAT,
   [change_percent_calculated] FLOAT,
   PRIMARY KEY ([formserialnumber], [position])
);
CREATE INDEX [idx_disclosurespositions_formserialnumber]
    ON [disclosurespositions] ([formserialnumber]);