{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["开始","投资组合","资产分配"],"not_rendered":{"charts":1,"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"开始","index":0,"n_rows":28,"n_cols":12,"rows_kept":28,"merged":[[0,1,0,12],[2,1,2,11],[6,1,6,3],[6,11,6,12],[27,2,27,4]]}
[null,"投资跟踪表"]
[]
[null,"投资跟踪表模板可以跟踪投资和资产配置。Excel 股票数据类型将使投资组合与当前价格和资产详细信息保持同步。有投资组合和资产分配两个工作表，如下所述。注释：Excel 股票数据类型是仅限 Office 365 订阅的功能。 "]
[]
[null,"投资组合"]
[]
[null,"在示例中添加投资、股票代码、公司名称或基金名称，或在其他行上添加更多内容。选择资产类别并输入股份数额。",{"$nulls":9},"单击“添加列”按钮添加“股票代码”或“交易所”等其他列。"]
{"$rows_empty":16}
[null,"要刷新数据，请单击任意股票。在“数据”选项卡的“查询和连接”组中，单击“全部刷新”或按 Ctrl+Alt+F5。"]
[]
[null,"资产配置"]
[]
[null,"更改“类别”和“我的目标值”以自定义投资组合目标。","资产类别超出“阈值”时，金额将以黄色突出显示。"]

{"sheet":"投资组合","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[0,1,0,3]]}
[null,"投资跟踪表"]
[]
[null,"投资组合"]
[]
[null,"公司","类别","股份","价格","变化","变化（百分比）","投资组合百分比","价值"]
[null,{"$error":"#VALUE!"},"美国股票",{"v":1200,"d":"1,200"},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Price\")","v":{"v":277.66,"d":"¥277.66"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change\")","v":{"v":5.37,"d":"¥5.37"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change (%)\",TRUE)","v":{"v":0.019722,"d":"1.97%"}},{"$f":"IFERROR(I6/SUBTOTAL(109,投资组合表[价值]),\"\")","v":""},{"$f":"D6 * E6","v":{"v":333192.00000000006,"d":"¥333,192.00"}}]
[null,{"$error":"#VALUE!"},"债券",{"v":1300,"d":"1,300"},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Price\")","v":{"v":9.75,"d":"¥9.75"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change\")","v":{"v":0.03,"d":"¥0.03"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change (%)\",TRUE)","v":{"v":3.0859999999999998E-3,"d":"0.31%"}},{"$f":"IFERROR(I7/SUBTOTAL(109,投资组合表[价值]),\"\")","v":""},{"v":12675,"d":"¥12,675.00"}]
[null,{"$error":"#VALUE!"},"国际股票",{"v":1200,"d":"1,200"},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Price\")","v":{"v":28.81,"d":"¥28.81"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change\")","v":{"v":0.14,"d":"¥0.14"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change (%)\",TRUE)","v":{"v":0.004883,"d":"0.49%"}},{"$f":"IFERROR(I8/SUBTOTAL(109,投资组合表[价值]),\"\")","v":""},{"v":34572,"d":"¥34,572.00"}]
[null,{"$error":"#VALUE!"},"现金",{"v":10000,"d":"10,000"},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Price\")","v":{"$error":"#VALUE!"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change\")","v":{"$error":"#VALUE!"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change (%)\",TRUE)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(I9/SUBTOTAL(109,投资组合表[价值]),\"\")","v":""},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},"不动产",125,{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Price\")","v":{"v":108.86,"d":"¥108.86"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change\")","v":{"v":-1.83,"d":"¥-1.83"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change (%)\",TRUE)","v":{"v":-0.016533,"d":"-1.65%"}},{"$f":"IFERROR(I10/SUBTOTAL(109,投资组合表[价值]),\"\")","v":""},{"v":13607.5,"d":"¥13,607.50"}]
[null,{"$error":"#VALUE!"},"商品",100,{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Price\")","v":{"v":185.74,"d":"¥185.74"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change\")","v":{"v":2.3,"d":"¥2.30"}},{"$f":"_FV(投资组合表[[#This Row],[公司]],\"Change (%)\",TRUE)","v":{"v":0.012538,"d":"1.25%"}},{"$f":"IFERROR(I11/SUBTOTAL(109,投资组合表[价值]),\"\")","v":""},{"v":18574,"d":"¥18,574.00"}]
[null,"汇总",{"$nulls":6},{"$f":"IFERROR(SUBTOTAL(109,投资组合表[价值]), \"\")","v":""}]

{"sheet":"资产分配","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[0,1,0,6]]}
[null,"投资跟踪表"]
[]
[null,"资产分配"]
{"$rows_empty":15}
[null,"类别","我的目标值","实际值","差额","阈值","价值"]
[null,"美国股票",{"v":0.55,"d":"55%"},{"$f":"IFERROR(G20/SUBTOTAL(109,资产分配表[价值]),\"\")","v":""},{"$f":"D20 - C20","v":{"$error":"#VALUE!"}},{"$f":"MIN(5%, $C20 * 25%)","v":{"v":0.05,"d":"5%"}},{"$f":"SUMIF(投资组合表[类别], B20, 投资组合表[价值])","v":{"v":333192.00000000006,"d":"¥333,192.00"}}]
[null,"国际股票",{"v":0.2,"d":"20%"},{"$f":"IFERROR(G21/SUBTOTAL(109,资产分配表[价值]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.05,"d":"5%"},{"$f":"SUMIF(投资组合表[类别], B21, 投资组合表[价值])","v":{"v":34572,"d":"¥34,572.00"}}]
[null,"债券",{"v":0.1,"d":"10%"},{"$f":"IFERROR(G22/SUBTOTAL(109,资产分配表[价值]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.025,"d":"3%"},{"$f":"SUMIF(投资组合表[类别], B22, 投资组合表[价值])","v":{"v":12675,"d":"¥12,675.00"}}]
[null,"现金",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G23/SUBTOTAL(109,资产分配表[价值]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(投资组合表[类别], B23, 投资组合表[价值])","v":{"$error":"#VALUE!"}}]
[null,"不动产",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G24/SUBTOTAL(109,资产分配表[价值]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(投资组合表[类别], B24, 投资组合表[价值])","v":{"v":13607.5,"d":"¥13,607.50"}}]
[null,"商品",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G25/SUBTOTAL(109,资产分配表[价值]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(投资组合表[类别], B25, 投资组合表[价值])","v":{"v":18574,"d":"¥18,574.00"}}]