{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "hybrid-emerald", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['/home/jovyan/work',\n", " '/opt/conda/lib/python38.zip',\n", " '/opt/conda/lib/python3.8',\n", " '/opt/conda/lib/python3.8/lib-dynload',\n", " '',\n", " '/opt/conda/lib/python3.8/site-packages',\n", " '/opt/conda/lib/python3.8/site-packages/IPython/extensions',\n", " '/home/jovyan/.ipython']" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import sys\n", "sys.path" ] }, { "cell_type": "markdown", "id": "brief-chamber", "metadata": {}, "source": [ "Instruct python to load external modules not bundled with the " ] }, { "cell_type": "code", "execution_count": 2, "id": "trying-sewing", "metadata": {}, "outputs": [ { "ename": "ModuleNotFoundError", "evalue": "No module named 'youtube'", "output_type": "error", "traceback": [ "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[0;31mModuleNotFoundError\u001b[0m Traceback (most recent call last)", "\u001b[0;32m\u001b[0m in \u001b[0;36m\u001b[0;34m\u001b[0m\n\u001b[1;32m 1\u001b[0m \u001b[0msys\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mpath\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'/home/jovyan/work/modules'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 2\u001b[0;31m \u001b[0;32mimport\u001b[0m \u001b[0myoutube\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m", "\u001b[0;31mModuleNotFoundError\u001b[0m: No module named 'youtube'" ] } ], "source": [ "sys.path.append('/home/jovyan/work/modules')\n", "import youtube" ] }, { "cell_type": "code", "execution_count": 3, "id": "chemical-width", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "https://www.hkexnews.hk/sdw/search/searchsdw_c.aspx\n", "----\n", "2021/02/04Data available\n", "香港上海匯豐銀行有限公司\n", "JPMORGAN CHASE BANK, NATIONAL ASSOCIATION\n", "花旗銀行\n", "CHINA SECURITIES DEPOSITORY AND CLEARING\n", "中國証券登記結算有限責任公司\n", "UBS SECURITIES HONG KONG LTD\n", "高盛(亞洲)證券有限公司\n", "中銀國際證券有限公司\n", "渣打銀行(香港)有限公司\n", "MORGAN STANLEY HONG KONG SECURITIES LTD\n", "德意志銀行\n", "盈透證券香港有限公司\n", "中國銀行(香港)有限公司\n", "BNP PARIBAS SECURITIES SERVICES\n", "MLFE LTD\n", "富途證券國際(香港)有限公司\n", "恒生證券有限公司\n", "DBS BANK LTD\n", "中國國際金融香港證券有限公司\n", "國泰君安證券(香港)有限公司\n", "中信証券經紀(香港)有限公司\n", "海通國際證券有限公司\n", "招商永隆銀行有限公司\n", "東亞銀行有限公司\n", "申萬宏源證券(香港)有限公司\n", "ABN AMRO CLEARING HONG KONG LTD\n", "新鴻基投資服務有限公司\n", "匯豐金融證券(香港)有限公司\n", "招商銀行股份有限公司\n", "上海浦東發展銀行股份有限公司\n", "雲鋒證券有限公司\n", "招商證券(香港)有限公司\n", "中國建設銀行(亞洲)股份有限公司\n", "法國興業證券(香港)有限公司\n", "上海商業銀行有限公司\n", "興證國際證券有限公司\n", "大華繼顯(香港)有限公司\n", "CREDIT SUISSE SECURITIES (HONG KONG) LTD\n", "招銀國際證券有限公司\n", "交通銀行信託有限公司\n", "輝立証券(香港)有限公司\n", "大眾証券有限公司\n", "南洋商業銀行有限公司\n", "工銀亞洲証券有限公司\n", "核聚證券有限公司\n", "富銀證券(香港)有限公司\n", "廣發証券(香港)經紀有限公司\n", "結好證券有限公司\n", "交銀國際證券有限公司\n", "耀才證券國際(香港)有限公司\n", "國都證券(香港)有限公司\n", "星展銀行(香港)有限公司\n", "華泰金融控股(香港)有限公司\n", "英皇證券(香港)有限公司\n", "中信銀行(國際)有限公司\n", "安信國際證券(香港)有限公司\n", "中國銀河國際證券(香港)有限公司\n", "國元証券經紀(香港)有限公司\n", "恒生銀行有限公司\n", "大新證券有限公司\n", "東亞證券有限公司\n", "直達國際金融服務有限公司\n", "凱基證券亞洲有限公司\n", "東方財富國際證券有限公司\n", "國信證券(香港)經紀有限公司\n", "集友銀行有限公司\n", "金英證券(香港)有限公司\n", "華盛資本証券有限公司\n", "創興證券有限公司\n", "大和資本市場香港有限公司\n", "致富證券有限公司\n", "第一上海證券有限公司\n", "尚乘環球市場有限公司\n", "銀河—聯昌證券(香港)有限公司\n", "華僑永亨銀行有限公司\n", "寶盛證券(香港)有限公司\n", "永豐金證券(亞洲)有限公司\n", "華僑永亨証券有限公司\n", "滙富金融服務有限公司\n", "大豐崑泰證券有限公司\n", "東方證券(香港)有限公司\n", "奕豐證券(香港)有限公司\n", "利弗莫爾證券有限公司\n", "星展唯高達香港有限公司\n", "大眾銀行(香港)有限公司\n", "鷹達證券有限公司\n", "中國工商銀行(亞洲)有限公司\n", "六福證券(香港)有限公司\n", "太平証券(香港)有限公司\n", "中信建投(國際)証券有限公司\n", "一通投資者有限公司\n", "創興銀行有限公司\n", "元大證券(香港)有限公司\n", "建銀國際證券有限公司\n", "德意志證券亞洲有限公司\n", "平證證券(香港)有限公司\n", "浦銀國際證券有限公司\n", "富昌證券有限公司\n", "中泰國際證券有限公司\n", "順安證券資產管理有限公司\n", "京華山一國際(香港)有限公司\n", "國金證券(香港)有限公司\n", "信達國際證券有限公司\n", "加皇投資理財有限公司\n", "東洋証券亞洲有限公司\n", "邦盟滙駿證券有限公司\n", "信誠證券有限公司\n", "國泰證券(香港)有限公司\n", "中信里昂證券有限公司\n", "金利豐證券有限公司\n", "中國通海證券有限公司\n", "農銀國際證券有限公司\n", "祺昌證券有限公司\n", "勝利證券有限公司\n", "匯濤證券有限公司\n", "富邦證券(香港)有限公司\n", "高鉦証券有限公司\n", "佳兆業金融集團有限公司\n", "東吳證券國際經紀有限公司\n", "友信證券有限公司\n", "茂宸證券有限公司\n", "財通國際證券有限公司\n", "尊嘉證券國際有限公司\n", "瑞士盈豐銀行股份有限公司\n", "寶通證券亞洲有限公司\n", "宏高證券有限公司\n", "工銀國際證券有限公司\n", "新富證券有限公司\n", "嘉實國際證券有限公司\n", "恆大證券(香港)有限公司\n", "溢利證券有限公司\n", "橫華國際証券有限公司\n", "周生生證券有限公司\n", "復星恆利證券有限公司\n", "SOFI SECURITIES (HONG KONG) LTD\n", "高信證券有限公司\n", "長江證券經紀(香港)有限公司\n", "大眾金融証券有限公司\n", "中順證券期貨有限公司\n", "南華證券投資有限公司\n", "未來資產證券(香港)有限公司\n", "金鷹證券有限公司\n", "峰匯金融集團有限公司\n", "潮商證券有限公司\n", "寶新證券有限公司\n", "常匯證券有限公司\n", "時富證券有限公司\n", "蘇佩瓚證券有限公司\n", "華融國際證券有限公司\n", "方德證券有限公司\n", "方正證券(香港)有限公司\n", "環一證券有限公司\n", "富元證券有限公司\n", "亨達証券有限公司\n", "天發證券有限公司\n", "瑞穗證券亞洲有限公司\n", "訊匯證券有限公司\n", "瑞豐證券有限公司\n", "山證國際證券有限公司\n", "立橋證券有限公司\n", "山金證券(香港)有限公司\n", "利銘證券有限公司\n", "大盛証券投資有限公司\n", "寶鉅證券有限公司\n", "海富證券投資有限公司\n", "青石證券(香港)有限公司\n", "新寶城證券有限公司\n", "艾德證券期貨有限公司\n", "協聯證券有限公司\n", "統一證券(香港)有限公司\n", "電訊濎匯證券有限公司\n", "源盛證券有限公司\n", "盈泰證券有限公司\n", "永豐證券有限公司\n", "東方匯財證券有限公司\n", "匯業證券有限公司\n", "嘉利證券投資有限公司\n", "發利證券有限公司\n", "嘉謨證券有限公司\n", "西證(香港)證券經紀有限公司\n", "越秀証券有限公司\n", "華信證券有限公司\n", "鴻昇證券有限公司\n", "博大證券有限公司\n", "富強證券有限公司\n", "日發證券有限公司\n", "朗盈證券有限公司\n", "恆豐證券有限公司\n", "安捷證券有限公司\n", "佐雄證券有限公司\n", "名匯證券有限公司\n", "盛源證券有限公司\n", "恒泰証券有限公司\n", "滙信理財有限公司\n", "中達證券投資有限公司\n", "偉富證券有限公司\n", "群益證券(香港)有限公司\n", "東信證券有限公司\n", "星火證券有限公司\n", "大唐資本證券有限公司\n", "利興股票有限公司\n", "首控證券有限公司\n", "聯發證券有限公司\n", "方達資本管理有限公司\n", "世博證券有限公司\n", "果樹證券有限公司\n", "偉民股票買賣有限公司\n", "東興證券(香港)有限公司\n", "實德證券有限公司\n", "大德證券(亞洲)有限公司\n", "東英亞洲證券有限公司\n", "高陞證券有限公司\n", "浩豐證券投資有限公司\n", "中原證券有限公司\n", "騰記證券有限公司\n", "微牛證券有限公司\n", "英明證券有限公司\n", "鉅亨證券有限公司\n", "步基證券有限公司\n", "雅利多證券有限公司\n", "第一證券(香港)有限公司\n", "集美證券有限公司\n", "華誠證券有限公司\n", "興業金融證券有限公司\n", "泰山證券有限公司\n", "天風國際證券與期貨有限公司\n", "太平基業證券有限公司\n", "達利證券有限公司\n", "益高證券有限公司\n", "新永安國際證券有限公司\n", "美建證券有限公司\n", "鎧盛證券有限公司\n", "恩明資產証券有限公司\n", "高誠證券有限公司\n", "百裕證券有限公司\n", "阿仕特朗資本管理有限公司\n", "匯盈證券有限公司\n", "威靈頓金融有限公司\n", "恆盛證券有限公司\n", "和豐證券有限公司\n", "齊榮證券有限公司\n", "第一金和昇證券有限公司\n", "展兆投資有限公司\n", "永富證券有限公司\n", "佳富達證券有限公司\n", "軟庫中華金融服務有限公司\n", "宏旺證券有限公司\n", "AAA SECURITIES CO. LTD\n", "榮興證券有限公司\n", "永聯財富管理有限公司\n", "興業證券有限公司\n", "鼎珮證券有限公司\n", "長雄證券有限公司\n", "元富證券(香港)有限公司\n", "FUNDERSTONE SECURITIES LTD\n", "恒億證券有限公司\n", "協興股票有限公司\n", "華德國際證券有限公司\n", "永勝證券有限公司\n", "大輝證券有限公司\n", "龍匯證券有限公司\n", "興偉聯合證券有限公司\n", "嘉信証券有限公司\n", "同德証券(香港)有限公司\n", "李氏證券有限公司\n", "恒昇證券有限公司\n", "克而瑞證券有限公司\n", "萬海證券有限公司\n", "萬利豐證券有限公司\n", "晉億證券有限公司\n", "興旺證券有限公司\n", "利星行證券有限公司\n", "東航國際金融(香港)有限公司\n", "海富證券有限公司\n", "元庫證券有限公司\n", "勤豐證券有限公司\n", "中州國際證券有限公司\n", "創市証券有限公司\n", "益群證券有限公司\n", "民眾證券有限公司\n", "堅固證券有限公司\n", "恒富證券有限公司\n", "大業證券有限公司\n", "大寧證券有限公司\n", "包大衛証券投資有限公司\n", "海悅證券有限公司\n", "穎翔證券有限公司\n", "祖達股票行有限公司\n", "大豐證券有限公司\n", "岡地投資(香港)有限公司\n", "加多利證券有限公司\n", "滿好證券有限公司\n", "華南永昌證券(香港)有限公司\n", "一中證券有限公司\n", "秦志遠證券有限公司\n", "中國民生銀行股份有限公司\n", "萬達基證券有限公司\n", "NERICO BROTHERS LTD\n", "華大證券有限公司\n", "安裕證券投資有限公司\n", "廣發行証券有限公司\n", "華生證券有限公司\n", "路華證券有限公司\n", "華億證券有限公司\n", "昇悅證券有限公司\n", "永安證券有限公司\n", "金輝証券有限公司\n", "偉祿亞太證券有限公司\n", "匯誠證券有限公司\n", "中融平和證券有限公司\n", "阿爾法國際證券(香港)有限公司\n", "民銀證券有限公司\n", "太陽國際証券有限公司\n", "T & F EQUITIES LTD\n", "貝格隆証券有限公司\n", "未來金融有限公司\n", "易昇證券有限公司\n", "創陞證券有限公司\n", "東泰證券有限公司\n", "聯勝網上證券有限公司\n", "聯合證券有限公司\n", "萬興證券有限公司\n", "興利証券有限公司\n", "瑭明金融集團有限公司\n", "富業證券投資有限公司\n", "耀佳金融集團有限公司\n", "長复證券有限公司\n", "昭海金融證券有限公司\n", "豐年証券投資有限公司\n", "百利證券有限公司\n", "富匯證券有限公司\n", "信亨証券有限公司\n", "新基立證券有限公司\n", "羅沙證券有限公司\n", "弘業國際金融控股有限公司\n", "擎天證券有限公司\n", "英華證券有限公司\n", "致德證券有限公司\n", "均益證券(國際)有限公司\n", "漢華證券有限公司\n", "匯金(證券)有限公司\n", "SIU YUK LUNG *\n", "中潤證券有限公司\n", "詠誼證券投資有限公司\n", "寶利證券有限公司\n", "禹洲金融控股(香港)有限公司\n", "明漢證券有限公司\n", "中華匯財金融有限公司\n", "文漢揚証券有限公司\n", "鼎展證券及期貨有限公司\n", "弘量研究有限公司\n", "香港國際證券有限公司\n", "瑞豐國際證券有限公司\n", "亞華證券有限公司\n", "漢英證券有限公司\n", "江陸證券有限公司\n", "智易東方證券有限公司\n", "中國信託綜合證券(香港)有限公司\n", "立生證券有限公司\n", "京基證券集團有限公司\n", "華業證券有限公司\n", "廣利証券有限公司\n", "浙商國際金融控股有限公司\n", "德豐證券投資有限公司\n", "富榮證券集團有限公司\n", "中策富匯證券有限公司\n", "匯生證券有限公司\n", "昊天國際證券有限公司\n", "智華證券有限公司\n", "友盈證券有限公司\n", "勁域證券有限公司\n", "怡發證券有限公司\n", "飛達證券有限公司\n", "太陽證券有限公司\n", "凱敏證券有限公司\n", "上高證券有限公司\n", "駿溢環球金融集團有限公司\n", "金禧國際證券 (香港) 有限公司\n", "新同得有限公司\n", "華金證券(國際)有限公司\n", "佳隆證券有限公司\n", "盛德證券有限公司\n", "三泰富金融投資有限公司\n", "中南金融有限公司\n", "昌盛證券有限公司\n", "鼎新證券有限公司\n", "環球大通證券有限公司\n", "韓國投資證券亞洲有限公司\n", "國投證券有限公司\n", "易易壹證券有限公司\n", "冠力金融服務有限公司\n", "威發證券有限公司\n", "進陞證券有限公司\n", "權威證券有限公司\n", "利盟證券有限公司\n", "金鵬證券有限公司\n", "中國北方證券集團有限公司\n", "冠泓證券有限公司\n", "陳岳明證券有限公司\n", "嘉銀證券有限公司\n", "昌萬年有限公司\n", "千里碩證券有限公司\n", "東海國際證券(香港)有限公司\n", "兆安證券有限公司\n", "泓福證券有限公司\n", "華邦證券有限公司\n", "香江證券有限公司\n", "金旭證券有限公司\n", "FIRST FIDELITY CAPITAL (INTERNATIONAL) LTD\n", "國新證券有限公司\n", "金裕富證券有限公司\n", "金橋證券有限公司\n", "敏哲証券有限公司\n", "公平證券有限公司\n", "中富證券有限公司\n", "偉文証券有限公司\n", "新城晉峰證券有限公司\n", "山高國際證券有限公司\n", "宏匯證券有限公司\n", "利得證券(香港)有限公司\n", "中融國際証券有限公司\n", "CONRAD INVESTMENT SERVICES LTD\n", "溢勝證券亞洲有限公司\n", "泰嘉證券資產管理有限公司\n", "環球證券有限公司\n", "聚富證券有限公司\n", "華贏東方(亞洲)控股有限公司\n", "加福證券有限公司\n", "東匯證券有限公司\n", "軟庫金匯證券有限公司\n", "妙然基金管理有限公司\n", "格理昂證券有限公司\n", "保興匯財證券有限公司\n", "海盈證券有限公司\n", "寶泰證券(香港)有限公司\n", "融德證券有限公司\n", "港股通証券有限公司\n", "匯心金融有限公司\n", "乾立亨證券有限公司\n", "摩根富國證券有限公司\n", "日盛嘉富證券國際有限公司\n", "摩石證券有限公司\n", "中港通證券有限公司\n", "富利證券有限公司\n", "億聲證券有限公司\n", "匯澤證券有限公司\n", "富國證券有限公司\n", "粵商國際證券有限公司\n", "萬金來證券有限公司\n", "巴西證券有限公司\n", "中國國際證券有限公司\n", "安里證券有限公司\n", "中財證券有限公司\n", "金源證券有限公司\n", "天大証券有限公司\n", "力高證券有限公司\n", "永高證券有限公司\n", "國興証券有限公司\n", "中發証券有限公司\n", "亞投證券有限公司\n", "通陸證券有限公司\n", "匯恆證券(香港)有限公司\n", "金聯證券有限公司\n", "南方匯發國際有限公司\n", "台新國際商業銀行股份有限公司\n", "百德能經紀有限公司\n", "高寶集團證券有限公司\n", "金滿天投資有限公司\n", "大聖證券有限公司\n", "西牛證券有限公司\n", "建豐証券有限公司\n", "川文證券有限公司\n", "藍山證券有限公司\n", "中國證券有限公司\n", "富盛證券有限公司\n", "榮通證券有限公司\n", "樹熊證券有限公司\n", "萬盛金融控股有限公司\n", "一盈證券有限公司\n", "進匯證券有限公司\n", "大灣區深港證券有限公司\n", "雅景證券股份有限公司\n", "高富金融有限公司\n", "IMAGI BROKERAGE LTD\n", "岡三國際(亞洲)有限公司\n", "博威環球證券有限公司\n", "駿昇証券有限公司\n", "黃河證券有限公司\n", "中國銀盛國際有限公司\n", "鼎鑫(證券)有限公司\n", "亞丁金融集團有限公司\n", "大田證券期貨有限公司\n", "世傳證券有限公司\n", "瑞邦證券有限公司\n", "威華達證券有限公司\n", "晉安証券有限公司\n", "惠興証券有限公司\n", "中天證券有限公司\n", "耀豐證券有限公司\n", "華晉證券資產管理有限公司\n", "中陽證券有限公司\n", "永裕證券有限公司\n", "泉湧證券有限公司\n", "團結證券有限公司\n", "萬基證券有限公司\n", "弘富投資服務有限公司\n", "原創集團證券有限公司\n", "天宸康合證券有限公司\n", "恆星證券有限公司\n", "RAFFAELLO SECURITIES (HK) LTD\n", "中金三甲證券有限公司\n", "鼎石證券有限公司\n", "信銀(香港)資本有限公司\n", "晉立峰證券有限公司\n", "貝德斯證券有限公司\n", "富明證券有限公司\n", "中國中期證券有限公司\n" ] } ], "source": [ "#\n", "# https://programmer.ink/think/5d872dc23f36a.html\n", "# \n", "from lxml import etree\n", "import requests\n", "import csv\n", "import os\n", "\n", "def get_shareholdings(stkcode, tdate, lang='c'):\n", "\n", " headers={\"User-Agent\":\"Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36\"}\n", " \n", " url= \"https://www.hkexnews.hk/sdw/search/searchsdw%s.aspx\" % ('_c' if lang == 'c' else '')\n", " print(url)\n", " shs_hold_date = '%s/%s/%s' % (tdate[0:4], tdate[4:6], tdate[6:8])\n", " datatime = {'__EVENTTARGET': 'btnSearch',\n", " '__EVENTARGUMENT':'',\n", " '__VIEWSTATE': '/wEPDwULLTIwNTMyMzMwMThkZHNjXATvSlyVIlPSDhuziMEZMG94',\n", " '__VIEWSTATEGENERATOR': '3B50BBBD',\n", " 'today': tdate,\n", " 'sortBy': 'shareholding',\n", " 'sortDirection': 'desc',\n", " 'alertMsg':'',\n", " 'txtShareholdingDate': shs_hold_date,\n", " 'txtStockCode': stkcode,\n", " 'txtStockName': '',\n", " 'txtParticipantID':'',\n", " 'txtParticipantName':''\n", " }\n", " repensoe=requests.post(url,headers=headers,data=datatime)\n", " text=repensoe.text\n", " html1 = etree.HTML(text)\n", " div = html1.xpath(\"//div[@id='pnlResultNormal']//tbody%s\" % ('/tr' if lang != 'en' else ''))\n", " data = []\n", " print(\"--\" * 2)\n", " valuetime = html1.xpath(\"//input[@id='txtShareholdingDate']/@value\")\n", " print(valuetime[0]+\"Data available\")\n", " filename = 'shshold-%s-%s%s.csv' % (stkcode, tdate, ('_c' if lang != 'en' else ''))\n", " \n", " for tb in div:\n", " try:\n", " participant_id = tb.xpath(\"./td[1]/div/text()\")[1]\n", " except IndexError:\n", " participant_id = ''\n", " participant_name = tb.xpath(\"./td[2]/div/text()\")[1]\n", " print (participant_name)\n", " participant_address = tb.xpath(\"./td[3]/div/text()\")[1]\n", " right = tb.xpath(\"./td[4]/div/text()\")[1]\n", " percent = tb.xpath(\"./td[5]/div/text()\")[1]\n", " datadic = {\"date\": valuetime[0], \"Participant number\": participant_id, \"Central System Participant Name\": participant_name, \"address\": participant_address, \"Shareholding\": right,\"Proportion\": percent}\n", " data.append(datadic)\n", " \n", " \n", "\n", "\n", " csvhead = [\"date\", \"Participant number\", \"Central System Participant Name\", \"address\", \"Shareholding\",\"Proportion\"]\n", " with open(filename, 'w', newline='') as fp:\n", " write = csv.DictWriter(fp, csvhead)\n", " write.writeheader()\n", " write.writerows(data)\n", " \n", "\n", "\n", "if __name__ == '__main__':\n", " os.getcwd()\n", " os.chdir(\"./\") \n", " get_shareholdings('01810', '20210204')\n", " " ] }, { "cell_type": "code", "execution_count": 8, "id": "legendary-blocking", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
dateParticipant numberCentral System Participant NameaddressShareholdingProportion
02021/02/04C00019香港上海匯豐銀行有限公司HSBC WEALTH BUSINESS SERVICES 8/F TOWER 2 & 3 ...6,174,683,77324.51%
12021/02/04C00100JPMORGAN CHASE BANK, NATIONAL ASSOCIATION18/F TOWER 2 THE QUAYSIDE 77 HOI BUN ROAD KWUN...2,469,268,9679.80%
22021/02/04C00010花旗銀行9/F CITI TOWER ONE BAY EAST 83 HOI BUN ROAD KW...2,331,702,0339.25%
32021/02/04A00004CHINA SECURITIES DEPOSITORY AND CLEARING17 TAIPING QIAO STREET XICHENG DISTRICT BEIJIN...1,607,058,2256.38%
42021/02/04A00003中國証券登記結算有限責任公司17 TAIPING QIAO STREET XICHENG DISTRICT BEIJIN...1,460,955,0225.80%
\n", "
" ], "text/plain": [ " date Participant number Central System Participant Name \\\n", "0 2021/02/04 C00019 香港上海匯豐銀行有限公司 \n", "1 2021/02/04 C00100 JPMORGAN CHASE BANK, NATIONAL ASSOCIATION \n", "2 2021/02/04 C00010 花旗銀行 \n", "3 2021/02/04 A00004 CHINA SECURITIES DEPOSITORY AND CLEARING \n", "4 2021/02/04 A00003 中國証券登記結算有限責任公司 \n", "\n", " address Shareholding Proportion \n", "0 HSBC WEALTH BUSINESS SERVICES 8/F TOWER 2 & 3 ... 6,174,683,773 24.51% \n", "1 18/F TOWER 2 THE QUAYSIDE 77 HOI BUN ROAD KWUN... 2,469,268,967 9.80% \n", "2 9/F CITI TOWER ONE BAY EAST 83 HOI BUN ROAD KW... 2,331,702,033 9.25% \n", "3 17 TAIPING QIAO STREET XICHENG DISTRICT BEIJIN... 1,607,058,225 6.38% \n", "4 17 TAIPING QIAO STREET XICHENG DISTRICT BEIJIN... 1,460,955,022 5.80% " ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "\n", "\n", "import numpy as np \n", "import pandas as pd \n", "\n", "import matplotlib\n", "import matplotlib.pyplot as plt\n", "data = pd.read_csv('./shshold-01810-20210204_c.csv')\n", "data.head()" ] }, { "cell_type": "code", "execution_count": null, "id": "upper-welsh", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "c1f22ec1", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "d20f6898", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.8.8" } }, "nbformat": 4, "nbformat_minor": 5 }