{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":34,"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":58,"n_cols":18,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Name","ISIN","Coupon","Bid","Ask","Next Coupon","Acrued int.","AVG YTM","clean price","Coupon (%)","Maturity","Settlement ","Duration","Price","Φ","t","Pnse","Error^2"]
["RGKB 1046","SE0000909640",5.5,1.0549999999999999,1.0429999999999999,"2012-10-08",{"$f":"(COUPDAYS(L2,K2,1,4)-COUPDAYSNC(L2,K2,1,4))/COUPDAYS(L2,K2,1,4)*100*J2","v":1.0083333333333333},{"$f":"AVERAGE(D2:E2)/100","v":1.0489999999999999E-2},{"$f":"PRICE(L2,K2,J2,H2,100,1,4)","v":103.59554269471373},{"$f":"C2/100","v":5.5E-2},"2012-10-08","2011-12-14",{"$f":"DURATION(L2,K2,C2,H2,1,4)","v":0.81666666666666654},{"$f":"I2+G2","v":104.60387602804707},{"$f":"(M2*I2)/(1+H2)","v":83.724753865962256},{"$f":"YEARFRAC(L2,K2,4)","v":0.81666666666666665},{"$f":"P_nse(P2,J2,B15,C15,D15,E15,F15,G15)","v":103.64557290043753},{"$f":"((N2-Q2)/O2)^2","v":1.3100807104475317E-4}]
["RGKB 1055","SE0004194025",1.5,0.71499999999999997,0.73,"2012-08-30",0.43333333333333329,7.2249999999999988E-3,101.31636605889007,1.4999999999999999E-2,"2013-08-30","2011-12-14",1.3344223272847906,101.74969939222341,134.22901634524743,1.711111111111111,{"$f":"P_nse(P3,J3,B15,C15,D15,E15,F15,G15)","v":107.87030295966447},{"$f":"((N3-Q3)/O3)^2","v":2.0791972253804145E-3}]
["RGKB 1041","SE0000412389",6.75,0.82499999999999996,0.81,"2012-05-05",4.1062500000000002,8.175E-3,113.98763953212206,6.7500000000000004E-2,"2014-05-05","2011-12-14",1.4331863998955099,118.09388953212206,162.04085077851477,2.3916666666666666,{"$f":"P_nse(P4,J4,B15,C15,D15,E15,F15,G15)","v":110.86286644077813},1.9913631547855541E-3]
["RGKB 1049","SE0001250135",4.5,0.9,0.89,"2012-08-12",1.5250000000000001,8.9499999999999996E-3,112.92310074017414,4.4999999999999998E-2,"2015-08-12","2011-12-14",2.2285024454969928,114.44810074017414,249.41712290260304,3.661111111111111,{"$f":"P_nse(P5,J5,B15,C15,D15,E15,F15,G15)","v":114.11234365776214},1.812165401102345E-6]
["RGKB 1050","SE0001517699",3,1.028,1.0149999999999999,"2012-07-12",1.2666666666666666,1.0215E-2,108.80106035354034,0.03,"2016-07-12","2011-12-14",2.6813257462928801,110.067727020207,288.78118454973765,4.5777777777777775,{"$f":"P_nse(P6,J6,B15,C15,D15,E15,F15,G15)","v":115.47121106029144},3.5011438848684231E-4]
["RGKB 1051","SE0001811399",3.75,1.2310000000000001,1.2250000000000001,"2012-08-12",1.2708333333333335,1.2280000000000003E-2,113.70610323271298,3.7499999999999999E-2,"2017-08-12","2011-12-14",3.2302831376549741,114.97693656604631,362.84714498072515,5.6611111111111114,{"$f":"P_nse(P7,J7,B15,C15,D15,E15,F15,G15)","v":116.83419182879071},2.6199667204022894E-5]
["RGKB 1052","SE0002241083",4.25,1.393,1.38,"2012-03-12",3.2111111111111112,1.3864999999999999E-2,119.60232620452825,4.2500000000000003E-2,"2019-03-12","2011-12-14",3.7695145912340369,122.81343731563936,444.67726351486863,7.2444444444444445,{"$f":"P_nse(P8,J8,B15,C15,D15,E15,F15,G15)","v":118.90892845501776},7.7097975941061334E-5]
["RGKB 1047","SE0001149311",5,1.538,1.5249999999999999,"2012-12-01",0.18055555555555555,1.5314999999999999E-2,128.844639789426,0.05,"2020-12-01","2011-12-14",4.9465387902383133,129.02519534498154,627.72145455615112,8.9638888888888886,{"$f":"P_nse(P9,J9,B15,C15,D15,E15,F15,G15)","v":121.93762282411625},1.2748558656543418E-4]
["RGKB 1054","SE0003784461",3.5,1.6339999999999999,1.62,"2012-06-01",1.8763888888888889,1.627E-2,117.88116206729798,3.5000000000000003E-2,"2022-06-01","2011-12-14",5.423203286592571,119.75755095618686,629.05872017349907,10.463888888888889,{"$f":"P_nse(P10,J10,B15,C15,D15,E15,F15,G15)","v":125.05353127634177},7.087781995308383E-5]
["RGKB 1053","SE0002829192",3.5,2.0840000000000001,2.0499999999999998,"2012-03-30",2.4694444444444446,2.0670000000000001E-2,129.65712841686877,3.5000000000000003E-2,"2039-03-30","2011-12-14",12.579107955848173,132.12657286131321,1597.941563483851,27.294444444444444,{"$f":"P_nse(P11,J11,B15,C15,D15,E15,F15,G15)","v":131.86432001620943},2.6935102371555709E-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUM»»»",{"$f":"SUM(R2:R11)","v":4.8551829898646403E-3}]
[]
[null,"β0","β1","β2","β3","τ1","τ2"]
[null,0.11965453340934315,-0.14802269102823484,-0.18082336007830255,-0.376965866779431,1.5454586925297356,12.511550251954649]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["t","R"]
[0.1,{"$f":"R_nse(A26)","v":-3.0783123044447819E-2}]
[0.3,{"$f":"R_nse(A27)","v":-3.4771639442335092E-2}]
[0.5,-3.7789654261584732E-2]
[0.7,-3.9996263170900728E-2]
[0.9,-4.1527872579096098E-2]
[1,-4.2077730764980822E-2]
[2,-4.2324969285913977E-2]
[3,-3.8060842799741333E-2]
[4,-3.3094293415954108E-2]
[5,-2.884195722297106E-2]
[6,-2.5662176712813303E-2]
[7,-2.3486367820184421E-2]
[8,-2.2106553782401714E-2]
[9,-2.1298011531439745E-2]
[10,-2.0865202370840261E-2]
[11,-2.06537063261934E-2]
[12,-2.0548357396523831E-2]
[13,-2.0466775383019623E-2]
[14,-2.0352223791414617E-2]
[15,-2.0167277406619916E-2]
[16,-1.9888700539915566E-2]
[17,-1.9503497239485509E-2]
[18,-1.9005946916513874E-2]
[19,-1.8395415352191691E-2]
[20,-1.767475439469289E-2]
[21,-1.6849139674603567E-2]
[22,-1.5925230576402327E-2]
[23,-1.4910565915591978E-2]
[24,-1.3813131589387448E-2]
[25,-1.2641053643506178E-2]
[26,-1.1402382856750229E-2]
[27,-1.0104946169141052E-2]
[27.2944,-9.7128867549257092E-3]