{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Plan1","Plan2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Plan1","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,8],[12,1,12,3],[13,1,13,3],[15,1,15,4],[4,1,4,2],[6,1,6,4],[11,1,11,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[2,1,2,8],[3,1,3,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[12,7,12,8],[13,7,13,8]]}
[]
[null,"CALCULADORA - MODELO BLACK & SCHOLES GENERALIZADO"]
[null,"DERIVATIVOS E RENDA FIXA - José Carlos de Souza Santos e Marcos Eugênio da Silva"]
[null,"Uso Exclusivamente Educacional"]
[null,"Selecione o tipo de opção:",null,"CALL",1]
[null,null,null,"PUT"]
[null,"Parâmetros"]
[null,"Preço do Ativo ( S )",null,null,41]
[null,"Preço de Exercício ( X )",null,null,38]
[null,"Prazo exercício - du ( T )",null,null,180]
[null,"Taxa de juros contínua (r)",null,null,0.14000000000000001]
[null,"Dividendo contínuo (q)",null,null,0.04]
[null,"Volatilidade aa ( σ)",null,null,0.3,null,0.38445420197296215,"<= Volatilidade Implícita"]
[null,"Prêmio",null,null,7.0856893046511695,null,8,"<=      Prêmio"]
[null,null,null,null,null,null,{"$f":"IFERROR(premio_CALL(E8,E9,E10,E11,E12,G13),G13)","v":7.9999172679272545},{"$f":"IFERROR(premio_PUT(E8,E9,E10,E11,E12,G13),G13)","v":2.5385912769414887}]
[null,"Análise de Sensibilidade"]
[null,null,"Gregos \"Puros\"","Gregos no Mercado","Observações",null,null,"Gregos Monetários"]
[null,"Delta ",0.73916092494347629,{"$f":"IF(C18=\"\",\"\",C18)","v":0.73916092494347629},"<= iguais",null,"$ DELTA",{"$f":"C18*E8","v":30.305597922682527}]
[null,"Gama ",2.9023913961314703E-2,{"$f":"IF(C19=\"\",\"\",C19)","v":2.9023913961314703E-2},"<= iguais",null,"$ GAMA",{"$f":"C19*(E8^2)/100","v":0.48789199368970015}]
[null,"Vega ",10.45482843620786,{"$f":"IF(C20=\"\",\"\",C20/100)","v":0.10454828436207859},"<= para cada (1%)"]
[null,"Teta",-4.2340772612207402,{"$f":"IF(C21=\"\",\"\",C21/252)","v":-1.6801893893733096E-2},"<= por dia útil"]
[null,"Rô ",16.585649012879543,{"$f":"IF(C22=\"\",\"\",C22/100)","v":0.16585649012879544},"<= para cada (1%)"]
[null,"Vanna",-0.45723659442406167,{"$f":"IF(C23=\"\",\"\",C23/100)","v":-4.5723659442406164E-3},"<= para cada (1%)"]
[null,"Volga",11.220358563427293,{"$f":"IF(C24=\"\",\"\",C24/10000)","v":1.1220358563427293E-3},"<= para cada (1%)"]
[]
[null,"d1",0.70818368183383162]
[null,"d2",0.45463740541527664]
[null,"N(d1)",0.76058440080902945]
[null,"N(d2)",0.67531494013216742]
[null,"n(d1)",0.31045988002937103]
[null,"n(d2)",0.35977151902097276]

{"sheet":"Plan2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}