{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["股票投资业绩"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"股票投资业绩","index":0,"n_rows":68,"n_cols":11,"rows_kept":68,"merged":[[0,0,0,1],[0,3,0,5],[0,6,0,7],[1,3,1,5],[1,6,1,7],[2,3,2,5],[2,6,2,7],[3,3,3,5],[3,6,3,7]]}
["股票投资业绩",null,null,"帐户总成本",null,null,{"$f":"SUM(G7:G68)","v":{"v":4929,"d":"￥4,929.00"}}]
["[日期]",null,null,"帐户市值",null,null,{"$f":"SUM(I7:I68)","v":{"v":5699,"d":"￥5,699.00"}}]
[{"$nulls":3},"差额",null,null,{"$f":"G2-G1","v":{"v":770,"d":"￥770.00"}}]
[{"$nulls":3},"差额百分比",null,null,{"$f":"(G2/G1)-100%","v":{"v":0.1562182998579833,"d":"15.6%"}}]
[]
["股票名称","发行商","代码","数量","每股买进价","交易费用","总成本（买进价＋交易费用）","当前价","市值","股票收益 (￥)","股票收益 (%)"]
["银河 A","京北证券交易所",123456,100,{"v":49,"d":"￥49.00"},{"v":29,"d":"￥29.00"},{"$f":"(D7*E7)+F7","v":{"v":4929,"d":"￥4,929.00"}},{"v":56.99,"d":"￥56.99"},{"$f":"D7*H7","v":{"v":5699,"d":"￥5,699.00"}},{"$f":"I7-G7","v":{"v":770,"d":"￥770.00"}},{"$f":"IF(ISERR(I7/G7),\"N/A\",(I7/G7)-100%)","v":{"v":0.1562182998579833,"d":"15.6%"}}]
[{"$nulls":6},{"$f":"(D8*E8)+F8","v":{"v":0,"d":"￥0.00"}},null,{"$f":"D8*H8","v":{"v":0,"d":"￥0.00"}},{"$f":"I8-G8","v":{"v":0,"d":"￥0.00"}},{"$f":"IF(ISERR(I8/G8),\"N/A\",(I8/G8)-100%)","v":"N/A"}]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"$f":"D9*H9","v":{"v":0,"d":"￥0.00"}},{"$f":"I9-G9","v":{"v":0,"d":"￥0.00"}},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]
[{"$nulls":6},{"v":0,"d":"￥0.00"},null,{"v":0,"d":"￥0.00"},{"v":0,"d":"￥0.00"},"N/A"]