{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["List1","Funkce skew"],"not_rendered":{"charts":1,"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":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Cena podkladu",null,272,null,null,"=CallCena(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)",null,null,null,null,null,null,null,null,"=IV(CenaPodkladu, Strike, Volatilita, P1, P2)"]
[null,"Entry datum",null,"2018-07-03",null,null,{"$f":"CallCena(D3,D10,D14,D7,D6,D8)","v":1.2000955750794162}," =CallCena(D3;D10;D13;D7;D6;D8)"]
[null,"Exit datum",null,"2018-07-06"]
[null,"Volatilita",null,0.12,null,null,"=PutCena(CenaPodkladu, Strike, ZivotOpce, Uroky, Volatilita, Dividenda)"]
[null,"Úroky",null,1.7500000000000002E-2,null,null,{"$f":"PutCena(D3,D10,D14,D7,D6,D8)","v":1.1609751009344222}," =PutCena(D3;D10;D13;D7;D6;D8)"]
[null,"Dividenda",null,0]
[]
[null,"Strike",null,272,null,null,"Cena Call",null,"Strike",null,"Cena Put","IV"]
[null,"Krok Strike",null,1,null,null,{"$f":"CallCena($D$3,I11,$D$14,$D$7,L11,$D$8)","v":5.2265246535512233},"ITM",{"$f":"I12-$D$11","v":267},"OTM",{"$f":"PutCena($D$3,I11,$D$14,$D$7,L11,$D$8)","v":0.18812330576913538},{"$f":" IV($D$3,I11,$D$6,$D$17,$D$18)","v":0.16139188984383643}]
[null,null,null,null,null,null,{"$f":"CallCena($D$3,I12,$D$14,$D$7,L12,$D$8)","v":4.2994191726154725},"ITM",268,"OTM",{"$f":"PutCena($D$3,I12,$D$14,$D$7,L12,$D$8)","v":0.26087399956077206},0.15166818985854946]
[null,"Do expirace (dny)",null,{"$f":"D5-D4","v":3},"=D5-D4",null,3.4090819367148981,"ITM",269,"OTM",0.37039293838762433,0.1424231569130793]
[null,"Život opce (roční)",null,{"$f":"(D5-D4)/365","v":8.21917808219178E-3},"=(D5-D4)/365",null,2.5750938093875106,"ITM",270,"OTM",0.53626098578762083,0.13378438025996442]
[null,null,null,null,null,null,1.8254533022326598,"ITM",{"$f":"I16-$D$11","v":271},"OTM",0.78647665336021078,0.126]
[null,"Parametry funkce skew y=xP1/P2",null,null,null,null,1.2000955750794162,"ATM",{"$f":"ROUND(D3,0)","v":272},"ATM",1.1609751009344222,0.12]
[null,"P1",null,1.2,null,null,0.71051212401832231,"OTM",{"$f":"I16+$D$11","v":273},"ITM",1.6712478246006981,0.11428571428571428]
[null,"P2",null,20,null,null,0.3579199793394352,"OTM",{"$f":"I17+$D$11","v":274},"ITM",2.3185118546492447,0.10763588374082608]
[null,null,null,null,null,null,0.14621271904070454,"OTM",275,"ITM",3.1066607690778767,0.10110715358449963]
[null,null,null,null,null,null,4.5347679960459075E-2,"OTM",276,"ITM",4.0056519047250845,9.4944101419222396E-2]
[null,null,null,null,null,null,9.8421579105449908E-3,"OTM",277,"ITM",4.9700025574025517,8.9223814244529312E-2]
[null,null,null,null,null,null,1.3559993065044296E-3,"OTM",{"$f":"I21+$D$11","v":278},"ITM",5.9613725735259209,8.3957726694210019E-2]
[null,null,null," "]

{"sheet":"Funkce skew","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"=IV(CenaPodkladu, Strike, Volatilita, P1, P2)",null,null,null,null,null,null,null,null,"Parametry funkce skew y=xP1/P2"]
[null,null,null,null,null,null,"strike","IV"]
[null,"Cena podkladu",null,0,null,null,5,{"$f":"IV($D$4,G4,$D$5,$D$6,$D$7)","v":7.4813758019896044}]
[null,"Volatilita",null,12,null,null,4,{"$f":"IV($D$4,G5,$D$5,$D$6,$D$7)","v":8.5458454574249139}]
[null,"P1",null,1.8,null,null,3,9.6710047604433278]
[null,"P2",null,30,null,null,2,10.75198092639681,null,"IV \"střední\" se funkcí dělí pro strikes vyšší než cena podkladu a násobí pro strikes nižší než cena podkladu."]
[null,null,null,null,null,null,1,11.61290322580645,null,"Pro SPY dne 3.7.2018 pro expiraci 3 dny vyhovovalo P1 = 1.2 a P2 = 20"]
[null,null,null,null,null,null,0,12]
[null,null,null,null,null,null,-1,12.400000000000002]
[null,null,null,null,null,null,-2,13.392880901273799]
[null,null,null,null,null,null,-3,14.889869622336832]
[null,null,null,null,null,null,-4,16.850293012833273]
[null,null,null,null,null,null,-5,19.247796636776954]