{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Riesgo-Retorno"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Riesgo-Retorno","index":0,"n_rows":196,"n_cols":16,"rows_kept":196,"cut":false,"hidden":false,"merged":[[6,7,6,10],[6,12,6,15]]}
[]
[null,"Período:",null,"12M","← Selecionar (D=dias; W=semanas; M=mes; Q=trimestre; Y=año)"]
[null,"Fecha:",null,{"$f":"IF(D4=\"\",_xll.ECONOMATICA(\"MERVAL\",\"DATE OF LAST QUOTE\"),D4)","v":"2020-04-30"},"← No modificar"]
[null,"Fecha:",null,"2020-04-30","← Digitar una fecha de preferencia en la celda C4."]
[]
[]
[null,null,null,null,null,null,null,"Títulos públicos",null,null,null,null,"Índice de Mercado y monedas"]
[null,null,null,null,null,null,null,{"$f":"_xll.ECOSECURITIES(\"GOVERNMENTBOND\",\"active\",,\"arg\",\"xbue\",,\"codigo_economatica\")","v":"codigo_economatica"},{"$f":"_xll.ECONOMATICA($H$9:$H$500,\"Ticker\")","v":"Codigo"},{"$f":"_xll.ECONOMATICA($H$9:$H$202,\"return\",$D$2,$D$3,,,\"USD\",,\"false\",,\"Retorno de \"&$D$2,{\"tc.dft=false\";\"tc.tp=0\";\"tc.pers=40\";\"tc.per=0\"})","v":"Retorno de 12M"},{"$f":"_xll.ECONOMATICA($H$9:$H$202,\"volatility\",$D$2,$D$3,,,\"USD\",,\"false\",,\"Volatilidad de \"&D2,{\"tolper.mei=0.10000000149\"})","v":"Volatilidad de 12M"},null,"codigo_economatica",{"$f":"_xll.ECONOMATICA($M$9:$M$22,\"name\")","v":"Nombre"},{"$f":"_xll.ECONOMATICA($M$9:$M$22,\"return\",$D$2,$D$3,,,,,,,\"Retorno de \"&$D$2)","v":"Retorno de 12M"},{"$f":"_xll.ECONOMATICA($M$9:$M$22,\"volatility\",$D$2,$D$3,,,,,,,\"Volatilidad de \"&$D$2)","v":"Volatilidad de 12M"}]
[null,null,null,null,null,null,null,"AF20<XBUE>","AF20",7.7947989284439201,70.970084820408402,null,"MERVAL<XBUE>","S&P Merval",10.7248364633124,72.9141525756568]
[null,null,null,null,null,null,null,"AF20D<XBUE>","AF20D",-31.843526385288001,65.324987974367104,null,"BOLSA<XBUE>","S&P/Byma Indice General",7.4021151684064499,71.244110736646704]
[null,null,null,null,null,null,null,"AF20C<XBUE>","AF20C",null,null,null,"SBDC<XBUE>","Subindice-Bonos En Dólares-Corto",0.12734683423332199,58.636039191158503]
[null,null,null,null,null,null,null,"CO26<XBUE>","CO26",23.140078630414799,56.000426317681601,null,"SBDL<XBUE>","Subindice-Bonos En Dólares-Largo",18.936711344576899,46.761795106343897]
[null,null,null,null,null,null,null,"CO26D<XBUE>","CO26D",-18.2745855742833,49.697393561073099,null,"SBPC<XBUE>","Subindice-Bonos En Pesos-Corto",118.919847939862,43.921701535116902]
[null,null,null,null,null,null,null,"BDC22<XBUE>","BDC22",6.4686072500990104,41.3541290062713,null,"SBPL<XBUE>","Subindice-Bonos En Pesos-Largo",79.648774091037893,60.669107630790698]
[null,null,null,null,null,null,null,"BDC24<XBUE>","BDC24",11.127183473217899,34.9849973546225,null,"IAMC<XBUE>","Indice de Bonos Iamc",37.517068331362701]
[null,null,null,null,null,null,null,"BDC28<XBUE>","BDC28",8.4871316818025697,null,null,"DCL<ArgNa>","Dolar Contado Con Liquidación",158.337088778615,38.320822301146102]
[null,null,null,null,null,null,null,"PR15<XBUE>","PR15",44.707913237274603,39.047190415964003,null,"DL<ArgNa>","Dolar Informal Venta",156.52173913037399,35.673601398011698]
[null,null,null,null,null,null,null,"PR15X<XBUE>","PR15X",null,null,null,"DLBDIA<ArgNa>","Dolar Oficial Venta",52.469135802704798,25.231825196387899]
[null,null,null,null,null,null,null,"PR15C<XBUE>","PR15C",null,null,null,"EURO PESOS<ArgNa>","Euro Divisa Bna Vendedor",47.727029844478203,25.0326943729888]
[null,null,null,null,null,null,null,"PR13<XBUE>","PR13",56.847884252609198,40.6195402086014,null,"REALV<ArgNa>","Real Billete Bna Vendedor",11.864406779568499,25.770669082994601]
[null,null,null,null,null,null,null,"PR13C<XBUE>","PR13C",null,null,null,"UVA<ArgNa>","Unidad de Valor Adquisitivo (Uva)",49.491812535445199,1.84425323755204]
[null,null,null,null,null,null,null,"PR13X<XBUE>","PR13X",null,null,null,"UVI<ArgNa>","Unidad de Vivienda Uvi",47.2781954886159,2.3727886663618798]
[null,null,null,null,null,null,null,"AA22C<XBUE>","AA22C"]
[null,null,null,null,null,null,null,"AA22<XBUE>","AA22",3.0366255215994902,38.372871550207499]
[null,null,null,null,null,null,null,"AA22D<XBUE>","AA22D"]
[null,null,null,null,null,null,null,"AM20X<XBUE>","AM20X"]
[null,null,null,null,null,null,null,"AM20C<XBUE>","AM20C"]
[null,null,null,null,null,null,null,"AM20<XBUE>","AM20",null,16.3935761522735]
[null,null,null,null,null,null,null,"AM20D<XBUE>","AM20D"]
[null,null,null,null,null,null,null,"AM20Z<XBUE>","AM20Z"]
[null,null,null,null,null,null,null,"AA25D<XBUE>","AA25D",-59.301044956722798,55.839049249771101]
[null,null,null,null,null,null,null,"AA25C<XBUE>","AA25C",-61.735025760659497]
[null,null,null,null,null,null,null,"AA25<XBUE>","AA25",-33.882195048383402,57.184050040435999]
[null,null,null,null,null,null,null,"AA37<XBUE>","AA37",-33.8780453542131,59.443024748005001]
[null,null,null,null,null,null,null,"AA37D<XBUE>","AA37D",-60.654554366832599,53.209480240533601]
[null,null,null,null,null,null,null,"AA37C<XBUE>","AA37C",-60.431592862994897]
[null,null,null,null,null,null,null,"AO20<XBUE>","AO20",-44.755784234730498,56.344561769336003]
[null,null,null,null,null,null,null,"AO20C<XBUE>","AO20C",-66.217421742156105,57.925507560430603]
[null,null,null,null,null,null,null,"AO20D<XBUE>","AO20D",-66.657667315914296,51.831693889456801]
[null,null,null,null,null,null,null,"AO20X<XBUE>","AO20X"]
[null,null,null,null,null,null,null,"A2M2X<XBUE>","A2M2X"]
[null,null,null,null,null,null,null,"A2M2<XBUE>","A2M2",null,22.852544125314999]
[null,null,null,null,null,null,null,"BP28<XBUE>","BP28"]
[null,null,null,null,null,null,null,"PBY22<XBUE>","PBY22",58.700492077157797,34.496220192231704]
[null,null,null,null,null,null,null,"PBA25<XBUE>","PBA25",18.266486646840299,47.960336270159999]
[null,null,null,null,null,null,null,"PBF23<XBUE>","PBF23",-30.467576628230699]
[null,null,null,null,null,null,null,"PBM24<XBUE>","PBM24"]
[null,null,null,null,null,null,null,"FORM3<XBUE>","FORM3",-15.958547841190001]
[null,null,null,null,null,null,null,"TJ20<XBUE>","TJ20",70.2379719418241,43.944324256619403]
[null,null,null,null,null,null,null,"TJ20C<XBUE>","TJ20C"]
[null,null,null,null,null,null,null,"TJ20D<XBUE>","TJ20D"]
[null,null,null,null,null,null,null,"TJ20X<XBUE>","TJ20X"]
[null,null,null,null,null,null,null,"TJ20Z<XBUE>","TJ20Z",null,98.261588707333402]
[null,null,null,null,null,null,null,"TN20<XBUE>","TN20"]
[null,null,null,null,null,null,null,"TO21C<XBUE>","TO21C"]
[null,null,null,null,null,null,null,"TO21X<XBUE>","TO21X"]
[null,null,null,null,null,null,null,"TO21Z<XBUE>","TO21Z"]
[null,null,null,null,null,null,null,"TO21<XBUE>","TO21",-22.037870031461399,68.142364805447897]
[null,null,null,null,null,null,null,"TO23<XBUE>","TO23"]
[null,null,null,null,null,null,null,"TO23Z<XBUE>","TO23Z"]
[null,null,null,null,null,null,null,"TO23X<XBUE>","TO23X"]
[null,null,null,null,null,null,null,"TO26X<XBUE>","TO26X"]
[null,null,null,null,null,null,null,"TO26<XBUE>","TO26",-32.1462680838304]
[null,null,null,null,null,null,null,"TO26Z<XBUE>","TO26Z"]
[null,null,null,null,null,null,null,"TO26C<XBUE>","TO26C"]
[null,null,null,null,null,null,null,"TC21Y<XBUE>","TC21Y"]
[null,null,null,null,null,null,null,"TC21C<XBUE>","TC21C"]
[null,null,null,null,null,null,null,"TC21Z<XBUE>","TC21Z"]
[null,null,null,null,null,null,null,"TC21X<XBUE>","TC21X",10.6848417621222]
[null,null,null,null,null,null,null,"TC21D<XBUE>","TC21D"]
[null,null,null,null,null,null,null,"TC21<XBUE>","TC21",33.970931823365397,45.299795383296399]
[null,null,null,null,null,null,null,"A2E3C<XBUE>","A2E3C"]
[null,null,null,null,null,null,null,"A2E3D<XBUE>","A2E3D",-55.817148950533003]
[null,null,null,null,null,null,null,"A2E3<XBUE>","A2E3",-31.824724426580399]
[null,null,null,null,null,null,null,"A2E2C<XBUE>","A2E2C",-60.972497619048198]
[null,null,null,null,null,null,null,"A2E2<XBUE>","A2E2",-34.963932651211501,50.285826112376498]
[null,null,null,null,null,null,null,"A2E2D<XBUE>","A2E2D",-59.792655588418697,52.697505993186503]
[null,null,null,null,null,null,null,"A2E8<XBUE>","A2E8",-29.437880873854699]
[null,null,null,null,null,null,null,"A2E8D<XBUE>","A2E8D",-55.7991719237179]
[null,null,null,null,null,null,null,"A2E8C<XBUE>","A2E8C",-61.046502167126199]
[null,null,null,null,null,null,null,"AA21D<XBUE>","AA21D"]
[null,null,null,null,null,null,null,"AA21X<XBUE>","AA21X"]
[null,null,null,null,null,null,null,"AA21Z<XBUE>","AA21Z"]
[null,null,null,null,null,null,null,"AA21C<XBUE>","AA21C"]
[null,null,null,null,null,null,null,"AA21<XBUE>","AA21"]
[null,null,null,null,null,null,null,"A2E7D<XBUE>","A2E7D",-57.387173215625801,53.922495468985304]
[null,null,null,null,null,null,null,"A2E7C<XBUE>","A2E7C",-60.715529065229902]
[null,null,null,null,null,null,null,"A2E7<XBUE>","A2E7",-31.0955551272782,58.578647296468297]
[null,null,null,null,null,null,null,"AE48<XBUE>","AE48",-39.100776354374801]
[null,null,null,null,null,null,null,"AE48C<XBUE>","AE48C"]
[null,null,null,null,null,null,null,"AE48D<XBUE>","AE48D",-56.744420368690001]
[null,null,null,null,null,null,null,"AC17<XBUE>","AC17",-29.750695696217001,58.045354324276602]
[null,null,null,null,null,null,null,"AC17C<XBUE>","AC17C",-60.925325671443701,63.619750862126203]
[null,null,null,null,null,null,null,"AC17D<XBUE>","AC17D",-57.395590413769199,45.791087751567801]
[null,null,null,null,null,null,null,"AA26X<XBUE>","AA26X"]
[null,null,null,null,null,null,null,"AA26<XBUE>","AA26"]
[null,null,null,null,null,null,null,"AA26C<XBUE>","AA26C"]
[null,null,null,null,null,null,null,"AA26D<XBUE>","AA26D",-62.242839854850899]
[null,null,null,null,null,null,null,"AA46C<XBUE>","AA46C"]
[null,null,null,null,null,null,null,"AA46X<XBUE>","AA46X"]
[null,null,null,null,null,null,null,"AA46Z<XBUE>","AA46Z"]
[null,null,null,null,null,null,null,"AA46D<XBUE>","AA46D",-54.310389325488401]
[null,null,null,null,null,null,null,"AA46<XBUE>","AA46"]
[null,null,null,null,null,null,null,"BPLE<XBUE>","BPLE",-33.137207890627899]
[null,null,null,null,null,null,null,"BPLED<XBUE>","BPLED"]
[null,null,null,null,null,null,null,"BPMDD<XBUE>","BPMDD"]
[null,null,null,null,null,null,null,"BPMD<XBUE>","BPMD",6.13532102725003]
[null,null,null,null,null,null,null,"PUM21<XBUE>","PUM21",48.830799582006897,66.074417659081504]
[null,null,null,null,null,null,null,"TX21<XBUE>","TX21",null,61.408792927337302]
[null,null,null,null,null,null,null,"TX21D<XBUE>","TX21D"]
[null,null,null,null,null,null,null,"TC20Z<XBUE>","TC20Z",null,34.6094750007614]
[null,null,null,null,null,null,null,"TC20<XBUE>","TC20",20.758568233955899,44.435068220424]
[null,null,null,null,null,null,null,"TC20X<XBUE>","TC20X",9.7877286309085303,23.584192034497399]
[null,null,null,null,null,null,null,"TC23<XBUE>","TC23",17.016219773358898]
[null,null,null,null,null,null,null,"TC25P<XBUE>","TC25P",-22.4099336171057]
[null,null,null,null,null,null,null,"TVPY<XBUE>","TVPY",-45.344129554752698,42.759516055521097]
[null,null,null,null,null,null,null,"TVPYX<XBUE>","TVPYX"]
[null,null,null,null,null,null,null,"TVPYC<XBUE>","TVPYC"]
[null,null,null,null,null,null,null,"TVPYD<XBUE>","TVPYD",-64.642857142956899]
[null,null,null,null,null,null,null,"AY24<XBUE>","AY24",-31.1496906869288,47.357464665372397]
[null,null,null,null,null,null,null,"AY24Y<XBUE>","AY24Y",-73.335074431961402]
[null,null,null,null,null,null,null,"AY24D<XBUE>","AY24D",-56.684033156605402,48.9035109314718]
[null,null,null,null,null,null,null,"AY24Z<XBUE>","AY24Z"]
[null,null,null,null,null,null,null,"AY24X<XBUE>","AY24X"]
[null,null,null,null,null,null,null,"AY24C<XBUE>","AY24C",-60.1748300161562,46.674930361565202]
[null,null,null,null,null,null,null,"DIA0D<XBUE>","DIA0D",-57.238257584685897,44.1145840313402]
[null,null,null,null,null,null,null,"DIA0C<XBUE>","DIA0C"]
[null,null,null,null,null,null,null,"DIA0<XBUE>","DIA0",-31.130688170553199,47.204700341797398]
[null,null,null,null,null,null,null,"PAP0<XBUE>","PAP0"]
[null,null,null,null,null,null,null,"PAA0<XBUE>","PAA0",-9.8452599505399103,28.837998204981002]
[null,null,null,null,null,null,null,"PAA0C<XBUE>","PAA0C"]
[null,null,null,null,null,null,null,"PAA0D<XBUE>","PAA0D",-48.578559584275403]
[null,null,null,null,null,null,null,"NO20<XBUE>","NO20",29.286572803714101]
[null,null,null,null,null,null,null,"PAY0D<XBUE>","PAY0D",-40.181938035588203]
[null,null,null,null,null,null,null,"PAY0<XBUE>","PAY0",-1.1979510361925301]
[null,null,null,null,null,null,null,"BPLD<XBUE>","BPLD",-1.7201974282215799,53.386477829771998]
[null,null,null,null,null,null,null,"BPLDD<XBUE>","BPLDD",-37.254901960725,58.907200945424798]
[null,null,null,null,null,null,null,"BPLDC<XBUE>","BPLDC",-48.556998557003702]
[null,null,null,null,null,null,null,"TD21<XBUE>","TD21"]
[null,null,null,null,null,null,null,"TX23<XBUE>","TX23"]
[null,null,null,null,null,null,null,"TX23D<XBUE>","TX23D"]
[null,null,null,null,null,null,null,"CUAPX<XBUE>","CUAPX"]
[null,null,null,null,null,null,null,"CUAP<XBUE>","CUAP",26.702511674025999,33.758785302401499]
[null,null,null,null,null,null,null,"TVPPC<XBUE>","TVPPC"]
[null,null,null,null,null,null,null,"TVPPD<XBUE>","TVPPD"]
[null,null,null,null,null,null,null,"TVPPX<XBUE>","TVPPX"]
[null,null,null,null,null,null,null,"TVPP<XBUE>","TVPP",-37.249151985975899,86.481810152297797]
[null,null,null,null,null,null,null,"TVPAC<XBUE>","TVPAC"]
[null,null,null,null,null,null,null,"TVPAX<XBUE>","TVPAX"]
[null,null,null,null,null,null,null,"TVPAD<XBUE>","TVPAD",-73.333333333372096]
[null,null,null,null,null,null,null,"TVPA<XBUE>","TVPA",-55.182186234916998,50.839391603716599]
[null,null,null,null,null,null,null,"DIP0<XBUE>","DIP0",-31.0212114527531]
[null,null,null,null,null,null,null,"DICPY<XBUE>","DICPY"]
[null,null,null,null,null,null,null,"DICPZ<XBUE>","DICPZ"]
[null,null,null,null,null,null,null,"DICPX<XBUE>","DICPX"]
[null,null,null,null,null,null,null,"DICPC<XBUE>","DICPC",-40.847458649834202]
[null,null,null,null,null,null,null,"DICPD<XBUE>","DICPD",-39.706024113984299]
[null,null,null,null,null,null,null,"DICP<XBUE>","DICP",21.044000014080702,47.2361150617362]
[null,null,null,null,null,null,null,"DIY0<XBUE>","DIY0",-19.644237050117201]
[null,null,null,null,null,null,null,"DIY0D<XBUE>","DIY0D",-53.9823067940888]
[null,null,null,null,null,null,null,"DIY0X<XBUE>","DIY0X"]
[null,null,null,null,null,null,null,"DICAX<XBUE>","DICAX"]
[null,null,null,null,null,null,null,"DICAC<XBUE>","DICAC",-58.379813109815601,51.8508547222009]
[null,null,null,null,null,null,null,"DICAY<XBUE>","DICAY"]
[null,null,null,null,null,null,null,"DICAD<XBUE>","DICAD",-58.111345124896602,47.3724900257657]
[null,null,null,null,null,null,null,"DICA<XBUE>","DICA",-32.144308036891701,51.725883798440897]
[null,null,null,null,null,null,null,"DICAZ<XBUE>","DICAZ"]
[null,null,null,null,null,null,null,"DICY<XBUE>","DICY",-13.553077304284701,37.3121749922866]
[null,null,null,null,null,null,null,"DICYD<XBUE>","DICYD",-47.385378908598803,42.183512230054497]
[null,null,null,null,null,null,null,"DICYC<XBUE>","DICYC",-42.448945026786497,47.1205769724329]
[null,null,null,null,null,null,null,"DICYZ<XBUE>","DICYZ"]
[null,null,null,null,null,null,null,"DICYX<XBUE>","DICYX"]
[null,null,null,null,null,null,null,"DICYY<XBUE>","DICYY"]
[null,null,null,null,null,null,null,"PARPC<XBUE>","PARPC"]
[null,null,null,null,null,null,null,"PARP<XBUE>","PARP",29.2912201021099,48.766386687930201]
[null,null,null,null,null,null,null,"PARPX<XBUE>","PARPX",-33.707102617365301]
[null,null,null,null,null,null,null,"PARPD<XBUE>","PARPD",0.99612617595994402]
[null,null,null,null,null,null,null,"PARYC<XBUE>","PARYC",-42.193507454183397,63.719143995549501]
[null,null,null,null,null,null,null,"PARYD<XBUE>","PARYD",-35.752008867100798,40.785984067828402]
[null,null,null,null,null,null,null,"PARYX<XBUE>","PARYX"]
[null,null,null,null,null,null,null,"PARY<XBUE>","PARY",12.632047987790401,53.647066164878197]
[null,null,null,null,null,null,null,"PARAD<XBUE>","PARAD",-43.097643097629799,59.725312747235897]
[null,null,null,null,null,null,null,"PARA<XBUE>","PARA",-0.19145028381899501,61.041345637815503]
[null,null,null,null,null,null,null,"PARAC<XBUE>","PARAC",-47.359404849354199]
[null,null,null,null,null,null,null,"PARAX<XBUE>","PARAX"]
[null,null,null,null,null,null,null,"PF23D<XBUE>","PF23D",-65.076562581350998,26.489252428058499]
[null,null,null,null,null,null,null,"PMJ21<XBUE>","PMJ21",28.701792069652601]
[null,null,null,null,null,null,null,"TVPED<XBUE>","TVPED"]
[null,null,null,null,null,null,null,"TVPEC<XBUE>","TVPEC"]
[null,null,null,null,null,null,null,"TVPEX<XBUE>","TVPEX"]
[null,null,null,null,null,null,null,"TVPE<XBUE>","TVPE",-54.588160638813903]
[null,null,null,null,null,null,null,"TX22D<XBUE>","TX22D"]
[null,null,null,null,null,null,null,"TX22<XBUE>","TX22",null,68.819657395593794]
[null,null,null,null,null,null,null,"TVY0C<XBUE>","TVY0C"]
[null,null,null,null,null,null,null,"TVY0D<XBUE>","TVY0D"]
[null,null,null,null,null,null,null,"TVY0<XBUE>","TVY0"]