{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["many bonds","single bond","Sheet3"],"not_rendered":{"charts":0,"images":0,"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":"many bonds","index":0,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"settlement date"]
[null,null,null,"2008-07-15"]
[]
["CUSIP","MATURITY","CPN","NXT_CPN_DT","ID_BB","ASK","YLD_YTM_MID","YLD_YTM_BID","YLD_YTM_ASK","PX_CLEAN_ASK","PX_DIRTY_ASK","price(ytm_ask)","YTM(ask)","diff price","diff YTM"]
["9128275G3","5/15/2009",5.5,"11/15/2008",102.75,102.78125,2.1339999999999999,2.1520000000000001,2.1150000000000002,102.78125,103.69293478,{"$f":"bondValue(C5,$D$2,B5,I5/100)","v":103.69578174477144},{"$f":"YTM(K5, C5, $D$2, B5)*100","v":2.1191406250000004},{"$f":"K5-L5","v":-2.846964771435978E-3},{"$f":"I5-M5","v":-4.1406250000002309E-3}]
["912828FM7","7/31/2008",5,"7/31/2008",100.125,100.15625,1.758,2.1059999999999999,1.411,100.15625,102.43646978,{"$f":"bondValue(C6,$D$2,B6,I6/100)","v":102.4368437003867},{"$f":"YTM(K6, C6, $D$2, B6)*100","v":1.40625},{"$f":"K6-L6","v":-3.7392038670702732E-4},{"$f":"I6-M6","v":4.750000000000032E-3}]
["912828FV7","10/31/2008",4.875,"10/31/2008",100.875,100.90625,1.806,1.859,1.7529999999999999,100.90625,101.91304348,{"$f":"bondValue(C7,$D$2,B7,I7/100)","v":101.90983965942469},{"$f":"YTM(K7, C7, $D$2, B7)*100","v":1.7431640625000002},{"$f":"K7-L7","v":3.2038205753082138E-3},9.8359374999996696E-3]
["912828GE4","1/31/2009",4.875,"7/31/2008",101.578125,101.609375,1.9139999999999999,1.9430000000000001,1.8859999999999999,101.609375,103.83258929,{"$f":"bondValue(C8,$D$2,B8,I8/100)","v":103.81431304942573},{"$f":"YTM(K8, C8, $D$2, B8)*100","v":1.8530273437500002},{"$f":"K8-L8","v":1.8276240574266467E-2},3.2972656249999677E-2]
["912828FE5","5/15/2009",4.875,"11/15/2008",102.15625,102.1875,2.2290000000000001,2.2480000000000002,2.2109999999999999,102.1875,102.99558424,{"$f":"bondValue(C9,$D$2,B9,I9/100)","v":102.99805340041021},{"$f":"YTM(K9, C9, $D$2, B9)*100","v":2.2143554687500004},{"$f":"K9-L9","v":-2.4691604102144993E-3},-3.3554687500005898E-3]
["912828GT1","5/31/2009",4.875,"11/30/2008",102.265625,102.296875,2.2309999999999999,2.2490000000000001,2.2130000000000001,102.296875,102.89626025,{"$f":"bondValue(C10,$D$2,B10,I10/100)","v":102.8911492021121},{"$f":"YTM(K10, C10, $D$2, B10)*100","v":2.20703125},{"$f":"K10-L10","v":5.1110478878939603E-3},5.9687500000000782E-3]
["9128274V1","11/15/2008",4.75,"11/15/2008",100.921875,100.953125,1.9119999999999999,1.958,1.8660000000000001,100.953125,101.74048913,{"$f":"bondValue(C11,$D$2,B11,I11/100)","v":101.73623482385875},{"$f":"YTM(K11, C11, $D$2, B11)*100","v":1.8554687500000004},{"$f":"K11-L11","v":4.2543061412487759E-3},1.0531249999999659E-2]
["912828GB0","12/31/2008",4.75,"12/31/2008",101.28125,101.3125,1.8979999999999999,1.9319999999999999,1.8640000000000001,101.3125,101.50611413,{"$f":"bondValue(C12,$D$2,B12,I12/100)","v":101.49930357769931},{"$f":"YTM(K12, C12, $D$2, B12)*100","v":1.8505859375000002},{"$f":"K12-L12","v":6.8105523006920521E-3},1.3414062499999879E-2]
["912828FT2","9/30/2008",4.625,"9/30/2008",100.609375,100.640625,1.6220000000000001,1.6950000000000001,1.5489999999999999,100.640625,101.98010587,{"$f":"bondValue(C13,$D$2,B13,I13/100)","v":101.97999750080335},{"$f":"YTM(K13, C13, $D$2, B13)*100","v":1.552734375},{"$f":"K13-L13","v":1.083691966528022E-4},-3.7343750000000675E-3]
["912828FZ8","11/30/2008",4.625,"11/30/2008",101.0625,101.09375,1.7370000000000001,1.778,1.696,101.09375,101.66239754,{"$f":"bondValue(C14,$D$2,B14,I14/100)","v":101.66129154254463},{"$f":"YTM(K14, C14, $D$2, B14)*100","v":1.6943359375000002},{"$f":"K14-L14","v":1.1059974553688789E-3},1.66406249999973E-3]
["912828GL8","3/31/2009",4.5,"9/30/2008",101.625,101.65625,2.1560000000000001,2.1779999999999999,2.1339999999999999,101.65625,102.95952869,{"$f":"bondValue(C15,$D$2,B15,I15/100)","v":102.96721389198485},{"$f":"YTM(K15, C15, $D$2, B15)*100","v":2.1435546875},{"$f":"K15-L15","v":-7.6852019848558939E-3},-9.554687500000103E-3]
["912828GP9","4/30/2009",4.5,"10/31/2008",101.8125,101.84375,2.16,2.1800000000000002,2.14,101.84375,102.77309783,{"$f":"bondValue(C16,$D$2,B16,I16/100)","v":102.77698271630618},{"$f":"YTM(K16, C16, $D$2, B16)*100","v":2.14599609375},{"$f":"K16-L16","v":-3.8848863061815564E-3},-5.9960937499998757E-3]
["912828EL0","11/15/2008",4.375,"11/15/2008",100.796875,100.828125,1.915,1.9610000000000001,1.8680000000000001,100.828125,101.5533288,{"$f":"bondValue(C17,$D$2,B17,I17/100)","v":101.54922663713364},{"$f":"YTM(K17, C17, $D$2, B17)*100","v":1.8554687500000004},{"$f":"K17-L17","v":4.102162866360004E-3},1.2531249999999661E-2]
["912828CH1","5/15/2009",3.875,"11/15/2008",101.359375,101.390625,2.2000000000000002,2.218,2.181,101.390625,102.03294837,{"$f":"bondValue(C18,$D$2,B18,I18/100)","v":102.03575020917111},{"$f":"YTM(K18, C18, $D$2, B18)*100","v":2.18505859375},{"$f":"K18-L18","v":-2.8018391711128743E-3},-4.0585937499999503E-3]
["912828BQ2","11/15/2008",3.375,"11/15/2008",100.46875,100.5,1.9059999999999999,1.952,1.859,100.5,101.05944293,{"$f":"bondValue(C19,$D$2,B19,I19/100)","v":101.05538623343639},{"$f":"YTM(K19, C19, $D$2, B19)*100","v":1.8457031250000004},{"$f":"K19-L19","v":4.0566965636088526E-3},1.3296874999999542E-2]
["912828BT6","12/15/2008",3.375,"12/15/2008",100.609375,100.640625,1.863,1.9,1.8260000000000001,100.640625,100.91726434,{"$f":"bondValue(C20,$D$2,B20,I20/100)","v":100.91564030780847},{"$f":"YTM(K20, C20, $D$2, B20)*100","v":1.8212890625000002},{"$f":"K20-L20","v":1.6240321915290679E-3},4.7109374999998455E-3]
["912828BV1","1/15/2009",3.25,"1/15/2009",100.671875,100.703125,1.8620000000000001,1.8939999999999999,1.831,100.703125,100.703125,{"$f":"bondValue(C21,$D$2,B21,I21/100)","v":100.69552065194887},{"$f":"YTM(K21, C21, $D$2, B21)*100","v":1.8164062500000002},{"$f":"K21-L21","v":7.6043480511316375E-3},1.4593749999999739E-2]
["912828BK5","9/15/2008",3.125,"9/15/2008",100.234375,100.265625,1.62,1.712,1.528,100.265625,101.30163043,{"$f":"bondValue(C22,$D$2,B22,I22/100)","v":101.30023491946076},{"$f":"YTM(K22, C22, $D$2, B22)*100","v":1.5234375},{"$f":"K22-L22","v":1.3955105392398082E-3},4.5625000000000249E-3]
["912828BM1","10/15/2008",3.125,"10/15/2008",100.359375,100.390625,1.615,1.6759999999999999,1.5529999999999999,100.390625,101.16760587,{"$f":"bondValue(C23,$D$2,B23,I23/100)","v":101.16724930904736},{"$f":"YTM(K23, C23, $D$2, B23)*100","v":1.552734375},{"$f":"K23-L23","v":3.5656095263902898E-4},2.6562499999993605E-4]
["912828CE8","4/15/2009",3.125,"10/15/2008",100.6875,100.71875,2.1739999999999999,2.1949999999999998,2.153,100.71875,101.49573087,{"$f":"bondValue(C24,$D$2,B24,I24/100)","v":101.49693648624837},{"$f":"YTM(K24, C24, $D$2, B24)*100","v":2.1533203125},{"$f":"K24-L24","v":-1.2056162483702337E-3},-3.2031249999997513E-4]
["912828CC2","3/15/2009",2.625,"9/15/2008",100.34375,100.375,2.0790000000000002,2.1019999999999999,2.0550000000000002,100.375,101.24524457,{"$f":"bondValue(C25,$D$2,B25,I25/100)","v":101.24518707230945},{"$f":"YTM(K25, C25, $D$2, B25)*100","v":2.0556640625000004},{"$f":"K25-L25","v":5.7497690548302671E-5},-6.6406250000028422E-4]

{"sheet":"single bond","index":1,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"cpn","maturity","settle"]
[null,3.3,"2015-02-15","2008-09-05"]
["price","ytm"]
[90,{"$f":"YTM(A5,$B$3,$D$3,$C$3)","v":5.1721191406250006E-2}]
[91,{"$f":"YTM(A6,$B$3,$D$3,$C$3)","v":4.9774169921875E-2}]
[92,4.78515625E-2]
[93,4.5950317382812494E-2]
[94,4.4073486328125001E-2]
[95,4.22210693359375E-2]
[96,4.0390014648437514E-2]
[97,3.8580322265625008E-2]
[98,3.6791992187500011E-2]
[99,3.5025024414062494E-2]
[100,3.3276367187500003E-2]
[101,3.1552124023437503E-2]
[102,2.9843139648437496E-2]
[103,2.8155517578125004E-2]
[104,2.6486206054687499E-2]
[105,2.4835205078125006E-2]
[106,2.3202514648437499E-2]
[107,2.1585083007812502E-2]
[108,1.9985961914062506E-2]
[109,1.8405151367187504E-2]
[110,1.6839599609375006E-2]
[111,1.5292358398437497E-2]
[112,1.3757324218749999E-2]

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