{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["start here","Treasury Bills","Treasury Notes & Bonds"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"start here","index":0,"n_rows":59,"n_cols":20,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,13,1,14],[1,17,1,18]]}
["Today's Date:",{"$f":"TODAY()","v":"2019-08-19"},null,"Pricing a Corporate Bond from a Zero Coupon Yield Curve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Treasury",null,null,null,"Corporate"]
["Period","Years till Mat.","Nearest Date","Cpn Rate (%)","Cpn Pmt","Price","Disc Fact","Sum DF","Zero","Zero BEY",null,null,null,"CF","PV CF",null,null,"Disc Rate","PV CF"]
[1,0.5,{"$f":"DATE(YEAR(B1), MONTH(B1)+6, DAY(B1))","v":"2020-02-19"},0,{"$f":"D4/2","v":0},null,{"$f":"1/(1+I4)^A4","v":0.99079060136035546},{"$f":"G4","v":0.99079060136035546},{"$f":"J4/2","v":9.2949999999999994E-3},{"$f":"VLOOKUP(A40,'Treasury Bills'!$A$2:$E$34,5,FALSE)/100","v":1.8589999999999999E-2},null,"Coupon Rate",null,{"$f":"$L$5/2*100","v":1.5},{"$f":"N4/(1+I4)^A4","v":1.4861859020405332},null,null,{"$f":"I4+$L$11/2","v":1.9295E-2},{"$f":"N4/(1+R4)^A4","v":1.4716053743028268}]
[2,1,{"$f":"DATE(YEAR(C4), MONTH(C4)+6, DAY(C4))","v":"2020-08-19"},0,{"$f":"D5/2","v":0},null,0.9816660157440148,{"$f":"G5+H4","v":1.9724566171043703},{"$f":"J5/2","v":9.2949999999999994E-3},{"$f":"VLOOKUP(A41,'Treasury Bills'!$A$2:$E$34,5,FALSE)/100","v":1.8589999999999999E-2},null,0.03,null,{"$f":"$L$5/2*100","v":1.5},1.472499023616022,null,null,1.9295E-2,1.4437482517846421]
[3,1.5,{"$f":"DATE(YEAR(C5), MONTH(C5)+6, DAY(C5))","v":"2021-02-19"},{"$f":"VLOOKUP(A42,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2.25},1.125,{"$f":"VLOOKUP(A42,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":100.292},0.96981939486534097,{"$f":"G6+H5","v":2.9422760119697111},{"$f":"((100+E6)/(F6-E6*H5))^(1/A6)-1","v":1.0267491199489553E-2},{"$f":"I6*2","v":2.0534982398979107E-2},null,null,null,1.5,1.4547290922980114,null,null,2.0267491199489555E-2,1.4123720424784829]
[4,2,"2021-08-19",{"$f":"VLOOKUP(A43,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2.125},1.0625,{"$f":"VLOOKUP(A43,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":101.042},0.96886413592858056,{"$f":"G7+H6","v":3.9111401478982915},7.9390704906723286E-3,1.5878140981344657E-2,null,null,null,1.5,1.4532962038928707,null,null,1.7939070490672331E-2,1.397024826539385]
[5,2.5,"2022-02-19",{"$f":"VLOOKUP(A44,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2},1,{"$f":"VLOOKUP(A44,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":101.07599999999999},0.96202831536734368,{"$f":"G8+H7","v":4.8731684632656354},7.7723279200925255E-3,1.5544655840185051E-2,null,null,null,1.5,1.4430424730510156,null,null,1.7772327920092527E-2,1.3735297341188841]
[6,3,"2022-08-19",{"$f":"VLOOKUP(A45,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":1.5},0.75,{"$f":"VLOOKUP(A45,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":100.02200000000001},0.95649750523623644,{"$f":"G9+H8","v":5.8296659685018719},7.4403929073689756E-3,1.4880785814737951E-2,null,null,null,1.5,1.4347462578543546,null,null,1.7440392907368978E-2,1.3521890258290585]
[7,3.5,"2023-02-19",{"$f":"VLOOKUP(A46,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2},1,{"$f":"VLOOKUP(A46,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":101.246},0.9447161785296847,6.7743821470315568,8.1574833907274158E-3,1.6314966781454832E-2,null,"Credit Spread",null,1.5,1.4170742677945269,null,null,1.8157483390727418E-2,1.3224722126190902]
[8,4,"2023-08-19",{"$f":"VLOOKUP(A47,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2.5},1.25,{"$f":"VLOOKUP(A47,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":103.304},0.93665207225886948,7.7110342192904264,8.213974420684611E-3,1.6427948841369222E-2,null,0.02,null,1.5,1.4049781083883042,null,null,1.8213974420684613E-2,1.2983112894553674]
[9,4.5,"2024-02-19",{"$f":"VLOOKUP(A48,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2.75},1.375,{"$f":"VLOOKUP(A48,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":105.172},0.93286636693933978,8.6439005862297655,7.751367258967079E-3,1.5502734517934158E-2,null,null,null,1.5,1.3992995504090098,null,null,1.7751367258967081E-2,1.2803125678927409]
[10,5,"2024-08-19",{"$f":"VLOOKUP(A49,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2.375},1.1875,{"$f":"VLOOKUP(A49,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":104.104},0.92738103079779632,9.5712816170275623,7.5675665275198867E-3,1.5135133055039773E-2,null,null,null,1.5,1.3910715461966945,null,null,1.7567566527519889E-2,1.260255782458291]
[11,5.5,"2025-02-19",{"$f":"VLOOKUP(A50,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2},1,{"$f":"VLOOKUP(A50,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":102.22199999999999},0.91733384537596496,10.488615462403526,7.8748273929567514E-3,1.5749654785913503E-2,null,null,null,1.5,1.3760007680639474,null,null,1.7874827392956753E-2,1.2343921276630327]
[12,6,"2025-08-19",{"$f":"VLOOKUP(A51,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2},1,{"$f":"VLOOKUP(A51,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":102.252},0.90854836175838249,11.397163824161909,8.0242867285038599E-3,1.604857345700772E-2,null,null,null,1.5,1.3628225426375737,null,null,1.8024286728503862E-2,1.2105802697315884]
[13,6.5,"2026-02-19",{"$f":"VLOOKUP(A52,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":1.625},0.8125,{"$f":"VLOOKUP(A52,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":100.19199999999999},0.90198938021444275,12.299153204376353,7.9663742350934985E-3,1.5932748470186997E-2,null,null,null,1.5,1.3529840703216642,null,null,1.79663742350935E-2,1.1900265111756361]
[14,7,"2026-08-19",{"$f":"VLOOKUP(A53,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":1.5},0.75,{"$f":"VLOOKUP(A53,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":99.245999999999995},0.89351498855302958,13.192668192929382,8.0747239615570621E-3,1.6149447923114124E-2,null,null,null,1.5,1.3402724828295443,null,null,1.8074723961557064E-2,1.167282799226675]
[15,7.5,"2027-02-19",{"$f":"VLOOKUP(A54,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2.25},1.125,{"$f":"VLOOKUP(A54,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":104.316},0.88478861095628658,14.077456803885669,8.1938217818220416E-3,1.6387643563644083E-2,null,null,null,1.5,1.3271829164344298,null,null,1.8193821781822044E-2,1.1445490170659705]
[16,8,"2027-08-19",{"$f":"VLOOKUP(A55,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2.25},1.125,{"$f":"VLOOKUP(A55,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":105.06399999999999},0.88234226052537468,14.959799064411044,7.8541361575548141E-3,1.5708272315109628E-2,null,null,null,1.5,1.3235133907880621,null,null,1.7854136157554816E-2,1.1301147065516284]
[17,8.5,"2028-02-19",{"$f":"VLOOKUP(A56,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2.75},1.375,{"$f":"VLOOKUP(A56,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":109.122},0.8735119732324037,15.833311037643448,7.9866327203945708E-3,1.5973265440789142E-2,null,null,null,1.5,1.3102679598486056,null,null,1.7986632720394573E-2,1.1078372896919577]
[18,9,"2028-08-19",{"$f":"VLOOKUP(A57,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2.875},1.4375,{"$f":"VLOOKUP(A57,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":110.252},0.86251746527061002,16.695828502914058,8.2505094357159248E-3,1.650101887143185E-2,null,null,null,1.5,1.293776197905915,null,null,1.8250509435715927E-2,1.0831979025011003]
[19,9.5,"2029-02-19",{"$f":"VLOOKUP(A58,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":2.625},1.3125,{"$f":"VLOOKUP(A58,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":109.03},0.85988130872227464,17.555709811636333,7.9769589239140348E-3,1.595391784782807E-2,null,null,null,1.5,1.2898219630834118,null,null,1.7976958923914037E-2,1.069227802752498]
[20,10,"2029-08-19",{"$f":"VLOOKUP(A59,'Treasury Notes & Bonds'!A2:D306,2,FALSE)","v":1.625},0.8125,{"$f":"VLOOKUP(A59,'Treasury Notes & Bonds'!A2:D306,4,FALSE)","v":100.084},0.85128318192729335,18.406992993563627,8.0830146906547551E-3,1.616602938130951E-2,null,null,null,{"$f":"100+L5/2*100","v":101.5},86.405242965620275,"Yield",null,1.8083014690654757E-2,70.925467026175681,"Yield"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O23)","v":112.73880768307478},{"$f":"YIELD(B1,C23,L5,O24,100,2)","v":1.6153367931124051E-2},null,null,{"$f":"SUM(S4:S23)","v":94.874496560014535},{"$f":"YIELD(B1,C23,L5,S24,100,2)","v":3.6153425422028262E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"INDEX('Treasury Bills'!A2:A34,MATCH(MIN(ABS('Treasury Bills'!A2:A34-$C$4)),ABS('Treasury Bills'!A2:A34-$C$4),0))","v":"2020-02-06"}]
[{"$f":"INDEX('Treasury Bills'!A2:A34,MATCH(MIN(ABS('Treasury Bills'!A2:A34-$C$5)),ABS('Treasury Bills'!A2:A34-$C$5),0))","v":"2020-02-06"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C6)),ABS('Treasury Notes & Bonds'!A2:A306-C6),0))","v":"2021-02-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C7)),ABS('Treasury Notes & Bonds'!A2:A306-C7),0))","v":"2021-08-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C8)),ABS('Treasury Notes & Bonds'!A2:A306-C8),0))","v":"2022-02-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C9)),ABS('Treasury Notes & Bonds'!A2:A306-C9),0))","v":"2022-08-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C10)),ABS('Treasury Notes & Bonds'!A2:A306-C10),0))","v":"2023-02-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C11)),ABS('Treasury Notes & Bonds'!A2:A306-C11),0))","v":"2023-08-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C12)),ABS('Treasury Notes & Bonds'!A2:A306-C12),0))","v":"2024-02-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C13)),ABS('Treasury Notes & Bonds'!A2:A306-C13),0))","v":"2024-08-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C14)),ABS('Treasury Notes & Bonds'!A2:A306-C14),0))","v":"2025-02-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C15)),ABS('Treasury Notes & Bonds'!A2:A306-C15),0))","v":"2025-08-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C16)),ABS('Treasury Notes & Bonds'!A2:A306-C16),0))","v":"2026-02-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C17)),ABS('Treasury Notes & Bonds'!A2:A306-C17),0))","v":"2026-08-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C18)),ABS('Treasury Notes & Bonds'!A2:A306-C18),0))","v":"2027-02-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C19)),ABS('Treasury Notes & Bonds'!A2:A306-C19),0))","v":"2027-08-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C20)),ABS('Treasury Notes & Bonds'!A2:A306-C20),0))","v":"2028-02-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C21)),ABS('Treasury Notes & Bonds'!A2:A306-C21),0))","v":"2028-08-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C22)),ABS('Treasury Notes & Bonds'!A2:A306-C22),0))","v":"2029-02-15"}]
[{"$f":"INDEX('Treasury Notes & Bonds'!A2:A306,MATCH(MIN(ABS('Treasury Notes & Bonds'!A2:A306-C23)),ABS('Treasury Notes & Bonds'!A2:A306-C23),0))","v":"2029-08-15"}]

{"sheet":"Treasury Bills","index":1,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["maturityDate","bid","ask","change","askYield"]
["2019-08-22",1.853,1.843,1.7999999999999999E-2,1.8683000000000001]
["2019-08-27",1.893,1.883,3.0000000000000001E-3,1.915]
["2019-08-29",1.76,1.75,-0.03,1.7749999999999999]
["2019-09-03",1.96,1.95,0.01,1.984]
["2019-09-05",1.9079999999999999,1.8979999999999999,3.3000000000000002E-2,1.9259999999999999]
["2019-09-10",1.9930000000000001,1.9830000000000001,3.3000000000000002E-2,2.0179999999999998]
["2019-09-12",1.9330000000000001,1.923,4.4999999999999998E-2,1.952]
["2019-09-17",2.0299999999999998,2.02,2.5000000000000001E-2,2.0569999999999999]
["2019-09-19",1.91,1.9,5.0000000000000001E-3,1.9347000000000001]
["2019-09-24",1.94,1.93,2.3E-2,1.966]
["2019-09-26",1.905,1.895,1.2999999999999999E-2,1.93]
["2019-10-01",1.9330000000000001,1.923,4.2999999999999997E-2,1.9589000000000001]
["2019-10-03",1.885,1.875,1.4999999999999999E-2,1.911]
["2019-10-08",1.89,1.88,2E-3,1.9159999999999999]
["2019-10-10",1.8779999999999999,1.8680000000000001,1.2999999999999999E-2,1.899]
["2019-10-15",1.925,1.915,5.0000000000000001E-3,1.9530000000000001]
["2019-10-17",1.853,1.843,2.8000000000000001E-2,1.879]
["2019-10-24",1.85,1.84,0.03,1.877]
["2019-10-31",1.8480000000000001,1.8380000000000001,3.3000000000000002E-2,1.875]
["2019-11-07",1.85,1.84,2.3E-2,1.873]
["2019-11-14",1.8680000000000001,1.8580000000000001,3.5000000000000003E-2,1.897]
["2019-11-21",1.8580000000000001,1.8480000000000001,0.06,1.887]
["2019-11-29",1.845,1.835,3.6999999999999998E-2,1.875]
["2019-12-05",1.82,1.81,3.3000000000000002E-2,1.845]
["2019-12-12",1.8080000000000001,1.798,2.3E-2,1.8380000000000001]
["2019-12-19",1.82,1.81,0.04,1.8513999999999999]
["2019-12-26",1.823,1.8129999999999999,1.4999999999999999E-2,1.855]
["2020-01-02",1.823,1.8129999999999999,2.5000000000000001E-2,1.85]
["2020-01-09",1.81,1.8,0.02,1.843]
["2020-01-16",1.798,1.788,1.7999999999999999E-2,1.831]
["2020-01-23",1.8149999999999999,1.8049999999999999,2.7E-2,1.85]
["2020-01-30",1.8280000000000001,1.8180000000000001,4.2999999999999997E-2,1.8580000000000001]
["2020-02-06",1.823,1.8129999999999999,3.7999999999999999E-2,1.859]
["2020-02-13",1.8380000000000001,1.8280000000000001,3.5000000000000003E-2,1.8748]
["2020-02-27",1.748,1.738,0.03,1.778]
["2020-03-26",1.718,1.708,3.5000000000000003E-2,1.7542]
["2020-04-23",1.7230000000000001,1.7130000000000001,1.4999999999999999E-2,1.762]
["2020-05-21",1.718,1.708,0.05,1.7589999999999999]
["2020-06-18",1.71,1.7,4.7E-2,1.7534000000000001]
["2020-07-16",1.7130000000000001,1.7030000000000001,4.7E-2,1.758]
["2020-08-13",1.7,1.69,4.7E-2,1.748]

{"sheet":"Treasury Notes & Bonds","index":2,"n_rows":207,"n_cols":6,"rows_kept":207,"cut":false,"hidden":false,"merged":[]}
["maturityDate","coupon","bid","ask","change","askYield"]
["2019-08-31",1,99.304000000000002,99.31,"unch.",2.0459999999999998]
["2019-08-31",1.625,99.305999999999997,99.311999999999998,-4.0000000000000001E-3,2.4049999999999998]
["2019-09-15",0.875,99.286000000000001,99.292000000000002,-4.0000000000000001E-3,2.0950000000000002]
["2019-09-30",1,99.275999999999996,99.281999999999996,"unch.",2.0489999999999999]
["2019-09-30",1.75,99.302000000000007,99.305999999999997,-4.0000000000000001E-3,2.0939999999999999]
["2019-10-15",1,99.266000000000005,99.272000000000006,-4.0000000000000001E-3,1.9730000000000001]
["2019-10-31",1.5,99.281999999999996,99.286000000000001,-8.0000000000000002E-3,2.0179999999999998]
["2019-11-15",3.375,100.096,100.102,-0.01,2.0009999999999999]
["2019-11-30",1,99.225999999999999,99.231999999999999,-8.0000000000000002E-3,1.9870000000000001]
["2019-11-30",1.75,99.293999999999997,99.3,-8.0000000000000002E-3,1.972]
["2019-12-15",1.375,99.254000000000005,99.26,-0.01,1.964]
["2019-12-31",1.125,99.221999999999994,99.225999999999999,-1.2E-2,1.93]
["2019-12-31",1.875,99.305999999999997,99.311999999999998,-0.01,1.929]
["2020-01-15",1.375,99.26,99.263999999999996,-4.0000000000000001E-3,1.8049999999999999]
["2020-01-31",1.25,99.22,99.224000000000004,-0.01,1.9219999999999999]
["2020-01-31",2,100.01,100.014,-6.0000000000000001E-3,1.893]
["2020-02-15",3.625,100.256,100.262,-1.6E-2,1.9219999999999999]
["2020-02-29",1.25,99.21,99.213999999999999,-0.01,1.875]
["2020-02-29",2.25,100.054,100.06,-1.6E-2,1.8919999999999999]
["2020-03-15",1.625,99.275999999999996,99.281999999999996,-0.01,1.8320000000000001]
["2020-03-31",1.125,99.174000000000007,99.18,-8.0000000000000002E-3,1.8460000000000001]
["2020-03-31",2.25,100.072,100.07599999999999,-1.4E-2,1.849]
["2020-04-30",1.125,99.156000000000006,99.162000000000006,-1.6E-2,1.839]
["2020-04-30",2.375,100.11199999999999,100.116,-1.4E-2,1.84]
["2020-05-15",1.5,99.24,99.244,-6.0000000000000001E-3,1.821]
["2020-05-31",1.375,99.203999999999994,99.21,-1.6E-2,1.821]
["2020-05-31",2.5,100.16200000000001,100.166,-1.4E-2,1.8180000000000001]
["2020-06-15",1.5,99.236000000000004,99.242000000000004,-8.0000000000000002E-3,1.798]
["2020-06-30",1.875,100.01600000000001,100.02200000000001,-1.7999999999999999E-2,1.7909999999999999]
["2020-07-15",1.5,99.242000000000004,99.245999999999995,-0.01,1.754]
["2020-07-31",2,100.06399999999999,100.07,-1.6E-2,1.7649999999999999]
["2020-08-15",2.625,100.27,100.274,-1.4E-2,1.742]
["2020-08-31",2.125,100.122,100.126,-1.2E-2,1.7330000000000001]
["2020-09-15",1.375,99.2,99.203999999999994,-0.02,1.7150000000000001]
["2020-09-30",2,100.09399999999999,100.1,-0.02,1.714]
["2020-10-15",1.625,99.286000000000001,99.292000000000002,-2.5999999999999999E-2,1.7]
["2020-10-31",1.75,100.02,100.024,-2.5999999999999999E-2,1.6830000000000001]
["2020-11-15",1.75,100.03,100.03400000000001,-2.5999999999999999E-2,1.66]
["2020-11-30",2,100.13200000000001,100.136,-0.03,1.6579999999999999]
["2020-12-15",1.875,100.084,100.09,-3.2000000000000001E-2,1.6579999999999999]
["2020-12-31",1.75,100.036,100.042,-2.8000000000000001E-2,1.65]
["2021-01-15",2,100.154,100.16,-0.03,1.637]
["2021-01-31",2.125,100.22,100.224,-0.03,1.631]
["2021-02-15",2.25,100.286,100.292,-0.71399999999999997,1.625]
["2021-02-28",2,100.182,100.18600000000001,-3.2000000000000001E-2,1.611]
["2021-03-15",2.375,101.054,101.06,-0.03,1.6060000000000001]
["2021-03-31",1.25,99.132000000000005,99.135999999999996,-3.4000000000000002E-2,1.61]
["2021-04-15",2.375,101.072,101.07599999999999,-4.2000000000000003E-2,1.61]
["2021-04-30",1.375,99.195999999999998,99.201999999999998,-0.04,1.595]
["2021-05-15",2.625,101.244,101.25,-3.7999999999999999E-2,1.58]
["2021-05-31",2,100.23399999999999,100.24,-0.04,1.57]
["2021-06-15",2.625,101.274,101.28,-3.7999999999999999E-2,1.575]
["2021-06-30",1.625,100.03400000000001,100.04,-3.7999999999999999E-2,1.556]
["2021-07-15",2.625,101.312,101.316,-0.71799999999999997,1.5580000000000001]
["2021-07-31",1.75,100.13200000000001,100.136,-3.4000000000000002E-2,1.5249999999999999]
["2021-08-15",2.125,101.036,101.042,-3.5999999999999997E-2,1.544]
["2021-08-31",2,100.292,100.29600000000001,-0.71799999999999997,1.5329999999999999]
["2021-09-15",2.75,102.154,102.16,-0.04,1.5189999999999999]
["2021-09-30",1.125,99.043999999999997,99.05,-0.04,1.532]
["2021-10-15",2.875,102.264,102.27,-0.04,1.5269999999999999]
["2021-10-31",1.25,99.13,99.134,-0.04,1.5189999999999999]
["2021-11-15",2,101.03,101.03400000000001,-4.2000000000000003E-2,1.4930000000000001]
["2021-11-30",1.75,100.164,100.17,-3.5999999999999997E-2,1.512]
["2021-12-15",2.625,102.176,102.182,-3.7999999999999999E-2,1.4930000000000001]
["2021-12-31",2,101.036,101.042,-3.7999999999999999E-2,1.51]
["2022-01-15",2.5,102.102,102.10599999999999,-3.7999999999999999E-2,1.506]
["2022-01-31",1.875,100.27200000000001,100.276,-4.3999999999999997E-2,1.512]
["2022-02-15",2,101.072,101.07599999999999,-0.04,1.4890000000000001]
["2022-02-28",1.75,100.194,100.2,-4.2000000000000003E-2,1.4970000000000001]
["2022-03-15",2.375,102.07599999999999,102.08199999999999,-4.5999999999999999E-2,1.4770000000000001]
["2022-03-31",1.75,100.2,100.20399999999999,-0.05,1.4990000000000001]
["2022-04-15",2.25,101.294,101.3,-0.72599999999999998,1.502]
["2022-04-30",1.75,100.214,100.22,-4.8000000000000001E-2,1.4890000000000001]
["2022-05-15",1.75,100.22,100.224,-4.3999999999999997E-2,1.4870000000000001]
["2022-05-31",1.75,100.22,100.224,-4.5999999999999999E-2,1.49]
["2022-06-15",1.75,100.242,100.246,-4.3999999999999997E-2,1.4670000000000001]
["2022-06-30",1.75,100.244,100.25,-4.8000000000000001E-2,1.47]
["2022-07-15",1.75,100.23,100.23399999999999,-5.1999999999999998E-2,1.49]
["2022-07-31",1.875,101.026,101.032,-5.6000000000000001E-2,1.4910000000000001]
["2022-08-15",1.5,100.01600000000001,100.02200000000001,-4.5999999999999999E-2,1.476]
["2022-08-31",1.625,100.124,100.13,-5.1999999999999998E-2,1.4870000000000001]
["2022-09-30",1.75,100.254,100.26,-4.8000000000000001E-2,1.482]
["2022-10-31",1.875,101.06399999999999,101.07,-4.8000000000000001E-2,1.4830000000000001]
["2022-11-15",1.625,100.14400000000001,100.15,-4.8000000000000001E-2,1.476]
["2022-11-30",2,101.20399999999999,101.21,-5.1999999999999998E-2,1.48]
["2022-12-31",2.125,102.03400000000001,102.04,-0.06,1.4750000000000001]
["2023-01-31",1.75,100.28400000000001,100.29,-0.73199999999999998,1.4790000000000001]
["2023-02-15",2,101.242,101.246,-5.1999999999999998E-2,1.476]
["2023-02-28",1.5,100.026,100.032,-4.8000000000000001E-2,1.47]
["2023-03-31",1.5,100.02,100.024,-0.06,1.478]
["2023-04-30",1.625,100.15600000000001,100.16200000000001,-6.4000000000000001E-2,1.4830000000000001]
["2023-05-15",1.75,100.306,100.312,-0.746,1.48]
["2023-05-31",1.625,100.164,100.17,-5.8000000000000003E-2,1.48]
["2023-06-30",1.375,99.183999999999997,99.19,-6.8000000000000005E-2,1.484]
["2023-07-31",1.25,99.024000000000001,99.03,-6.6000000000000003E-2,1.4870000000000001]
["2023-08-15",2.5,103.3,103.304,-0.74,1.4750000000000001]
["2023-08-31",1.375,99.186000000000007,99.191999999999993,-6.4000000000000001E-2,1.4770000000000001]
["2023-09-30",1.375,99.186000000000007,99.191999999999993,-5.8000000000000003E-2,1.4750000000000001]
["2023-10-31",1.625,100.18600000000001,100.19199999999999,-5.8000000000000003E-2,1.476]
["2023-11-15",2.75,105.056,105.062,-6.6000000000000003E-2,1.48]
["2023-11-30",2.125,102.206,102.212,-6.8000000000000005E-2,1.48]
["2023-12-31",2.25,103.07,103.074,-7.1999999999999995E-2,1.4810000000000001]
["2024-01-31",2.5,104.114,104.12,-6.6000000000000003E-2,1.4790000000000001]
["2024-02-15",2.75,105.166,105.172,-7.3999999999999996E-2,1.47]
["2024-02-29",2.125,102.254,102.26,-0.752,1.4810000000000001]
["2024-03-31",2.125,102.27,102.274,-0.754,1.4810000000000001]
["2024-04-30",2,102.11199999999999,102.116,-7.0000000000000007E-2,1.476]
["2024-05-15",2.5,104.214,104.22,-7.8E-2,1.472]
["2024-05-31",2,102.142,102.146,-7.3999999999999996E-2,1.4650000000000001]
["2024-06-30",1.75,101.102,101.10599999999999,-7.3999999999999996E-2,1.464]
["2024-07-31",1.75,101.116,101.122,-7.5999999999999998E-2,1.4590000000000001]
["2024-08-15",2.375,104.1,104.104,-6.4000000000000001E-2,1.472]
["2024-08-31",1.875,101.30200000000001,101.306,-0.74199999999999999,1.4690000000000001]
["2024-09-30",2.125,103.054,103.06,-0.06,1.4750000000000001]
["2024-10-31",2.25,103.26600000000001,103.27200000000001,-0.74399999999999999,1.4770000000000001]
["2024-11-15",2.25,103.274,103.28,-0.748,1.478]
["2024-11-30",2.125,103.072,103.07599999999999,-7.0000000000000007E-2,1.484]
["2024-12-31",2.25,103.29600000000001,103.30200000000001,-0.748,1.482]
["2025-01-31",2.5,105.084,105.09,-7.5999999999999998E-2,1.4870000000000001]
["2025-02-15",2,102.21599999999999,102.22199999999999,-8.4000000000000005E-2,1.4870000000000001]
["2025-02-28",2.75,106.20399999999999,106.21,-8.2000000000000003E-2,1.492]
["2025-03-31",2.625,106,106.004,-8.5999999999999993E-2,1.5029999999999999]
["2025-04-30",2.875,107.14,107.14400000000001,-0.09,1.504]
["2025-05-15",2.125,103.13,103.134,-8.4000000000000005E-2,1.5]
["2025-05-31",2.875,107.164,107.17,-0.09,1.5089999999999999]
["2025-06-30",2.75,106.286,106.292,-0.77400000000000002,1.5129999999999999]
["2025-07-31",2.875,107.21599999999999,107.22199999999999,-0.78400000000000003,1.5169999999999999]
["2025-08-15",2,102.246,102.252,-0.77,1.5109999999999999]
["2025-08-31",2.75,107.014,107.02,-0.108,1.52]
["2025-09-30",3,108.19199999999999,108.196,-9.8000000000000004E-2,1.518]
["2025-10-31",3,108.22199999999999,108.226,-0.77800000000000002,1.5209999999999999]
["2025-11-15",2.25,104.1,104.104,-0.1,1.52]
["2025-11-30",2.875,108.012,108.01600000000001,-9.4E-2,1.5249999999999999]
["2025-12-31",2.625,106.196,106.202,-9.8000000000000004E-2,1.5269999999999999]
["2026-01-31",2.625,106.21599999999999,106.22199999999999,-0.78400000000000003,1.53]
["2026-02-15",1.625,100.18600000000001,100.19199999999999,-0.1,1.5269999999999999]
["2026-02-28",2.5,105.312,105.316,-0.78400000000000003,1.532]
["2026-03-31",2.25,104.154,104.16,-0.106,1.532]
["2026-04-30",2.375,105.1,105.104,-0.106,1.534]
["2026-05-15",1.625,100.18,100.184,-0.10199999999999999,1.534]
["2026-05-31",2.125,103.242,103.246,-0.78400000000000003,1.5369999999999999]
["2026-06-30",1.875,102.07,102.074,-0.10199999999999999,1.5289999999999999]
["2026-07-31",1.875,102.062,102.066,-0.12,1.538]
["2026-08-15",1.5,99.242000000000004,99.245999999999995,-0.78200000000000003,1.534]
["2026-11-15",2,103.04,103.044,-0.11600000000000001,1.54]
["2027-02-15",2.25,104.312,104.316,-0.80400000000000005,1.5409999999999999]
["2027-05-15",2.375,106.004,106.01,-0.13600000000000001,1.5449999999999999]
["2027-08-15",2.25,105.06,105.06399999999999,-0.122,1.5549999999999999]
["2027-11-15",2.25,105.092,105.096,-0.13,1.5609999999999999]
["2028-02-15",2.75,109.116,109.122,-0.14399999999999999,1.5649999999999999]
["2028-05-15",2.875,110.172,110.176,-0.84199999999999997,1.577]
["2028-08-15",2.875,110.246,110.252,-0.84799999999999998,1.5820000000000001]
["2028-11-15",3.125,113.05200000000001,113.056,-0.17,1.585]
["2029-02-15",2.625,109.024,109.03,-0.16600000000000001,1.589]
["2029-05-15",2.375,106.31399999999999,107,-0.85,1.5960000000000001]
["2029-08-15",1.625,100.074,100.084,-0.17599999999999999,1.5960000000000001]
["2030-05-15",6.25,145.244,145.25399999999999,-0.88600000000000001,1.5920000000000001]
["2031-02-15",5.375,139.084,139.09399999999999,-0.22800000000000001,1.613]
["2036-02-15",4.5,139.01400000000001,139.024,-1.016,1.7589999999999999]
["2037-02-15",4.75,144.172,144.18199999999999,-1.05,1.774]
["2037-05-15",5,148.24600000000001,148.256,-1.758,1.7789999999999999]
["2038-02-15",4.375,140.00399999999999,140.01400000000001,-1.0860000000000001,1.8149999999999999]
["2038-05-15",4.5,142.10599999999999,142.11600000000001,-1.0940000000000001,1.821]
["2039-02-15",3.5,126.14400000000001,126.154,-1.0760000000000001,1.8720000000000001]
["2039-05-15",4.25,139.01,139.02000000000001,-1.1040000000000001,1.873]
["2039-08-15",4.5,143.17400000000001,143.184,-1.1379999999999999,1.875]
["2039-11-15",4.375,141.17400000000001,141.184,-1.1419999999999999,1.8919999999999999]
["2040-02-15",4.625,146.05199999999999,146.06200000000001,-1.1819999999999999,1.8939999999999999]
["2040-05-15",4.375,142.00200000000001,142.012,-1.1739999999999999,1.91]
["2040-08-15",3.875,133.15199999999999,133.16200000000001,-1.1599999999999999,1.9259999999999999]
["2040-11-15",4.25,140.042,140.05199999999999,-1.1819999999999999,1.9350000000000001]
["2041-02-15",4.75,149.102,149.11199999999999,-1.9,1.9319999999999999]
["2041-05-15",4.375,142.24,142.25,-1.88,1.9510000000000001]
["2041-08-15",3.75,131.19200000000001,131.202,-1.87,1.97]
["2041-11-15",3.125,120.116,120.126,-1.1659999999999999,1.986]
["2042-02-15",3.125,120.13200000000001,120.142,-1.17,1.9930000000000001]
["2042-05-15",3,118.02200000000001,118.032,-1.18,2.0049999999999999]
["2042-08-15",2.75,113.12,113.13,-1.1759999999999999,2.0179999999999998]
["2042-11-15",2.75,113.104,113.114,-1.1759999999999999,2.0259999999999998]
["2043-02-15",3.125,120.136,120.146,-1.88,2.0259999999999998]
["2043-05-15",2.875,115.24,115.25,-1.89,2.0329999999999999]
["2043-08-15",3.625,130.072,130.08199999999999,-1.9339999999999999,2.0259999999999998]
["2043-11-15",3.75,132.25399999999999,132.26400000000001,-1.95,2.0289999999999999]
["2044-02-15",3.625,130.154,130.16399999999999,-1.952,2.036]
["2044-05-15",3.375,125.214,125.224,-1.958,2.0459999999999998]
["2044-08-15",3.125,120.276,120.286,-1.944,2.052]
["2044-11-15",3,118.17,118.18,-1.9319999999999999,2.0539999999999998]
["2045-02-15",2.5,108.19199999999999,108.202,-1.9039999999999999,2.0630000000000002]
["2045-05-15",3,118.256,118.26600000000001,-1.944,2.0539999999999998]
["2045-08-15",2.875,116.11,116.12,-1.94,2.0579999999999998]
["2045-11-15",3,119.01,119.02,-1.276,2.056]
["2046-02-15",2.5,108.21,108.22,-1.9319999999999999,2.0720000000000001]
["2046-05-15",2.5,108.21,108.22,-1.9319999999999999,2.0750000000000002]
["2046-08-15",2.25,103.154,103.164,-1.9119999999999999,2.0790000000000002]
["2046-11-15",2.875,116.232,116.242,-1.97,2.0670000000000002]
["2047-02-15",3,119.184,119.194,-1.978,2.0619999999999998]
["2047-05-15",3,119.17,119.18,-1.982,2.069]
["2047-08-15",2.75,114.06,114.07,-1.964,2.077]
["2047-11-15",2.75,114.086,114.096,-1.968,2.0779999999999998]
["2048-02-15",3,119.252,119.262,-1.984,2.0750000000000002]
["2048-05-15",3.125,122.20399999999999,122.214,-2.0179999999999998,2.0739999999999998]
["2048-08-15",3,120.012,120.02200000000001,-2,2.0750000000000002]
["2048-11-15",3.375,128.19999999999999,128.21,-2.032,2.0649999999999999]
["2049-02-15",3,120.102,120.11199999999999,-2.008,2.0739999999999998]
["2049-05-15",2.875,117.206,117.21599999999999,-2.016,2.0750000000000002]
["2049-08-15",2.25,103.22,103.23,-1.97,2.0830000000000002]