{"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 の株式データ型は、現在の価格と資産の詳細に合わせてポートフォリオを最新の状態に保ちます。以下に説明するポートフォリオと資産配分の 2 つのワークシートがあります。注:Excel の株式データ型は、Office 365 のサブスクリプションのみの機能です。 "]
[]
[null,"ポートフォリオ"]
[]
[null,"例に上書きする形で、自分の投資、ティッカー シンボル、会社名、ファンド名を追加するか、別の行にさらに追加します。資産のカテゴリを選択し、株式数を追加します。",{"$nulls":9},"[列の追加] ボタンをクリックして、ティッカー シンボルや取引所などの列を追加します。\n"]
{"$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":272.29,"d":"¥272"}},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Change\")","v":{"v":-1.49,"d":"¥-1"}},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Change (%)\",TRUE)","v":{"v":-0.005442,"d":"-0.54%"}},{"$f":"IFERROR(I6/SUBTOTAL(109,テーブル_ポートフォリオ[価値]),\"\")","v":""},{"$f":"D6 * E6","v":{"v":326748,"d":"¥326,748"}}]
[null,{"$error":"#VALUE!"},"債券",{"v":1300,"d":"1,300"},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Price\")","v":{"v":9.72,"d":"¥10"}},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Change\")","v":{"v":0.09,"d":"¥0"}},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Change (%)\",TRUE)","v":{"v":0.009346,"d":"0.93%"}},{"$f":"IFERROR(I7/SUBTOTAL(109,テーブル_ポートフォリオ[価値]),\"\")","v":""},{"v":12636,"d":"¥12,636"}]
[null,{"$error":"#VALUE!"},"国際銘柄",{"v":1200,"d":"1,200"},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Price\")","v":{"v":28.67,"d":"¥29"}},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Change\")","v":0},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Change (%)\",TRUE)","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(I8/SUBTOTAL(109,テーブル_ポートフォリオ[価値]),\"\")","v":""},{"v":34404,"d":"¥34,404"}]
[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":110.69,"d":"¥111"}},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Change\")","v":{"v":-4.25,"d":"¥-4"}},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Change (%)\",TRUE)","v":{"v":-0.036976,"d":"-3.70%"}},{"$f":"IFERROR(I10/SUBTOTAL(109,テーブル_ポートフォリオ[価値]),\"\")","v":""},{"v":13836.25,"d":"¥13,836"}]
[null,{"$error":"#VALUE!"},"商品",100,{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Price\")","v":{"v":183.44,"d":"¥183"}},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Change\")","v":{"v":3.07,"d":"¥3"}},{"$f":"_FV(テーブル_ポートフォリオ[[#This Row],[会社]],\"Change (%)\",TRUE)","v":{"v":0.017020999999999998,"d":"1.70%"}},{"$f":"IFERROR(I11/SUBTOTAL(109,テーブル_ポートフォリオ[価値]),\"\")","v":""},{"v":18344,"d":"¥18,344"}]
[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":326748,"d":"¥326,748.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":34404,"d":"¥34,404.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":12636,"d":"¥12,636.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":13836.25,"d":"¥13,836.25"}}]
[null,"商品",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G25/SUBTOTAL(109,テーブル資産配分[価値]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.0125,"d":"1%"},{"$f":" SUMIF(テーブル_ポートフォリオ[カテゴリ], B25,テーブル_ポートフォリオ[価値])","v":{"v":18344,"d":"¥18,344.00"}}]