{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Ceny opcí"],"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":"Ceny opcí","index":0,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Cena podkladu",null,175.07,null,null,null,null,null,"Cena Call",null,"Strike",null,"Cena Put"]
[null,"Entry datum",null,"2019-06-05",null,null,null,null,null,{"$f":"CallCena($D$3,L4,$D$14,$D$7,$D$6,$D$8)","v":13.524439024263614},"ITM",{"$f":"L5-$D$11","v":162.5},"OTM",{"$f":"PutCena($D$3,L4,$D$14,$D$7,$D$6,$D$8)","v":0.82982929164180419}]
[null,"Exit datum",null,"2019-06-21",null,null,null,null,null,11.462102661841016,"ITM",165,"OTM",1.2655758564096189]
[null,"Volatilita",null,0.33179999999999998,null,null,null,null,null,9.5536195961400807,"ITM",167.5,"OTM",1.8551757178991153]
[null,"Úroky",null,1.7500000000000002E-2,null,null,null,null,null,7.8221161582885941,"ITM",170,"OTM",2.6217552072380599]
[null,"Dividenda",null,0,null,null,null,null,null,6.284750792979878,"ITM",{"$f":"L9-$D$11","v":172.5},"OTM",3.5824727691197467]
[null,null,null,null,null,null,null,null,null,4.9508758212954831,"ATM",{"$f":"ROUND(D3,0)","v":175},"ATM",4.7466807246258185]
[null,"Strike",null,175,null,null,null,null,null,3.8211995586785434,"OTM",{"$f":"L9+$D$11","v":177.5},"ITM",6.1150873891993172]
[null,"Krok Strike",null,2.5,null,null,null,null,null,2.8880520801140008,"OTM",{"$f":"L10+$D$11","v":180},"ITM",7.68002283782522]
[null,null,null,null,null,null,null,null,null,2.1366286109096961,"OTM",182.5,"ITM",9.4266822958113323]
[null,"Do expirace (dny)",null,{"$f":"D5-D4","v":16},"=D5-D4",null,null,null,null,1.5469100998518357,"OTM",185,"ITM",11.335046711943846]
[null,"Život opce (roční)",null,{"$f":"(D5-D4)/365","v":4.3835616438356165E-2},"=(D5-D4)/365",null,null,null,null,1.0958787997157842,"OTM",187.5,"ITM",13.382098338998276]
[null,null,null,null,null,null,null,null,null,0.75966180961300722,"OTM",{"$f":"L14+$D$11","v":190},"ITM",15.543964276085916]
[]
[null,"=CallCena(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)"]
[null,{"$f":"CallCena(D3,D10,D14,D7,D6,D8)","v":4.9508758212954831}," =CallCena(D3;D10;D13;D7;D6;D8)"]
[]
[null,"=PutCena(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)"]
[null,{"$f":"PutCena(D3,D10,D14,D7,D6,D8)","v":4.7466807246258185}," =PutCena(D3;D10;D13;D7;D6;D8)"]
[]
[null,"=DeltaCall(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)"]
[null,{"$f":"DeltaCall(D3,D10,D14,D7,D6,D8)","v":0.52054997028536154},"=DeltaCall(D3;D10;D14;D7;D6;D8)"]
[]
[null,"=DeltaPut(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)"]
[null,{"$f":"DeltaPut(D3,D10,D14,D7,D6,D8)","v":-0.47945002971463846},"=DeltaPut(D3;D10;D14;D7;D6;D8)"]
[]
[null,"=GammaOpce(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)"]
[null,{"$f":"GammaOpce(D3,D10,D14,D7,D6,D8)","v":3.2759080648698126E-2},"=GammaOpce(D3;D10;D14;D7;D6;D8)"]
[]
[null,"=ThetaCall(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)"]
[null,{"$f":"ThetaCall(D3,D10,D14,D7,D6,D8)","v":-0.15555264255101275},"=ThetaCall(D3;D10;D14;D7;D6;D8)"]
[]
[null,"=ThetaPut(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)"]
[null,{"$f":"ThetaPut(D3,D10,D14,D7,D6,D8)","v":-0.14716866560359282},"=ThetaPut(D3;D10;D14;D7;D6;D8)"]
[]
[null,"=VegaOpce(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)"]
[null,{"$f":"VegaOpce(D3,D10,D14,D7,D6,D8)","v":0.14603557621020699},"=VegaOpce(D3;D10;D14;D7;D6;D8)"]