{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Portföljanalys","Cirkeldiagram för portfölj"],"not_rendered":{"charts":2,"images":1,"defined_names":3},"unopened":[{"sheet":"Cirkeldiagram för portfölj","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Portföljanalys","index":0,"n_rows":9,"n_cols":11,"rows_kept":9,"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]]}
["Portföljanalys",{"$nulls":5},"Total kostnad för konton",null,null,{"$f":"SUM(G6:G8)","v":{"v":18770,"d":"18,770.00 kr"}}]
[{"$nulls":6},"Kontovärden",null,null,{"$f":"SUM(I6:I8)","v":{"v":19553.5,"d":"19,553.50 kr"}}]
[{"$f":"TODAY()","v":{"v":41128,"d":"4112800.00%"}},{"$nulls":5},"Orealiserad vinst/förlust kr",null,null,{"$f":"J2-J1","v":{"v":783.5,"d":"783.50 kr"}}]
[{"$nulls":6},"Orealiserad vinst/förlust %",null,null,{"$f":"(J2/J1)-100%","v":{"v":0.0417421417155035,"d":"4.17%"}}]
["Värdepapper","Kontonamn eller -nr","Symbol","Antal","Köpkurs per aktie","Avgifter","Total kostnad (Köpsumma + avgifter)","Aktuell kurs","Marknadsvärde","Vinst/förl. (kr)","Vinst/förl. (%)"]
["A Datum Corporation","Woodgrove Bank","AAAA",100,{"v":49,"d":"49.00 kr"},{"v":29,"d":"29.00 kr"},{"$f":"(Tabell1[Antal]*Tabell1[Köpkurs per aktie])+Tabell1[Avgifter]","v":{"v":4929,"d":"4,929.00 kr"}},{"v":56.99,"d":"56.99 kr"},{"$f":"Tabell1[Antal]*Tabell1[Aktuell kurs]","v":{"v":5699,"d":"5,699.00 kr"}},{"$f":"Tabell1[Marknadsvärde]-Tabell1[Total kostnad (köpsumma + avgifter)]","v":{"v":770,"d":"770.00 kr"}},{"$f":"IF(ISERR(Tabell1[Marknadsvärde]/Tabell1[Total kostnad (köpsumma + avgifter)]),\"\",(Tabell1[Marknadsvärde]/Tabell1[Total kostnad (köpsumma + avgifter)])-100%)","v":{"v":0.1562182998579833,"d":"15.62%"}}]
["Adventure Works","Woodgrove Bank","AWAW",250,{"v":21.56,"d":"21.56 kr"},{"v":13,"d":"13.00 kr"},{"$f":"(Tabell1[Antal]*Tabell1[Köpkurs per aktie])+Tabell1[Avgifter]","v":{"v":5403,"d":"5,403.00 kr"}},{"v":19.13,"d":"19.13 kr"},{"$f":"Tabell1[Antal]*Tabell1[Aktuell kurs]","v":{"v":4782.5,"d":"4,782.50 kr"}},{"$f":"Tabell1[Marknadsvärde]-Tabell1[Total kostnad (köpsumma + avgifter)]","v":{"v":-620.5,"d":"-620.50 kr"}},{"$f":"IF(ISERR(Tabell1[Marknadsvärde]/Tabell1[Total kostnad (köpsumma + avgifter)]),\"\",(Tabell1[Marknadsvärde]/Tabell1[Total kostnad (köpsumma + avgifter)])-100%)","v":{"v":-0.11484360540440497,"d":"-11.48%"}}]
["Wingtip Toys","Woodgrove Bank","WWTT",1200,{"v":7.01,"d":"7.01 kr"},{"v":26,"d":"26.00 kr"},{"$f":"(Tabell1[Antal]*Tabell1[Köpkurs per aktie])+Tabell1[Avgifter]","v":{"v":8438,"d":"8,438.00 kr"}},{"v":7.56,"d":"7.56 kr"},{"$f":"Tabell1[Antal]*Tabell1[Aktuell kurs]","v":{"v":9072,"d":"9,072.00 kr"}},{"$f":"Tabell1[Marknadsvärde]-Tabell1[Total kostnad (köpsumma + avgifter)]","v":{"v":634,"d":"634.00 kr"}},{"$f":"IF(ISERR(Tabell1[Marknadsvärde]/Tabell1[Total kostnad (köpsumma + avgifter)]),\"\",(Tabell1[Marknadsvärde]/Tabell1[Total kostnad (köpsumma + avgifter)])-100%)","v":{"v":0.07513628821995733,"d":"7.51%"}}]
["Summa",{"$nulls":5},{"$f":"SUBTOTAL(109,Tabell1[Total kostnad (köpsumma + avgifter)])","v":{"v":18770,"d":"18,770.00 kr"}},null,{"$f":"SUBTOTAL(109,Tabell1[Marknadsvärde])","v":{"v":19553.5,"d":"19,553.50 kr"}},{"$f":"SUBTOTAL(109,Tabell1[Vinst/förl. (kr)])","v":{"v":783.5,"d":"783.50 kr"}},{"$f":"Tabell1[[#Totals],[Marknadsvärde]]/Tabell1[[#Totals],[Total kostnad (köpsumma + avgifter)]]-100%","v":{"v":0.0417421417155035,"d":"4.17%"}}]