{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ماشین حساب"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":22,"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":"ماشین حساب","index":0,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,9],[21,0,27,9]]}
["جهت استفاده مناسب از این فایل اکسل لطفا فرمول سلولها را تغییر ندهید. فقط اعداد قرارداد را در ستون آبی رنگ وارد نمایید و نتایج را در ستون زردرنگ مشاهده بفرمایید."]
[]
[null,null,null,null,null,null,null,null,"بلک شولز Call"]
["Stock قیمت دارایی پایه",543]
["Exercise قیمت اعمال",450]
["Rate نرخ بهره",0.25]
["Sigma نوسان پذیری",0.44]
["Time زمان تا سررسید",{"$f":"115/365","v":0.31506849315068491}]
[]
[null,null,null,null,null,null,null,null,"بلک شولز Put"]
[]
[]
["d_1",{"$f":"(LN(Stock/Exercise)+(Rate+(Sigma^2)/2)*Time)/(Sigma*SQRT(Time))","v":1.2030610618131057},null,{"$f":"GetCF(d_1)","v":"B13:  =(LN(Stock/Exercise)+(Rate+(Sigma^2)/2)*Time)/(Sigma*SQRT(Time))"}]
["d_2",{"$f":"(LN(Stock/Exercise)+(Rate-(Sigma^2)/2)*Time)/(Sigma*SQRT(Time))","v":0.95608482758403546},null,{"$f":"GetCF(d_2)","v":"B14:  =(LN(Stock/Exercise)+(Rate-(Sigma^2)/2)*Time)/(Sigma*SQRT(Time))"}]
["Nd_1",{"$f":"_xlfn.NORM.S.DIST(d_1,TRUE)","v":0.88552365398002875},null,{"$f":"GetCF(Nd_1)","v":"B15:  =NORM.S.DIST(d_1,TRUE)"}]
["Nd_2",{"$f":"_xlfn.NORM.S.DIST(d_2,TRUE)","v":0.8304853102249149},null,{"$f":"GetCF(Nd_2)","v":"B16:  =NORM.S.DIST(d_2,TRUE)"}]
["Nminusd_1",{"$f":"_xlfn.NORM.S.DIST(-d_1,TRUE)","v":0.11447634601997128},null,{"$f":"GetCF(Nminusd_1)","v":"B17:  =NORM.S.DIST(-d_1,TRUE)"}]
["Nminusd_2",{"$f":"_xlfn.NORM.S.DIST(-d_2,TRUE)","v":0.16951468977508508},null,{"$f":"GetCF(Nminusd_2)","v":"B18:  =NORM.S.DIST(-d_2,TRUE)"}]
["Call",{"$f":"Stock*Nd_1-Exercise*EXP(-Rate*Time)*Nd_2","v":135.42820277468229},null,{"$f":"GetCF(B19)","v":"B19:  =Stock*Nd_1-Exercise*EXP(-Rate*Time)*Nd_2"}]
["Put",{"$f":"Exercise*EXP(-Rate*Time)*Nminusd_2-Stock*Nminusd_1","v":8.3430143719251788},null,{"$f":"GetCF(B20)","v":"B20:  =Exercise*EXP(-Rate*Time)*Nminusd_2-Stock*Nminusd_1"}]
[]
["ما را در صفحات اجتماعی دنبال کنید\nwww.optionbaaz.ir\nInstagram: @optionbaaz\nTelegram: @optionbaaz\n\n"]