{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Aggregated Transaction Report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Aggregated Transaction Report","index":0,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9]]}
["Aggregated Transaction Report (HK Investor ID Regime)",null,null,null,null,null,null,null,null,null,"v1.2"]
["合併交易指令報告(香港投資者識別碼制度)"]
[]
["* To be reported by the Regulated Intermediary who aggregated the order"]
["* 由合併交易指令的註冊機構申報"]
["* Click the button above to generate a CSV for submission in ECP"]
["* 點擊以上按鈕以匯出CSV文檔於ECP遞交"]
["A","B","C","D","E","F","G","H","I","J"]
["Item No.","Reporting Date","CE No. of Reporting Regulated Intermediary","Executing Exchange Participant Firm ID","Transaction Date","Stock Code","Price","Quantity","Side (B/S)","Underlying Individual CE No. and BCAN"]
["編號","申報日期\n(YYYYMMDD)","申報註冊機構的中央編號","執行交易的交易所參與者代號","交易日期\n(YYYYMMDD)","股票編號","價格","股數","買入 / 沽出","個別相關券商客戶編碼\n(註冊機構的中央編號 + \".\" + 券商客戶編碼)"]
["(E.g) 1 ","20210311","ABC123",1234,"20210309","5","43.1","10000","B","ABC123.8888888"]
["(E.g) 2 ","20210311","ABC123",1234,"20210309","5","43.1",30000,"B","ABC123.9999999"]
["1"]
["2"]