{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Pagina Iniziale","LPM","Grafico 1","Grafico 2"],"not_rendered":{"charts":2,"images":6,"macros":1,"defined_names":23},"read":"whole","date_system":"1900"}

{"sheet":"Pagina Iniziale","index":0,"n_rows":9,"n_cols":2,"rows_kept":9}
[]
[]
[null,"Manuale di"]
[null,"Matematica finanziaria"]
[null,"Carocci editore - 2012"]
[]
[null,"Marco Micocci - Giovanni Masala"]
[]
[null,"Capitolo 8"]

{"sheet":"LPM","index":1,"n_rows":86,"n_cols":9,"rows_kept":86}
[]
[]
[null,"Lower Partial Moments"]
[]
[null,null,"Distribuzione congiunta di probabilità"]
[null,null,"titolo 1","titolo 2","titolo 3","Probabilità"]
[]
[null,1,{"v":5,"d":"5.00"},{"v":3,"d":"3.00"},{"v":10,"d":"10.00"},{"v":0.1,"d":"0.1000"}]
[null,2,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},{"v":10,"d":"10.00"},{"v":0.15,"d":"0.1500"}]
[null,3,{"v":5,"d":"5.00"},{"v":7,"d":"7.00"},{"v":7,"d":"7.00"},{"v":0.05,"d":"0.0500"}]
[null,4,{"v":7,"d":"7.00"},{"v":3,"d":"3.00"},{"v":7,"d":"7.00"},{"v":0.1,"d":"0.1000"}]
[null,5,{"v":7,"d":"7.00"},{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},{"v":0.2,"d":"0.2000"}]
[null,6,{"v":7,"d":"7.00"},{"v":7,"d":"7.00"},{"v":5,"d":"5.00"},{"v":0.15,"d":"0.1500"}]
[null,7,{"v":12,"d":"12.00"},{"v":3,"d":"3.00"},{"v":10,"d":"10.00"},{"v":0.1,"d":"0.1000"}]
[null,8,{"v":12,"d":"12.00"},{"v":5,"d":"5.00"},{"v":7,"d":"7.00"},{"v":0.1,"d":"0.1000"}]
[null,9,{"v":12,"d":"12.00"},{"v":7,"d":"7.00"},{"v":5,"d":"5.00"},{"v":0.05,"d":"0.0500"}]
[]
[null,null,"quote"]
[null,null,"titolo 1","titolo 2","titolo 3",null,"somma quote"]
[null,null,{"v":0.8331323774951341,"d":"0.8331"},{"v":-0.6028710866135331,"d":"-0.6029"},{"v":0.7697387091183988,"d":"0.7697"},null,{"$f":"+E20+D20+C20","v":{"v":0.9999999999999999,"d":"1.0000"}}]
[]
[null,null,"Costruzione del rendimento atteso e della varianza"]
[]
[null,1,{"$f":"+$C$20*C8+$D$20*D8+$E$20*E8","v":{"v":10.054435718819061,"d":"10.05"}},{"$f":"+C24*F8","v":{"v":1.0054435718819061,"d":"1.0054"}},null,{"$f":"+(C24-$G$34)^2*F8","v":{"v":0.11118346755475,"d":"0.1112"}}]
[null,2,{"$f":"+$C$20*C9+$D$20*D9+$E$20*E9","v":{"v":8.848693545591994,"d":"8.85"}},{"v":1.327304031838799,"d":"1.3273"},null,{"$f":"+(C25-$G$34)^2*F9","v":{"v":0.003434046677901111,"d":"0.0034"}}]
[null,3,{"v":5.333735245009731,"d":"5.33"},{"v":0.26668676225048654,"d":"0.2667"},null,{"v":0.672074864348624,"d":"0.6721"}]
[null,4,{"v":9.411484346454131,"d":"9.41"},{"v":0.9411484346454131,"d":"0.9411"},null,{"v":0.016931936364062494,"d":"0.0169"}]
[null,5,{"v":6.666264754990268,"d":"6.67"},{"v":1.3332529509980535,"d":"1.3333"},null,{"v":1.0892640429980547,"d":"1.0893"}]
[null,6,{"v":5.460522581763202,"d":"5.46"},{"v":0.8190783872644803,"d":"0.8191"},null,{"v":1.8791850639518481,"d":"1.8792"}]
[null,7,{"v":15.886362361284998,"d":"15.89"},{"v":1.5886362361285,"d":"1.5886"},null,{"v":4.742198650839653,"d":"4.7422"}]
[null,8,{"v":12.371404060702735,"d":"12.37"},{"v":1.2371404060702735,"d":"1.2371"},null,{"v":1.1366365309911524,"d":"1.1366"}]
[null,9,{"v":9.626184469238872,"d":"9.63"},{"v":0.4813092234619436,"d":"0.4813"},null,{"v":0.019605349191519746,"d":"0.0196"}]
[]
[null,null,"Rendimento atteso del portafoglio",{"$nulls":3},{"$f":"SUM(D24:D32)","v":{"v":9.000000004539855,"d":"9.0000"}},"pari a ",{"v":9,"d":"9.0000"}]
[null,null,"Varianza del portafoglio",{"$nulls":3},{"$f":"SUM(F24:F32)","v":{"v":9.670513952917567,"d":"9.6705"}}]
[]
[null,null,"Partial moment"]
[null,null,"Ordine LPM",null,2]
[null,null,"Soglia eta",null,{"v":6.5,"d":"6.50"}]
[]
[null,null,"Costruzione del LPM"]
[]
[null,1,{"$f":"ABS(MIN(C24-$E$39,0))^$E$38*F8","v":{"v":0,"d":"0.0000"}}]
[null,2,{"$f":"ABS(MIN(C25-$E$39,0))^$E$38*F9","v":{"v":0,"d":"0.0000"}}]
[null,3,{"v":0.06800867393662566,"d":"0.0680"}]
[null,4,{"v":0,"d":"0.0000"}]
[null,5,{"v":0,"d":"0.0000"}]
[null,6,{"v":0.1620769954536358,"d":"0.1621"}]
[null,7,{"v":0,"d":"0.0000"}]
[null,8,{"v":0,"d":"0.0000"}]
[null,9,{"v":0,"d":"0.0000"}]
[]
[null,null,"LPM",null,{"$f":"SUM(C43:C51)","v":{"v":0.23008566939026145,"d":"0.2301"}}]
{"$rows_empty":9}
[null,null,"La frontiera efficiente"]
[null,null,"minimizzazione del LPM"]
[{"$nulls":6},"Quote"]
[null,"E(Rp)","Soglia","Varianza","LPM(6,50%,2)","titolo 1","titolo 2","titolo 3"]
[]
[null,{"v":7,"d":"7.0000"},{"v":6.5,"d":"6.5000"},{"v":1.7701220258515535,"d":"1.7701"},{"v":0.0829657783275532,"d":"0.0830"},{"v":0.49337012024563315,"d":"0.4934"},{"v":0.1903608708289025,"d":"0.1904"},{"v":0.3162690089254645,"d":"0.3163"}]
[null,{"v":7.5,"d":"7.5000"},{"v":6.5,"d":"6.5000"},{"v":3.447589089800597,"d":"3.4476"},{"v":0.0430215904780203,"d":"0.0430"},{"v":0.6859856515021239,"d":"0.6860"},{"v":0.010380535887647523,"d":"0.0104"},{"v":0.30363381261022876,"d":"0.3036"}]
[null,{"v":8,"d":"8.0000"},{"v":6.5,"d":"6.5000"},{"v":5.0955199177731485,"d":"5.0955"},{"v":0.07083924195379844,"d":"0.0708"},{"v":0.7837203182583217,"d":"0.7837"},{"v":-0.18574973607740483,"d":"-0.1857"},{"v":0.4020294178190832,"d":"0.4020"}]
[null,{"v":8.5,"d":"8.5000"},{"v":6.5,"d":"6.5000"},{"v":7.577235079103777,"d":"7.5772"},{"v":0.11497252763809543,"d":"0.1150"},{"v":0.9299448768527725,"d":"0.9299"},{"v":-0.3736264046521864,"d":"-0.3736"},{"v":0.44368152779941394,"d":"0.4437"}]
[null,{"v":9,"d":"9.0000"},{"v":6.5,"d":"6.5000"},{"v":10.601843438709524,"d":"10.6018"},{"v":0.16974034050603612,"d":"0.1697"},{"v":1.0761695845381762,"d":"1.0762"},{"v":-0.5615030501525371,"d":"-0.5615"},{"v":0.4853334656143607,"d":"0.4853"}]
[]
[]
[]
[]
[null,null,"La frontiera efficiente"]
[null,null,"minimizzazione della Varianza"]
[{"$nulls":6},"Quote"]
[null,"E(Rp)","Soglia","Varianza","LPM(6,50%,2)","titolo 1","titolo 2","titolo 3"]
[]
[null,{"v":7,"d":"7.000"},{"v":6.5,"d":"6.500"},{"v":1.45035881313136,"d":"1.4504"},{"v":0.1646795548666056,"d":"0.1647"},{"v":0.35096181299086887,"d":"0.3510"},{"v":0.1661211749992797,"d":"0.1661"},{"v":0.48291701200985143,"d":"0.4829"}]
[null,{"v":7.5,"d":"7.500"},{"v":6.5,"d":"6.500"},{"v":2.7222581393620167,"d":"2.7223"},{"v":0.12753755621496082,"d":"0.1275"},{"v":0.4715044575416675,"d":"0.4715"},{"v":-0.02612690480491931,"d":"-0.0261"},{"v":0.5546224472632519,"d":"0.5546"}]
[null,{"v":8,"d":"8.000"},{"v":6.5,"d":"6.500"},{"v":4.516250377545164,"d":"4.5163"},{"v":0.12833213424641243,"d":"0.1283"},{"v":0.5920471014854771,"d":"0.5920"},{"v":-0.21837496338113252,"d":"-0.2184"},{"v":0.6263278618956554,"d":"0.6263"}]
[null,{"v":8.5,"d":"8.500"},{"v":6.5,"d":"6.500"},{"v":6.832335653603457,"d":"6.8323"},{"v":0.16435777069485477,"d":"0.1644"},{"v":0.7125897400052216,"d":"0.7126"},{"v":-0.4106230249096874,"d":"-0.4106"},{"v":0.6980332849044658,"d":"0.6980"}]
[null,{"v":9,"d":"9.000"},{"v":6.5,"d":"6.500"},{"v":9.670513982474068,"d":"9.6705"},{"v":0.23008566939026145,"d":"0.2301"},{"v":0.8331323813435813,"d":"0.8331"},{"v":-0.6028710879875715,"d":"-0.6029"},{"v":0.7697387066439904,"d":"0.7697"}]

{"sheet":"Grafico 1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Grafico 2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}