{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Start","Portfolio","Asset Allocation"],"not_rendered":{"charts":1,"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":29,"n_cols":2,"rows_kept":29}
["Investment Tracker","Investment Tracker"]
[]
["The Investment Tracker template will allow you to track your investments and asset allocation. The Excel Stocks data type will keep your portfolio up to date with current prices and details of your assets. There are two worksheets, Portfolio and Asset Allocation, described below. Note: The Excel Stocks data type is an Office 365 subscription-only feature. "]
[]
["Portfolio","Portfolio"]
["Add your investments, type ticker symbols, company names or fund names over the examples or add more on additional rows. Select an asset category and enter the number of shares."]
["Click the Add Column button to add additional columns such as Ticker Symbol or Exchange."]
{"$rows_empty":13}
["To refresh the data, click on any of the stocks. In the Data tab in the Queries & Connections group, click Refresh All or press Ctrl + Alt + F5."]
[]
[]
[]
[]
["Asset Allocation","Asset Allocation"]
[]
["Change Categories and My Target to customise these to your portfolio goals."]
["When an asset category exceeds the Threshold, the amounts will be highlighted in yellow."]

{"sheet":"Portfolio","index":1,"n_rows":12,"n_cols":9,"rows_kept":12}
["Investment Tracker","Investment Tracker"]
[]
["Portfolio","Portfolio"]
[]
["There is a table with existing stocks in cells B5:I11 and a total row on row 12. Enter a company name in cells B5:B11, then go to Data > Refresh or press Ctrl + Alt + F5.","Company","Category","Shares","Price","Change","Change (%)","Portfolio %","Value"]
["Add your investments, type ticker symbols, company names or fund names over the examples or add more on additional rows.  Select an asset category and enter the number of shares.",{"$error":"#VALUE!"},"US Stocks",{"v":1200,"d":"1,200"},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":105.21,"d":"£105.21"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":{"v":-0.24,"d":"-£0.24"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":-0.002276,"d":"-0.23%"}},{"$f":"IFERROR(I6/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.5974736139719061,"d":"60%"}},{"$f":"D6 * E6","v":{"v":126251.99999999999,"d":"£126,252.00"}}]
["Click the Add Column button to add additional columns such as Ticker Symbol or Exchange.",{"$error":"#VALUE!"},"Bonds",{"v":1300,"d":"1,300"},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":10.46,"d":"£10.46"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":{"v":0.0122760756111569,"d":"£0.01"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":1.1749999999999998E-3,"d":"0.12%"}},{"$f":"IFERROR(I7/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.06435102970875695,"d":"6%"}},{"v":13598.000000000002,"d":"£13,598.00"}]
["To refresh the data, click on any of the stocks. In the Data tab in the Queries & Connections group, click Refresh All or press Ctrl + Alt + F5.",{"$error":"#VALUE!"},"International Stocks",{"v":1200,"d":"1,200"},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":29.29,"d":"£29.29"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":{"v":0.0699994333574489,"d":"£0.07"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":0.0023956,"d":"0.24%"}},{"$f":"IFERROR(I8/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.16633401913541615,"d":"17%"}},{"v":35148,"d":"£35,148.00"}]
[null,{"$error":"#VALUE!"},"Cash",{"v":10000,"d":"10,000"},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":1,"d":"£1.00"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":0},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(I9/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.0473238930054103,"d":"5%"}},{"v":10000,"d":"£10,000.00"}]
[null,{"$error":"#VALUE!"},"Property",125,{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":116.63,"d":"£116.63"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":{"v":-0.249994620493774,"d":"-£0.25"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":-2.1389E-3,"d":"-0.21%"}},{"$f":"IFERROR(I10/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.06899232051526255,"d":"7%"}},{"v":14578.75,"d":"£14,578.75"}]
[null,{"$error":"#VALUE!"},"Commodities",100,{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":117.33,"d":"£117.33"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":{"v":-0.27,"d":"-£0.27"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":-0.002296,"d":"-0.23%"}},{"$f":"IFERROR(I11/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.05552512366324791,"d":"6%"}},{"v":11733,"d":"£11,733.00"}]
[null,"Total",{"$nulls":6},{"$f":"IFERROR(SUBTOTAL(109,TablePortfolio[Value]), \"\")","v":{"v":211309.75,"d":"£211,309.75"}}]

{"sheet":"Asset Allocation","index":2,"n_rows":25,"n_cols":7,"rows_kept":25}
["Investment Tracker","Investment Tracker"]
[]
["Asset Allocation","Asset Allocation"]
[]
[]
["There is a bar chart that visually compares the actual percentage of investments in each category to the targets set in the table below on rows 19-25."]
{"$rows_empty":12}
["There is a table that calculates the actual percentage of investments in each category and compares it to the targets.","Category","My Target","Actual","Difference","Threshold","Value"]
["The table automatically populates the investment categories from the Portfolio table in cells B19:G25. Enter a target for each investment category in cells C20:C25, then go to Data > Refresh or press Ctrl + Alt + F5. ","US Stocks",{"v":0.55,"d":"55%"},{"$f":"IFERROR(G20/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.5974736139719061,"d":"60%"}},{"$f":"D20 - C20","v":{"v":0.04747361397190608,"d":"4.7%"}},{"$f":"MIN(5%, $C20 * 25%)","v":{"v":0.05,"d":"5%"}},{"$f":"SUMIF(TablePortfolio[Category], B20, TablePortfolio[Value])","v":{"v":126251.99999999999,"d":"£126,252.00"}}]
["When an asset category exceeds the Threshold, the amounts will be highlighted in yellow.","International Stocks",{"v":0.2,"d":"20%"},{"$f":"IFERROR(G21/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.16633401913541615,"d":"17%"}},{"v":-0.03366598086458386,"d":"-3.4%"},{"v":0.05,"d":"5%"},{"$f":"SUMIF(TablePortfolio[Category], B21, TablePortfolio[Value])","v":{"v":35148,"d":"£35,148.00"}}]
[null,"Bonds",{"v":0.1,"d":"10%"},{"$f":"IFERROR(G22/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.06435102970875695,"d":"6%"}},{"v":-0.03564897029124306,"d":"-3.6%"},{"v":0.025,"d":"3%"},{"$f":"SUMIF(TablePortfolio[Category], B22, TablePortfolio[Value])","v":{"v":13598.000000000002,"d":"£13,598.00"}}]
[null,"Cash",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G23/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.0473238930054103,"d":"5%"}},{"v":-0.0026761069945897,"d":"-0.3%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Category], B23, TablePortfolio[Value])","v":{"v":10000,"d":"£10,000.00"}}]
[null,"Property",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G24/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.06899232051526255,"d":"7%"}},{"v":0.018992320515262548,"d":"1.9%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Category], B24, TablePortfolio[Value])","v":{"v":14578.75,"d":"£14,578.75"}}]
[null,"Commodities",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G25/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.05552512366324791,"d":"6%"}},{"v":0.005525123663247908,"d":"0.6%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Category], B25, TablePortfolio[Value])","v":{"v":11733,"d":"£11,733.00"}}]