{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["List1"],"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":"List1","index":0,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vyplň zelená pole!!!",null,null,"Vyplň žlutá pole!!!"]
[null,"Cena podkladu",null,89.86,null,null,"Cena Call",null,"Strike",null,"Cena Put",null,null,null,null,null,"Vstup",null,null,"Scénář"]
[null,"Entry datum",null,"2020-05-19",null,null,{"$f":"CallCena($D$3,I4,$D$14,$D$7,$D$6,$D$8)","v":7.1249382931546492},"ITM",{"$f":"I5-$D$11","v":85},"OTM",{"$f":"PutCena($D$3,I4,$D$14,$D$7,$D$6,$D$8)","v":2.2288500658548465},null,null,null,null,null,"Vstup dne","2020-05-19",null,"Výstup dne","2020-05-19"]
[null,"Exit datum",null,"2020-06-19",null,null,{"$f":"CallCena($D$3,I5,$D$14,$D$7,$D$6,$D$8)","v":6.4876627457870057},"ITM",86,"OTM",{"$f":"PutCena($D$3,I5,$D$14,$D$7,$D$6,$D$8)","v":2.5911499511071803},null,null,null,null,null,"Expirace","2020-06-19"]
[null,"Volatilita",null,0.41699999999999998,null,null,5.8867920515216881,"ITM",87,"OTM",2.9898546894618718,null,null,null,null,null,"Dividenda",0]
[null,"Úroky",null,5.0000000000000001E-3,null,null,5.3227967387544055,"ITM",88,"OTM",3.4254348093146021,null,null,null,null,null,"Úroky",5.0000000000000001E-3]
[null,"Dividenda",null,0,null,null,4.7958176868137414,"ITM",{"$f":"I9-$D$11","v":89},"OTM",3.8980311899939366]
[null,null,null,null,null,null,4.305673487934385,"ATM",{"$f":"ROUND(D3,0)","v":90},"ATM",4.4074624237345859,null,null,null,null,null,"Aktuální Cena",89.86,null,"Cena",89.86]
[null,"Strike",null,91,null,null,3.8518757346749695,"OTM",{"$f":"I9+$D$11","v":91},"ITM",4.9532401030951547,null,null,null,null,null,"Implied Volatility",0.41699999999999998,null,"Implied Volatility",0.41699999999999998]
[null,"Krok Strike",null,1,null,null,3.4336511640633773,"OTM",{"$f":"I10+$D$11","v":92},"ITM",5.5345909651035683]
[null,null,null,null,null,null,3.0499693982628457,"OTM",93,"ITM",6.1504846319230495,null,null,null,null,null,"Call ",null,"cntr","Strike "]
[null,"Do expirace (dny)",null,{"$f":"D5-D4","v":31},null,null,2.6995749127522508,"OTM",94,"ITM",6.7996655790324425,null,null,null,null,null,89,{"$f":"CallCena($R$9,Q13,($R$5-$R$4)/365,$R$7,$R$10,$R$6)","v":4.7958176868137414},1,{"$f":"Q13","v":89},{"$f":"CallCena($U$9,T13,($R$5-$U$4)/365,$R$7,$U$10,$R$6)","v":4.7958176868137414}]
[null,"Život opce (roční)",null,{"$f":"(D5-D4)/365","v":8.4931506849315067E-2},null,null,2.3810218328014159,"OTM",95,"ITM",7.4806879317016168,null,null,null,null,null,94,{"$f":"CallCena($R$9,Q14,($R$5-$R$4)/365,$R$7,$R$10,$R$6)","v":2.6995749127522508},-2,{"$f":"Q14","v":94},{"$f":"CallCena($U$9,T14,($R$5-$U$4)/365,$R$7,$U$10,$R$6)","v":2.6995749127522508}]
[null,null,null,null,null,null,2.0927101988308365,"OTM",{"$f":"I14+$D$11","v":96},"ITM",8.1919517303510432,null,null,null,null,null,99,{"$f":"CallCena($R$9,Q15,($R$5-$R$4)/365,$R$7,$R$10,$R$6)","v":1.3916717159963561},1,{"$f":"Q15","v":99},{"$f":"CallCena($U$9,T15,($R$5-$U$4)/365,$R$7,$U$10,$R$6)","v":1.3916717159963561}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Put"]
[null,"=CallCena(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,{"$f":"PutCena($R$9,Q17,($R$5-$R$4)/365,$R$7,$R$10,$R$6)","v":3.8980311899939366},0,{"$f":"Q17","v":89},{"$f":"PutCena($U$9,T17,($R$5-$U$4)/365,$R$7,$U$10,$R$6)","v":3.8980311899939366}]
[null,{"$f":"CallCena(D3,D10,D14,D7,D6,D8)","v":3.8518757346749695}," =CallCena(D3;D10;D13;D7;D6;D8)",null,null,null,null,null,null,null,null,null,null,null,null,null,94,{"$f":"PutCena($R$9,Q18,($R$5-$R$4)/365,$R$7,$R$10,$R$6)","v":6.7996655790324425},0,{"$f":"Q18","v":94},{"$f":"PutCena($U$9,T18,($R$5-$U$4)/365,$R$7,$U$10,$R$6)","v":6.7996655790324425}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,{"$f":"PutCena($R$9,Q19,($R$5-$R$4)/365,$R$7,$R$10,$R$6)","v":10.489639545376562},0,{"$f":"Q19","v":99},{"$f":"PutCena($U$9,T19,($R$5-$U$4)/365,$R$7,$U$10,$R$6)","v":10.489639545376562}]
[null,"=PutCena(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)"]
[null,{"$f":"PutCena(D3,D10,D14,D7,D6,D8)","v":4.9532401030951547}," =PutCena(D3;D10;D13;D7;D6;D8)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Teoretický vstup",{"$f":"(((S13*R13)+(S14*R14)+(S15*R15))*-100) +(((S17*R17)+(S18*R18)+(S19*R19))*-100)","v":-78.83395773055959},null,"Teoretický výstup",{"$f":"(((U13*S13)+(U14*S14)+(U15*S15))*100)+(((U17*S17)+(U18*S18)+(U19*S19))*100)","v":78.83395773055959},"P/L",{"$f":"(R21+U21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reálný vstup",-114.8,null,"Reálný výstup",null,"P/L",{"$f":"(R22+U21)","v":-35.966042269440408}]
[null,"=DeltaCall(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)"]
[null,{"$f":"DeltaCall(D3,D10,D14,D7,D6,D8)","v":0.48425464491865289},"=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.51574535508134711},"=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.6503520845399103E-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":-7.0756219605652843E-2},"=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":-6.9510173518414209E-2},"=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.10439326193042489},"=VegaOpce(D3;D10;D14;D7;D6;D8)"]