{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Carteira","Vetor Mapeado"],"not_rendered":{"macros":1,"external_links":3,"defined_names":8},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Carteira","index":0,"n_rows":49,"n_cols":9,"rows_kept":49,"merged":[[3,0,3,2],[5,0,5,6]],"flags":["formulas_cached_only"]}
[]
["Cálculo de Valor-em-Risco de uma Carteira de Ações"]
[]
["Grau de Confiança",null,null,{"v":0.95,"d":"95%"}]
[]
["Carteira",{"$nulls":7},"Valor da Carteira"]
[null,"Ação","Quantidade","Preço","Valor Posição","Volatilidade","Valor-em-Risco",null,{"v":3231180,"d":"3,231,180.00"}]
[null,"ACES4",150000,1.38,{"v":206999.99999999997,"d":"207,000.00"},{"v":0.4800330912363985,"d":"48.00%"},{"v":10295.99547638858,"d":"10,296.00"},null,"Valor-em-Risco Exato"]
[null,"PETR4",4000,57.2,{"v":228800,"d":"228,800.00"},{"v":0.34831882893557936,"d":"34.83%"},{"v":8257.713151434666,"d":"8,257.71"},null,{"v":96050.68792577516,"d":"96,050.69"}]
[null,"VALE5",10000,52.4,{"v":524000,"d":"524,000.00"},{"v":0.3746196089404807,"d":"37.46%"},{"v":20339.89066781656,"d":"20,339.89"},null,"VaR percentual"]
[null,"BESP4",5000,55.2,{"v":276000,"d":"276,000.00"},{"v":0.39262270175304453,"d":"39.26%"},{"v":11228.230261556579,"d":"11,228.23"},null,{"v":0.029726195360758347,"d":"2.97%"}]
[null,"BBAS4",30000,9.2,{"v":276000,"d":"276,000.00"},{"v":0.48486801445968764,"d":"48.49%"},{"v":13866.263179660627,"d":"13,866.26"}]
[null,"CMIG3",10000,23,{"v":230000,"d":"230,000.00"},{"v":0.4553797971307396,"d":"45.54%"},{"v":10852.465560055154,"d":"10,852.47"}]
[null,"DURA4",5000,57.8,{"v":289000,"d":"289,000.00"},{"v":0.39795936249624214,"d":"39.80%"},{"v":11916.902613065824,"d":"11,916.90"}]
[null,"ELET6",10000,41.6,{"v":416000,"d":"416,000.00"},{"v":0.4320213335730468,"d":"43.20%"},{"v":18621.958084929203,"d":"18,621.96"}]
[null,"CLSC6",150000,0.68,{"v":102000.00000000001,"d":"102,000.00"},{"v":0.48086197968539685,"d":"48.09%"},{"v":5082.149458050897,"d":"5,082.15"}]
[null,"PETR3",5000,54.4,{"v":272000,"d":"272,000.00"},{"v":0.4409519670716638,"d":"44.10%"},{"v":12427.592643504579,"d":"12,427.59"}]
[null,"TSPP4",3000,33.11,{"v":99330,"d":"99,330.00"},{"v":0.6905160705368524,"d":"69.05%"},{"v":7106.913784082748,"d":"7,106.91"}]
[null,"USIM5",15000,9.07,{"v":136050,"d":"136,050.00"},{"v":0.4502202273803986,"d":"45.02%"},{"v":6346.735070352237,"d":"6,346.74"}]
[null,"VCPA4",2500,70,{"v":175000,"d":"175,000.00"},{"v":0.42938974716660533,"d":"42.94%"},{"v":7786.038376120854,"d":"7,786.04"}]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]
[{"$nulls":3},"","","",""]

{"sheet":"Vetor Mapeado","index":1,"n_rows":58,"n_cols":6,"rows_kept":58,"flags":["formulas_cached_only"]}
["Ações","Preços","Volatilidades","Betas","VaR","Mapeamento"]
["IBOVESPA",{"v":17279,"d":"17279.00"},{"v":0.3109616230268862,"d":"31.10%"},{"v":1,"d":"1.0000"},0,0]
["ACES4",1.38,{"v":0.4800330912363985,"d":"48.00%"},{"v":0.48661148879110905,"d":"0.4866"},{"v":10295.99547638858,"d":"10,296.00"},{"v":100728.57817975956,"d":"100,728.58"}]
["ARCZ6",3.54,{"v":0.3641721424814228,"d":"36.42%"},{"v":0.3141479238929741,"d":"0.3141"},0,0]
["BESP4",{"v":55.2,"d":"55.20"},{"v":0.39262270175304453,"d":"39.26%"},{"v":0.5246124804099613,"d":"0.5246"},{"v":11228.230261556579,"d":"11,228.23"},{"v":144793.04459314933,"d":"144,793.04"}]
["BBDC4",{"v":16,"d":"16.00"},{"v":0.3749299033378598,"d":"37.49%"},{"v":0.6245503010273306,"d":"0.6246"},0,0]
["BRHA4",{"v":1550,"d":"1550.00"},{"v":0.3486817665045273,"d":"34.87%"},{"v":0.3198407941920957,"d":"0.3198"},0,0]
["BBAS3",{"v":6.4,"d":"6.40"},{"v":0.43263869881633515,"d":"43.26%"},{"v":0.3829653216149437,"d":"0.3830"},0,0]
["BBAS4",{"v":9.2,"d":"9.20"},{"v":0.48486801445968764,"d":"48.49%"},{"v":0.5294235908667246,"d":"0.5294"},{"v":13866.263179660627,"d":"13,866.26"},{"v":146120.911079216,"d":"146,120.91"}]
["CLSC6",0.68,{"v":0.48086197968539685,"d":"48.09%"},{"v":0.65973793418021,"d":"0.6597"},{"v":5082.149458050897,"d":"5,082.15"},{"v":67293.26928638143,"d":"67,293.27"}]
["CMIG3",{"v":23,"d":"23.00"},{"v":0.4553797971307396,"d":"45.54%"},{"v":0.5010540060966073,"d":"0.5011"},{"v":10852.465560055154,"d":"10,852.47"},{"v":115242.42140221968,"d":"115,242.42"}]
["CMIG4",33.13,{"v":0.44277602570048546,"d":"44.28%"},{"v":0.6558069892157331,"d":"0.6558"},0,0]
["CESP4",13.28,{"v":0.6112888790695833,"d":"61.13%"},{"v":1.0437650455846628,"d":"1.0438"},0,0]
["CPLE6",17.29,{"v":0.4367487642690597,"d":"43.67%"},{"v":0.5434684931786506,"d":"0.5435"},0,0]
["CPNE5",{"v":719,"d":"719.00"},{"v":0.40999312518940534,"d":"41.00%"},{"v":0.3869312361077642,"d":"0.3869"},0,0]
["CPSL3",{"v":87,"d":"87.00"},{"v":0.6800886198404004,"d":"68.01%"},{"v":0.32234506713784983,"d":"0.3223"},0,0]
["DURA4",{"v":57.8,"d":"57.80"},{"v":0.39795936249624214,"d":"39.80%"},{"v":0.30967634949983064,"d":"0.3097"},{"v":11916.902613065824,"d":"11,916.90"},{"v":89496.46500545106,"d":"89,496.47"}]
["ELET3",{"v":39.1,"d":"39.10"},{"v":0.42488755933102146,"d":"42.49%"},{"v":0.6186466053112042,"d":"0.6186"},0,0]
["ELET6",{"v":41.6,"d":"41.60"},{"v":0.4320213335730468,"d":"43.20%"},{"v":0.6924370857982692,"d":"0.6924"},{"v":18621.958084929203,"d":"18,621.96"},{"v":288053.82769208,"d":"288,053.83"}]
["ELPL4",{"v":125.5,"d":"125.50"},{"v":0.5201895663463578,"d":"52.02%"},{"v":0.48870839173285824,"d":"0.4887"},0,0]
["EMBR3",11.25,{"v":0.47701697784576874,"d":"47.70%"},{"v":0.5212057274720848,"d":"0.5212"},0,0]
["EMBR4",10.79,{"v":0.47986607423692546,"d":"47.99%"},{"v":0.35244720106889027,"d":"0.3524"},0,0]
["EBTP3",{"v":35.6,"d":"35.60"},{"v":0.5711917049825803,"d":"57.12%"},{"v":0.8915502654455634,"d":"0.8916"},0,0]
["EBTP4",43.95,{"v":0.5957938401504173,"d":"59.58%"},{"v":0.8172470127095764,"d":"0.8172"},0,0]
["GETI4",{"v":11.4,"d":"11.40"},{"v":0.28980180019119206,"d":"28.98%"},{"v":0.5954353928685292,"d":"0.5954"},0,0]
["GRSU3",2.24,{"v":0.5208559013492915,"d":"52.09%"},{"v":0.40017253993546376,"d":"0.4002"},0,0]
["PLIM4",2.61,{"v":0.6131880812428504,"d":"61.32%"},{"v":0.9846822351655053,"d":"0.9847"},0,0]
["INEP4",{"v":4,"d":"4.00"},{"v":0.5990292096131572,"d":"59.90%"},{"v":0.872756258534505,"d":"0.8728"},0,0]
["PTIP4",{"v":18.8,"d":"18.80"},{"v":0.525962688563182,"d":"52.60%"},{"v":0.4222647373822837,"d":"0.4223"},0,0]
["ITAU4",157.28,{"v":0.4773580402678955,"d":"47.74%"},{"v":0.5878849193486914,"d":"0.5879"},0,0]
["ITSA4",1.82,{"v":0.35286956582595724,"d":"35.29%"},{"v":0.4983199306452399,"d":"0.4983"},0,0]
["KLAB4",1.57,{"v":0.3818030061716098,"d":"38.18%"},{"v":0.2895413016962106,"d":"0.2895"},0,0]
["LIGH3",{"v":213.6,"d":"213.60"},{"v":0.527607182334386,"d":"52.76%"},{"v":0.2784337888421509,"d":"0.2784"},0,0]
["PETR3",{"v":54.4,"d":"54.40"},{"v":0.4409519670716638,"d":"44.10%"},{"v":0.5144094935633392,"d":"0.5144"},{"v":12427.592643504579,"d":"12,427.59"},{"v":139919.38224922828,"d":"139,919.38"}]
["PETR4",{"v":57.2,"d":"57.20"},{"v":0.34831882893557936,"d":"34.83%"},{"v":0.4592133556835969,"d":"0.4592"},{"v":8257.713151434666,"d":"8,257.71"},{"v":105068.01578040697,"d":"105,068.02"}]
["BRDT4",25.52,{"v":0.4166147190181892,"d":"41.66%"},{"v":0.4708376986031656,"d":"0.4708"},0,0]
["SBSP3",{"v":143.2,"d":"143.20"},{"v":0.46181197458619233,"d":"46.18%"},{"v":0.5062185551272482,"d":"0.5062"},0,0]
["CSNA3",{"v":63,"d":"63.00"},{"v":0.5537489103876356,"d":"55.37%"},{"v":0.23604963560125714,"d":"0.2360"},0,0]
["CSTB4",{"v":23.9,"d":"23.90"},{"v":0.4512558590590696,"d":"45.13%"},{"v":0.5841032598180451,"d":"0.5841"},0,0]
["CRUZ3",{"v":10.6,"d":"10.60"},{"v":0.4686948042168986,"d":"46.87%"},{"v":0.47666625216033043,"d":"0.4767"},0,0]
["TCSL4",8.35,{"v":0.8112851752569451,"d":"81.13%"},{"v":0.8592614621026682,"d":"0.8593"},0,0]
["TCOC4",{"v":8,"d":"8.00"},{"v":0.6082645213358667,"d":"60.83%"},{"v":0.7826922367823322,"d":"0.7827"},0,0]
["TCSP3",{"v":18.9,"d":"18.90"},{"v":0.4837501964215676,"d":"48.38%"},{"v":0.7972008472313968,"d":"0.7972"},0,0]
["TCSP4",{"v":26.2,"d":"26.20"},{"v":0.4575840283107151,"d":"45.76%"},{"v":0.7584862519437501,"d":"0.7585"},0,0]
["TNEP4",6.65,{"v":0.7661231465773182,"d":"76.61%"},{"v":0.6897036319468619,"d":"0.6897"},0,0]
["TSEP4",{"v":9.9,"d":"9.90"},{"v":1.5918465981979375,"d":"159.18%"},{"v":0.6199473596090367,"d":"0.6199"},0,0]
["TNLP3",37.35,{"v":0.6044933249593136,"d":"60.45%"},{"v":0.7679472183737119,"d":"0.7679"},0,0]
["TNLP4",43.74,{"v":0.48068612711221037,"d":"48.07%"},{"v":0.8199555573728382,"d":"0.8200"},0,0]
["TEPR4",{"v":651,"d":"651.00"},{"v":0.46026348417131185,"d":"46.03%"},{"v":0.5171213456925908,"d":"0.5171"},0,0]
["TERJ4",{"v":48.7,"d":"48.70"},{"v":0.47748640790201646,"d":"47.75%"},{"v":0.6472989904106996,"d":"0.6473"},0,0]
["TLPP3",20.05,{"v":0.8359679905010261,"d":"83.60%"},{"v":0.588638754530363,"d":"0.5886"},0,0]
["TLPP4",{"v":29.3,"d":"29.30"},{"v":1.0852686511913745,"d":"108.53%"},{"v":0.6878171850773229,"d":"0.6878"},0,0]
["TSPP3",19.18,{"v":0.796077129756301,"d":"79.61%"},{"v":0.1649279436219408,"d":"0.1649"},0,0]
["TSPP4",33.11,{"v":0.6905160705368524,"d":"69.05%"},{"v":0.7379812842554506,"d":"0.7380"},{"v":7106.913784082748,"d":"7,106.91"},{"v":73303.68096509391,"d":"73,303.68"}]
["TRPL4",8.39,{"v":0.656949238106292,"d":"65.69%"},{"v":0.7298503774901013,"d":"0.7299"},0,0]
["USIM5",9.07,{"v":0.4502202273803986,"d":"45.02%"},{"v":0.600691119934,"d":"0.6007"},{"v":6346.735070352237,"d":"6,346.74"},{"v":81724.0268670207,"d":"81,724.03"}]
["VCPA4",{"v":70,"d":"70.00"},{"v":0.42938974716660533,"d":"42.94%"},{"v":0.515062163630312,"d":"0.5151"},{"v":7786.038376120854,"d":"7,786.04"},{"v":90135.8786353046,"d":"90,135.88"}]
["VALE5",{"v":52.4,"d":"52.40"},{"v":0.3746196089404807,"d":"37.46%"},{"v":0.48969031103928895,"d":"0.4897"},{"v":20339.89066781656,"d":"20,339.89"},{"v":256597.72298458742,"d":"256,597.72"}]