{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["BCAN Error 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":"BCAN Error Report","index":0,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8]]}
["BCAN Error Report  (HK Investor ID Regime) ",null,null,null,null,null,null,null,null,null,"v1.1"]
["券商客戶編碼錯誤報告 (香港投資者識別碼制度)"]
[]
["* To be reported by the Executing Exchange Participant"]
["* 由執行交易的交易所參與者申報"]
["* 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","Executing Exchange Participant Firm ID","Transaction Date","Stock Code","Trade Quantity","Trade Side (B/S)","Original CE No. and BCAN input in OTP-C","Revised CE No. and BCAN","Trade ID (OTP-C)"]
["編號","申報日期\n(YYYYMMDD)","執行交易的交易所參與者代號","交易日期\n(YYYYMMDD)","股票編號","股數","買入 / 沽出","輸入於OTP-C 的錯誤券商客戶編碼\n(註冊機構的中央編號 + \".\" + 券商客戶編碼)","更正的券商客戶編碼\n(註冊機構的中央編號 + \".\" + 券商客戶編碼)","交易編號 (OTP-C)"]
["(E.g) 1 ","20210309","1234","20210309","2345",200000,"B","ABC123.23456","ABC123.2345698765",2345000000001]
["(E.g) 2 ","20210309","1234","20210309","7654","1500000","S","ABC123.6789","ABC123.987654321","7654000000002"]
["1"]
["2"]