{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":2,"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":"Sheet1","index":0,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["   Portfolio Profit Diagram"]
[null,null,null,null,null,null,"       Profit is calculated as payoff - future value of cost, where"]
["Start Stock Value","End Stock Value","Increment",null,null,null,"       cost = Shares*S_0 + Cash + total cost of calls and puts. Cost of"]
[0,35,1,null,null,null,"       K-calls is determined by CRR; that of K-puts by put-call parity."]
["S_0","u","d","i","Periods"]
[12,1.5,0.7,1E-3,90,null,"       Enter parameters in yellow cells and enter portfolio"]
["Strike Prices","Calls","Puts","Shares","Cash",null,"       data in columns A - E. Shares and cash are optional."]
[5,-2,null,3.2,-50,null,"       Entries in the first yellow block are for the graph."]
[10,null,1]
[15,1]
[20,-3,1,null,null,null,"S_N","Profit"]
[30,1,null,null,null,null,0,49.95410469541735]
[null,null,null,null,null,null,1,51.154104695417345]
[null,null,null,null,null,null,2,52.354104695417348]
[null,null,null,null,null,null,3,53.554104695417351]
[null,null,null,null,null,null,4,54.754104695417347]
[null,null,null,null,null,null,5,55.95410469541735]
[null,null,null,null,null,null,6,55.154104695417352]
[null,null,null,null,null,null,7,54.354104695417355]
[null,null,null,null,null,null,8,53.554104695417351]
[null,null,null,null,null,null,9,52.754104695417347]
[null,null,null,null,null,null,10,51.95410469541735]
[null,null,null,null,null,null,11,52.154104695417352]
[null,null,null,null,null,null,12,52.354104695417355]
[null,null,null,null,null,null,13,52.554104695417351]
[null,null,null,null,null,null,14,52.754104695417354]
[null,null,null,null,null,null,15,52.95410469541735]
[null,null,null,null,null,null,16,54.154104695417352]
[null,null,null,null,null,null,17,55.354104695417355]
[null,null,null,null,null,null,18,56.554104695417351]
[null,null,null,null,null,null,19,57.754104695417354]
[null,null,null,null,null,null,20,58.95410469541735,null,null,"Sample data and text example"]
[null,null,null,null,null,null,21,58.154104695417352,null,null,"Start ","End","Increment"]
[null,null,null,null,null,null,22,57.354104695417355,null,null,0,35,1]
[null,null,null,null,null,null,23,56.554104695417358,null,null,"S_0","u","d","i","Periods"]
[null,null,null,null,null,null,24,55.754104695417361,null,null,12,1.5,0.7,1E-3,90]
[null,null,null,null,null,null,25,54.95410469541735,null,null,"Strike ","Calls","Puts","Shares","Cash"]
[null,null,null,null,null,null,26,54.154104695417352,null,null,5,-2,null,3.2,-50]
[null,null,null,null,null,null,27,53.354104695417355,null,null,10,null,1]
[null,null,null,null,null,null,28,52.554104695417358,null,null,15,1]
[null,null,null,null,null,null,29,51.754104695417361,null,null,20,-3,1]
[null,null,null,null,null,null,30,50.95410469541735,null,null,30,1]
[null,null,null,null,null,null,31,51.154104695417352]
[null,null,null,null,null,null,32,51.354104695417355]
[null,null,null,null,null,null,33,51.554104695417358]
[null,null,null,null,null,null,34,51.754104695417361]
[null,null,null,null,null,null,35,51.95410469541735]

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

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