{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Portfolio Analysis"],"read":"whole","date_system":"1900"}

{"sheet":"Portfolio Analysis","index":0,"n_rows":10,"n_cols":11,"rows_kept":10,"merged":[[0,0,1,5],[0,6,0,8],[0,9,0,10],[1,6,1,8],[1,9,1,10],[2,0,3,5],[2,6,2,8],[2,9,2,10],[3,6,3,8],[3,9,3,10]]}
["Portfolio Analysis",{"$nulls":5},"Total cost of accounts",null,null,{"$f":"SUM(G6:G9)","v":{"v":18770,"d":"$18,770.00"}}]
[{"$nulls":6},"Value of accounts",null,null,{"$f":"SUM(I6:I9)","v":{"v":19553.5,"d":"$19,553.50"}}]
[{"$f":"TODAY()","v":{"v":39008,"d":"3900800.00%"}},{"$nulls":5},"Unrealized gain/loss $",null,null,{"$f":"J2-J1","v":{"v":783.5,"d":"$783.50"}}]
[{"$nulls":6},"Unrealized gain/loss %",null,null,{"$f":"(J2/J1)-100%","v":{"v":0.0417421417155035,"d":"4.17%"}}]
["Investment Name","Account Name or Number","Symbol","Quantity","Purchase Price Per Share","Trade Fees","Total Cost (Purchase Price + Fees)","Current Quote","Market Value","Gain/Loss ($)","Gain/Loss (%)"]
["A Datum Corporation","Woodgrove Bank","ZZZZ",100,{"v":49,"d":"$49.00"},{"v":29,"d":"$29.00"},{"$f":"('Portfolio Analysis'!$D$6:$D$9*'Portfolio Analysis'!$E$6:$E$9)+'Portfolio Analysis'!$F$6:$F$9","v":{"v":4929,"d":"$4,929.00"}},{"v":56.99,"d":"$56.99"},{"$f":"'Portfolio Analysis'!$D$6:$D$9*'Portfolio Analysis'!$H$6:$H$9","v":{"v":5699,"d":"$5,699.00"}},{"$f":"'Portfolio Analysis'!$I$6:$I$9-'Portfolio Analysis'!$G$6:$G$9","v":{"v":770,"d":"$770.00"}},{"$f":"IF(ISERR('Portfolio Analysis'!$I$6:$I$9/'Portfolio Analysis'!$G$6:$G$9),\"\",('Portfolio Analysis'!$I$6:$I$9/'Portfolio Analysis'!$G$6:$G$9)-100%)","v":{"v":0.1562182998579833,"d":"15.62%"}}]
["Adventure Works",2222222222,"AAAA",250,{"v":21.56,"d":"$21.56"},{"v":13,"d":"$13.00"},{"$f":"('Portfolio Analysis'!$D$6:$D$9*'Portfolio Analysis'!$E$6:$E$9)+'Portfolio Analysis'!$F$6:$F$9","v":{"v":5403,"d":"$5,403.00"}},{"v":19.13,"d":"$19.13"},{"$f":"'Portfolio Analysis'!$D$6:$D$9*'Portfolio Analysis'!$H$6:$H$9","v":{"v":4782.5,"d":"$4,782.50"}},{"$f":"'Portfolio Analysis'!$I$6:$I$9-'Portfolio Analysis'!$G$6:$G$9","v":{"v":-620.5,"d":"$(620.50)"}},{"$f":"IF(ISERR('Portfolio Analysis'!$I$6:$I$9/'Portfolio Analysis'!$G$6:$G$9),\"\",('Portfolio Analysis'!$I$6:$I$9/'Portfolio Analysis'!$G$6:$G$9)-100%)","v":{"v":-0.11484360540440497,"d":"-11.48%"}}]
["Wingtip Toys",1313131313,"WWWW",1200,{"v":7.01,"d":"$7.01"},{"v":26,"d":"$26.00"},{"$f":"('Portfolio Analysis'!$D$6:$D$9*'Portfolio Analysis'!$E$6:$E$9)+'Portfolio Analysis'!$F$6:$F$9","v":{"v":8438,"d":"$8,438.00"}},{"v":7.56,"d":"$7.56"},{"$f":"'Portfolio Analysis'!$D$6:$D$9*'Portfolio Analysis'!$H$6:$H$9","v":{"v":9072,"d":"$9,072.00"}},{"$f":"'Portfolio Analysis'!$I$6:$I$9-'Portfolio Analysis'!$G$6:$G$9","v":{"v":634,"d":"$634.00"}},{"$f":"IF(ISERR('Portfolio Analysis'!$I$6:$I$9/'Portfolio Analysis'!$G$6:$G$9),\"\",('Portfolio Analysis'!$I$6:$I$9/'Portfolio Analysis'!$G$6:$G$9)-100%)","v":{"v":0.07513628821995733,"d":"7.51%"}}]
[{"$nulls":6},{"$f":"('Portfolio Analysis'!$D$6:$D$9*'Portfolio Analysis'!$E$6:$E$9)+'Portfolio Analysis'!$F$6:$F$9","v":0},null,{"$f":"'Portfolio Analysis'!$D$6:$D$9*'Portfolio Analysis'!$H$6:$H$9","v":0},{"$f":"'Portfolio Analysis'!$I$6:$I$9-'Portfolio Analysis'!$G$6:$G$9","v":0},{"$f":"IF(ISERR('Portfolio Analysis'!$I$6:$I$9/'Portfolio Analysis'!$G$6:$G$9),\"\",('Portfolio Analysis'!$I$6:$I$9/'Portfolio Analysis'!$G$6:$G$9)-100%)","v":""}]
["Total",{"$nulls":5},{"$f":"SUBTOTAL(109,G6:G9)","v":{"v":18770,"d":"$18,770.00"}},null,{"$f":"SUBTOTAL(109,I6:I9)","v":{"v":19553.5,"d":"$19,553.50"}},{"$f":"SUBTOTAL(109,J6:J9)","v":{"v":783.5,"d":"$783.50"}},{"$f":"I10/G10-100%","v":{"v":0.0417421417155035,"d":"4.17%"}}]