{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Curvas","Feriados","DDI_Fra","Graficos CC","Spot","Arbitragem","Futuro","Futuro 2"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":1,"defined_names":4,"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":"Curvas","index":0,"n_rows":63,"n_cols":15,"rows_kept":63,"cut":false,"hidden":false,"merged":[[55,6,55,7],[57,6,57,7]]}
["Liq.","2014-09-11"]
["Venc","2015-01-02"]
["Libor",0.23,null,null,null,null,null,"Ticker","Data","DU","DI",null,"DC","FRA","DDI"]
["Prêmio",99.675385269219362,null,null,null,null,null,"v4","2014-10-01",{"$f":"NETWORKDAYS(Curvas!$B$1,I4,Feriados)-1","v":14},10.82,null,{"$f":"Curvas!I4-Curvas!B1","v":20},null,7.18]
["Dif. Libor",{"$f":"-(B3-B14)*100","v":80.753887691918536},null,null,null,null,null,"x4","2014-11-03",{"$f":"NETWORKDAYS(Curvas!$B$1,I5,Feriados)-1","v":37},10.82,null,{"$f":"Curvas!I5-Curvas!$I$4","v":33},0.71,3.15]
[null,null,null,null,null,null,null,"z4","2014-12-01",{"$f":"NETWORKDAYS(Curvas!$B$1,I6,Feriados)-1","v":57},10.82,null,{"$f":"Curvas!I6-Curvas!$I$4","v":61},0.74,2.33]
["DC",{"$f":"B2-$B$1","v":113},null,null,null,null,null,"f5","2015-01-02",{"$f":"NETWORKDAYS(Curvas!$B$1,I7,Feriados)-1","v":79},10.83,null,{"$f":"Curvas!I7-Curvas!$I$4","v":93},0.98,2.08]
["Dias 30/360",{"$f":"DAYS360($B$1,B2)","v":111},null,null,null,null,null,"j5","2015-04-01",{"$f":"NETWORKDAYS(Curvas!$B$1,I8,Feriados)-1","v":140},10.98,null,{"$f":"Curvas!I8-Curvas!$I$4","v":182},0.97,1.59]
["DU",{"$f":"NETWORKDAYS($B$1,B2,Tab_Fer)-1","v":79},null,null,null,null,null,"N5","2015-07-01",{"$f":"NETWORKDAYS(Curvas!$B$1,I9,Feriados)-1","v":201},11.14,null,{"$f":"Curvas!I9-Curvas!$I$4","v":273},1.1599999999999999,1.58]
[null,null,"Real",null,null,null,null,"v5","2015-10-01",{"$f":"NETWORKDAYS(Curvas!$B$1,I10,Feriados)-1","v":266},11.32,null,{"$f":"Curvas!I10-Curvas!$I$4","v":365},1.28,1.59]
["Curva Pré",{"$f":"ROUND(CURVAPRE(J4:J14,K4:K14,B9,100,35),2)","v":10.83},{"$f":"B59","v":13},null,null,null,null,"f6","2016-01-04",{"$f":"NETWORKDAYS(Curvas!$B$1,I11,Feriados)-1","v":329},11.48,null,{"$f":"Curvas!I11-Curvas!$I$4","v":460},1.41,1.66]
["DI-Curto",{"$f":"Curvas!K4","v":10.82},null,null,null,null,null,"f17","2017-01-02",{"$f":"NETWORKDAYS(Curvas!$B$1,I12,Feriados)-1","v":580},11.59,null,{"$f":"Curvas!I12-Curvas!$I$4","v":824},1.88,2.0099999999999998]
[]
["CC LIMPO",{"$f":"CupomCambial(B9,B7,B26,B28,J4:K12,M4:N12,B4)","v":1.0375388769191853}]
["C.sujo",{"$f":"CupomCambial(B9,B7,$B$29,B28,J4:K14,M4:N17,B4)","v":2.0468835016307776},null,null,null,null,null,"BACEN","US$","Di","Cupom Cambial","Pr. Libor"]
[null,null,null,null,null,null,null,"Tradicional","venda","compra","compra","vende"]
[null,null,null,null,null,null,null,"Reverso","compra","venda","venda","compra"]
["NDF",{"$f":"Futuro!J18","v":2.3583663750000001},"Real"]
["US$",{"$f":"DOLFUTURO($K$4,B11,B28,B25,J$4,B9,B7,$M$4)","v":2.3565527395354682},{"$f":"B60","v":2.5},null,null,null,null,"MERCADO","US$","Di","Cupom Cambial","Pr. Libor"]
["Var. Cambial",{"$f":"(B19/$B$26-1)*36000/B7","v":9.3346897934404289},null,null,null,null,null,"Tradicional","compra","venda","venda","compra"]
[null,null,null,null,null,null,null,"Reverso","venda","compra","compra","vende"]
[]
[]
["C. Curto",{"$f":"IF($F$27=0,0,(((1+$K$4/100)^($J$4/252))*B26/B28*1000-1)*36000/$M$4)","v":1.490261080399069},null,"PRÉ"]
["FRA",{"$f":"ROUND(CURVAFRA(M4:M12,N4:N12,B7,$K$4,36),3)","v":0.98},null,null,null,null,null,null,{"$f":"B9","v":79}]
["Spot",{"$f":"(B28-B27)/1000","v":2.2894700000000001}]
["Casado",11.2,null,null,null,{"$f":"Curvas!J4","v":14},{"$f":"B12","v":10.82},null,null,null,{"$f":"I25-F27","v":65},null,{"$f":"B11","v":10.83}]
["1o Futuro",2300.67]
["Ptax",2.2967]
[null,null,null,"CÂMBIO",null,null,null,null,{"$f":"B7","v":113},{"$f":"B8","v":111},"(30/360)"]
["CURVA",{"$f":"((B32/100+1)^(1/2)-1)*200","v":1.05730197662397},null,"Ptax"]
["TIR",{"$f":"((1+B14*B7/36000)^(360/B8)-1)*100","v":1.060096695298407},null,{"$f":"B29","v":2.2967},null,{"$f":"Curvas!M4","v":20},{"$f":"B28/1000","v":2.3006700000000002},null,null,null,{"$f":"I30-F32","v":93},null,null,{"$f":"B19","v":2.3565527395354682}]
["COTAÇÂO",{"$f":"100/(1+B32/100)^((B8)/360)","v":99.6753852538383},null,"Spot","casado",{"$f":"(G32-D34)*1000","v":11.200000000000099}]
[null,null,null,{"$f":"B26","v":2.2894700000000001}]
[]
[null,null,null,"fator",null,{"$f":"IF(F27=0,1,((1+G27/100)^(F27/252))*D34/G32)","v":1.0008279228224439},null,null,null,null,{"$f":"(K37/36000*K32)+1","v":1.0025316666666666}]
[null,null,null,"taxa",null,{"$f":"IF(F32=0,0,(F36-1)*36000/F32)","v":1.490261080399069},null,null,null,null,{"$f":"B25","v":0.98}]
[null,null,null,null,null,null,null,null,{"$f":"F36*K36","v":1.0033616855137226}]
[]
[null,null,null,null,null,"C. Limpo",null,null,{"$f":"(I38-1)*36000/I30","v":1.0709794556992427},{"$f":"I40*I30/36000+1","v":1.0033616855137226},{"$f":"100/J40","v":99.66495775528827},{"$f":"K40*10*D34/1.8","v":1267.6662823999991}]
[null,null,null,null,null,"C.Sujo",null,null,{"$f":"(I38*D32/D34-1)*36000/I30","v":2.0804296836223202},{"$f":"I41*I30/36000+1","v":1.0065302376180367},{"$f":"100/J41","v":99.351212971654917},{"$f":"K41*10*D32/1.8","v":1267.6662823999991}]
[null,null,null,null,null,"Nominal",null,null,{"$f":"((I43/100+1)^(1/2)-1)*200","v":1.0914150736985651},{"$f":"(I42/200+1)^(J30/180)","v":1.0033616855137226},{"$f":"100/J42","v":99.66495775528827},{"$f":"K42*10*D34/1.8","v":1267.6662823999991}]
[null,null,null,null,null,"Tir",null,null,{"$f":"((I40*I30/36000+1)^(360/J30)-1)*100","v":1.0943930408563007},{"$f":"(I43/100+1)^(J30/360)","v":1.0033616855137226},{"$f":"100/J43","v":99.66495775528827},{"$f":"K43*10*D34/1.8","v":1267.6662823999991}]
[null,null,"us$",1000000]
[null,"Fluxo de caixa"]
[null,null,null,null,null,null,"Resultado SWAP"]
[null,null,"Ativo","Passivo",null,null,null,"Hoje",null,"cupom","Var cambial"]
["HOJE",null,null,null,null,null,"Posição cambial",{"$f":"D44*B49","v":2289470},null,{"$f":"B4/B33","v":1.0000000001543115},{"$f":"B60/B49","v":1.0919557801587267},{"$f":"H48*J48*K48","v":2500000.000385779}]
["SPOT",{"$f":"B26","v":2.2894700000000001},null,{"$f":"B49*D44","v":2289470},null,null,null,null,"Var juros"]
[null,null,{"$f":"D49","v":2289470},null,null,null,"Posição juros",{"$f":"H48","v":2289470},{"$f":"(1+B59/100)^(A57/252)","v":1.0390577136482784},null,null,{"$f":"H50*I50","v":2378891.463666324}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L48-L50","v":121108.53671945492}]
[]
[]
[]
["PRAZO",null,null,null,null,null,"Resultado consolidado"]
[{"$f":"I25","v":79}]
["VENCIMENTO",null,null,null,null,null,{"$f":"D63+L52","v":3.8577895611524582E-4}]
["JUROS",13,{"$f":"C50*(1+B59/100)^(A57/252)","v":2378891.463666324}]
["FUTURO",2.5,null,{"$f":"D44*B60","v":2500000}]
[]
[]
["RESULTADO",null,null,{"$f":"C59-D60","v":-121108.53633367596}]

{"sheet":"Feriados","index":1,"n_rows":68,"n_cols":12,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["2003-01-01","2003-03-03","2003-03-04","2003-04-18","2003-04-21","2003-05-01","2003-06-19","2003-09-07","2003-10-12","2003-11-02","2003-11-15","2003-12-25"]
["2004-01-01","2004-02-23","2004-02-24","2004-04-09","2004-04-21","2004-05-01","2004-06-10","2004-09-07","2004-10-12","2004-11-02","2004-11-15","2004-12-25"]
["2005-01-01","2005-02-07","2005-02-08","2005-03-25","2005-04-21","2005-05-01","2005-05-26","2005-09-07","2005-10-12","2005-11-02","2005-11-15","2005-12-25"]
["2006-01-01","2006-02-27","2006-02-28","2006-04-14","2006-04-21","2006-05-01","2006-06-15","2006-09-07","2006-10-12","2006-11-02","2006-11-15","2006-12-25"]
["2007-01-01","2007-02-19","2007-02-20","2007-04-06","2007-04-21","2007-05-01","2007-06-07","2007-09-07","2007-10-12","2007-11-02","2007-11-15","2007-12-25"]
["2008-01-01","2008-02-04","2008-02-05","2008-03-21","2008-04-21","2008-05-01","2008-05-22","2008-09-07","2008-10-12","2008-11-02","2008-11-15","2008-12-25"]
["2009-01-01","2009-02-23","2009-02-24","2009-04-10","2009-04-21","2009-05-01","2009-06-11","2009-09-07","2009-10-12","2009-11-02","2009-11-15","2009-12-25"]
["2010-01-01","2010-02-15","2010-02-16","2010-04-02","2010-04-21","2010-05-01","2010-06-03","2010-09-07","2010-10-12","2010-11-02","2010-11-15","2010-12-25"]
["2011-01-01","2011-03-07","2011-03-08","2011-04-21","2011-04-22","2011-05-01","2011-06-23","2011-09-07","2011-10-12","2011-11-02","2011-11-15","2011-12-25"]
["2012-01-01","2012-02-20","2012-02-21","2012-04-06","2012-04-21","2012-05-01","2012-06-07","2012-09-07","2012-10-12","2012-11-02","2012-11-15","2012-12-25"]
["2013-01-01","2013-02-11","2013-02-12","2013-03-29","2013-04-21","2013-05-01","2013-05-30","2013-09-07","2013-10-12","2013-11-02","2013-11-15","2013-12-25"]
["2014-01-01","2014-03-03","2014-03-04","2014-04-18","2014-04-21","2014-05-01","2014-06-19","2014-09-07","2014-10-12","2014-11-02","2014-11-15","2014-12-25"]
["2015-01-01","2015-02-16","2015-02-17","2015-04-03","2015-04-21","2015-05-01","2015-06-04","2015-09-07","2015-10-12","2015-11-02","2015-11-15","2015-12-25"]
["2016-01-01","2016-02-08","2016-02-09","2016-03-25","2016-04-21","2016-05-01","2016-05-26","2016-09-07","2016-10-12","2016-11-02","2016-11-15","2016-12-25"]
["2017-01-01","2017-02-27","2017-02-28","2017-04-14","2017-04-21","2017-05-01","2017-06-15","2017-09-07","2017-10-12","2017-11-02","2017-11-15","2017-12-25"]
["2018-01-01","2018-02-12","2018-02-13","2018-03-30","2018-04-21","2018-05-01","2018-05-31","2018-09-07","2018-10-12","2018-11-02","2018-11-15","2018-12-25"]
["2019-01-01","2019-03-04","2019-03-05","2019-04-19","2019-04-21","2019-05-01","2019-06-20","2019-09-07","2019-10-12","2019-11-02","2019-11-15","2019-12-25"]
["2020-01-01","2020-02-24","2020-02-25","2020-04-10","2020-04-21","2020-05-01","2020-06-11","2020-09-07","2020-10-12","2020-11-02","2020-11-15","2020-12-25"]
["2021-01-01","2021-02-15","2021-02-16","2021-04-02","2021-04-21","2021-05-01","2021-06-03","2021-09-07","2021-10-12","2021-11-02","2021-11-15","2021-12-25"]
["2022-01-01","2022-02-28","2022-03-01","2022-04-15","2022-04-21","2022-05-01","2022-06-16","2022-09-07","2022-10-12","2022-11-02","2022-11-15","2022-12-25"]
["2023-01-01","2023-02-20","2023-02-21","2023-04-07","2023-04-21","2023-05-01","2023-06-08","2023-09-07","2023-10-12","2023-11-02","2023-11-15","2023-12-25"]
["2024-01-01","2024-02-12","2024-02-13","2024-03-29","2024-04-21","2024-05-01","2024-05-30","2024-09-07","2024-10-12","2024-11-02","2024-11-15","2024-12-25"]
["2025-01-01","2025-03-03","2025-03-04","2025-04-18","2025-04-21","2025-05-01","2025-06-19","2025-09-07","2025-10-12","2025-11-02","2025-11-15","2025-12-25"]
["2026-01-01","2026-02-16","2026-02-17","2026-04-03","2026-04-21","2026-05-01","2026-06-04","2026-09-07","2026-10-12","2026-11-02","2026-11-15","2026-12-25"]
["2027-01-01","2027-02-08","2027-02-09","2027-03-26","2027-04-21","2027-05-01","2027-05-27","2027-09-07","2027-10-12","2027-11-02","2027-11-15","2027-12-25"]
["2028-01-01","2028-02-28","2028-02-29","2028-04-14","2028-04-21","2028-05-01","2028-06-15","2028-09-07","2028-10-12","2028-11-02","2028-11-15","2028-12-25"]
["2029-01-01","2029-02-12","2029-02-13","2029-03-30","2029-04-21","2029-05-01","2029-05-31","2029-09-07","2029-10-12","2029-11-02","2029-11-15","2029-12-25"]
["2030-01-01","2030-03-04","2030-03-05","2030-04-19","2030-04-21","2030-05-01","2030-06-20","2030-09-07","2030-10-12","2030-11-02","2030-11-15","2030-12-25"]
["2031-01-01","2031-02-24","2031-02-25","2031-04-11","2031-04-21","2031-05-01","2031-06-12","2031-09-07","2031-10-12","2031-11-02","2031-11-15","2031-12-25"]
["2032-01-01","2032-02-09","2032-02-10","2032-03-26","2032-04-21","2032-05-01","2032-05-27","2032-09-07","2032-10-12","2032-11-02","2032-11-15","2032-12-25"]
["2033-01-01","2033-02-28","2033-03-01","2033-04-15","2033-04-21","2033-05-01","2033-06-16","2033-09-07","2033-10-12","2033-11-02","2033-11-15","2033-12-25"]
["2034-01-01","2034-02-20","2034-02-21","2034-04-07","2034-04-21","2034-05-01","2034-06-08","2034-09-07","2034-10-12","2034-11-02","2034-11-15","2034-12-25"]
["2035-01-01","2035-02-05","2035-02-06","2035-03-23","2035-04-21","2035-05-01","2035-05-24","2035-09-07","2035-10-12","2035-11-02","2035-11-15","2035-12-25"]
["2036-01-01","2036-02-25","2036-02-26","2036-04-11","2036-04-21","2036-05-01","2036-06-12","2036-09-07","2036-10-12","2036-11-02","2036-11-15","2036-12-25"]
["2037-01-01","2037-02-16","2037-02-17","2037-04-03","2037-04-21","2037-05-01","2037-06-04","2037-09-07","2037-10-12","2037-11-02","2037-11-15","2037-12-25"]
["2038-01-01","2038-03-08","2038-03-09","2038-04-21","2038-04-23","2038-05-01","2038-06-24","2038-09-07","2038-10-12","2038-11-02","2038-11-15","2038-12-25"]
["2039-01-01","2039-02-21","2039-02-22","2039-04-08","2039-04-21","2039-05-01","2039-06-09","2039-09-07","2039-10-12","2039-11-02","2039-11-15","2039-12-25"]
["2040-01-01","2040-02-13","2040-02-14","2040-03-30","2040-04-21","2040-05-01","2040-05-31","2040-09-07","2040-10-12","2040-11-02","2040-11-15","2040-12-25"]
["2041-01-01","2041-03-04","2041-03-05","2041-04-19","2041-04-21","2041-05-01","2041-06-20","2041-09-07","2041-10-12","2041-11-02","2041-11-15","2041-12-25"]
["2042-01-01","2042-02-17","2042-02-18","2042-04-04","2042-04-21","2042-05-01","2042-06-05","2042-09-07","2042-10-12","2042-11-02","2042-11-15","2042-12-25"]
["2043-01-01","2043-02-09","2043-02-10","2043-03-27","2043-04-21","2043-05-01","2043-05-28","2043-09-07","2043-10-12","2043-11-02","2043-11-15","2043-12-25"]
["2044-01-01","2044-02-29","2044-03-01","2044-04-15","2044-04-21","2044-05-01","2044-06-16","2044-09-07","2044-10-12","2044-11-02","2044-11-15","2044-12-25"]
["2045-01-01","2045-02-20","2045-02-21","2045-04-07","2045-04-21","2045-05-01","2045-06-08","2045-09-07","2045-10-12","2045-11-02","2045-11-15","2045-12-25"]
["2046-01-01","2046-02-05","2046-02-06","2046-03-23","2046-04-21","2046-05-01","2046-05-24","2046-09-07","2046-10-12","2046-11-02","2046-11-15","2046-12-25"]
["2047-01-01","2047-02-25","2047-02-26","2047-04-12","2047-04-21","2047-05-01","2047-06-13","2047-09-07","2047-10-12","2047-11-02","2047-11-15","2047-12-25"]
["2048-01-01","2048-02-17","2048-02-18","2048-04-03","2048-04-21","2048-05-01","2048-06-04","2048-09-07","2048-10-12","2048-11-02","2048-11-15","2048-12-25"]
["2049-01-01","2049-03-01","2049-03-02","2049-04-16","2049-04-21","2049-05-01","2049-06-17","2049-09-07","2049-10-12","2049-11-02","2049-11-15","2049-12-25"]
["2050-01-01","2050-02-21","2050-02-22","2050-04-08","2050-04-21","2050-05-01","2050-06-09","2050-09-07","2050-10-12","2050-11-02","2050-11-15","2050-12-25"]
["2051-01-01","2051-02-13","2051-02-14","2051-03-31","2051-04-21","2051-05-01","2051-06-01","2051-09-07","2051-10-12","2051-11-02","2051-11-15","2051-12-25"]
["2052-01-01","2052-03-04","2052-03-05","2052-04-19","2052-04-21","2052-05-01","2052-06-20","2052-09-07","2052-10-12","2052-11-02","2052-11-15","2052-12-25"]
["2053-01-01","2053-02-17","2053-02-18","2053-04-04","2053-04-21","2053-05-01","2053-06-05","2053-09-07","2053-10-12","2053-11-02","2053-11-15","2053-12-25"]
["2054-01-01","2054-02-09","2054-02-10","2054-03-27","2054-04-21","2054-05-01","2054-05-28","2054-09-07","2054-10-12","2054-11-02","2054-11-15","2054-12-25"]
["2055-01-01","2055-03-01","2055-03-02","2055-04-16","2055-04-21","2055-05-01","2055-06-17","2055-09-07","2055-10-12","2055-11-02","2055-11-15","2055-12-25"]
["2056-01-01","2056-02-14","2056-02-15","2056-03-31","2056-04-21","2056-05-01","2056-06-01","2056-09-07","2056-10-12","2056-11-02","2056-11-15","2056-12-25"]
["2057-01-01","2057-03-05","2057-03-06","2057-04-20","2057-04-21","2057-05-01","2057-06-21","2057-09-07","2057-10-12","2057-11-02","2057-11-15","2057-12-25"]
["2058-01-01","2058-02-25","2058-02-26","2058-04-12","2058-04-21","2058-05-01","2058-06-13","2058-09-07","2058-10-12","2058-11-02","2058-11-15","2058-12-25"]
["2059-01-01","2059-02-10","2059-02-11","2059-03-28","2059-04-21","2059-05-01","2059-05-29","2059-09-07","2059-10-12","2059-11-02","2059-11-15","2059-12-25"]
["2060-01-01","2060-03-01","2060-03-02","2060-04-16","2060-04-21","2060-05-01","2060-06-17","2060-09-07","2060-10-12","2060-11-02","2060-11-15","2060-12-25"]
["2061-01-01","2061-02-21","2061-02-22","2061-04-08","2061-04-21","2061-05-01","2061-06-09","2061-09-07","2061-10-12","2061-11-02","2061-11-15","2061-12-25"]
["2062-01-01","2062-02-06","2062-02-07","2062-03-24","2062-04-21","2062-05-01","2062-05-25","2062-09-07","2062-10-12","2062-11-02","2062-11-15","2062-12-25"]
["2063-01-01","2063-02-26","2063-02-27","2063-04-13","2063-04-21","2063-05-01","2063-06-14","2063-09-07","2063-10-12","2063-11-02","2063-11-15","2063-12-25"]
["2064-01-01","2064-02-18","2064-02-19","2064-04-04","2064-04-21","2064-05-01","2064-06-05","2064-09-07","2064-10-12","2064-11-02","2064-11-15","2064-12-25"]
["2065-01-01","2065-02-09","2065-02-10","2065-03-27","2065-04-21","2065-05-01","2065-05-28","2065-09-07","2065-10-12","2065-11-02","2065-11-15","2065-12-25"]
["2066-01-01","2066-02-22","2066-02-23","2066-04-09","2066-04-21","2066-05-01","2066-06-10","2066-09-07","2066-10-12","2066-11-02","2066-11-15","2066-12-25"]
["2067-01-01","2067-02-14","2067-02-15","2067-04-01","2067-04-21","2067-05-01","2067-06-02","2067-09-07","2067-10-12","2067-11-02","2067-11-15","2067-12-25"]
["2068-01-01","2068-03-05","2068-03-06","2068-04-20","2068-04-21","2068-05-01","2068-06-21","2068-09-07","2068-10-12","2068-11-02","2068-11-15","2068-12-25"]
["2069-01-01","2069-02-25","2069-02-26","2069-04-12","2069-04-21","2069-05-01","2069-06-13","2069-09-07","2069-10-12","2069-11-02","2069-11-15","2069-12-25"]
["2070-01-01","2070-02-10","2070-02-11","2070-03-28","2070-04-21","2070-05-01","2070-05-29","2070-09-07","2070-10-12","2070-11-02","2070-11-15","2070-12-25"]

{"sheet":"DDI_Fra","index":2,"n_rows":137,"n_cols":12,"rows_kept":137,"cut":false,"hidden":false,"merged":[[104,1,104,8],[106,1,106,2],[107,1,107,2],[108,1,108,2]]}
[1,"Mercado e DDI"]
[]
[null,null,"taxa",5.25,60,"dc",null,"PU"]
[null,null,null,null,40,"du",2.673,{"$f":"100000/(1+D3/100*E3/360)","v":99132.589838909538}]
[]
[]
[null,null,"No resgate",null,"CDI",null,"ptax",{"$f":"H4*(1+E8/100)^(E4/252)*G4/G8","v":100829.11618733223}]
[null,null,null,null,19.25,null,2.7025000000000001]
[]
[null,null,"Resultado",null,{"$f":"(100000-H7)*G8/2","v":-1120.343248132672},"Para o vendedor o contrato"]
[]
[2,"Mercado de FRA",null,200,1.45,null,{"$f":"G15-G14","v":93},null,"***"]
[]
[null,"PU Ajuste DDI Curto",null,null,{"$f":"(((100000/I14)-1)*360/G14)*100","v":2.5899612563331065},null,20,null,99856.320000000007]
[null,"PU Ajuste DDI Longo",null,null,{"$f":"(((E14/100*G14/360)+1)*((E12/100*G12/360)+1)-1)*360/(G15)*100","v":1.6534801450511685},null,113,null,{"$f":"100000/(1+E15/100*G15/360)","v":99483.670749982353}]
[null,"No. Cts Curtos",null,{"$f":"D12/(1+E12/100*G12/360)","v":199.25362911427609}]
[]
[]
[3]
[null,null,null,"Qde","Taxa",null,"Prazo",null,"PU"]
[null,"Mercado de FRA",null,100,0.98,null,{"$f":"Curvas!M7","v":93},null,"***"]
[]
[null,"PU Ajuste DDI Curto",null,null,{"$f":"(((100000/I23)-1)*360/G23)*100","v":7.1799654729682416},null,{"$f":"Curvas!M4","v":20},null,99602.697815926193]
[null,"PU Ajuste DDI Longo",null,null,2.08,null,{"$f":"G23+G21","v":113},null,{"$f":"100000/(1+E24/100*G24/360)","v":99351.346100349285}]
[null,"No. Cts Curtos",null,{"$f":"D21/(1+E21/100*G21/360)","v":99.747472648411772}]
[]
[]
[4,"Mercado de FRA",null,100,0.99,null,93,null,"***"]
[]
[null,"PU Ajuste DDI Curto",null,null,{"$f":"(((100000/I30)-1)*360/G30)*100","v":-40.14995159270633},null,{"$f":"G23-1","v":19},null,102164.9]
[null,"PU Ajuste DDI Longo",null,null,{"$f":"(((100000/I31)-1)*360/G31)*100","v":-6.0100000000000113},null,{"$f":"G24-1","v":112},null,{"$f":"F48","v":101905.40460974759}]
[null,"No. Cts Curtos",null,{"$f":"D28/(1+E28/100*G28/360)","v":99.744902412081103}]
[]
[5]
[null,null,null,"Qde","Taxa",null,"Prazo",null,"PU"]
[null,"Mercado de FRA",null,100,2.75,null,{"$f":"81","v":81},null,"***"]
[]
[null,"PU Ajuste DDI Curto",null,null,{"$f":"(((100000/I38)-1)*360/G38)*100","v":6.2681497821857697},null,21,null,99635.69]
[null,"PU Ajuste DDI Longo",null,null,{"$f":"(((E38/100*G38/360)+1)*((E36/100*G36/360)+1)-1)*360/(G39)*100","v":3.4823099327276763},null,{"$f":"G38+G36","v":102},null,{"$f":"100000/(1+E39/100*G39/360)","v":99022.985278588734}]
[null,"No. Cts Curtos",null,{"$f":"D36/(1+E36/100*G36/360)","v":99.385054972358532}]
[]
[6]
[null,"Ajustes DDI Jan/15"]
[null,"2015-01-02",null,"Pc Ajuste","DC","PU","PU AJ.","CDI","PTAX"]
[null,"2014-09-11",null,2.08,{"$f":"B44-B45","v":113},{"$f":"100000/(1+D45/100*E45/360)","v":99351.346100349285},null,10.81,2.2967,null,"Dif pontos","Vr. Ajuste"]
[]
[]
[null,"2014-09-12",null,-6.01,{"$f":"B44-B48","v":112},{"$f":"100000/(1+D48/100*E48/360)","v":101905.40460974759},{"$f":"TRUNC((1+H45/100)^(1/252)/(I48/I45),6)*F45","v":99769.714618777856},10.81,2.2879999999999998,null,{"$f":"F48-G48","v":2135.6899909697386},{"$f":"K48*I48/2","v":2443.2293496693806}]
[]
[]
[7,"Ajustes DDI Out/14"]
[null,"2014-10-01",null,"Pc Ajuste","DC","PU","PU AJ.","CDI","PTAX"]
[null,"2014-09-11",null,7.18,{"$f":"B52-B53","v":20},{"$f":"100000/(1+D53/100*E53/360)","v":99602.695912969386},null,10.81,2.2967,null,"Dif pontos","Vr. Ajuste"]
[]
[]
[null,"2014-09-12",null,-40.149951159146688,{"$f":"B52-B56","v":19},{"$f":"100000/(1+D56/100*E56/360)","v":102164.8999761162},{"$f":"TRUNC((1+H53/100)^(1/252)/(I56/I53),6)*F53","v":100022.12286545889},10.81,2.2879999999999998,null,{"$f":"F56-G56","v":2142.7771106573055},{"$f":"K56*I56/2","v":2451.3370145919571}]
[]
[]
[8,"Ajustes DDI posição vendida de 200 cts"]
[]
[null,null,"Taxa","Saques",null,"Taxa Cetip","PTAX800","PU","PU Cor.","Ajuste","Ajuste "]
[null,null,"Cupom","(DU)","DC","( % aa 252)",null,null,null,null,"Acum."]
[null,null,null,6,8,null,2.2250000000000001]
[null,null,7.7,5,7,10.95,2.2210000000000001,{"$f":"100000/(1+C64/100*E64/360)","v":99850.501610089341}]
[null,null,7.4,4,4,11.05,2.2149999999999999,99917.845327175426,{"$f":"H64*L65*G63/G64","v":100071.58634518365},null,null,{"$f":"(1+F64/100)^(1/252)","v":1.0004124241639076}]
[null,null,7.6,3,3,11,2.2229999999999999,99936.706752390164,{"$f":"H65*L66*G64/G65","v":100230.18162975991},{"$f":"(I65-H65)*G65/2","v":170.26817744410636},{"$f":"J66*200","v":34053.635488821274},{"$f":"(1+F65/100)^(1/252)","v":1.0004160006485354}]
[null,null,7.9,2,2,10.9,2.2280000000000002,99956.130365006466,{"$f":"H66*L67*G65/G66","v":99618.306578049291},{"$f":"(I66-H66)*G66/2","v":326.19732619647732},{"$f":"J67*200+K66","v":99293.10072811674},{"$f":"(1+F66/100)^(1/252)","v":1.0004142128073805}]
[null,null,7.7,1,1,11,2.2309999999999999,99978.615684978489,{"$f":"H67*L68*G66/G67","v":99772.765643216233},-376.33569867029286,{"$f":"J68*200+K67","v":24025.960994058172},{"$f":"(1+F67/100)^(1/252)","v":1.0004106347173949}]
[null,null,null,0,0,null,2.2269999999999999,100000,{"$f":"H68*L69*G67/G68","v":99885.532328443005},-229.6257215857969,-21899.183323101206,{"$f":"(1+F68/100)^(1/252)","v":1.0004142128073805}]
[null,null,null,null,null,null,null,null,null,-127.45975227871382,-47391.133778843971]
[]
[]
[9]
[]
[]
[null,null,"DDI","Dias corridos","DI","Dias úteis"]
[null,"vctoMAI",99917.24,42,98061.05,29]
[null,"vctoJUN",99639.31,68,96598.5,47]
[null,"vctoJUL",99338.57,98,95080.36,69]
[null,"ptax compra",2.7280000000000002]
[null,"ptax venda",2.7288000000000001]
[]
[null,null,"Vcto Mai","Vcto Jun","Vcto Jul"]
[null,"Tx impl DI",{"$f":"100000/E77","v":1.0197728863804743},{"$f":"100000/E78","v":1.0352127621029312},{"$f":"100000/E79","v":1.051741915996111}]
[null,"Tx impl DDI",{"$f":"100000/C77","v":1.0008282854890707},{"$f":"100000/C78","v":1.0036199568222623},{"$f":"100000/C79","v":1.0066583402599816}]
[null,"(1+ iR$)/(1+iUS$)",{"$f":"C84/C85","v":1.0189289223397058},{"$f":"D84/D85","v":1.0314788531913019},1.0447853794411379]
[null,"Dólar para compra",{"$f":"$C$80*C86","v":2.7796381001427175},{"$f":"$C$80*D86","v":2.813874311505872},{"$f":"$C$80*E86","v":2.8501745151154245}]
[null,"Dólar para venda",{"$f":"$C$81*C86","v":2.7804532432805891},{"$f":"$C$81*D86","v":2.8146994945884249},{"$f":"$C$81*E86","v":2.8510103434189773}]
[]
[]
[10]
[]
[null,"Dados","2014-12-28",null,"Tx Implic.",null,"Us $ Fut"]
[null,"Dólar à vista ",1.9510000000000001]
[null,"DI futuro Mar",97585,null,{"$f":"100000/C95","v":1.024747655889737},null,{"$f":"C94*E95/E96","v":1.9586984378746732}]
[null,"DDI Mar 1 ",97970.06,null,{"$f":"100000/C96","v":1.0207200036419291}]
[]
[11,"Fundo cambial",null,"Vol",10000000,null,"Cupom real no venc"]
[null,null,null,"Cupom",8.9499999999999993,null,8]
[null,null,null,"Venc","2014-07-31"]
[null,"Dados:","2014-12-28",null,null,null,"PU Ajustado"]
[null,"DDI Ago",94926.07,{"$f":"((100000/C102)-1)*36000/C103","v":8.9499995003455624},null,null,{"$f":"C102*(1+G99/100*C103/360)","v":99461.426677777781}]
[null,"dc ago",215]
[null,"Qde cts",{"$f":"E98/C102*2","v":210.69027718096828}]
[null,"Resposta: Hedge em 28/12 – Compra de 211 contratos DDI Ago."]
[null,"Resultado final:"]
[null,"Recebimento do ativo",null,null,{"$f":"100000/C102*E98","v":10534513.859048415}]
[null,"Perda DDI futuro ",null,null,{"$f":"(G102-100000)*211/2","v":-56819.485494444089}]
[null,"Recebimento líquido",null,null,{"$f":"E107+E108","v":10477694.373553971},null,{"$f":"(E109/10000000-1)*36000/C103","v":7.9986034641595278}]
[]
[]
[12]
[null,null,1.07,null,"CDI","spot","futuro","DU","DC"]
[null,null,1.1200000000000001,null,{"$f":"Curvas!K7","v":10.83},{"$f":"Curvas!B26","v":2.2894700000000001},{"$f":"Curvas!B19","v":2.3565527395354682},{"$f":"Curvas!B9","v":79},{"$f":"Curvas!B7","v":113}]
[]
[null,"Importador",null,null,"sem hedge",null,"IF"]
["US$",5000000,null,"Passivo",{"$f":"B117*G114*B125","v":11822373.643711444},"Ativo",{"$f":"B118*B122*B125","v":11822373.643711444},"USD"]
["R$",{"$f":"B117*F114","v":11447350},null,"Ativo",{"$f":"B118*(1+E114/100)^(H114/252)","v":11822373.643711444},"Passivo",{"$f":"E118","v":11822373.643711444},"CDI"]
[null,null,null,"Res.",{"$f":"E118-E117","v":0},null,{"$f":"G117-G118","v":0}]
[null,null,null,null,null,"Res. Liq",{"$f":"E119+G119","v":0}]
[null,{"$f":"(1+E114/100)^(H114/252)","v":1.0327607388357518}]
[null,{"$f":"G114/F114","v":1.0293005540738547}]
[null,{"$f":"(B121/B122-1)*36000/I114","v":1.0709794556993844}]
[]
[null,1.0033616855137231]
[]
[]
[null,"IF",null,null,"IMP",null,"BACEN"]
["US$",5000000,null,"Passivo",{"$f":"G117","v":11822373.643711444},"Ativo",{"$f":"B130*B134*B137","v":11828055.552998854},"USD"]
["R$",{"$f":"B118","v":11447350},null,"Ativo",{"$f":"G118","v":11822373.643711444},"Passivo",{"$f":"E130","v":11822373.643711444},"CDI"]
[null,null,null,"Res.",{"$f":"E130-E129","v":0},null,{"$f":"G129-G130","v":5681.9092874098569}]
[null,null,null,null,null,"Res. Liq",{"$f":"E131+G131","v":5681.9092874098569}]
[null,{"$f":"(1+E133/100)^(H114/252)","v":1.0332570903308498},null,null,11]
[null,{"$f":"G114/F114","v":1.0293005540738547}]
[null,{"$f":"(B133/B134-1)*36000/I114","v":1.2246077416537138}]
[]
[null,1.0038439076335242]

{"sheet":"Graficos CC","index":3,"n_rows":154,"n_cols":5,"rows_kept":154,"cut":false,"hidden":false,"merged":[]}
["2011-01-17",1.95,null,"2011-02-21",2.38]
["2011-01-18",2.2800000003803031,null,"2011-02-22",1.93]
["2011-01-19",1.7500000004015577,null,"2011-02-23",1.86]
["2011-01-20",1.7500000004155367,null,"2011-02-24",3.2100000002873683]
["2011-01-21",1.5600000000958159,null,"2011-02-25",2.7400000000410225]
["2011-01-24",1.77,null,"2011-02-28",2.7000000002992324]
["2011-01-26",2.4300000000000002,null,"2011-03-01",2.6100000002965049]
["2011-01-27",0.61,null,"2011-03-02",3.1000000000668204]
["2011-01-28",0.13,null,"2011-03-03",3.6300000001317692]
["2011-01-31",2.4300000000000002,null,"2011-03-04",3.7700000000438938]
["2011-02-01",3.35,null,"2011-03-09",1.8500000003018882]
["2011-02-02",1.23,null,"2011-03-10",2.3000000002120502]
["2011-02-03",1.58,null,"2011-03-11",2.38000000008963]
["2011-02-04",1.19,null,"2011-03-14",2.9400000001088049]
["2011-02-07",1.3,null,"2011-03-15",2.2900000000068506]
["2011-02-08",3.88,null,"2011-03-16",2.4600000001613131]
["2011-02-09",3.67,null,"2011-03-17",0.55000000020855921]
["2011-02-10",1.19,null,"2011-03-18",3.1400000001432864]
["2011-02-11",2.38,null,"2011-03-21",3.4700000003389695]
["2011-02-14",2.15,null,"2011-03-22",2.9600000000175473]
["2011-02-15",2.0099999999999998,null,"2011-03-23",3.2200000001959244]
["2011-02-16",1.64,null,"2011-03-24",2.9800000002860867]
["2011-02-17",3.55,null,"2011-03-25",2.7700000000561578]
["2011-02-18",2.75,null,"2011-03-28",2.4400000003732019]
["2011-02-21",2.5099999999999998,null,"2011-03-29",3.7500000002809575]
["2011-02-22",1.73,null,"2011-03-30",5.350000000369092]
["2011-02-23",1.52,null,"2011-03-31",3.4100000002149171]
["2011-02-24",3.7600000001193599,null,"2011-04-01",5.0500000001108809]
["2011-02-25",2.9500000001572473,null,"2011-04-04",4.3900000000227868]
["2011-02-28",2.8000000003648631,null,"2011-04-05",3.4700000000579974]
["2011-03-01",2.580000000592245,null,"2011-04-06",2.9000000000515502]
["2011-03-02",3.500000000603225,null,"2011-04-07",7.110000000260821]
["2011-03-03",4.5000000002618288,null,"2011-04-08",6.3100000004070234]
["2011-03-04",4.7100000002616964,null,"2011-04-11",3.4900000003780307]
["2011-03-09",1.2500000003864828,null,"2011-04-12",2.5600000003712005]
["2011-03-10",1.9100000005413995,null,"2011-04-13",3.1500000000701918]
["2011-03-11",2.1400000000878889,null,"2011-04-14",4.4000000000224579]
["2011-03-14",3.0900000005284238,null,"2011-04-15",4.5800000001766943]
["2011-03-15",1.9900000001896363,null,"2011-04-18",2.4100000001588167]
["2011-03-16",2.4000000001007389,null,"2011-04-19",6.5800000004479573]
["2011-03-17",-1.1099999996840964,null,"2011-04-20",6.1000000000016792]
["2011-03-18",3.7000000002354225,null,"2011-04-25",4.8500000001656041]
["2011-03-21",4.2700000003771059,null,"2011-04-26",6.3000000000943803]
["2011-03-22",3.2700000007135022,null,"2011-04-27",4.9400000002196345]
["2011-03-23",3.8300000004718537,null,"2011-04-28",4.7400000004111025]
["2011-03-24",3.3900000001669413,null,"2011-04-29",8.0500000001349896]
["2011-03-25",2.9600000004530043,null,"2011-05-02",5.8200000000520902]
["2011-03-28",2.2300000007511569,null,"2011-05-03",2.7000000002338815]
["2011-03-29",4.9300000002835009,null,"2011-05-04",2.2100000000137943]
["2011-03-30",8.160000000496801,null,"2011-05-05",1.0600000003954018]
["2011-03-31",4.1000000001410299,null,"2011-05-06",5.050000000080459]
["2011-04-01",7.3300000003963568,null,"2011-05-09",3.3900000003079391]
["2011-04-04",6.0800000006355361,null,"2011-05-10",6.4300000003135782]
["2011-04-05",4.0900000001259791,null,"2011-05-11",2.1800000000138957]
["2011-04-06",2.7500000003515166,null,"2011-05-12",3.4700000001368081]
["2011-04-07",11.36000000004997,null,"2011-05-13",1.8400000002755639]
["2011-04-08",9.6900000000122848,null,"2011-05-16",3.6400000001079507]
["2011-04-11",3.5400000002835261,null,"2011-05-17",5.1800000001023125]
["2011-04-12",1.660000000364692,null,"2011-05-18",6.7300000003502793]
["2011-04-13",3.1900000004810365,null,"2011-05-19",4.2300000003613718]
["2011-04-14",5.8700000005163293,null,"2011-05-20",4.3700000000255725]
["2011-04-15",6.2400000007033105,null,"2011-05-23",1.5600000004969283]
["2011-04-18",1.2700000000682721,null,"2011-05-24",5.6400000003004953]
["2011-04-19",10.410000000511625,null,"2011-05-25",3.5300000004967931]
["2011-04-20",8.7800000009839998,null,"2011-05-26",5.8600000005373145]
["2011-04-25",6.110000001091306,null,"2011-05-27",6.7600000000509164]
["2011-04-26",9.4100000002815936,null,"2011-05-30",4.8300000001653123]
["2011-04-27",5.2300000001596398,null,"2011-05-31",6.7700000003022254]
["2011-04-28",4.890000000551745,null,"2011-06-01",2.0400000004744796]
["2011-04-29",12.910000000129683,null,"2011-06-02",5.3700000000096715]
["2011-05-02",7.0700000007600128,null,"2011-06-03",4.9500000004247706]
["2011-05-03",-0.23999999919435358,null,"2011-06-06",2.2800000003798213]
["2011-05-04",-1.5299999988224904,null,"2011-06-07",4.6900000004282374]
["2011-05-05",-3.7899999996325815,null,"2011-06-08",2.8700000000458914]
["2011-05-06",6.1700000011052838,null,"2011-06-09",2.5100000003463179]
["2011-05-09",1.9100000009060623,null,"2011-06-10",1.9900000000291282]
["2011-05-10",10.430000000138888,null,"2011-06-13",4.7400000002624392]
["2011-05-11",-1.1899999995444019,null,"2011-06-14",4.8900000002564692]
["2011-05-12",2.4400000003897659,null,"2011-06-15",-0.17999999984748397]
["2011-05-13",-1.6599999996866446,null,"2011-06-16",9.0000000006859829E-2]
["2011-05-16",3.6900000005388924,null,"2011-06-17",6.2700000005954468]
["2011-05-17",8.2900000007612107,null,"2011-06-20",3.9600000000535016]
["2011-05-18",12.800000000168332,null,"2011-06-21",5.1800000005680467]
["2011-05-19",4.7100000015668364,null,"2011-06-22",3.820000000662962]
["2011-05-20",5.2800000001364138,null,"2011-06-24",-1.999999937825224E-2]
["2011-05-23",-3.9299999991151924,null,"2011-06-27",3.820000000362878]
["2011-05-24",9.9700000005152702,null,"2011-06-28",7.8300000002000845]
["2011-05-25",2.5700000001208614,null,"2011-06-29",6.1300000003412514]
["2011-05-26",11.330000000334239,null,"2011-06-30",6.6600000005627944]
["2011-05-27",15.720000001741674,null,"2011-07-01",4.9800000005181939]
["2011-05-30",8.8600000003450639,null,"2011-07-04",5.8200000005870516]
["2011-05-31",15.150000001674121,null,"2011-07-05",2.4400000004815681]
["2011-06-01",-4.179999998098527,null,"2011-07-06",2.3200000007066905]
["2011-06-02",9.4700000013265448,null,"2011-07-07",5.8900000004488939]
["2011-06-03",8.4300000011769018,null,"2011-07-08",1.0800000002923644]
["2011-06-06",-4.1299999971797341,null,"2011-07-11",-0.62999999948744523]
["2011-06-07",7.2800000026509437,null,"2011-07-12",4.1200000007426594]
["2011-06-08",-1.0099999999301561,null,"2011-07-13",4.2900000008249304]
["2011-06-09",-2.519999996904998,null,"2011-07-14",2.8400000007001345]
["2011-06-10",-5.1599999978968469,null,"2011-07-15",2.6700000006603775]
["2011-06-13",11.100000003402055,null,"2011-07-18",2.2000000009023259]
["2011-06-14",12.95000000384865,null,"2011-07-19",8.7300000001501701]
["2011-06-15",-21.209999996485124,null,"2011-07-20",6.6800000009781613]
["2011-06-16",-20.849999997660973,null,"2011-07-21",7.0500000009344479]
["2011-06-17",25.210000000483188,null,"2011-07-22",5.3100000005708514]
["2011-06-20",10.340000000741382,null,"2011-07-25",8.7700000004217333]
["2011-06-21",23.640000006496997,null,"2011-07-26",7.7800000006572079]
["2011-06-22",10.350000004995863,null,"2011-07-27",-4.3699999998544738]
["2011-06-24",-41.899999998325768,null,"2011-07-28",1.490000000099063]
["2011-06-27",24.130000003891094,null,"2011-07-29",7.7100000000141753]
["2011-06-28",157.80000001485473,null,"2011-08-01",1.5400000010095434]
["2011-06-29",-145.530000029099,null,"2011-08-02",-1.4299999997331374]
["2011-06-30",290.93000001286919,null,"2011-08-03",4.4400000000288244]
[null,null,null,"2011-08-04",-3.2799999991713014]
[null,null,null,"2011-08-05",-1.6799999987879841]
[null,null,null,"2011-08-08",-4.9999999995747659]
[null,null,null,"2011-08-09",-9.1199999990335137]
[null,null,null,"2011-08-10",10.470000001093696]
[null,null,null,"2011-08-11",0.34000000064880453]
[null,null,null,"2011-08-12",8.8400000010781739]
[null,null,null,"2011-08-15",14.460000001424442]
[null,null,null,"2011-08-16",4.6900000004708735]
[null,null,null,"2011-08-17",5.9700000009091383]
[null,null,null,"2011-08-18",-7.6699999985307681]
[null,null,null,"2011-08-19",6.250000001221955]
[null,null,null,"2011-08-22",-1.4899999998643538]
[null,null,null,"2011-08-23",2.7800000006235819]
[null,null,null,"2011-08-24",-0.50999999834226983]
[null,null,null,"2011-08-25",-0.79999999879707917]
[null,null,null,"2011-08-26",11.030000001744396]
[null,null,null,"2011-08-29",16.800000000731735]
[null,null,null,"2011-08-30",12.250000002135785]
[null,null,null,"2011-08-31",4.6300000012740652]
[null,null,null,"2011-09-01",-9.3699999978401607]
[null,null,null,"2011-09-02",-24.489999999141641]
[null,null,null,"2011-09-05",-10.009999999574257]
[null,null,null,"2011-09-06",-5.62999999923397]
[null,null,null,"2011-09-08",1.9800000013865926]
[null,null,null,"2011-09-09",-20.379999999665056]
[null,null,null,"2011-09-12",-38.099999998797813]
[null,null,null,"2011-09-13",-18.879999998424445]
[null,null,null,"2011-09-14",-8.0999999986299933]
[null,null,null,"2011-09-15",21.70000000145178]
[null,null,null,"2011-09-16",-11.92999999708314]
[null,null,null,"2011-09-19",-95.919999999821599]
[null,null,null,"2011-09-20",-22.159999996913914]
[null,null,null,"2011-09-21",-100.06999999742418]
[null,null,null,"2011-09-22",-111.89999999992355]
[null,null,null,"2011-09-23",104.59000000673875]
[null,null,null,"2011-09-26",78.840000004590948]
[null,null,null,"2011-09-27",157.73000000535254]
[null,null,null,"2011-09-28",-91.999999988406074]
[null,null,null,"2011-09-29",-176.46999999996004]
[null,null,null,"2011-09-30",-158.43999999811498]

{"sheet":"Spot","index":4,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Spot",null,"Receita",null,"Vol",null,"Linha","CDI"]
[null,null,null,2.2799999999999998,null,2000,null,1000000,null,1.28,10.91]
[]
[]
[null,null,"Liq D0",null,null,"Prazo",null,"Fator"]
[null,"Rec","Reais",null,null,2,"DU",{"$f":"(1+K4/100)^(F8/252)","v":1.000822154256926}]
[null,"Custo","US$",null,null,4,"DC",{"$f":"(1+J4/100*F9/360)","v":1.0001422222222223}]
[]
[null,null,null,null,null,"Spread US$ x BRL",null,{"$f":"H8/H9","v":1.0006798353470099}]
[]
[null,null,null,"US$-DO",null,"US$ Final"]
[null,null,null,{"$f":"D4/H11","v":2.2784510284544255},null,{"$f":"D14+F4/H4","v":2.2804510284544253}]
[]
[]
[null,null,"Liq D1",null,null,"Prazo",null,"Fator"]
[null,"Rec","Reais",null,null,1,"DU",{"$f":"(1+K4/100)^(F18/252)","v":1.0004109926709752}]
[null,"Custo","US$",null,null,3,"DC",{"$f":"(1+J4/100*F19/360)","v":1.0001066666666667}]
[]
[null,null,null,null,null,"Spread US$ x BRL",null,{"$f":"H18/H19","v":1.0003042935463302}]
[]
[null,null,null,"US$-DO",null,"US$ Final"]
[null,null,null,{"$f":"D4/H21","v":2.2793064217657473},null,{"$f":"D24+F4/H4","v":2.2813064217657471}]

{"sheet":"Arbitragem","index":5,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Obter cotações moeda:",null,null,null,null,null,null,"Obter cotações moeda:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"compra","venda"]
[null,"Moeda A","Real/USD",null,2.2755000000000001,null,null,null,null,"Moeda A","Real/USD",null,2.2783000000000002,2.2784]
[null,"Moeda B","US$/EUR",null,1.2916000000000001,null,null,null,null,"Moeda B","US$/EUR",null,1.2915000000000001,1.2916000000000001]
[]
[null,null,"REAL/EUR",null,{"$f":"E5*E6","v":2.9390358000000001},null,null,null,null,null,"REAL/EUR",null,{"$f":"M5*M6","v":2.9424244500000003},{"$f":"N6*N5","v":2.9427814400000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"compra","venda"]
[null,"Moeda A","Real/USD",null,2.2755000000000001,null,null,null,null,"Moeda A","Real/USD",null,2.2783000000000002,2.2784]
[null,"Moeda A","ARS/USD",null,8.4113000000000007,null,null,null,null,"Moeda A","ARS/USD",null,8.4074000000000009,8.4144000000000005]
[]
[null,null,"REAL/ARS",null,{"$f":"E11*1/E12","v":0.2705289313185833},null,null,null,null,null,"REAL/ARS",null,{"$f":"M11/N12","v":0.27076202700133106},{"$f":"N11/M12","v":0.27099935770868516}]

{"sheet":"Futuro","index":6,"n_rows":92,"n_cols":23,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
[]
["Ex 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Curvas!B7","v":113}]
[null,null,null,null,null,"Cotação","Ajuste","Vr. Uint","p/100 ct","Liq.",null,null,null,"Data","US$"]
[null,null,null,null,"compra - D0",2259.5,null,null,null,null,null,null,null,"2014-09-11",2.2866]
[null,null,null,null,"D0",2261.33,{"$f":"F6-F5","v":1.8299999999999272},{"$f":"G6*50","v":91.499999999996362},{"$f":"H6*100","v":9149.9999999996362},null,null,null,{"$f":"N6-$N$5","v":1},"2014-09-12",2.2872889999999999]
[null,null,null,null,"D1",2262.5,{"$f":"F7-F6","v":1.1700000000000728},{"$f":"G7*50","v":58.500000000003638},{"$f":"H7*100","v":5850.0000000003638},{"$f":"I6","v":9149.9999999996362},null,null,{"$f":"N7-$N$5","v":7},"2014-09-18",2.2914219999999998]
[null,null,null,null,"D2",2244.1799999999998,{"$f":"F8-F7","v":-18.320000000000164},-916.00000000000819,-91600.000000000815,{"$f":"J7+I7","v":15000},null,null,14,"2014-09-25",2.2957459999999998]
[null,null,null,null,"D3",2257.1,12.920000000000073,646.00000000000364,64600.000000000364,{"$f":"J8+I8","v":-76600.000000000815},null,null,21,"2014-10-02",2.3000699999999998]
[null,null,null,null,"D4",2258.6999999999998,1.5999999999999091,79.999999999995453,7999.9999999995453,-12000.000000000451,null,null,33,"2014-10-14",2.307483]
[null,null,null,null,"venda - D5",2270,11.300000000000182,565.00000000000909,56500.000000000909,-4000.0000000009059,null,null,62,"2014-11-12",2.3262350000000001]
[null,null,null,null,"D6",null,null,null,null,52500,null,null,81,"2014-12-01",2.3385579999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,91,"2014-12-11",2.3450440000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,123,"2015-01-12",2.3644219999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,153,"2015-02-11",2.3825880000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,172,"2015-03-02",2.3940939999999999]
[null,null,null,null,null,null,null,null,"Spline",{"$f":"_xll.SRS1Splines.Functions.Cubic_Spline(M6:M27,O6:O27,N3)","v":{"$error":"#NAME?"}},null,null,181,"2015-03-11",2.3995440000000001]
[null,null,null,null,null,null,null,null,"Linear",{"$f":"O13+(O14-O13)*(N3-M13)/(M14-M13)","v":2.3583663750000001},null,null,263,"2015-06-01",2.4541439999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,273,"2015-06-11",2.4608029999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,355,"2015-09-01",2.515895]
[null,null,null,null,null,null,null,null,null,null,null,null,365,"2015-09-11",2.5226130000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,456,"2015-12-11",2.5812529999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,547,"2016-03-11",2.639894]
[null,null,null,null,null,null,null,null,null,null,null,null,732,"2016-09-12",2.7591079999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,1096,"2017-09-11",2.9598819999999999,null,"Vender inclinação",null,"Comprar curto",null,2286]
[null,null,"Aj. = 50000/1000*(Pontos Aj.)",null,null,"Aj - Aj Ant.",null,75,null,null,null,null,1461,"2018-09-11",3.1560769999999998,null,null,null,"Vender longo",null,3347]
[null,null,null,null,"Cotação","Pontos Aj.","Aj  Diário","Acumulado",null,null,null,null,1826,"2019-09-11",3.3466399999999998]
["Ex 2",null,null,"Venda",2465.5,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vender Spread",null,{"$f":"U26-U25","v":1061}]
[null,null,null,"2014-01-05",2461.13,{"$f":"E29-E28","v":-4.3699999999998909},{"$f":"F29*$H$26*50","v":-16387.499999999593},{"$f":"G29","v":-16387.499999999593}]
[null,null,null,{"$f":"D29+1","v":"2014-01-06"},2476.69,{"$f":"E30-E29","v":15.559999999999945},58349.999999999796,{"$f":"H29+G30","v":41962.500000000204}]
[null,null,null,{"$f":"D30+1","v":"2014-01-07"},2461.5100000000002,-15.179999999999836,-56924.999999999389,{"$f":"H30+G31","v":-14962.499999999185}]
[null,null,null,{"$f":"D31+1+2","v":"2014-01-10"},2452.94,-8.5700000000001637,-32137.500000000615,-47099.999999999796,null,null,null,null,null,2]
[null,null,null,"2014-01-11",2470.23,17.289999999999964,64837.499999999862,17737.500000000065,null,null,null,null,null,"Data","US$"]
[null,null,null,"2014-01-12",2445.48,-24.75,-92812.5,-75074.999999999942,null,null,null,null,null,"2014-09-11",2.3428629005999824]
[null,null,null,"2014-01-13",2443.34,-2.1399999999998727,-8024.9999999995225,-83099.999999999462,null,null,null,null,null,"2014-09-12",2.3436838133999913]
[null,null,null,"2014-01-14",2445.06,1.7199999999997999,6449.9999999992497,-76650.000000000218,null,null,null,null,null,"2014-09-18",2.3485983029999602]
[null,null,null,{"$f":"D36+1+2","v":"2014-01-17"},2444.1,-0.96000000000003638,-3600.0000000001364,-80250.000000000349,null,null,null,null,null,"2014-09-25",2.3543080686000053]
[null,null,null,"2014-01-18",2460.0500000000002,15.950000000000273,59812.500000001026,-20437.499999999323,null,null,null,null,null,"2014-10-02",2.359992197400004]
[null,null,null,"2014-01-19",2460.04,-1.0000000000218279E-2,-37.500000000818545,-20475.000000000142,null,null,null,null,null,"2014-10-14",2.3696767733999877]
[null,null,null,"2014-01-20",2457.31,-2.7300000000000182,-10237.500000000069,-30712.500000000211,null,null,null,null,null,"2014-11-12",2.3927701229999343]
[null,null,null,"2014-01-21",2423.73,-33.579999999999927,-125924.99999999972,-156637.49999999994,null,null,null,null,null,"2014-12-01",2.4076616693999426]
[null,null,null,{"$f":"D41+1+2","v":"2014-01-24"},2414.1799999999998,-9.5500000000001819,-35812.500000000684,-192450.00000000064,null,null,null,null,null,"2014-12-11",2.4154234613999961]
[null,null,null,{"$f":"D42+1+1","v":"2014-01-26"},2395.83,-18.349999999999909,-68812.499999999665,-261262.50000000029,null,null,null,null,null,"2015-01-12",2.4399096053999756]
[null,null,null,"2014-01-27",2393.0300000000002,-2.7999999999997272,-10499.999999998978,-271762.49999999924,null,null,null,null,null,"2015-02-11",2.4623787893999065]
[null,null,null,"2014-01-28",2376.9499999999998,-16.080000000000382,-60300.000000001433,-332062.5000000007,null,null,null,null,null,"2015-03-02",2.4763657230000149]
[null,null,null,{"$f":"D45+1+2","v":"2014-01-31"},2336.6999999999998,-40.25,-150937.5,-483000.0000000007,null,null,null,null,null,"2015-03-11",2.482925189399964]
[null,null,null,{"$f":"D46+1","v":"2014-02-01"},2332.46,-4.2399999999997817,-15899.999999999181,-498899.99999999988,null,null,null,null,null,"2015-06-01",2.5407371574000308]
[null,null,null,"2014-02-02",2339.06,6.5999999999999091,24749.999999999658,-474150.00000000023,null,null,null,null,null,"2015-06-11",2.5475467253999682]
[null,null,null,"2014-02-03",2324.56,-14.5,-54375,-528525.00000000023,null,null,null,null,null,"2015-09-01",2.6014116725999656]
[null,null,null,"2014-02-04",2332.23,7.6700000000000728,28762.500000000273,-499762.49999999994,null,null,null,null,null,"2015-09-11",2.6077398966000374]
[null,null,null,{"$f":"D50+1+2+2","v":"2014-02-09"},2319.63,-12.599999999999909,-47249.999999999658,-547012.49999999965,null,null,null,null,null,"2015-12-11",2.6629223694000075]
[null,null,null,{"$f":"D51+1","v":"2014-02-10"},2334.3000000000002,14.670000000000073,55012.500000000276,-491999.99999999936,null,null,null,null,null,"2016-03-11",2.7137722229999781,null,"Comprar inclinação",null,"Vender curto",null,2343,{"$f":"U52-U25","v":57},{"$f":"V52*50","v":2850}]
[null,null,null,"2014-02-11",2318.12,-16.180000000000291,-60675.000000001091,-552675.00000000047,null,null,null,null,null,"2016-09-12",2.803791002999958,null,null,null,"Comprar longo",null,2970,{"$f":"U53-U26","v":-377},{"$f":"V53*50","v":-18850}]
[null,null,null,{"$f":"D53+1+2","v":"2014-02-14"},2293.56,-24.559999999999945,-92099.999999999796,-644775.00000000023,null,null,null,null,null,"2017-09-11",2.9286319373999845]
[null,null,null,{"$f":"D54+1","v":"2014-02-15"},2291.4299999999998,-2.1300000000001091,-7987.5000000004093,-652762.5000000007,null,null,null,null,null,"2018-09-11",2.984208005399978,null,null,null,"Comprar Spread",null,{"$f":"U53-U52","v":627}]
[null,null,null,"2014-02-16",2297.36,5.930000000000291,22237.500000001091,-630524.99999999965,null,null,null,null,null,"2019-09-11",2.9700807533999978]
[null,null,null,"2014-02-17",2275.0100000000002,-22.349999999999909,-83812.499999999665,-714337.4999999993,null,null,null,null,null,null,null,null,null,null,"Resultado",null,{"$f":"U55-U28","v":-434}]
[null,null,null,"2014-02-18",2283.12,8.1099999999996726,30412.49999999877,-683925.00000000058,null,null,null,null,null,null,null,null,null,null,"Valor p/ct",null,{"$f":"U57*50","v":-21700}]
[null,null,null,{"$f":"D58+1+2","v":"2014-02-21"},2284.4899999999998,1.3699999999998909,5137.4999999995907,-678787.50000000105]
[null,null,null,{"$f":"D59+1","v":"2014-02-22"},2306.46,21.970000000000255,82387.50000000096,-596400.00000000012]
[null,null,null,"2014-02-23",2297.56,-8.9000000000000909,-33375.000000000342,-629775.00000000047]
[null,null,null,"2014-02-24",2338.81,41.25,154687.5,-475087.50000000047]
[null,null,null,"2014-02-25",2321.21,-17.599999999999909,-65999.999999999665,-541087.50000000012]
[null,null,null,{"$f":"D63+1+2","v":"2014-02-28"},2295,-26.210000000000036,-98287.500000000131,-639375.00000000023]
[]
[]
["Ex.3",null,null,"Estimativa enviar EUR",null,2500000]
[null,null,null,"Com Hedge"]
[]
[]
[null,null,"Ev 1","12/7/x0","C",{"$f":"F67/50000","v":50},2885,"jan/x1"]
[]
[null,null,"Ev 2","18/10/x0"]
[null,null,null,"Nova estimativa lucro",null,2300000]
[null,null,null,"Rolagem de posição para março"]
[]
[null,null,null,null,"V",50,2931,"jan/x1"]
[null,null,null,null,"Resultado 1",null,{"$f":"(G77-G71)*50*F77","v":115000}]
[]
[null,null,null,null,"C",{"$f":"F74/50000","v":46},2920,"mar/X1"]
[]
[null,null,"Ev 3","31/01/x1","Apuração Lucro",null,"Valor Remessa"]
[null,null,null,null,7719125,null,{"$f":"E83*0.8","v":6175300}]
[]
[null,null,"Ev 4","10/02/x1","V",46,2957.5]
[null,null,null,null,"Resultado 2",null,{"$f":"(G85-G80)*50*F85","v":86250}]
[]
[null,null,null,null,"Contrata câmbio p/remessa:",null,2956]
[]
[null,null,null,null,"Total remessa",null,{"$f":"(G78+G83+G86)/G88*1000","v":2157154.9391069012}]
[]
[null,null,null,null,"Sem Hedge",null,{"$f":"G83/G88*1000","v":2089073.0717185384}]

{"sheet":"Futuro 2","index":7,"n_rows":56,"n_cols":5,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,1,"Em","2014-06-08"]
[]
[null,"Posição",10000000,"passivo","2014-06-30"]
[null,"Spot em 30/6",2.9933999999999998]
[null,"Cotação fut jul",2985.2]
[]
[]
[null,"Hedge"]
[null,"Compra",200,"cts","JUL"]
[]
[null,"posição em 30/6",{"$f":"C5*C6","v":29934000}]
[null,"Res. Futuro",{"$f":"(C6*1000-C7)*50*C11","v":81999.999999998181},"positivo"]
[]
[null,"Res. Hedge",{"$f":"C13-C14","v":29852000}]
[null,"Cot dólar",{"$f":"C16/C5","v":2.9851999999999999}]
[]
[]
[]
[null,2]
[]
[null,"Compra",230,"cts"]
[null,null,2600,"cotação"]
[]
[null,"Pç Ajuste",2716.8]
[]
[null,"Ajuste",{"$f":"(C26-C24)*50*C23","v":1343200.0000000021},"positivo"]
[]
[]
[null,3,"Em","2014-04-05"]
[]
[null,"Posição",1000000,"ativo","2014-04-30"]
[null,"Spot em 30/4",3.2010000000000001]
[null,"Cotação fut maio",3171]
[]
[]
[null,"Hedge"]
[null,"Venda",{"$f":"C33/50000","v":20},"cts","mai"]
[]
[null,"posição em 30/4",{"$f":"C33*C34","v":3201000}]
[null,"Res. Futuro",{"$f":"(C34*1000-C35)*50*C39","v":30000},"positivo"]
[]
[null,"Res. Hedge",{"$f":"C41-C42","v":3171000}]
[null,"Cot dólar",{"$f":"C44/C33","v":3.1709999999999998}]
[]
[]
[]
[null,4]
[]
[null,"Compra",10,"cts"]
[null,null,1751,"cotação"]
[]
[null,"Pç Ajuste no resgate",1806.7]
[]
[null,"Ajuste",{"$f":"(C54-C52)*50*C51","v":27850.000000000022},"positivo"]