{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["期貨","選擇權","交易紀錄","交易彙總"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":1},"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":"期貨","index":0,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["時間","名稱","買價","賣價","成交","漲跌","漲%","開盤","最高","最低","成交量","未平倉","昨收"]
["13:30:00","台灣加權",0,0,8317,-139,-1.64,8472,8496,8317,0,0,8456]
["13:45:00","台指期近1",8292,8295,8294,-142,-1.68,8430,8488,8278,144679,66978,8436]
["13:45:00","台指期近2",8263,8271,8265,-143,-1.7,8408,8456,8251,2944,9459,8408]
["13:30:00","小台指現貨",0,0,8317,-139,-1.64,8472,8496,8317,0,0,8456]
["13:45:00","小台指近1",8291,8292,8291,-145,-1.72,8431,8488,8278,84808,23880,8436]
["13:45:00","小台指近2",8265,8270,8268,-140,-1.67,8413,8456,8253,3862,5953,8408]
["13:30:00","摩根現貨",0,0,290.25,-5.17,-1.75,295.27999999999997,296.66000000000003,290.25,0,0,295.42]
["13:45:00","摩台指近1",287.5,287.5,288.10000000000002,-4.9000000000000004,-1.67,292.8,294.7,287.5,43962,197462,293]
["13:45:00","摩台指近2",283.8,296.89999999999998,287.10000000000002,-6.7,-2.2799999999999998,288.60000000000002,288.60000000000002,287.10000000000002,4,212,293.8]
["13:45:00","新摩台指近1",286.10000000000002,295.89999999999998,0,0,0,0,0,0,0,0,294.5]
["13:45:00","新摩台指近2",278.10000000000002,317.89999999999998,0,0,0,0,0,0,0,0,298]
["13:30:00","寶來台灣50",0,0,5558,-93,-1.65,5658,5672,5558,0,0,5651]
["13:45:00","台灣50近1",5501,5598,5698,10,0.18,5698,5698,5698,1,4,5688]
["13:45:00","台灣50近2",5331,5639,0,0,0,0,0,0,0,1,5583]
["13:45:00","櫃買期近1",125,128.05000000000001,127,-1.9,-1.47,129.9,129.9,127,58,140,128.9]
["13:45:00","櫃買期近2",119.7,133.94999999999999,0,0,0,0,0,0,0,60,128.69999999999999]
["13:30:00","電子指數",0,0,295.47000000000003,-5.97,-1.98,301.42,302.33999999999997,295.47000000000003,0,0,301.44]
["13:45:00","台電指近1",293.89999999999998,294.45,293.89999999999998,-6.45,-2.15,300.89999999999998,301.89999999999998,293.75,8166,6434,300.35000000000002]
["13:45:00","台電指近2",293,294,292.89999999999998,-6.4,-2.14,299.25,300.39999999999998,292.89999999999998,213,496,299.3]
["13:30:00","金融指數",0,0,1045,3.5,0.34,1045.5,1073,1043,0,0,1041.5]
["13:45:00","台金指近1",1040.4000000000001,1041,1041,5.6,0.54,1037.8,1066.8,1036.2,14017,6347,1035.4000000000001]
["13:45:00","台金指近2",1035.2,1037.2,1037,5.6,0.54,1032.8,1060.2,1032.8,461,573,1031.4000000000001]
["13:30:00","非金電期貨",0,0,11691,-237,-1.99,11969,11969,11691,0,0,11928]
["13:45:00","非金電近1",11656,11665,11668,-253,-2.12,11905,11938,11656,856,1700,11921]
["13:45:00","非金電近2",11612,11620,11620,-255,-2.15,11866,11893,11620,190,100,11875]

{"sheet":"選擇權","index":1,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["月份: 2011/08"]
[]
["買 權 ",null,null,null,null,null,null,null,"賣 權"]
["履約價","時間","成交價","買價","賣價","漲跌","總量",null,"履約價","時間","成交價","買價","賣價","漲跌","總量"]
[7100,"09:13:00",1590,1110,1280,"△240",2,null,7100,"13:26:00",0.5,0.1,0.5,"△0.4",121]
[7200,"13:44:00",1070,1080,1120,"▽180",21,null,7200,"13:31:00",0.8,0.1,0.8,"△0.6",120]
[7300,"13:32:00",995,910,1080,"▽155",20,null,7300,"12:53:00",0.4,0.5,3.3,"△0.2",140]
[7400,"13:32:00",895,875,910,"▽155",20,null,7400,"13:44:00",1.2,1.2,1.3,"△0.8",137]
[7500,"13:32:00",800,710,880,"▽155",20,null,7500,"13:44:00",3.2,1.4,3,"△2.5",3030]
[7600,"13:32:00",700,615,780,"▽155",31,null,7600,"13:44:00",2.4,2.2999999999999998,2.4,"△1.4",1351]
[7700,"13:44:00",595,515,600,"▽160",46,null,7700,"13:44:00",4.2,4.0999999999999996,4.4000000000000004,"△2.3",10217]
[7800,"13:32:00",500,485,520,"▽155",11,null,7800,"13:44:00",9.1999999999999993,9.1999999999999993,9.3000000000000007,"△5.5",5331]
[7900,"13:42:00",400,393,423,"▽150",63,null,7900,"13:44:00",17,16.5,17,"△9.7",20590]
[8000,"13:44:00",320,307,337,"▽132",173,null,8000,"13:44:00",31,30.5,31,"△17",41909]
[8100,"13:43:00",234,237,245,"▽127",764,null,8100,"13:44:00",51,50,51,"△26",52555]
[8200,"13:44:00",171,171,175,"▽108",3680,null,8200,"13:44:00",82,80,82,"△40.5",48914]
[8300,"13:44:00",113,113,118,"▽92",8545,null,8300,"13:44:00",122,121,122,"△55",58381]
[8400,"13:44:00",70,69,70,"▽71",26682,null,8400,"13:44:00",177,175,179,"△72",41639]
[8500,"13:44:00",39.5,39.5,40,"▽51.5",52964,null,8500,"13:44:00",248,245,248,"△94",16718]
[8600,"13:44:00",20.5,19.5,20,"▽33.5",60435,null,8600,"13:44:00",326,325,330,"△111",6542]
[8700,"13:44:00",8.6,8.3000000000000007,8.6,"▽20.4",69149,null,8700,"13:44:00",415,413,423,"△121",1869]
[8800,"13:44:00",3.8,3.7,3.8,"▽10.7",44393,null,8800,"13:44:00",515,505,520,"△139",481]
[8900,"13:44:00",1.8,1.7,1.8,"▽5.1",17986,null,8900,"13:44:00",610,600,630,"△142",183]
[9000,"13:44:00",1.3,1.2,1.3,"▽1.8",16976,null,9000,"12:09:00",600,690,725,"△35",34]
[9100,"13:43:00",0.9,0.8,0.9,"▽0.6",11477,null,9100,"12:50:00",765,720,890,"△125",20]
[9200,"13:43:00",0.5,0.2,0.7,"▽0.3",604,null,9200,"09:14:00",700,820,925,"▽40",12]
[9300,"13:43:00",0.7,0.4,0.7,0,297,null,9300,"08:45:00",870,920,1090,"△30",10]
[9400,"13:37:00",0.3,0.3,0.5,"▽0.3",190,null,9400,"－","－",1020,1190,"－","－"]
[9500,"13:11:00",1.5,0.3,1,"△1.4",10,null,9500,"－","－",1130,1300,"－","－"]
[9600,"11:01:00",0.4,0.2,1.5,"△0.3",2,null,9600,"－","－",1230,1400,"－","－"]
[9700,"－","－",0.2,1.5,"－","－",null,9700,"－","－",1330,1500,"－","－"]
[9800,"－","－",0.1,1.5,"－","－",null,9800,"－","－",1430,1600,"－","－"]
[9900,"13:35:00",0.1,0,1.5,0,5,null,9900,"－","－",1520,1690,"－","－"]
[10000,"09:46:00",0.5,0,0.4,"△0.4",1,null,10000,"－","－",1620,1790,"－","－"]
[10200,"－","－",0,1.5,"－","－",null,10200,"－","－",1820,1990,"－","－"]
[10400,"－","－",0,1.5,"－","－",null,10400,"－","－",2080,2140,"－","－"]
[10600,"10:46:00",0.1,0,1.5,0,50,null,10600,"－","－",2280,2340,"－","－"]

{"sheet":"交易紀錄","index":2,"n_rows":129,"n_cols":25,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
["交易編號　","交易日期","商品別","購入口數","購入價位","出售口數","出售價位","手續費","證交稅","購入總價","出售總價",null,null,null,null,null,null,"交易編號　","商品別","原始保證金/TXO_A","原始保證金/TXO_B","手續費","證交稅","交割證交稅","單點價格"]
[969,"2011-07-25","買權8400",3,70,null,null,{"$f":"IF(A2=\"\",\"\",IF($D2>0,VLOOKUP($C2,商品規格,4,0)*$D2*VLOOKUP($C2,商品規格,7,0),VLOOKUP($C2,商品規格,4,0)*$F2*VLOOKUP($C2,商品規格,7,0)))","v":300},{"$f":"IF(A2=\"\",\"\",IF($D2>0,VLOOKUP($C2,商品規格,5,0)*$D2*VLOOKUP($C2,商品規格,7,0)*$E2,IF(AND(A2<>\"\",$F2>0),VLOOKUP($C2,商品規格,5,0)*$F2*VLOOKUP($C2,商品規格,7,0)*$G2)))","v":13.125},{"$f":"IF(D2>0,D2*E2,\"\")","v":210},{"$f":"IF(F2>0,F2*G2,\"\")","v":""},null,null,null,null,null,null,168,"台指期近1",64000,49000,1,2.5000000000000001E-4,2.5000000000000001E-4,200]
[969,"2011-07-25","買權8400",null,null,3,80,300,15,{"$f":"IF(D3>0,D3*E3,\"\")","v":""},{"$f":"IF(F3>0,F3*G3,\"\")","v":240},null,null,null,null,null,null,588,"台電指近1",39000,37000,6.25E-2,2.5000000000000001E-4,2.5000000000000001E-4,4000]
[969,"2011-07-26","買權8700",2,20,null,null,200,2.5,40,"",null,null,null,null,null,null,832,"台金指近1",34000,32000,0.25,2.5000000000000001E-4,2.5000000000000001E-4,1000]
[969,"2011-07-26","買權8700",null,null,2,15,200,1.875,"",30,null,null,null,null,null,null,707,"台指期近2",64000,49000,1,2.5000000000000001E-4,2.5000000000000001E-4,200]
[969,"2011-07-28","賣權8200",3,70,null,null,300,13.125,210,"",null,null,null,null,null,null,969,"台電指近2",39000,37000,6.25E-2,2.5000000000000001E-4,2.5000000000000001E-4,4000]
[969,"2011-07-28","賣權8000",2,10,null,null,200,1.25,20,"",null,null,null,null,null,null,248,"台金指近2",34000,32000,0.25,2.5000000000000001E-4,2.5000000000000001E-4,1000]
[969,"2011-07-29","賣權8200",null,null,1,80,100,5,"",80,null,null,null,null,null,null,249,"買權5000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[969,"2011-07-30","台指期近1",2,8500,null,null,400,850,17000,"",null,null,null,null,null,null,null,"買權5100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[969,"2011-07-31","台指期近1",null,null,1,8450,200,422.5,"",8450,null,null,null,null,null,null,null,"買權5200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權5300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權5400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權5500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權5600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權5700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權5800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權5900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權6000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權6100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權6200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權6300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權6400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權6500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權6600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權6700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權6800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權6900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權7000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權7100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權7200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權7300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權7400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權7500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,{"$f":"IF(A34=\"\",\"\",IF($D34>0,VLOOKUP($C34,商品規格,4,0)*$D34*VLOOKUP($C34,商品規格,7,0),VLOOKUP($C34,商品規格,4,0)*$F34*VLOOKUP($C34,商品規格,7,0)))","v":""},{"$f":"IF(A34=\"\",\"\",IF($D34>0,VLOOKUP($C34,商品規格,5,0)*$D34*VLOOKUP($C34,商品規格,7,0)*$E34,IF(AND(A34<>\"\",$F34>0),VLOOKUP($C34,商品規格,5,0)*$F34*VLOOKUP($C34,商品規格,7,0)*$G34)))","v":""},"","",null,null,null,null,null,null,null,"買權7600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權7700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權7800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權7900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權8000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權8100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權8200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權8300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權8400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權8500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權8600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權8700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權8800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權8900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權9000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權9100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權9200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權9300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權9400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權9500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權9600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權9700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權9800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權9900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權10000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權10100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權10200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權10300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權10400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權10500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權10600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權10700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,{"$f":"IF(A66=\"\",\"\",IF($D66>0,VLOOKUP($C66,商品規格,4,0)*$D66*VLOOKUP($C66,商品規格,7,0),VLOOKUP($C66,商品規格,4,0)*$F66*VLOOKUP($C66,商品規格,7,0)))","v":""},{"$f":"IF(A66=\"\",\"\",IF($D66>0,VLOOKUP($C66,商品規格,5,0)*$D66*VLOOKUP($C66,商品規格,7,0)*$E66,IF(AND(A66<>\"\",$F66>0),VLOOKUP($C66,商品規格,5,0)*$F66*VLOOKUP($C66,商品規格,7,0)*$G66)))","v":""},"","",null,null,null,null,null,null,null,"買權10800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","",{"$f":"IF(D67>0,D67*E67,\"\")","v":""},{"$f":"IF(F67>0,F67*G67,\"\")","v":""},null,null,null,null,null,null,null,"買權10900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"買權11000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權5000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權5100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權5200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權5300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權5400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權5500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權5600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權5700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權5800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權5900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權6000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權6100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權6200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權6300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權6400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權6500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權6600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,"賣權6700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權6800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權6900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權7000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權7100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權7200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權7300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權7400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權7500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權7600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權7700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權7800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權7900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權8000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權8100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權8200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權8300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權8400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權8500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權8600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權8700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權8800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權8900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權9000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權9100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權9200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權9300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權9400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權9500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權9600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權9700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權9800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權9900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權10000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權10100",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權10200",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權10300",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權10400",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權10500",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權10600",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權10700",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權10800",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權10900",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賣權11000",17000,9000,2,1.25E-3,2.5000000000000001E-4,50]

{"sheet":"交易彙總","index":3,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["交易編號　","(全部)",null,null,null,null,null,null,null,null,null,null,"台指期近1",8250]
["交易日期","(全部)",null,null,null,null,null,null,null,null,null,false,"台電指近1",300]
[null,null,null,null,null,null,null,null,null,null,null,null,"台金指近1",1050]
[null,"數值"]
["列標籤"," 購入口數"," 購入總價"," 出售口數"," 出售總價"," 手續費"," 證交稅"," 平倉口數"," 未平倉口數","購入均價","出售均價","收盤價","實現損益","未實現損益","損益小計","保證金"]
["台指期近1",2,17000,1,8450,600,1272.5,1,1,{"$f":"IF(AND(LEN(A6)>4,B6>0),C6/B6,\"\")","v":8500},{"$f":"IF(AND(LEN(A6)>4,D6>0),E6/D6,\"\")","v":8450},{"$f":"IF(AND(LEN(A6)>4,LEFT(A6,1)=\"台\"),IF($L$2,VLOOKUP(A6,結算價格,2,0),VLOOKUP(A6,期貨收盤,4,0)),IF(LEFT(A6,1)=\"買\",IF($L$2,$N$1,LOOKUP(VALUE(RIGHT(A6,4)),執行價格,買權價格)),IF(LEFT(A6,1)=\"賣\",IF($L$2,$N$1,LOOKUP(VALUE(RIGHT(A6,4)),執行價格,賣權價格)),\"\")))","v":8294},{"$f":"IF(LEN(A6)>4,IF(AND(H6>0,LEFT(A6,1)=\"台\"),(K6-J6)*H6*VLOOKUP(A6,商品規格,7,0)-F6-G6,IF(AND(H6>0,MID(A6,2,1)=\"權\"),(K6-J6)*H6*VLOOKUP(A6,商品規格,7,0)-F6-G6,-F6-G6)),\"\")","v":-11872.5},{"$f":"IF(LEN(A6)>4,IF(AND($L$2,MID(A6,2,1)=\"權\"),0,IF(B6>=D6, I6*VLOOKUP(A6,商品規格,7,0)*(L6-J6-VLOOKUP(A6,商品規格,4,0)-IF($L$2,VLOOKUP(A6,商品規格,6,0),VLOOKUP(A6,商品規格,5,0))*L6),I6*VLOOKUP(A6,商品規格,7,0)*(K6-L6-VLOOKUP(A6,商品規格,4,0)-IF($L$2,VLOOKUP(A6,商品規格,6,0),VLOOKUP(A6,商品規格,5,0))*L6))),\"\")","v":-41814.699999999997},{"$f":"IF(LEN(A6)>4,M6+N6,\"\")","v":-53687.199999999997},{"$f":"IF(LEN(A6)>=4,IF($L$2,0,I6*VLOOKUP(A6,商品規格,2,0)),\"\")","v":64000}]
["買權8400",3,210,3,240,600,28.125,3,0,{"$f":"IF(AND(LEN(A7)>4,B7>0),C7/B7,\"\")","v":70},{"$f":"IF(AND(LEN(A7)>4,D7>0),E7/D7,\"\")","v":80},{"$f":"IF(AND(LEN(A7)>4,LEFT(A7,1)=\"台\"),VLOOKUP(A7,期貨收盤,4,0),IF(LEFT(A7,1)=\"買\",LOOKUP(VALUE(RIGHT(A7,4)),執行價格,買權價格),IF(LEFT(A7,1)=\"賣\",LOOKUP(VALUE(RIGHT(A7,4)),執行價格,賣權價格),\"\")))","v":70},871.875,0,{"$f":"IF(LEN(A7)>4,M7+N7,\"\")","v":871.875},0]
["買權8700",2,40,2,30,400,4.375,2,0,20,{"$f":"IF(AND(LEN(A8)>4,D8>0),E8/D8,\"\")","v":15},{"$f":"IF(AND(LEN(A8)>4,LEFT(A8,1)=\"台\"),VLOOKUP(A8,期貨收盤,4,0),IF(LEFT(A8,1)=\"買\",LOOKUP(VALUE(RIGHT(A8,4)),執行價格,買權價格),IF(LEFT(A8,1)=\"賣\",LOOKUP(VALUE(RIGHT(A8,4)),執行價格,賣權價格),\"\")))","v":8.6},-904.375,0,-904.375,0]
["賣權8200",3,210,1,80,400,18.125,1,2,70,80,82,81.875,989.75000000000011,1071.625,34000]
["賣權8000",2,20,null,0,200,1.25,0,2,10,"",31,-201.25,1896.125,1694.875,34000]
[null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M6:M20)","v":-12024.375},{"$f":"SUM(N6:N20)","v":-38928.824999999997},{"$f":"SUM(O6:O20)","v":-50953.2},{"$f":"SUM(P6:P20)","v":132000}]