{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["操作说明","主界面","数据表"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["期权模拟交易游戏----四大基本策略的使用"]
["设计思路："]
["本模拟交易借鉴了CBOE的期权游戏的思路，以EXCEL为工具，进行单机版的期权模拟操作。"]
["本版本目前支持期权的四大基本策略的使用，组合策略尚待后续完善。"]
[]
["使用说明："]
["在本游戏中，用户将初始具备一定的资金（10，000），来进行期权的投资操作。每次交易的期权的有效期为一步，即行情每往后一步，前步的期权将到期交割。"]
["标的ETF的初始价格为1元，在每一步中，标的ETF的变动方向由两个因素驱动，一个是预报的方向，另一个是随机因素，两者共同确定了标的ETF的下一步走势。"]
["用户在下单之前，可以看到标的ETF的当前最新价格、对应的几个期权的市场价格、以及关于下一步行情的预报。根据上述信息，用户需要做出期权投资决策。"]
["下单之后，系统将行情推演至下一步，并依据最新行情中的标的ETF价格来计算前次期权交易的盈亏，同时展示用户总资金变动的曲线及操作细节信息。"]
["另外，对于每一个策略，都会有交易金额、盈亏平衡点、盈亏曲线图等辅助性提示。"]
[]
["主要操作按钮：",null,"重置","表示重新初始化，重新开始游戏"]
[null,null,"下单，看结果","表示往后推演一步。下单前，根据对行情的预判以及对可承受风险的评估，"]
[null,null,null,"做出选择“买入”或“卖出”、交易哪个品种、交易多少数量的决策。"]
[]
["行情预报的含义：",null,null,null,"随机因素："]
["市场将有大利好",null,"一步上涨5%",null,"每一步标的ETF的波动率为10%"]
["市场将有小利好",null,"一步上涨2%"]
["市场将风平浪静",null,"价格不变"]
["市场将有小利空来袭",null,"一步下跌2%"]
["市场将有大利空来袭",null,"一步下跌5%"]
[]
[]
["*为了本游戏能顺利操作，请务必启用EXCEL宏内容。"]

{"sheet":"主界面","index":1,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[24,0,27,2]]}
["期权模拟交易----四大基本策略的使用"]
[]
["标的ETF走势",null,null,null,null,null,"标的最新价格：",null,1,null,null,"总资金：",10000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["下步预报：\n市场将风平浪静",null,null,null,"目前的期权行情",null,null,null,null,"交易决策",null,"选择交易品种",null,"设置交易数量"]
[null,null,null,null,"CALL","行权价","PUT",null,null,null,null,null,null,1]
[null,null,null,null,2.06E-2,{"$f":"F28*1.05","v":1.05},7.0599999999999996E-2]
[null,null,null,null,3.9899999999999998E-2,{"$f":"I3","v":1},3.9899999999999998E-2,null,null,null,null,null,"交易金额：",{"$f":"K29*数据表!L9*N26","v":399}]
[null,null,null,null,6.8900000000000003E-2,{"$f":"F28*0.95","v":0.95},1.89E-2,null,null,"合约单位为",10000,null,"盈亏平衡点",{"$f":"数据表!L12","v":1.0399}]
[]
["交易记录："]

{"sheet":"数据表","index":2,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["分时数据区域，每步结果"]
["步骤",510050,null,null,"盈亏","总资产",null,null,"买入",1,null,"CALL-1.050",2]
[0,1,null,null,null,10000,null,null,"卖出",null,null,"CALL-1.000"]
[1,null,null,null,null,null,null,null,null,null,null,"CALL-0.950"]
[2,null,null,null,null,null,null,null,null,null,null,"PUT-0.950"]
[3,null,null,null,null,null,null,null,null,null,null,"PUT-1.000"]
[4,null,null,null,null,null,null,null,null,null,null,"PUT-1.050"]
[5]
[6,null,null,null,null,null,null,null,null,null,"期权价格",{"$f":"IF(M2=1,主界面!E27,IF(M2=2,主界面!E28,IF(M2=3,主界面!E29,IF(M2=4,主界面!G29,IF(M2=5,主界面!G28,IF(M2=6,主界面!G27,\"\"))))))","v":3.9899999999999998E-2}]
[7,null,null,null,null,null,null,null,null,null,"S",{"$f":"主界面!I3","v":1}]
[8,null,null,null,null,null,null,null,null,null,"K",{"$f":"IF(OR($M$2=1,$M$2=6),L10*1.05,IF(OR($M$2=2,$M$2=5),L10,L10*0.95))","v":1}]
[9,null,null,null,null,null,null,null,null,null,"盈亏平衡点",{"$f":"IF($M$2<4,$L$11+$L$9,$L$11-$L$9)","v":1.0399}]
[10]
[]
[]
[]
["股票价格",null,{"$f":"D17-0.05","v":0.74999999999999978},0.79999999999999982,0.84999999999999987,0.89999999999999991,{"$f":"H17-0.05","v":0.95},{"$f":"$L$11","v":1},{"$f":"H17+0.05","v":1.05},{"$f":"I17+0.05","v":1.1000000000000001},1.1500000000000001,1.2000000000000002,1.2500000000000002]
["期权损益",null,{"$f":"IF(AND($J$2=1,$M$2<4),MAX(C17-$L$11,0)-$L$9,IF(AND($J$2=1,$M$2>3),MAX($L$11-C17,0)-$L$9,IF(AND($J$2=2,$M$2<4),$L$9-MAX(C17-$L$11,0),IF(AND($J$2=2,$M$2>3),$L$9-MAX($L$11-C17,0),))))","v":-3.9899999999999998E-2},-3.9899999999999998E-2,-3.9899999999999998E-2,-3.9899999999999998E-2,-3.9899999999999998E-2,-3.9899999999999998E-2,1.0100000000000046E-2,6.0100000000000091E-2,0.11010000000000014,0.16010000000000019,0.21010000000000023]