{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["公式应用示例","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,4,7,9]]}
["资产价格(S)",50,null,null,"操作说明：1.该工作簿中有10个自定义函数：其中bs_call()计算的是欧式看涨期权的价值；bs_put计算的是欧式看跌期权的价值;其他为希腊字母计算函数。参数依次表示：标的资产价格，标的资产的波动率，无风险利率，红利率，期权到期期限（以年为单位），执行价格。参数个数不可缺少，顺序不可倒换",null,null,null,null,null,"函数名"]
["资产波动率(σ)",0.38519100000000001,null,null,null,null,null,null,null,null,"bs_call(S,σ,rf,q,T,X)"]
["无风险利率（ r )",0.03,null,null,null,null,null,null,null,null,"bs_put(S,σ,rf,q,T,X)"]
["红利率(q)",0,null,null,null,null,null,null,null,null,"delta_call(S,σ,rf,q,T,X)"]
["到期期限(T,year)",1,null,null,null,null,null,null,null,null,"delta_put(S,σ,rf,q,T,X)"]
["执行价格（X）",50,null,null,null,null,null,null,null,null,"gamma_opt(S,σ,rf,q,T,X)"]
[null,null,null,null,null,null,null,null,null,null,"vega(S,σ,rf,q,T,X)"]
["d1",{"$f":"(LN(S/X)+(rf-q+σ^2/2)*T)/(σ*SQRT(T))","v":0.27047893964422842},null,null,null,null,null,null,null,null,"theta_call(S,σ,rf,q,T,X)"]
["d2",{"$f":"B8-σ*SQRT(T)","v":-0.11471206035577158},null,null,null,null,null,null,null,null,"theta_put(S,σ,rf,q,T,X)"]
[null,null,null,null,null,null,null,null,null,null,"rho_call(S,σ,rf,q,T,X)"]
["看涨期权B-S",{"$f":"BS_call(S,σ,rf,q,T,X)","v":8.2847546216057815},null,null,null,null,null,null,null,null,"rho_put(S,σ,rf,q,T,X)"]
["看跌期权B-S",{"$f":"BS_put(S,σ,rf,q,T,X)","v":6.8070312990311912}]
[]
["delta_call",{"$f":"delta_call(S,σ,rf,q,T,X)","v":0.60660409147791616}]
["delta_put",{"$f":"delta_put(S,σ,rf,q,T,X)","v":-0.39339590852208384}]
["gamma",{"$f":"gamma_opt(S,σ,rf,q,T,X)","v":1.9969982593020554E-2}]
["vega",{"$f":"vega(S,σ,rf,q,T,X)","v":19.230643912470452}]
["theta_call",{"$f":"theta_call(S,σ,rf,q,T,X)","v":-4.3650989782129042}]
["theta_put",{"$f":"theta_put(S,σ,rf,q,T,X)","v":-2.9094306778901418}]
["rho_call",{"$f":"rho_call(S,σ,rf,q,T,X)","v":22.045449952290028}]
["rho_put",{"$f":"rho_put(S,σ,rf,q,T,X)","v":-26.476826725135382}]

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

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