{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Stocks & Options"],"not_rendered":{"images":4,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Stocks & Options","index":0,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[1,1,1,3],[1,5,1,8],[3,5,3,6],[3,7,3,8]]}
[]
[null,"Stock Calculator",{"$nulls":3},"Options Calculator"]
[]
[null,"Company Name","ABC Corp",null,null,"Buyer (Owner)",null,"Seller (Writer)"]
[null,"Ticker","$ABC",null,null,"Type","Long Call","Type","Short Call"]
[null,"Current Price",{"v":0,"d":"$0.00"},null,null,"Excercise Date","Month","Excercise Date","Month"]
[null,"Average Cost",{"v":0,"d":"$0.00"},null,null,"Strike Price",{"v":0,"d":"$0.00"},"Strike Price",{"v":0,"d":"$0.00"}]
[null,"Price Target",{"v":0,"d":"$0.00"},null,null,"Premium",{"v":0,"d":"$0.00"},"Premium",{"v":0,"d":"$0.00"}]
[null,"# of Shares Purchased",0,null,null,"# of Contracts",0,"# of Contracts",0]
[]
[null,"Cost Basis",{"$f":"C7*C9","v":{"v":0,"d":"$0.00"}},null,null,"Contract Cost",{"$f":"(G8*100)*G9","v":{"v":0,"d":"$0.00"}},"Contract Cost",{"$f":"(I8*100)*I9","v":{"v":0,"d":"$0.00"}}]
[null,"Total Equity",{"$f":"C6*C9","v":{"v":0,"d":"$0.00"}},null,null,"Intrinsic Value",{"$f":"ASVP_OptionIntrinsicValue(G5,C6,G7)","v":{"v":0,"d":"$0.00"}},"Intrinsic Value",{"$f":"ASVP_OptionIntrinsicValue(I5,C6,I7)","v":{"v":0,"d":"$0.00"}}]
[null,"Target Equity",{"$f":"C8*C9","v":{"v":0,"d":"$0.00"}},null,null,"Breakeven Price",{"$f":"ASVP_OptionBreakeven(G5,G7,G8)","v":{"v":0,"d":"$0.00"}},"Breakeven Price",{"$f":"ASVP_OptionBreakeven(I5,I7,I8)","v":{"v":0,"d":"$0.00"}}]
[null,"Total Return",{"$f":"C12-C11","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(((C12-C11)/C11), 0)","v":{"v":0,"d":"0.00%"}},null,"Profit/Loss",{"$f":"ASVP_OptionPnL(G5,C6,G7,G11)","v":{"v":0,"d":"$0.00"}},"Profit/Loss",{"$f":"ASVP_OptionPnL(I5,C6,I7,I11)","v":{"v":0,"d":"$0.00"}}]
[null,"Target Return",{"$f":"(C8*C9)-C11","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR((((C8*C9)-C11)/C11), 0)","v":{"v":0,"d":"0.00%"}},null,"Status",{"$f":"ASVP_OptionContractStatus(G5,C6,G7)","v":"At-the-Money"},"Status",{"$f":"ASVP_OptionContractStatus(I5,C6,I7)","v":"At-the-Money"}]
[]
[{"$nulls":5},"Calculator Functions"]
[{"$nulls":5},"ASVP_OptionPnL(optionType, currentPrice, strikePrice, contractCost)"]
[{"$nulls":5},"ASVP_OptionIntrinsicValue(optionType, currentPrice, strikePrice)"]
[{"$nulls":5},"ASVP_OptionContractStatus(optionType, currentPrice, strikePrice)"]
[{"$nulls":5},"ASVP_OptionTimeValue(premium, intrinsicValue)"]
[{"$nulls":5},"ASVP_OptionBreakeven(optionType, strikePrice, premium)"]