{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Deutschland","United Kingdom"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":136,"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":"Deutschland","index":0,"n_rows":165,"n_cols":24,"rows_kept":165,"cut":false,"hidden":false,"merged":[[71,0,72,11],[0,17,0,23],[37,13,37,14],[35,13,35,14],[0,0,0,11],[1,13,1,14],[2,13,2,14],[0,13,0,15]]}
["Daten der Finanzagentur ",null,null,null,null,null,null,null,null,null,null,null,null,"Bewertung der Anleihen",null,null,null,"Nelson-Siegel-Svensson Modellparameter"]
["WKN","Bezeichnung","Laufzeit (Tage)","Laufzeit (Monate)","Laufzeit (Jahre)","Kupon","Kuponwert","Kuponfälligkeit ","Tage bis Kuponfälligkeit","Fälligkeit","Tatsächlicher Preis","Theoretischer Preis",null,"Ausgangsdatum",null,"2023-12-07",null,"β0","β1","β2","β3","λ","μ","β0+β1"]
[110487,"0,000 BSA 22",{"$f":"J3-$P$2","v":99},{"$f":"DATEDIF($P$2,J3,\"M\")","v":3},{"$f":"DATEDIF($P$2,J3,\"Y\")","v":0},0,{"$f":"100*F3","v":0},"2024-03-15",{"$f":"H3-$P$2","v":99},"2024-03-15",99.063000000000002,{"$f":"SUM(G3/((1+$P$6)^(I3/$P$3)))+(100/((1+$P$6)^(C3/$P$3)))","v":99.000563308786283},null,"Tage im Jahr",null,360,null,1.1664156619044801,-1.1227760185978537,-0.7442669738562987,-3.4175692205773962,11,70.194999999999993,{"$f":"R3+S3","v":4.3639643306626397E-2}]
[114179,"0,000 BO S 179",120,3,0,0,{"$f":"100*F4","v":0},"2024-04-05",120,"2024-04-05",98.858000000000004,98.789849107276609,null,"Laufzeit (in Jahren)","Laufzeit (in Tagen)","Kassazinssätze"]
[110235,"1,500 Bund 14",160,5,0,1.4999999999999999E-2,1.5,"2024-05-15",160,"2024-05-15",99.12,99.86557456917464,null,0,{"$f":"N5*$P$3","v":0}]
[110488,"0,200 BSA 22",190,6,0,2E-3,0.2,"2024-06-14",190,"2024-06-14",98.277000000000001,98.286883555053336,null,1,360,{"$f":"$R$3 + $S$3*((1-EXP(-N6/$V$3))/(N6/$V$3)) + $T$3*(((1-EXP(-N6/$V$3))/(N6/$V$3))-EXP(-N6/$V$3)) + $U$3*(((1-EXP(-N6/$W$3))/(N6/$W$3))-EXP(-N6/$W$3))","v":3.7201255368413143E-2}]
[110236,"1,000 Bund 14",252,8,0,0.01,1,"2024-08-15",252,"2024-08-15",98.382000000000005,98.450346764984701,null,2,720,{"$f":"$R$3 + $S$3*((1-EXP(-N7/$V$3))/(N7/$V$3)) + $T$3*(((1-EXP(-N7/$V$3))/(N7/$V$3))-EXP(-N7/$V$3)) + $U$3*(((1-EXP(-N7/$W$3))/(N7/$W$3))-EXP(-N7/$W$3))","v":3.2031146855815575E-2}]
[110489,"0,400 BSA 22",281,9,0,4.0000000000000001E-3,0.4,"2024-09-13",281,"2024-09-13",97.81,97.577959851505966,null,3,1080,2.7948406222361652E-2]
[114180,"0,000BO S 180",316,10,0,0,0,"2024-10-18",316,"2024-10-18",97.272000000000006,96.844682903575915,null,4,1440,2.4792725810872759E-2]
[110490,"2,200 BSA 22",371,12,1,2.1999999999999999E-2,2.1999999999999997,"2023-12-12",5,"2024-12-12",99.03,{"$f":"SUM(G10/((1+$P$6:$P$7)^((I10+$P$3*$N$5:$N$6)/$P$3)))+(100/((1+$P$7)^(C10/$P$3)))","v":101.13266676732142},null,5,1800,2.2422304904718041E-2]
[110237,"0,500 Bund 15",436,14,1,5.0000000000000001E-3,0.5,"2024-02-15",70,"2025-02-15",97.14,{"$f":"SUM(G11/((1+$P$6:$P$7)^((I11+$P$3*$N$5:$N$6)/$P$3)))+(100/((1+$P$7)^(C11/$P$3)))","v":97.23147340521021},null,6,2160,2.0711954463378035E-2]
["BU2200","2,500 BSA 23",462,15,1,2.5000000000000001E-2,2.5,"2024-03-13",97,"2025-03-13",99.415000000000006,{"$f":"SUM(G12/((1+$P$6:$P$7)^((I12+$P$3*$N$5:$N$6)/$P$3)))+(100/((1+$P$7)^(C12/$P$3)))","v":100.911995692733},null,7,2520,1.9551384738602573E-2]
[114181,"0,000 BO S 181",491,16,1,0,0,"2024-04-11",126,"2025-04-11",96.281000000000006,{"$f":"SUM(G13/((1+$P$6:$P$7)^((I13+$P$3*$N$5:$N$6)/$P$3)))+(100/((1+$P$7)^(C13/$P$3)))","v":95.790962271178913},null,8,2880,1.8843658687999587E-2]
["BU2201","2,800 BSA 23",553,18,1,2.8000000000000001E-2,2.8000000000000003,"2024-06-12",188,"2025-06-12",99.915999999999997,{"$f":"SUM(G14/((1+$P$6:$P$7)^((I14+$P$3*$N$5:$N$6)/$P$3)))+(100/((1+$P$7)^(C14/$P$3)))","v":100.68811791605619},null,9,3240,1.8503795668157047E-2]
[110238,"1,000 Bund 15",617,20,1,0.01,1,"2024-08-15",252,"2025-08-15",97.26,{"$f":"SUM(G15/((1+$P$6:$P$7)^((I15+$P$3*$N$5:$N$6)/$P$3)))+(100/((1+$P$7)^(C15/$P$3)))","v":96.662278712780548},null,10,3600,1.8457511312647334E-2]
["BU2202","3,100 BSA 23",651,21,1,3.1E-2,3.1,"2024-09-18",286,"2025-09-18",100.69199999999999,{"$f":"SUM(G16/((1+$P$6:$P$7)^((I16+$P$3*$N$5:$N$6)/$P$3)))+(100/((1+$P$7)^(C16/$P$3)))","v":100.39884003596048},null,11,3960,1.8640080795053304E-2]
[114182,"0,000 BO S 182",673,22,1,0,0,"2024-10-10",308,"2025-10-10",95.435000000000002,{"$f":"SUM(G17/((1+$P$6:$P$7)^((I17+$P$3*$N$5:$N$6)/$P$3)))+(100/((1+$P$7)^(C17/$P$3)))","v":94.276198595001873},null,12,4320,1.8995313854252793E-2]
[103071,"0,000 BO Green",673,22,1,0,0,"2024-10-10",308,"2025-10-10",95.6,{"$f":"SUM(G18/((1+$P$6:$P$7)^((I18+$P$3*$N$5:$N$6)/$P$3)))+(100/((1+$P$7)^(C18/$P$3)))","v":94.276198595001873},null,13,4680,1.947463102972069E-2]
["BU2203","3,100 BSA 23 II",736,24,2,3.1E-2,3.1,"2023-12-12",5,"2025-12-12",101,{"$f":"SUM(G19/((1+$P$6:$P$8)^((I19+$P$3*$N$5:$N$7)/$P$3)))+(100/((1+$P$8)^(C19/$P$3)))","v":103.55384452026721},null,14,5040,2.0036231527864101E-2]
[110239,"0,500 Bund 16",801,26,2,5.0000000000000001E-3,0.5,"2024-02-15",70,"2026-02-15",95.86,{"$f":"SUM(G20/((1+$P$6:$P$8)^((I20+$P$3*$N$5:$N$7)/$P$3)))+(100/((1+$P$8)^(C20/$P$3)))","v":95.499720374057745},null,15,5400,2.064434402513543E-2]
[114183,"0,000 BO S 183",855,28,2,0,0,"2024-04-10",125,"2026-04-10",94.584999999999994,{"$f":"SUM(G21/((1+$P$6:$P$8)^((I21+$P$3*$N$5:$N$7)/$P$3)))+(100/((1+$P$8)^(C21/$P$3)))","v":93.663012267116883},null,16,5760,2.1268552518091177E-2]
[110240,"0,000 Bund 16",982,32,2,0,0,"2024-08-15",252,"2026-08-15",94.045000000000002,{"$f":"SUM(G22/((1+$P$6:$P$8)^((I22+$P$3*$N$5:$N$7)/$P$3)))+(100/((1+$P$8)^(C22/$P$3)))","v":92.756618138559546},null,17,6120,2.1883190061491253E-2]
[114184,"0,000 BO S 184",1037,34,2,0,0,"2024-10-09",307,"2026-10-09",93.71,{"$f":"SUM(G23/((1+$P$6:$P$8)^((I23+$P$3*$N$5:$N$7)/$P$3)))+(100/((1+$P$8)^(C23/$P$3)))","v":92.366812085383089},null,18,6480,2.2466793900060789E-2]
[110241,"0,250 Bund 17",1166,38,3,2.5000000000000001E-3,0.25,"2024-01-15",39,"2027-02-15",93.93,{"$f":"SUM(G24/((1+$P$6:$P$9)^((I24+$P$3*$N$5:$N$8)/$P$3)))+(100/((1+$P$9)^(C24/$P$3)))","v":93.332268068736695},null,19,6840,2.3001616103266287E-2]
[114185,"0,000 BO S 185",1226,40,3,0,0,"2024-04-16",131,"2027-04-16",92.9,{"$f":"SUM(G25/((1+$P$6:$P$9)^((I25+$P$3*$N$5:$N$8)/$P$3)))+(100/((1+$P$9)^(C25/$P$3)))","v":91.998001936246951},null,20,7200,2.3473184361073152E-2]
[113504,"6,500 Bund 97",1305,42,3,6.5000000000000002E-2,6.5,"2024-07-04",210,"2027-07-04",114.31,{"$f":"SUM(G26/((1+$P$6:$P$9)^((I26+$P$3*$N$5:$N$8)/$P$3)))+(100/((1+$P$9)^(C26/$P$3)))","v":116.05848301015374},null,21,7560,2.3869908097129022E-2]
[110242,"0,500 Bund 17",1347,44,3,5.0000000000000001E-3,0.5,"2024-08-15",252,"2027-08-15",94.15,{"$f":"SUM(G27/((1+$P$6:$P$9)^((I27+$P$3*$N$5:$N$8)/$P$3)))+(100/((1+$P$9)^(C27/$P$3)))","v":93.125937107604756},null,22,7920,2.4182725508588798E-2]
[114186,"1,300 BO S 186",1408,46,3,1.2999999999999999E-2,1.3,"2024-10-15",313,"2027-10-15",96.84,{"$f":"SUM(G28/((1+$P$6:$P$9)^((I28+$P$3*$N$5:$N$8)/$P$3)))+(100/((1+$P$9)^(C28/$P$3)))","v":95.734529400931365},null,23,8280,2.4404787553070295E-2]
[103074,"1,300 BO Green",1408,46,3,1.2999999999999999E-2,1.3,"2024-10-15",313,"2027-10-15",97.04,{"$f":"SUM(G29/((1+$P$6:$P$9)^((I29+$P$3*$N$5:$N$8)/$P$3)))+(100/((1+$P$9)^(C29/$P$3)))","v":95.734529400931365},null,24,8640,2.4531175276811146E-2]
[110252,"0,000 Bund 20",1439,47,3,0,0,"2024-11-15",344,"2027-11-15",91.97,{"$f":"SUM(G30/((1+$P$6:$P$9)^((I30+$P$3*$N$5:$N$8)/$P$3)))+(100/((1+$P$9)^(C30/$P$3)))","v":90.674549886150459},null,25,9000,2.4558647217219232E-2]
[113506,"5,625 Bund 98",1489,48,4,5.6250000000000001E-2,5.625,"2024-01-04",28,"2028-01-04",113.35,{"$f":"SUM(G31/((1+$P$6:$P$10)^((I31+$P$3*$N$5:$N$9)/$P$3)))+(100/((1+$P$10)^(C31/$P$3)))","v":117.94963921610804},null,26,9360,2.448541392103043E-2]
[110244,"0,500 Bund 18",1531,50,4,5.0000000000000001E-3,0.5,"2024-02-15",70,"2028-02-15",93.59,{"$f":"SUM(G32/((1+$P$6:$P$10)^((I32+$P$3*$N$5:$N$9)/$P$3)))+(100/((1+$P$10)^(C32/$P$3)))","v":93.367232100926245},null,27,9720,2.4310936898863655E-2]
["BU2500","2,200 BO S 187",1589,52,4,2.1999999999999999E-2,2.1999999999999997,"2024-04-13",128,"2028-04-13",100.16,{"$f":"SUM(G33/((1+$P$6:$P$10)^((I33+$P$3*$N$5:$N$9)/$P$3)))+(100/((1+$P$10)^(C33/$P$3)))","v":101.04125683593391},null,28,10080,2.403574959073751E-2]
[113508,"4,750 Bund 98 II",1671,54,4,4.7500000000000001E-2,4.75,"2024-07-04",210,"2028-07-04",111.34,{"$f":"SUM(G34/((1+$P$6:$P$10)^((I34+$P$3*$N$5:$N$9)/$P$3)))+(100/((1+$P$10)^(C34/$P$3)))","v":112.45322624812304},null,29,10440,2.366129814740825E-2]
[110245,"0,250 Bund 18",{"$f":"J35-$P$2","v":1713},{"$f":"DATEDIF($P$2,J35,\"M\")","v":56},{"$f":"DATEDIF($P$2,J35,\"Y\")","v":4},2.5000000000000001E-3,0.25,"2024-08-15",{"$f":"H35-$P$2","v":252},"2028-08-15",91.91,{"$f":"SUM(G35/((1+$P$6:$P$10)^((I35+$P$3*$N$5:$N$9)/$P$3)))+(100/((1+$P$10)^(C35/$P$3)))","v":91.152476419187522},null,30,10800,2.3189800041448327E-2]
["BU2501","2,400 BO S 188",1778,58,4,2.4E-2,2.4,"2024-10-19",317,"2028-10-19",101.22,{"$f":"SUM(G36/((1+$P$6:$P$10)^((I36+$P$3*$N$5:$N$9)/$P$3)))+(100/((1+$P$10)^(C36/$P$3)))","v":100.76551923061406},null,"Mispricing",null,{"$f":"SUMSQ(K3:K70-L3:L70)","v":621.00662461839102}]
[110255,"0,000 Bund 21",1805,59,4,0,0,"2024-11-15",344,"2028-11-15",90.34,{"$f":"SUM(G37/((1+$P$6:$P$10)^((I37+$P$3*$N$5:$N$9)/$P$3)))+(100/((1+$P$10)^(C37/$P$3)))","v":89.477670454454511}]
[110246,"0,250 Bund 19",1897,62,5,2.5000000000000001E-3,0.25,"2024-02-15",70,"2029-02-15",91.19,{"$f":"SUM(G38/((1+$P$6:$P$11)^((I38+$P$3*$N$5:$N$10)/$P$3)))+(100/((1+$P$11)^(C38/$P$3)))","v":91.168507762888467},null,"Anpassung"]
[110247,"0,000 Bund 19",2078,68,5,0,0,"2024-08-15",252,"2029-08-15",89.08,{"$f":"SUM(G39/((1+$P$6:$P$11)^((I39+$P$3*$N$5:$N$10)/$P$3)))+(100/((1+$P$11)^(C39/$P$3)))","v":88.840039737641831},null,"Mittelwert (Tatsächliche Preise)",{"$f":"AVERAGE(K3:K70)","v":96.080161764705863}]
[110262,"2,100 Bund 22",2170,71,5,2.1000000000000001E-2,2.1,"2024-11-15",344,"2029-11-15",100.01,{"$f":"SUM(G40/((1+$P$6:$P$11)^((I40+$P$3*$N$5:$N$10)/$P$3)))+(100/((1+$P$11)^(C40/$P$3)))","v":99.960138423530424},null,"Totale Quadratsumme (SQT)",{"$f":"SUM((K3:K70-$O$39)^2)","v":13924.269889220584}]
[113514,"6,250 Bund 00",2220,72,6,6.25E-2,6.25,"2024-01-04",28,"2030-01-04",123.54,{"$f":"SUM(G41/((1+$P$6:$P$12)^((I41+$P$3*$N$5:$N$11)/$P$3)))+(100/((1+$P$12)^(C41/$P$3)))","v":129.61462736566386},null,"Residuenquadratsumme (SQR)",{"$f":"SUM((K3:K70-L3:L70)^2)","v":621.00662461839102}]
[110249,"0,000 Bund 20",2262,74,6,0,0,"2024-02-15",70,"2030-02-15",88.2,{"$f":"SUM(G42/((1+$P$6:$P$12)^((I42+$P$3*$N$5:$N$11)/$P$3)))+(100/((1+$P$12)^(C42/$P$3)))","v":88.544727016777941},null,"R squared",{"$f":"1-(O41/O40)","v":0.95540113560286988}]
[110250,"0,000 Bund 20 II",2443,80,6,0,0,"2024-08-15",252,"2030-08-15",87.3,{"$f":"SUM(G43/((1+$P$6:$P$12)^((I43+$P$3*$N$5:$N$11)/$P$3)))+(100/((1+$P$12)^(C43/$P$3)))","v":87.686913842826911}]
[103070,"0,000 Bund 20 Green",2443,80,6,0,0,"2024-08-15",252,"2030-08-15",87.4,{"$f":"SUM(G44/((1+$P$6:$P$12)^((I44+$P$3*$N$5:$N$11)/$P$3)))+(100/((1+$P$12)^(C44/$P$3)))","v":87.686913842826911}]
["BU2700","2,400 Bund 23",2535,83,6,2.4E-2,2.4,"2024-11-15",344,"2030-11-15",101.83,{"$f":"SUM(G45/((1+$P$6:$P$12)^((I45+$P$3*$N$5:$N$11)/$P$3)))+(100/((1+$P$12)^(C45/$P$3)))","v":102.59089678157437}]
[113517,"5,500 Bund 00",2585,84,7,5.5E-2,5.5,"2024-01-04",28,"2031-01-04",122.2,{"$f":"SUM(G46/((1+$P$6:$P$13)^((I46+$P$3*$N$5:$N$12)/$P$3)))+(100/((1+$P$13)^(C46/$P$3)))","v":128.23927422323106}]
[110253,"0,000 Bund 21",2627,86,7,0,0,"2024-02-15",70,"2031-02-15",86.33,{"$f":"SUM(G47/((1+$P$6:$P$13)^((I47+$P$3*$N$5:$N$12)/$P$3)))+(100/((1+$P$13)^(C47/$P$3)))","v":87.264464864658748}]
[110256,"0,000 Bund 21 II",2808,92,7,0,0,"2024-08-15",252,"2031-08-15",85.4,{"$f":"SUM(G48/((1+$P$6:$P$13)^((I48+$P$3*$N$5:$N$12)/$P$3)))+(100/((1+$P$13)^(C48/$P$3)))","v":86.449231209165902}]
[103073,"0,000 Bund 21 Green",2808,92,7,0,0,"2024-08-15",252,"2031-08-15",85.45,{"$f":"SUM(G49/((1+$P$6:$P$13)^((I49+$P$3*$N$5:$N$12)/$P$3)))+(100/((1+$P$13)^(C49/$P$3)))","v":86.449231209165902}]
[110258,"0,000 Bund 22",2992,98,8,0,0,"2024-02-15",70,"2032-02-15",84.36,{"$f":"SUM(G50/((1+$P$6:$P$14)^((I50+$P$3*$N$5:$N$13)/$P$3)))+(100/((1+$P$14)^(C50/$P$3)))","v":85.866056112934046}]
[110260,"1,700 Bund 22",3174,104,8,1.7000000000000001E-2,1.7000000000000002,"2024-08-15",252,"2032-08-15",96.71,{"$f":"SUM(G51/((1+$P$6:$P$14)^((I51+$P$3*$N$5:$N$13)/$P$3)))+(100/((1+$P$14)^(C51/$P$3)))","v":98.932151774054944}]
["BU2Z00","2,300 Bund 23",3358,110,9,2.3E-2,2.2999999999999998,"2024-02-15",70,"2033-02-15",101.3,{"$f":"SUM(G52/((1+$P$6:$P$15)^((I52+$P$3*$N$5:$N$14)/$P$3)))+(100/((1+$P$15)^(C52/$P$3)))","v":105.24420317619047}]
["BU3Z00","2,300 Bund 23 Green",3358,110,9,2.3E-2,2.2999999999999998,"2024-02-15",70,"2033-02-15",101.35,{"$f":"SUM(G53/((1+$P$6:$P$15)^((I53+$P$3*$N$5:$N$14)/$P$3)))+(100/((1+$P$15)^(C53/$P$3)))","v":105.24420317619047}]
["BU2Z01","2,600 Bund 23",3539,116,9,2.5999999999999999E-2,2.6,"2024-08-15",252,"2033-08-15",103.67,{"$f":"SUM(G54/((1+$P$6:$P$15)^((I54+$P$3*$N$5:$N$14)/$P$3)))+(100/((1+$P$15)^(C54/$P$3)))","v":106.9167154075536}]
[113522,"4,750 Bund 03",3862,126,10,4.7500000000000001E-2,4.75,"2024-07-04",210,"2034-07-04",123.69,{"$f":"SUM(G55/((1+$P$6:$P$15)^((I55+$P$3*$N$5:$N$14)/$P$3)))+(100/((1+$P$15)^(C55/$P$3)))","v":125.00394655979784}]
[110251,"0,000 Bund 20",4177,137,11,0,0,"2024-05-15",160,"2035-05-15",77.42,{"$f":"SUM(G56/((1+$P$6:$P$15)^((I56+$P$3*$N$5:$N$14)/$P$3)))+(100/((1+$P$15)^(C56/$P$3)))","v":80.879808857096023}]
[110254,"0,000 Bund 21",4543,149,12,0,0,"2024-05-15",160,"2036-05-15",75.36,{"$f":"SUM(G57/((1+$P$6:$P$15)^((I57+$P$3*$N$5:$N$14)/$P$3)))+(100/((1+$P$15)^(C57/$P$3)))","v":79.389820272661865}]
[113527,"4,000 Bund 05",4777,156,13,0.04,4,"2024-01-04",28,"2037-01-04",118.82,{"$f":"SUM(G58/((1+$P$6:$P$15)^((I58+$P$3*$N$5:$N$14)/$P$3)))+(100/((1+$P$15)^(C58/$P$3)))","v":114.95057255186713}]
[110259,"1,000 Bund 22",5273,173,14,0.01,1,"2024-05-15",160,"2038-05-15",83.52,{"$f":"SUM(G59/((1+$P$6:$P$15)^((I59+$P$3*$N$5:$N$14)/$P$3)))+(100/((1+$P$15)^(C59/$P$3)))","v":85.544180330669121}]
[113532,"4,250 Bund 07",5688,186,15,4.2500000000000003E-2,4.25,"2024-07-04",210,"2039-07-04",123.91,{"$f":"SUM(G60/((1+$P$6:$P$15)^((I60+$P$3*$N$5:$N$14)/$P$3)))+(100/((1+$P$15)^(C60/$P$3)))","v":113.21556358963392}]
[113536,"4,750 Bund 08",6054,198,16,4.7500000000000001E-2,4.75,"2024-07-04",210,"2040-07-04",131.85,{"$f":"SUM(G61/((1+$P$6:$P$15)^((I61+$P$3*$N$5:$N$14)/$P$3)))+(100/((1+$P$15)^(C61/$P$3)))","v":116.34297784563617}]
[113543,"3,250 Bund 10",6784,222,18,3.2500000000000001E-2,3.25,"2024-07-04",210,"2042-07-04",112.31,{"$f":"SUM(G62/((1+$P$6:$P$24)^((I62+$P$3*$N$5:$N$23)/$P$3)))+(100/((1+$P$24)^(C62/$P$3)))","v":116.11401842136291}]
[113548,"2,500 Bund 12",7515,246,20,2.5000000000000001E-2,2.5,"2024-07-04",210,"2044-07-04",101.38,{"$f":"SUM(G63/((1+$P$6:$P$26)^((I63+$P$3*$N$5:$N$25)/$P$3)))+(100/((1+$P$26)^(C63/$P$3)))","v":103.44579050954883}]
[110234,"2,500 Bund 14",8287,272,22,2.5000000000000001E-2,2.5,"2024-08-15",252,"2046-08-15",101.86,{"$f":"SUM(G64/((1+$P$6:$P$28)^((I64+$P$3*$N$5:$N$27)/$P$3)))+(100/((1+$P$28)^(C64/$P$3)))","v":102.56039816066371}]
[110243,"1,250 Bund 17",9018,296,24,1.2500000000000001E-2,1.25,"2024-08-15",252,"2048-08-15",79.52,{"$f":"SUM(G65/((1+$P$6:$P$30)^((I65+$P$3*$N$5:$N$29)/$P$3)))+(100/((1+$P$30)^(C65/$P$3)))","v":78.424903871411033}]
[110248,"0,000 Bund 19",9748,320,26,0,0,"2024-08-15",252,"2050-08-15",54.21,{"$f":"SUM(G66/((1+$P$6:$P$32)^((I66+$P$3*$N$5:$N$31)/$P$3)))+(100/((1+$P$32)^(C66/$P$3)))","v":52.183087491426534}]
[103072,"0,000 Bund 21 Green",9748,320,26,0,0,"2024-08-15",{"$f":"H67-$P$2","v":252},"2050-08-15",54.48,{"$f":"SUM(G67/((1+$P$6:$P$32)^((I67+$P$3*$N$5:$N$31)/$P$3)))+(100/((1+$P$32)^(C67/$P$3)))","v":52.183087491426534}]
[110257,"0,000 Bund 21",10479,344,28,0,{"$f":"100*F68","v":0},"2024-08-15",252,"2052-08-15",51.74,{"$f":"SUM(G68/((1+$P$6:$P$34)^((I68+$P$3*$N$5:$N$33)/$P$3)))+(100/((1+P34)^(C68/$P$3)))","v":50.625286839208741}]
[110261,"1,800 Bund 22",10844,356,29,1.7999999999999999E-2,1.7999999999999998,"2024-08-15",252,"2053-08-15",88.04,{"$f":"SUM(G69/((1+$P$6:$P$35)^((I69+$P$3*$N$5:$N$34)/$P$3)))+(100/((1+$P$35)^(C69/$P$3)))","v":89.321818708239391}]
[103075,"1,800 Bund 23 Green",10844,356,29,1.7999999999999999E-2,1.7999999999999998,"2024-08-15",252,"2053-08-15",88.22,{"$f":"SUM(G70/((1+$P$6:$P$35)^((I70+$P$3*$N$5:$N$34)/$P$3)))+(100/((1+$P$35)^(C70/$P$3)))","v":89.321818708239391}]
[]
["Rastersuche"]
[]
[]
["                  μ\n  λ",0.1,1,10,25,50,75,100]
[0.1,0.93544052143868006,0.94086391745124853,0.93618964220465584,0.94985234281377384,0.94963707688425969,0.9494472909578151,0.94933925189148693]
[1,0.94057052218815518,0.94203641296641305,0.93911416266254455,0.95060993895846357,0.95023935054583863,0.9496584033786436,0.94936867393460711]
[10,0.94921684602407008,0.95074041101843154,0.94766689651102376,0.94873098363253039,0.94769812221960115,0.95524128052722124,0.94690403481547936]
[25,0.94916707630145403,0.95084627326592619,0.94901072468157566,0.94467213156902941,0.94056956374598222,0.94465535863804106,0.94469975939045203]
[50,0.94968143267211935,0.9502182827081106,0.94695419293110961,0.94492361877560838,0.94387664644066505,0.94392081326184163,0.9439360493805995]
[75,0.94947529922431062,0.94918231067183412,0.94714155500296238,0.94444440661923368,0.94390832748863507,0.94362495072378305,0.94365429967346715]
[100,0.94935664646269236,0.94851336543061415,0.94712047112566589,0.94450453512588772,0.9438917308834297,0.94365551005725146,0.94248811857208104]
[]
[]
[]
["                  μ\n  λ",70,71,72,73,74,75,76,77,78,79]
[5,0.95443101711401213,0.95443480270087588,0.95443843390410099,0.95444191991565608,0.95444526949562425,0.95444849053020842,0.95445159055277529,0.95445457617281337,0.95445745382199509,0.95446022930065422]
[6,0.95489542560904261,0.954898723777453,0.95490187152319383,0.95490487897578125,0.95490775562946195,0.95491050958279711,0.95491314879394074,0.95491568039412955,0.95491811072219757,0.95492044585803848]
[7,0.95515018427226828,0.95515315441626192,0.95515596670353597,0.95515863378194754,0.9551611666981773,0.95516357507962002,0.95516586777662582,0.95516805317362308,0.95517013880702295,0.95517213139324408]
[8,0.95527309281422945,0.95527646604139116,0.95527961903126912,0.95528257153057083,0.95528534233028695,0.95528794631672953,0.95529039734875409,0.95529270833995228,0.95529489099481246,0.95529695403268433]
[9,0.95534504436718481,0.95530656825322158,0.94724643859921731,0.94737902011445463,0.94779745281687389,0.94779329558905256,0.94779703254468362,0.94780407400818978,0.94781128696181194,0.94781759444018532]
[10,0.95517722476699773,0.94687206226654586,0.95521414055615039,0.94640978688928823,0.95527844436434473,0.95524128052722124,0.95524825961274429,0.95534921307012866,0.95525664779671871,0.95526569476027834]
[11,0.95535341424700793,0.94706232098843435,0.94704860888914366,0.94703586245737426,0.94702224408653546,0.9470063289318974,0.94699205056024449,0.94699407421336423,0.94697302460806421,0.94696627244743026]
[12,0.94649168109185533,0.94649013116969605,0.94654621709184594,0.94653921869298607,0.94654819277871627,0.94658763278516256,0.94655067887200584,0.94655224576243513,0.94655791910445841,0.94655826095849116]
[13,0.94628534481635351,0.94625946214983148,0.94625844979890672,0.94625988000654926,0.94626119879059034,0.94625496339092874,0.94624894458435127,0.94624350452467376,0.94623910139331935,0.94626522568604221]
[14,0.94591680401008793,0.9458869392395699,0.94592114240613856,0.9461841062021864,0.94645784168795333,0.94648736150452084,0.94651525061472264,0.94653203812922404,0.94652851972009655,0.94654085801604115]
[15,0.94584813087682607,0.94584698735838257,0.94585157429020661,0.94584900919606663,0.94584663394157964,0.94584478008835471,0.94584333763910922,0.94584206811723603,0.94584094550911135,0.94583996325975339]
[]
[]
[]
["                  μ\n  λ",65,66,67,68,69,70,71,72,73,74]
[8,0.95525201060187015,0.95525689672200198,0.95526141128332387,0.95526559366896091,0.95526947776465165,0.95527309281422945,0.95527646604139116,0.95527961903126912,0.95528257153057083,0.95528534233028695]
[9,0.95525337583764025,0.95526381943633942,0.95528769517669576,0.95529425198150264,0.95533640066959979,0.95534504436718481,0.95530656825322158,0.94724643859921731,0.94737902011445463,0.94779745281687389]
[10,0.95523799591670899,0.95535170986508122,0.95516714631136423,0.95514884260328659,0.95516846924987309,0.95517722476699773,0.94687206226654586,0.95521414055615039,0.94640978688928823,0.95527844436434473]
[11,0.94715598735035877,0.94717296046169552,0.94718687624600084,0.9471986831699426,0.94720895383993664,0.95535341424700793,0.94706232098843435,0.94704860888914366,0.94703586245737426,0.94702224408653546]
[12,0.94663375337365729,0.94650201431245595,0.94651008103034662,0.94651077077613188,0.94650592902206721,0.94649168109185533,0.94649013116969605,0.94654621709184594,0.94653921869298607,0.94654819277871627]
[]
[]
[]
["                  μ\n  λ",69.5,69.599999999999994,69.7,69.8,69.900000000000006,70,70.099999999999994,70.2,70.3,70.400000000000006]
[10.5,0.95504383391425407,0.95504460525137647,0.95504643133745071,0.95509988275437474,0.95508111667519036,0.95507430499492574,0.95506977801856741,0.95506757435350809,0.95506751309965554,0.95506872439693125]
[10.6,0.95504386157703614,0.94714837593230594,0.95502915819883827,0.95503057958761939,0.95502089385883271,0.95527416919200148,0.95502607499307302,0.95508760891233579,0.95508443660735431,0.94706157378288369]
[10.7,0.95504222515176274,0.95499718096425501,0.95497559226833306,0.9549832614279945,0.95503726435023983,0.95520191636379004,0.95534137868181368,0.95529361804937418,0.9550693071176497,0.95502066413330244]
[10.8,0.94701347927903479,0.94701177608219567,0.94701010064633762,0.94700843194785989,0.94700678108938674,0.947005135560541,0.94700351430047736,0.94700190271870177,0.94700030767952703,0.94699874139446072]
[10.9,0.94708977004105288,0.94706926368095967,0.94706718795167644,0.94708380166470485,0.94706305233372701,0.947061029593804,0.94705900317295844,0.94705696385802352,0.9470549411097311,0.94705294590423883]
[11,0.9553144656142416,0.95531736887675378,0.955322756465522,0.95532889529291665,0.95533519940859779,0.95535341424700793,0.95536672986472404,0.95525608691645414,0.95534750230243659,0.94706509869337585]
[11.1,0.94715319314209778,0.94715399971005998,0.94715739402901988,0.94715559509336489,0.94715637942611963,0.94715716283746454,0.94715793811624827,0.94715870609932729,0.94715947013971169,0.94716022948584122]
[11.2,0.9467494882827191,0.94682759668708638,0.95481994233123479,0.95495934903948421,0.95488602122810895,0.94695445496780706,0.94695942782258868,0.94696416430988573,0.94696867888329639,0.94697297009534054]
[11.3,0.94668727381734119,0.9466881116749738,0.94682536043509213,0.946825383107466,0.94682541607179815,0.94682545835230414,0.94682551286627714,0.94682558436563857,0.94682566041066096,0.94682575734734453]
[11.4,0.94656047810579902,0.94656034072904982,0.94656030115152268,0.94656051057364421,0.94656076240501508,0.94656104426701937,0.9465613599621564,0.94656170231525927,0.94656206759013728,0.94656245537831241]
[11.5,0.94661235186115,0.94660993683057693,0.94660744911973826,0.9466048426037047,0.94660213015188976,0.94659933125913975,0.94659642653758158,0.94659343682562347,0.94659035653299028,0.94660679860405372]
[]
[]
[]
["                  μ\n  λ",70.05,70.06,70.069999999999993,70.08,70.09,70.099999999999994,70.11,70.11999999999999,70.13,70.14]
[10.95,0.95519480156474301,0.95497562319824114,0.94714318975934808,0.94702695558815364,0.94721729865117221,0.95498126621767565,0.95489065466539014,0.95505614546210882,0.95488249681933568,0.94698787504407722]
[10.959999999999999,0.94680588395883558,0.94679355355190853,0.94684215659044635,0.94717333216795985,0.9471755561851406,0.94713000105124645,0.94712939065284663,0.94712872726879704,0.94712808647018643,0.94716255685923345]
[10.969999999999999,0.94668203371177062,0.94668122436958169,0.94668067952071144,0.94668097003329899,0.94668717440253658,0.95488537357591674,0.94671118509272434,0.94670449346634722,0.94675765383669697,0.9551677933925542]
[10.979999999999999,0.94723331176892178,0.94723338491335807,0.94723346411460185,0.94723354252280678,0.94723361686692154,0.94723369404539526,0.94723357459436908,0.94723384654598275,0.9472339215062815,0.94723399886694681]
[10.989999999999998,0.94705654334597456,0.94705645871817268,0.94705637304720447,0.94705629406059189,0.947056216374495,0.94705612283062468,0.9470560401338759,0.94705594583723784,0.94705586713199463,0.94705577968413912]
[11,0.9553555564501256,0.95535819145598999,0.9553608011122745,0.95536221348349393,0.95536419436396847,0.95536672986472404,0.95536926586405868,0.95537233066764526,0.95537511530321795,0.95537852736463569]
[11.01,0.95525442156597029,0.95521143202141201,0.94710776111069506,0.94701123879522719,0.94699002669281662,0.94698822218361156,0.94698885276551426,0.94708413345182296,0.95485182799982071,0.94716768443659793]
[11.02,0.94710302602490315,0.94710298478313526,0.94710292636762095,0.94710292041216193,0.94710306540330169,0.94718441821313459,0.94710295228999786,0.94710261743165103,0.94683426965881745,0.94710240468330353]
[11.03,0.94721841079813818,0.94721846250500574,0.94721870245456552,0.94721856262734905,0.94721880164380667,0.94721885394785998,0.94721890491724148,0.94721876209184064,0.94668179350884329,0.946680563041844]
[11.04,0.94721095919493303,0.9472110125237847,0.94721106614552208,0.94721130865029224,0.94721117401488897,0.94721141373639106,0.94721128075851857,0.94721133315250772,0.94721138811014371,0.94721162853140806]
[11.049999999999999,0.94689751811454459,0.94689682656598362,0.94689622523955463,0.94689562639510771,0.94689506613310981,0.94689483344942693,0.94692772410234893,0.94689378364750154,0.94689311150255873,0.94689284144998864]
[]
[]
[]
["                  μ\n  λ",70.14,70.150000000000006,70.16,70.17,70.180000000000007,70.19,70.2]
[10.99,0.94705577976548805,0.94705569318788796,0.94705559473912282,0.94705552287621186,0.94705543168319517,0.94705534876228958,0.94705524546477005]
[11,0.95537852736463569,0.95538228174786555,0.95538618772549955,0.95538992874677253,0.95539453682978082,0.9553991919500523,0.95525608691645414]
[11.01,0.94716768443659793,0.94717066987672449,0.94719371941267194,0.95538878669504346,0.9471929603984397,0.94716810825343045,0.95485732649134536]
[]
[]
[]
["                  μ\n  λ",70.185000000000002,70.186000000000007,70.186999999999998,70.188000000000002,70.189000000000007,70.19,70.191000000000003,70.192000000000007,70.192999999999998,70.194000000000003]
[10.994999999999999,0.94706451460401975,0.94706451373645162,0.94706452232732863,0.94706453189465589,0.9470645416529121,0.9470645536707869,0.94706455830586123,0.94706456062891442,0.94706458130942184,0.94706458570273511]
[10.995999999999999,0.94706260420041843,0.94706260274340848,0.94706261444630679,0.94706261948134451,0.94706262633512417,0.94706263356597342,0.94706264923037609,0.94706265258062061,0.94706265808492063,0.94706266743991896]
[10.997,0.94706335512298723,0.94706335507268824,0.94706334044940499,0.94706333220806105,0.94706331758816231,0.94706331246045194,0.94706330769593605,0.94706330984335585,0.94706329811770884,0.94706328753586499]
[10.997999999999999,0.94706441995391077,0.94706441900655514,0.94706441488439874,0.9470644092201862,0.94706440264458924,0.94706439454885294,0.94706438583058417,0.94706438185524966,0.947064377584937,0.94706436984275921]
[10.998999999999999,0.95536599210601381,0.95536706912368796,0.95536864331971849,0.95536881322267087,0.95536936777254289,0.95536953689396198,0.95536982651476987,0.95537028427227533,0.95537058455586732,0.95537073761643221]
[11,0.9553965329538523,0.95539721771353869,0.95539791123434603,0.9553980015852569,0.95539874164023475,0.9553991919500523,0.95539943674776229,0.95539975944624644,0.95540027043560793,0.95540066099038434]
[11.000999999999999,0.95535980606470183,0.9553598847681859,0.95536029035519499,0.95536041964061924,0.95536073910960195,0.95536089783987288,0.95536121158290332,0.95536152812978736,0.95536174557390441,0.95536212802480114]
[11.001999999999999,0.95534507742150443,0.95534514394278858,0.95534532170410591,0.95534534141837546,0.95534547316740193,0.95534551311134819,0.95534565413921779,0.95534572188805422,0.95534579964797162,0.95534600057115493]
[11.002999999999998,0.95533829800721881,0.95533834862073719,0.95533840143313009,0.95533849623384881,0.95533855100978393,0.95533868458472748,0.95533870229332074,0.95533877731827377,0.95533883746236459,0.95533890910309727]
[11.004,0.95533662904695782,0.95533666819530971,0.95533704874018732,0.95533770352046443,0.95533839806655663,0.95533907852660671,0.95533883280260734,0.95533820560679283,0.95533779318629275,0.95534017352186995]
[11.004999999999999,0.95533603147290691,0.95533603134540124,0.95533610880089614,0.95533611914090633,0.95533614473134143,0.95533616388695497,0.95533616781168873,0.95533621278033753,0.95533627336665794,0.95533630056112617]
[]
[]
[]
["                  μ\n  λ",70.194000000000003,70.194999999999993,70.195999999999998,70.197000000000003,70.197999999999993,70.198999999999998,70.2]
[10.999000000000001,0.95537074241807463,0.9553837039913935,0.95538597543889558,0.95538692348723131,0.95538906502892618,0.95539075541796437,0.95539186633325224]
[11,0.95540066099038434,0.95540111855980048,0.95525340362702105,0.95525405559015786,0.95525476109683705,0.95525506496963897,0.95525608691645414]
[11.000999999999999,0.95536212802480114,0.95536249788654393,0.95536273073277056,0.9553628155688253,0.95536318765015626,0.95536326587090903,0.95536366477725965]

{"sheet":"United Kingdom","index":1,"n_rows":147,"n_cols":26,"rows_kept":147,"cut":false,"hidden":false,"merged":[[1,15,1,16],[2,15,2,16],[0,19,0,25],[65,0,66,13],[55,15,55,16],[57,15,57,16],[0,0,0,13],[0,15,0,17]]}
["Daten des UK Debt Management Office",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bewertung der Anleihen",null,null,null,"Nelson-Siegel-Svensson Modellparameter"]
["ISIN","Bezeichnung","Laufzeit (Tage)","Laufzeit (Monate)","Laufzeit (Jahre)","Kupon","Kuponwert bei einer Zahlung","Erste Kuponfälligkeit ","Tage bis zur ersten Kuponfälligkeit","Zweite Kuponfälligkeit","Tage bis zur zweiten Kuponfälligkeit","Fälligkeit","Tatsächlicher Preis","Theoretischer Preis",null,"Ausgangsdatum",null,"2023-12-08",null,"β0","β1","β2","β3","λ","μ","β0+β1"]
["GB00BMGR2791","0 1/8% Treasury Gilt 2024",{"$f":"L3-$R$2","v":54},{"$f":"DATEDIF($R$2,L3,\"M\")","v":1},{"$f":"DATEDIF($R$2,L3,\"Y\")","v":0},1.25E-3,{"$f":"(100*F3)/2","v":6.25E-2},"2024-01-31",{"$f":"H3-$R$2","v":54},"-","-","2024-01-31",99.29,{"$f":"SUM(G3/((1+$R$6)^(I3/$R$3))) + (100/((1+$R$6)^(C3/$R$3)))","v":98.96262700567631},null,"Tage im Jahr",null,360,null,2.3299921922053081E-2,-1.184655532255802E-2,8.5800887654535238E-2,1.0217929696148267,12.532999999999999,0.06,{"$f":"T3+U3","v":1.1453366599495061E-2}]
["GB00BFWFPL34","1% Treasury Gilt 2024",136,4,0,0.01,{"$f":"(100*F4)/2","v":0.5},"2024-04-22",136,"-","-","2024-04-22",98.5,{"$f":"SUM(G4/((1+$R$6)^(I4/$R$3))) + (100/((1+$R$6)^(C4/$R$3)))","v":97.741012933112572},null,"Laufzeit (in Jahren)","Laufzeit (in Tagen)","Kassazinssätze"]
["GB00BHBFH458","2¾% Treasury Gilt 2024",274,8,0,2.75E-2,1.375,"2024-03-07",90,{"$f":"EDATE(H5,6)","v":"2024-09-07"},{"$f":"J5-$R$2","v":274},"2024-09-07",98.4,{"$f":"SUM(G5/((1+$R$6)^(I5/$R$3))) + SUM(G5/((1+$R$6)^(K5/$R$3))) + (100/((1+$R$6)^(C5/$R$3)))","v":97.196043762864178},null,0,{"$f":"P5*$R$3","v":0}]
["GB00BLPK7110","0¼% Treasury Gilt 2025",420,13,1,2.5000000000000001E-3,0.125,"2024-01-31",54,"2024-07-31",236,"2025-01-31",95.09,{"$f":"SUM(G6/((1+$R$6:$R$7)^((I6+$R$3*$P$5:$P$6)/$R$3))) + SUM(G6/((1+$R$6)^(K6/$R$3))) + (100/((1+$R$7)^(C6/$R$3)))","v":94.915683347576092},null,1,{"$f":"P6*$R$3","v":360},{"$f":"$T$3 + $U$3*((1-EXP(-P6/$X$3))/(P6/$X$3)) + $V$3*(((1-EXP(-P6/$X$3))/(P6/$X$3))-EXP(-P6/$X$3)) + $W$3*(((1-EXP(-P6/$Y$3))/(P6/$Y$3))-EXP(-P6/$Y$3))","v":7.6467427146634376E-2}]
["GB0030880693","5% Treasury Stock 2025",455,14,1,0.05,2.5,"2024-03-07",90,"2024-09-07",274,"2025-03-07",100.34,{"$f":"SUM(G7/((1+$R$6:$R$7)^((I7+$R$3*$P$5:$P$6)/$R$3))) + SUM(G7/((1+$R$6)^(K7/$R$3))) + (100/((1+$R$7)^(C7/$R$3)))","v":101.28695234644994},null,2,720,{"$f":"$T$3 + $U$3*((1-EXP(-P7/$X$3))/(P7/$X$3)) + $V$3*(((1-EXP(-P7/$X$3))/(P7/$X$3))-EXP(-P7/$X$3)) + $W$3*(((1-EXP(-P7/$Y$3))/(P7/$Y$3))-EXP(-P7/$Y$3))","v":4.9163518638630964E-2}]
["GB00BK5CVX03","0 5/8% Treasury Gilt 2025",547,17,1,6.2500000000000003E-3,0.3125,"2024-06-07",182,"2024-12-07",365,"2025-06-07",94.48,{"$f":"SUM(G8/((1+$R$6:$R$7)^((I8+$R$3*$P$5:$P$6)/$R$3))) + SUM(G8/((1+$R$6)^(K8/$R$3))) + (100/((1+$R$7)^(C8/$R$3)))","v":93.84903521021414},null,3,1080,4.1968838291041297E-2]
["GB00BTHH2R79","2% Treasury Gilt 2025",639,20,1,0.02,1,"2024-03-07",90,"2024-09-07",274,"2025-09-07",95.94,{"$f":"SUM(G9/((1+$R$6:$R$7)^((I9+$R$3*$P$5:$P$6)/$R$3))) + SUM(G9/((1+$R$6:$R$7)^((K9+$R$3*$P$5:$P$6)/$R$3))) + (100/((1+$R$7)^(C9/$R$3)))","v":95.621902154570066},null,4,1440,3.9584270037172797E-2]
["GB00BPCJD880","3½% Treasury Gilt 2025",684,22,1,3.5000000000000003E-2,1.7500000000000002,"2024-04-22",136,"2024-10-22",319,"2025-10-22",98.15,{"$f":"SUM(G10/((1+$R$6:$R$7)^((I10+$R$3*$P$5:$P$6)/$R$3))) + SUM(G10/((1+$R$6:$R$7)^((K10+$R$3*$P$5:$P$6)/$R$3))) + (100/((1+$R$7)^(C10/$R$3)))","v":97.86261134462616},null,5,1800,3.8969902426845164E-2]
["GB00BL68HJ26","0 1/8% Treasury Gilt 2026",784,25,2,1.25E-3,6.25E-2,"2024-01-30",53,"2024-07-30",235,"2026-01-30",91.63,{"$f":"SUM(G11/((1+$R$6:$R$8)^((I11+$R$3*$P$5:$P$7)/$R$3))) + SUM(G11/((1+$R$6:$R$7)^((K11+$R$3*$P$5:$P$6)/$R$3))) + (100/((1+$R$8)^(C11/$R$3)))","v":91.731315495222105},null,6,2160,3.9127340225038054E-2]
["GB00BYZW3G56","1½% Treasury Gilt 2026",957,31,2,1.4999999999999999E-2,0.75,"2024-01-22",45,"2024-07-22",227,"2026-07-22",93.37,{"$f":"SUM(G12/((1+$R$6:$R$8)^((I12+$R$3*$P$5:$P$7)/$R$3))) + SUM(G12/((1+$R$6:$R$8)^((K12+$R$3*$P$5:$P$7)/$R$3))) + (100/((1+$R$8)^(C12/$R$3)))","v":93.870664618293873},null,7,2520,3.9640164835715225E-2]
["GB00BNNGP668","0 3/8% Treasury Gilt 2026",1049,34,2,3.7499999999999999E-3,0.1875,"2024-04-22",136,"2024-10-22",319,"2026-10-22",89.8,{"$f":"SUM(G13/((1+$R$6:$R$8)^((I13+$R$3*$P$5:$P$7)/$R$3))) + SUM(G13/((1+$R$6:$R$8)^((K13+$R$3*$P$5:$P$7)/$R$3))) + (100/((1+$R$8)^(C13/$R$3)))","v":89.751483712371524},null,8,2880,4.0309159954788752E-2]
["GB00BL6C7720","4 1/8% Treasury Gilt 2027",1148,37,3,4.1250000000000002E-2,2.0625,"2024-01-29",52,"2024-07-29",234,"2027-01-29",99.69,{"$f":"SUM(G14/((1+$R$6:$R$9)^((I14+$R$3*$P$5:$P$8)/$R$3))) + SUM(G14/((1+$R$6:$R$8)^((K14+$R$3*$P$5:$P$7)/$R$3))) + (100/((1+$R$9)^(C14/$R$3)))","v":101.78404762801431},null,9,3240,4.1030809322825386E-2]
["GB00BDRHNP05","1¼% Treasury Gilt 2027",1322,43,3,1.2500000000000001E-2,0.625,"2024-01-22",45,"2024-07-22",227,"2027-07-22",90.78,{"$f":"SUM(G15/((1+$R$6:$R$9)^((I15+$R$3*$P$5:$P$8)/$R$3))) + SUM(G15/((1+$R$6:$R$9)^((K15+$R$3*$P$5:$P$8)/$R$3))) + (100/((1+$R$9)^(C15/$R$3)))","v":91.329727640636008},null,10,3600,4.1748768682455778E-2]
["GB00B16NNR78","4¼% Treasury Gilt 2027",1460,47,3,4.2500000000000003E-2,2.125,"2024-06-07",182,"2024-12-07",365,"2027-12-07",100.83,{"$f":"SUM(G16/((1+$R$6:$R$9)^((I16+$R$3*$P$5:$P$8)/$R$3))) + SUM(G16/((1+$R$6:$R$9)^((K16+$R$3*$P$5:$P$8)/$R$3))) + (100/((1+$R$9)^(C16/$R$3)))","v":100.82557781162356},null,11,3960,4.2431867666124945E-2]
["GB00BMBL1G81","0 1/8% Treasury Gilt 2028",1515,49,4,1.25E-3,6.25E-2,"2024-01-31",54,"2024-07-31",236,"2028-01-31",85.46,{"$f":"SUM(G17/((1+$R$6:$R$10)^((I17+$R$3*$P$5:$P$9)/$R$3))) + SUM(G17/((1+$R$6:$R$9)^((K17+$R$3*$P$5:$P$8)/$R$3))) + (100/((1+$R$10)^(C17/$R$3)))","v":85.653477001901507},null,12,4320,4.3063160696166454E-2]
["GB00BMF9LG83","4½% Treasury Gilt 2028",1643,53,4,4.4999999999999998E-2,2.25,"2024-06-07",182,"2024-12-07",365,"2028-06-07",101.74,{"$f":"SUM(G18/((1+$R$6:$R$10)^((I18+$R$3*$P$5:$P$9)/$R$3))) + SUM(G18/((1+$R$6:$R$9)^((K18+$R$3*$P$5:$P$8)/$R$3))) + (100/((1+$R$10)^(C18/$R$3)))","v":102.18191616446599},null,13,4680,4.3634073124577538E-2]
["GB00BFX0ZL78","1 5/8% Treasury Gilt 2028",1780,58,4,1.6250000000000001E-2,0.8125,"2024-04-22",136,"2024-10-22",319,"2028-10-22",89.93,{"$f":"SUM(G19/((1+$R$6:$R$10)^((I19+$R$3*$P$5:$P$9)/$R$3))) + SUM(G19/((1+$R$6:$R$10)^((K19+$R$3*$P$5:$P$9)/$R$3))) + (100/((1+$R$10)^(C19/$R$3)))","v":90.061774554514926},null,14,5040,4.4141091356875987E-2]
["GB0002404191","6% Treasury Stock 2028",1826,59,4,0.06,3,"2024-06-07",182,"2024-12-07",365,"2028-12-07",109.06,{"$f":"SUM(G20/((1+$R$6:$R$10)^((I20+$R$3*$P$5:$P$9)/$R$3))) + SUM(G20/((1+$R$6:$R$10)^((K20+$R$3*$P$5:$P$9)/$R$3))) + (100/((1+$R$10)^(C20/$R$3)))","v":109.10625819294326},null,15,5400,4.4583806681452481E-2]
["GB00BLPK7227","0½% Treasury Gilt 2029",1881,61,5,5.0000000000000001E-3,0.25,"2024-01-31",54,"2024-07-31",236,"2029-01-31",84.03,{"$f":"SUM(G21/((1+$R$6:$R$11)^((I21+$R$3*$P$5:$P$10)/$R$3))) + SUM(G21/((1+$R$6:$R$10)^((K21+$R$3*$P$5:$P$9)/$R$3))) + (100/((1+$R$11)^(C21/$R$3)))","v":84.300513193803738},null,16,5760,4.496371792779523E-2]
["GB00BJMHB534","0 7/8% Treasury Gilt 2029",2145,70,5,8.7500000000000008E-3,0.43750000000000006,"2024-04-22",136,"2024-10-22",319,"2029-10-22",84.35,{"$f":"SUM(G22/((1+$R$6:$R$11)^((I22+$R$3*$P$5:$P$10)/$R$3))) + SUM(G22/((1+$R$6:$R$11)^((K22+$R$3*$P$5:$P$10)/$R$3))) + (100/((1+$R$11)^(C22/$R$3)))","v":84.185369804545843},null,17,6120,4.5283478244220209E-2]
["GB00BL68HH02","0 3/8% Treasury Gilt 2030",2510,82,6,3.7499999999999999E-3,0.1875,"2024-04-22",136,"2024-10-22",319,"2030-10-22",78.97,{"$f":"SUM(G23/((1+$R$6:$R$12)^((I23+$R$3*$P$5:$P$11)/$R$3))) + SUM(G23/((1+$R$6:$R$12)^((K23+$R$3*$P$5:$P$11)/$R$3))) + (100/((1+$R$12)^(C23/$R$3)))","v":78.531492228427538},null,18,6480,4.554641135048125E-2]
["GB00B24FF097","4¾% Treasury Gilt 2030",2556,83,6,4.7500000000000001E-2,2.375,"2024-06-07",182,"2024-12-07",365,"2030-12-07",105.11,{"$f":"SUM(G24/((1+$R$6:$R$12)^((I24+$R$3*$P$5:$P$11)/$R$3))) + SUM(G24/((1+$R$6:$R$12)^((K24+$R$3*$P$5:$P$11)/$R$3))) + (100/((1+$R$12)^(C24/$R$3)))","v":104.50476622710103},null,19,6840,4.5756196322583501E-2]
["GB00BMGR2809","0¼% Treasury Gilt 2031",2792,91,7,2.5000000000000001E-3,0.125,"2024-01-31",54,"2024-07-31",236,"2031-07-31",75.94,{"$f":"SUM(G25/((1+$R$6:$R$13)^((I25+$R$3*$P$5:$P$12)/$R$3))) + SUM(G25/((1+$R$6:$R$13)^((K25+$R$3*$P$5:$P$12)/$R$3))) + (100/((1+$R$13)^(C25/$R$3)))","v":75.321098918393673},null,20,7200,4.5916660489033666E-2]
["GB00BM8Z2T38","1% Treasury Gilt 2032",2976,97,8,0.01,0.5,"2024-01-31",54,"2024-07-31",236,"2032-01-31",79.55,{"$f":"SUM(G26/((1+$R$6:$R$14)^((I26+$R$3*$P$5:$P$13)/$R$3))) + SUM(G26/((1+$R$6:$R$13)^((K26+$R$3*$P$5:$P$12)/$R$3))) + (100/((1+$R$14)^(C26/$R$3)))","v":78.951457198382613},null,21,7560,4.6031643160824753E-2]
["GB0004893086","4¼% Treasury Stock 2032",3104,101,8,4.2500000000000003E-2,2.125,"2024-06-07",182,"2024-12-07",365,"2032-06-07",102.25,{"$f":"SUM(G27/((1+$R$6:$R$14)^((I27+$R$3*$P$5:$P$13)/$R$3))) + SUM(G27/((1+$R$6:$R$13)^((K27+$R$3*$P$5:$P$12)/$R$3))) + (100/((1+$R$14)^(C27/$R$3)))","v":100.94931932972796},null,22,7920,4.6104906582177974E-2]
["GB00BMV7TC88","3¼% Treasury Gilt 2033",3342,109,9,3.2500000000000001E-2,1.625,"2024-01-31",54,"2024-07-31",236,"2033-01-31",94.24,{"$f":"SUM(G28/((1+$R$6:$R$15)^((I28+$R$3*$P$5:$P$14)/$R$3))) + SUM(G28/((1+$R$6:$R$14)^((K28+$R$3*$P$5:$P$13)/$R$3))) + (100/((1+$R$15)^(C28/$R$3)))","v":94.17738772334792},null,23,8280,4.6140078797363558E-2]
["GB00BM8Z2S21","0 7/8% Green Gilt 2033",3523,115,9,8.7500000000000008E-3,0.43750000000000006,"2024-01-31",54,"2024-07-31",236,"2033-07-31",74.92,{"$f":"SUM(G29/((1+$R$6:$R$15)^((I29+$R$3*$P$5:$P$14)/$R$3))) + SUM(G29/((1+$R$6:$R$15)^((K29+$R$3*$P$5:$P$14)/$R$3))) + (100/((1+$R$15)^(C29/$R$3)))","v":74.247542593230747},null,24,8640,4.6140618313428181E-2]
["GB00BPJJKN53","4 5/8% Treasury Gilt 2034",3707,121,10,4.6249999999999999E-2,2.3125,"2024-01-31",54,"2024-07-31",236,"2034-01-31",104.33,{"$f":"SUM(G30/((1+$R$6:$R$16)^((I30+$R$3*$P$5:$P$15)/$R$3))) + SUM(G30/((1+$R$6:$R$15)^((K30+$R$3*$P$5:$P$14)/$R$3))) + (100/((1+$R$16)^(C30/$R$3)))","v":104.93473253113669},null,25,9000,4.6109793749575641E-2]
["GB00B52WS153","4½% Treasury Gilt 2034",3926,128,10,4.4999999999999998E-2,2.25,"2024-03-07",90,"2024-09-07",274,"2034-09-07",103.33,{"$f":"SUM(G31/((1+$R$6:$R$16)^((I31+$R$3*$P$5:$P$15)/$R$3))) + SUM(G31/((1+$R$6:$R$16)^((K31+$R$3*$P$5:$P$15)/$R$3))) + (100/((1+$R$16)^(C31/$R$3)))","v":103.49625808446987},null,26,9360,4.6050673822496974E-2]
["GB00BMGR2916","0 5/8% Treasury Gilt 2035",4253,139,11,6.2500000000000003E-3,0.3125,"2024-01-31",54,"2024-07-31",236,"2035-07-31",67.540000000000006,{"$f":"SUM(G32/((1+$R$6:$R$17)^((I32+$R$3*$P$5:$P$16)/$R$3))) + SUM(G32/((1+$R$6:$R$17)^((K32+$R$3*$P$5:$P$16)/$R$3))) + (100/((1+$R$17)^(C32/$R$3)))","v":66.727300588399316},null,27,9720,4.596612445046265E-2]
["GB0032452392","4¼% Treasury Stock 2036",4473,146,12,4.2500000000000003E-2,2.125,"2024-03-07",90,"2024-09-07",274,"2036-03-07",100.59,{"$f":"SUM(G33/((1+$R$6:$R$18)^((I33+$R$3*$P$5:$P$17)/$R$3))) + SUM(G33/((1+$R$6:$R$17)^((K33+$R$3*$P$5:$P$16)/$R$3))) + (100/((1+$R$18)^(C33/$R$3)))","v":100.41582649253039},null,28,10080,4.585881072688297E-2]
["GB00BZB26Y51","1¾% Treasury Gilt 2037",5022,164,13,1.7500000000000002E-2,0.87500000000000011,"2024-03-07",90,"2024-09-07",274,"2037-09-07",73.75,{"$f":"SUM(G34/((1+$R$6:$R$19)^((I34+$R$3*$P$5:$P$18)/$R$3))) + SUM(G34/((1+$R$6:$R$19)^((K34+$R$3*$P$5:$P$18)/$R$3))) + (100/((1+$R$19)^(C34/$R$3)))","v":73.351484625110487},null,29,10440,4.5731202177287052E-2]
["GB00BQC4R999","3¾% Treasury Gilt 2038",{"$f":"L35-$R$2","v":5166},{"$f":"DATEDIF($R$2,L35,\"M\")","v":169},{"$f":"DATEDIF($R$2,L35,\"Y\")","v":14},3.7499999999999999E-2,1.875,"2024-01-29",{"$f":"H35-$R$2","v":52},"2024-07-29",234,"2038-01-29",93.76,{"$f":"SUM(G35/((1+$R$6:$R$20)^((I35+$R$3*$P$5:$P$19)/$R$3))) + SUM(G35/((1+$R$6:$R$19)^((K35+$R$3*$P$5:$P$18)/$R$3))) + (100/((1+$R$20)^(C35/$R$3)))","v":94.559264725596108},null,30,10800,4.5585580174181614E-2]
["GB00B00NY175","4¾% Treasury Stock 2038",5478,179,14,4.7500000000000001E-2,2.375,"2024-06-07",182,"2024-12-07",365,"2038-12-07",104.45,{"$f":"SUM(G36/((1+$R$6:$R$20)^((I36+$R$3*$P$5:$P$19)/$R$3))) + SUM(G36/((1+$R$6:$R$20)^((K36+$R$3*$P$5:$P$19)/$R$3))) + (100/((1+$R$20)^(C36/$R$3)))","v":103.94201932529805},null,31,11160,4.5424046707748099E-2]
["GB00BLPK7334","1 1/8% Treasury Gilt 2039",5533,181,15,1.125E-2,0.5625,"2024-01-31",54,"2024-07-31",{"$f":"J37-$R$2","v":236},"2039-01-31",64.37,{"$f":"SUM(G37/((1+$R$6:$R$21)^((I37+$R$3*$P$5:$P$20)/$R$3))) + SUM(G37/((1+$R$6:$R$20)^((K37+$R$3*$P$5:$P$19)/$R$3))) + (100/((1+$R$21)^(C37/$R$3)))","v":63.773201513333333},null,32,11520,4.5248533939923702E-2]
["GB00B3KJDS62","4¼% Treasury Gilt 2039",5752,188,15,4.2500000000000003E-2,2.125,"2024-03-07",90,"2024-09-07",274,"2039-09-07",98.55,{"$f":"SUM(G38/((1+$R$6:$R$21)^((I38+$R$3*$P$5:$P$20)/$R$3))) + SUM(G38/((1+$R$6:$R$21)^((K38+$R$3*$P$5:$P$20)/$R$3))) + (100/((1+$R$21)^(C38/$R$3)))","v":99.127269360415795},null,33,11880,4.5060814133798595E-2]
["GB00B6460505","4¼% Treasury Gilt 2040",6209,203,16,4.2500000000000003E-2,2.125,"2024-06-07",182,"2024-12-07",365,"2040-12-07",98.09,{"$f":"SUM(G39/((1+$R$6:$R$22)^((I39+$R$3*$P$5:$P$21)/$R$3))) + SUM(G39/((1+$R$6:$R$22)^((K39+$R$3*$P$5:$P$21)/$R$3))) + (100/((1+$R$22)^(C39/$R$3)))","v":97.663773120393955},null,34,12240,4.4862509668849117E-2]
["GB00BJQWYH73","1¼ % Treasury Gilt 2041",6528,214,17,1.2500000000000001E-2,0.625,"2024-04-22",136,"2024-10-22",319,"2041-10-22",61.21,{"$f":"SUM(G40/((1+$R$6:$R$23)^((I40+$R$3*$P$5:$P$22)/$R$3))) + SUM(G40/((1+$R$6:$R$23)^((K40+$R$3*$P$5:$P$22)/$R$3))) + (100/((1+$R$23)^(C40/$R$3)))","v":60.267564216037414},null,35,12600,4.4655102938597833E-2]
["GB00B1VWPJ53","4½% Treasury Gilt 2042",6939,227,18,4.4999999999999998E-2,2.25,"2024-06-07",182,"2024-12-07",365,"2042-12-07",100.54,{"$f":"SUM(G41/((1+$R$6:$R$24)^((I41+$R$3*$P$5:$P$23)/$R$3))) + SUM(G41/((1+$R$6:$R$24)^((K41+$R$3*$P$5:$P$23)/$R$3))) + (100/((1+$R$24)^(C41/$R$3)))","v":100.28183518814062},null,36,12960,4.4439945990056032E-2]
["GB00BPJJKP77","4¾% Treasury Gilt 2043",7258,238,19,4.7500000000000001E-2,2.375,"2024-04-22",136,"2024-10-22",319,"2043-10-22",103.39,{"$f":"SUM(G42/((1+$R$6:$R$25)^((I42+$R$3*$P$5:$P$24)/$R$3))) + SUM(G42/((1+$R$6:$R$25)^((K42+$R$3*$P$5:$P$24)/$R$3))) + (100/((1+$R$25)^(C42/$R$3)))","v":104.05477834617139},null,37,13320,4.4218269810216711E-2]
["GB00B84Z9V04","3¼% Treasury Gilt 2044",7350,241,20,3.2500000000000001E-2,1.625,"2024-01-22",45,"2024-07-22",227,"2044-01-22",83.7,{"$f":"SUM(G43/((1+$R$6:$R$26)^((I43+$R$3*$P$5:$P$25)/$R$3))) + SUM(G43/((1+$R$6:$R$25)^((K43+$R$3*$P$5:$P$24)/$R$3))) + (100/((1+$R$26)^(C43/$R$3)))","v":84.564788559985089},null,38,13680,4.3991193198500318E-2]
["GB00BN65R313","3½% Treasury Gilt 2045",7716,253,21,3.5000000000000003E-2,1.7500000000000002,"2024-01-22",45,"2024-07-22",227,"2045-01-22",86.47,{"$f":"SUM(G44/((1+$R$6:$R$27)^((I44+$R$3*$P$5:$P$26)/$R$3))) + SUM(G44/((1+$R$6:$R$26)^((K44+$R$3*$P$5:$P$25)/$R$3))) + (100/((1+$R$27)^(C44/$R$3)))","v":87.525939987462635},null,39,14040,4.3759731188683232E-2]
["GB00BNNGP775","0 7/8% Treasury Gilt 2046",8090,265,22,8.7500000000000008E-3,0.43750000000000006,"2024-01-31",54,"2024-07-31",236,"2046-01-31",49.84,{"$f":"SUM(G45/((1+$R$6:$R$28)^((I45+$R$3*$P$5:$P$27)/$R$3))) + SUM(G45/((1+$R$6:$R$27)^((K45+$R$3*$P$5:$P$26)/$R$3))) + (100/((1+$R$28)^(C45/$R$3)))","v":48.968287480004037},null,40,14400,4.3524803001821315E-2]
["GB00B128DP45","4¼% Treasury Gilt 2046",8400,275,22,4.2500000000000003E-2,2.125,"2024-06-07",182,"2024-12-07",365,"2046-12-07",96.34,{"$f":"SUM(G46/((1+$R$6:$R$28)^((I46+$R$3*$P$5:$P$27)/$R$3))) + SUM(G46/((1+$R$6:$R$28)^((K46+$R$3*$P$5:$P$27)/$R$3))) + (100/((1+$R$28)^(C46/$R$3)))","v":96.282892372657727},null,41,14760,4.3287239524736246E-2]
["GB00BDCHBW80","1½% Treasury Gilt 2047",8627,283,23,1.4999999999999999E-2,0.75,"2024-01-22",45,"2024-07-22",227,"2047-07-22",56.8,{"$f":"SUM(G47/((1+$R$6:$R$29)^((I47+$R$3*$P$5:$P$28)/$R$3))) + SUM(G47/((1+$R$6:$R$29)^((K47+$R$3*$P$5:$P$28)/$R$3))) + (100/((1+$R$29)^(C47/$R$3)))","v":56.480068272705978},null,42,15120,4.3047790318020779E-2]
["GB00BFWFPP71","1¾% Treasury Gilt 2049",9177,301,25,1.7500000000000002E-2,0.87500000000000011,"2024-01-22",45,"2024-07-22",227,"2049-01-22",59.16,{"$f":"SUM(G48/((1+$R$6:$R$31)^((I48+$R$3*$P$5:$P$30)/$R$3))) + SUM(G48/((1+$R$6:$R$30)^((K48+$R$3*$P$5:$P$29)/$R$3))) + (100/((1+$R$31)^(C48/$R$3)))","v":58.914587713629757},null,43,15480,4.2807130164170329E-2]
["GB00B39R3707","4¼% Treasury Gilt 2049",9496,311,25,4.2500000000000003E-2,2.125,"2024-06-07",182,"2024-12-07",365,"2049-12-07",96.1,{"$f":"SUM(G49/((1+$R$6:$R$31)^((I49+$R$3*$P$5:$P$30)/$R$3))) + SUM(G49/((1+$R$6:$R$31)^((K49+$R$3*$P$5:$P$30)/$R$3))) + (100/((1+$R$31)^(C49/$R$3)))","v":96.052815432352062},null,44,15840,4.2565865171053631E-2]
["GB00BMBL1F74","0 5/8% Treasury Gilt 2050",9815,322,26,6.2500000000000003E-3,0.3125,"2024-04-22",136,"2024-10-22",319,"2050-10-22",40.64,{"$f":"SUM(G50/((1+$R$6:$R$32)^((I50+$R$3*$P$5:$P$31)/$R$3))) + SUM(G50/((1+$R$6:$R$32)^((K50+$R$3*$P$5:$P$31)/$R$3))) + (100/((1+$R$32)^(C50/$R$3)))","v":39.252092311584207},null,45,16200,4.2324538449010192E-2]
["GB00BLH38158","1¼% Treasury Gilt 2051",10097,331,27,1.2500000000000001E-2,0.625,"2024-01-31",54,"2024-07-31",236,"2051-07-31",49.4,{"$f":"SUM(G51/((1+$R$6:$R$33)^((I51+$R$3*$P$5:$P$32)/$R$3))) + SUM(G51/((1+$R$6:$R$33)^((K51+$R$3*$P$5:$P$32)/$R$3))) + (100/((1+$R$33)^(C51/$R$3)))","v":48.769159971856922},null,46,16560,4.2083635381794861E-2]
["GB00B6RNH572","3¾% Treasury Gilt 2052",10454,343,28,3.7499999999999999E-2,1.875,"2024-01-22",45,"2024-07-22",227,"2052-07-22",88.29,{"$f":"SUM(G52/((1+$R$6:$R$34)^((I52+$R$3*$P$5:$P$33)/$R$3))) + SUM(G52/((1+$R$6:$R$34)^((K52+$R$3*$P$5:$P$33)/$R$3))) + (100/((1+$R$34)^(C52/$R$3)))","v":89.421602728162341},null,47,16920,4.1843588512670504E-2]
["GB00BM8Z2V59","1½% Green Gilt 2053",10828,355,29,1.4999999999999999E-2,0.75,"2024-01-31",54,"2024-07-31",236,"2053-07-31",51.69,{"$f":"SUM(G53/((1+$R$6:$R$35)^((I53+$R$3*$P$5:$P$34)/$R$3))) + SUM(G53/((1+$R$6:$R$35)^((K53+$R$3*$P$5:$P$34)/$R$3))) + (100/((1+$R$35)^(C53/$R$3)))","v":51.39231810206239},null,48,17280,4.1604782067401536E-2]
["GB00BPCJD997","3¾% Treasury Gilt 2053",10911,358,29,3.7499999999999999E-2,1.875,"2024-04-22",136,"2024-10-22",319,"2053-10-22",87.8,{"$f":"SUM(G54/((1+$R$6:$R$35)^((I54+$R$3*$P$5:$P$34)/$R$3))) + SUM(G54/((1+$R$6:$R$35)^((K54+$R$3*$P$5:$P$34)/$R$3))) + (100/((1+$R$35)^(C54/$R$3)))","v":88.331086987063458},null,49,17640,4.1367556135888425E-2]
["GB00BJLR0J16","1 5/8% Treasury Gilt 2054",11276,370,30,1.6250000000000001E-2,0.8125,"2024-04-22",136,"2024-10-22",319,"2054-10-22",52.94,{"$f":"SUM(G55/((1+$R$6:$R$36)^((I55+$R$3*$P$5:$P$35)/$R$3))) + SUM(G55/((1+$R$6:$R$36)^((K55+$R$3*$P$5:$P$35)/$R$3))) + (100/((1+$R$36)^(C55/$R$3)))","v":52.344049901873817},null,50,18000,4.1132210533835922E-2]
["GB00B06YGN05","4¼% Treasury Gilt 2055",11687,383,31,4.2500000000000003E-2,2.125,"2024-06-07",182,"2024-12-07",365,"2055-12-07",96.29,{"$f":"SUM(G56/((1+$R$6:$R$37)^((I56+$R$3*$P$5:$P$36)/$R$3))) + SUM(G56/((1+$R$6:$R$37)^((K56+$R$3*$P$5:$P$36)/$R$3))) + (100/((1+$R$37)^(C56/$R$3)))","v":96.258221473813421},null,"Mispricing",null,{"$f":"SUMSQ(M3:M64-N3:N64)","v":35.751156595737989}]
["GB00BD0XH204","1¾% Treasury Gilt 2057",12280,403,33,1.7500000000000002E-2,0.87500000000000011,"2024-01-22",45,"2024-07-22",227,"2057-07-22",53.88,{"$f":"SUM(G57/((1+$R$6:$R$39)^((I57+$R$3*$P$5:$P$38)/$R$3))) + SUM(G57/((1+$R$6:$R$39)^((K57+$R$3*$P$5:$P$38)/$R$3))) + (100/((1+$R$39)^(C57/$R$3)))","v":53.56100895685816}]
["GB00B54QLM75","4% Treasury Gilt 2060",13194,433,36,0.04,2,"2024-01-22",45,"2024-07-22",227,"2060-01-22",92.65,{"$f":"SUM(G58/((1+$R$6:$R$42)^((I58+$R$3*$P$5:$P$41)/$R$3))) + SUM(G58/((1+$R$6:$R$41)^((K58+$R$3*$P$5:$P$40)/$R$3))) + (100/((1+$R$42)^(C58/$R$3)))","v":93.917085374986456},null,"Anpassung"]
["GB00BMBL1D50","0½% Treasury Gilt 2061",13833,454,37,5.0000000000000001E-3,0.25,"2024-04-22",136,"2024-10-22",319,"2061-10-22",30.35,{"$f":"SUM(G59/((1+$R$6:$R$43)^((I59+$R$3*$P$5:$P$42)/$R$3))) + SUM(G59/((1+$R$6:$R$43)^((K59+$R$3*$P$5:$P$42)/$R$3))) + (100/((1+$R$43)^(C59/$R$3)))","v":28.350687183549947},null,"Mittelwert (Tatsächliche Preise)",{"$f":"AVERAGE(M3:M64)","v":83.605322580645151}]
["GB00BMF9LF76","4% Treasury Gilt 2063",14563,478,39,0.04,2,"2024-04-22",136,"2024-10-22",319,"2063-10-22",92.41,{"$f":"SUM(G60/((1+$R$6:$R$45)^((I60+$R$3*$P$5:$P$44)/$R$3))) + SUM(G60/((1+$R$6:$R$45)^((K60+$R$3*$P$5:$P$44)/$R$3))) + (100/((1+$R$45)^(C60/$R$3)))","v":93.163884005757069},null,"Totale Quadratsumme (SQT)",{"$f":"SUM((M3:M64-$Q$59)^2)","v":24121.162543548384}]
["GB00BYYMZX75","2½% Treasury Gilt 2065",15202,499,41,2.5000000000000001E-2,1.25,"2024-01-22",45,"2024-07-22",227,"2065-07-22",64.69,{"$f":"SUM(G61/((1+$R$6:$R$47)^((I61+$R$3*$P$5:$P$46)/$R$3))) + SUM(G61/((1+$R$6:$R$47)^((K61+$R$3*$P$5:$P$46)/$R$3))) + (100/((1+$R$47)^(C61/$R$3)))","v":65.36212552766213},null,"Residuenquadratsumme (SQR)",{"$f":"SUM((M3:M64-N3:N64)^2)","v":35.751156595737989}]
["GB00BBJNQY21","3½% Treasury Gilt 2068",16298,535,44,3.5000000000000003E-2,1.7500000000000002,"2024-01-22",45,"2024-07-22",227,"2068-07-22",83.51,{"$f":"SUM(G62/((1+$R$6:$R$50)^((I62+$R$3*$P$5:$P$49)/$R$3))) + SUM(G62/((1+$R$6:$R$50)^((K62+$R$3*$P$5:$P$49)/$R$3))) + (100/((1+$R$50)^(C62/$R$3)))","v":84.924379502187278},null,"R squared",{"$f":"1-(Q61/Q60)","v":0.9985178510143865}]
["GB00BFMCN652","1 5/8% Treasury Gilt 2071",17485,574,47,1.6250000000000001E-2,0.8125,"2024-04-22",136,"2024-10-22",319,"2071-10-22",47.37,{"$f":"SUM(G63/((1+$R$6:$R$53)^((I63+$R$3*$P$5:$P$52)/$R$3))) + SUM(G63/((1+$R$6:$R$53)^((K63+$R$3*$P$5:$P$52)/$R$3))) + (100/((1+$R$53)^(C63/$R$3)))","v":46.491805928155479}]
["GB00BLBDX619","1 1/8% Treasury Gilt 2073",18216,598,49,1.125E-2,0.5625,"2024-04-22",136,"2024-10-22",319,"2073-10-22",37.47,{"$f":"SUM(G64/((1+$R$6:$R$55)^((I64+$R$3*$P$5:$P$54)/$R$3))) + SUM(G64/((1+$R$6:$R$55)^((K64+$R$3*$P$5:$P$54)/$R$3))) + (100/((1+$R$55)^(C64/$R$3)))","v":35.942855014334917}]
[]
["Rastersuche"]
[]
[]
["                  μ\n  λ",0.1,1,10,25,50,75,100]
[0.1,0.99470673569905255,0.99479032221146146,0.99556667162948687,0.99539568579277837,0.99485661823854865,0.99474572615697709,0.99471723842612569]
[1,0.9942862180131774,0.99428466583275765,0.99491527267254354,0.99493660917831694,0.99429183396449805,0.9942640206972243,0.99426221592040964]
[10,0.99827050813109452,0.99793886057479042,0.99636521835620606,0.9969983574685618,0.99631745044937503,0.99799267028025185,0.99795141882766636]
[25,0.98507370749279966,0.98894466054783081,0.99628570531176475,0.997252914605672,0.99689768410420998,0.97811263373382273,0.99728228370287808]
[50,0.99582941441351147,0.9961185240003918,0.97444682313151998,0.99673773801698573,0.99577761008898058,0.99553087779064942,0.99615484950606592]
[75,0.99524134431143618,0.99568961252495247,0.99596087427214675,0.99712124998495111,0.99515081535758354,0.99506810164437132,0.99466424991326885]
[100,0.99479015165120155,0.99509209146194477,0.97604889152261098,0.99722384915810169,0.99704403268110442,0.99749767537214173,0.99482700714762196]
[]
[]
[]
["                  μ\n  λ",0.05,6.0000000000000005E-2,7.0000000000000007E-2,0.08,0.09,0.1,0.11,0.12000000000000001,0.13,0.14000000000000001,0.15000000000000002]
[5,0.98670765961207052,0.98672312604505963,0.98677241466772081,0.98698860886966988,0.98786275068919838,0.99704306382659269,0.997043368307727,0.99704390197817327,0.99704472522838927,0.99704589661766041,0.9970474530325113]
[6,0.99747917810550346,0.98468527193856914,0.9974799639035723,0.99747999582946323,0.99748007356728652,0.99748026629813935,0.99748065586973766,0.99748133420507956,0.99748238285944923,0.99748387350509005,0.99748585588646743]
[7,0.99782866238961143,0.99783261053487038,0.99783261726394423,0.9978326513873097,0.99783274583950976,0.99783298747295446,0.99783347286574531,0.99783429986915906,0.99783559419279966,0.99783743179868922,0.99783988995698847]
[8,0.99806914302682737,0.99807862014227922,0.9980786249103043,0.99807866583576021,0.99807878480275236,0.99807906597212748,0.99807963667335564,0.99808063665395286,0.99808217616886297,0.99808437272096351,0.99808731032495868]
[9,0.99821994845002682,0.99822010492773927,0.99822019945760532,0.9982201548727565,0.99822030485482571,0.99822063767037172,0.99822130513792939,0.99822245788458708,0.99822424465478865,0.99822734934596746,0.99823032269445444]
[10,0.99835480094197782,0.9982728723876011,0.99826991208538562,0.99826996232548271,0.99827011951153666,0.99827050813109452,0.99827125346502277,0.99827257196319541,0.99827460426443804,0.99828025379771534,0.99829421231942028]
[11,0.99843671792593136,0.99843671874932505,0.99824408853734015,0.99824415008008893,0.99824432560425058,0.9982447497000313,0.99824559211438102,0.99824705193679397,0.99825637194160155,0.99825947796287395,0.99826369292968431]
[12,0.99849337548010209,0.99849290408962887,0.99849243582014913,0.99691883352183575,0.97079043709886548,0.9710497024871424,0.97130710894843197,0.97156262707521335,0.97181621704594845,0.9720678316434429,0.97231741925743598]
[13,0.99692042580287887,0.99842167494925593,0.99843720248176726,0.99843252608739264,0.96714087901419155,0.96750634646893152,0.96788074193510931,0.96826131511335489,0.99803285154899302,0.99803672448364988,0.9980419114377086]
[14,0.99700623003505873,0.99764705801984122,0.99765709391381741,0.99569504074635917,0.99786549334516439,0.99782739047098712,0.99770152254689493,0.99767812805683231,0.99770213378256012,0.9978713268707089,0.99737483781597569]
[15,0.99325523214606171,0.99771568610497074,0.99744355664904583,0.99766857365527928,0.99766924177558447,0.99762733100607925,0.99762819525308266,0.99763000501098609,0.99763288186477761,0.99753113394391557,0.9975660386628632]
[]
[]
[]
["                  μ\n  λ",4.4999999999999998E-2,4.5999999999999999E-2,4.7E-2,4.8000000000000001E-2,4.9000000000000002E-2,0.05,5.0999999999999997E-2,5.1999999999999998E-2,5.2999999999999999E-2,5.3999999999999999E-2,5.5E-2]
[11.5,0.99682406365308951,0.99682866856455077,0.99683314600869044,0.99683758247445142,0.99684196812053649,0.99684631194415674,0.9968506122580163,0.99685489680542938,0.9968592139045126,0.99820914918232495,0.99820914868063448]
[11.6,0.99690017036528389,0.9969071566867771,0.99691411161918031,0.99692103508628571,0.9969279267845742,0.99693503328308886,0.99694160630995821,0.99694839136296176,0.99695513750940135,0.99696184566519164,0.99696851285891974]
[11.7,0.99673306803342765,0.99673947261684059,0.99674453591167944,0.99674761766083675,0.99670577790744463,0.99671034523339341,0.9967143458021247,0.99672930794214754,0.99671875197294901,0.99677927645827114,0.99678311614806836]
[11.8,0.99683539548930167,0.99684432422348779,0.99679648074517213,0.99683862499674181,0.99686852757059008,0.99687559631818412,0.99688212051276648,0.99688808677391283,0.99689349325376642,0.99689834674828015,0.99690266199483168]
[11.9,0.99676190367793782,0.99676546566711233,0.99676902932602951,0.99677259552725794,0.99848959040045848,0.96999482805871606,0.97002053569426461,0.97004622619571301,0.97007190088794759,0.9700975592320551,0.97012320082585712]
[12,0.99849376069559026,0.9984936097755075,0.99849348249555914,0.9984933929884412,0.99849335390878324,0.99849337548010209,0.99849346335171807,0.998493616398617,0.99849355087827785,0.99849337217808276,0.99849320508058725]
[12.1,0.99849608633088216,0.99849596462781998,0.99849591053349207,0.99849593166322848,0.99849603253364416,0.9984962143265278,0.99849608464882778,0.99849579025485447,0.99849551151232629,0.99849525620583524,0.99849503164385756]
[12.2,0.99679889541624522,0.99680285489017872,0.9968068210470693,0.99849585238627347,0.99849566737255668,0.99849555746716179,0.99849553439879202,0.99849559807478661,0.99849575353603859,0.9984960024358831,0.99849609278320883]
[12.3,0.99680257554687546,0.9968065078387045,0.99681045591464457,0.99681441813922222,0.99850331498135869,0.99850395911319267,0.9985026150886479,0.99850232497134084,0.99850207992773032,0.99850188224508385,0.99850173551321464]
[12.4,0.99680493806507631,0.99680873261106817,0.99681254650020501,0.99681637977554405,0.99682023240388606,0.9985124151635355,0.99851230897347099,0.99851209871970237,0.99851180625263891,0.99851145088853366,0.9985110483114944]
[12.5,0.99680746648686935,0.99681108294020992,0.99681472094305146,0.99681838033635806,0.99682206126969441,0.99682576360611397,0.99469626102401842,0.99483171486866973,0.99495714356267417,0.99507362344704731,0.99851588063021934]
[]
[]
[]
["                  μ\n  λ",5.2999999999999999E-2,5.3999999999999999E-2,5.5E-2,5.6000000000000001E-2,5.6999999999999995E-2,5.8000000000000003E-2,5.8999999999999997E-2,0.06]
[12.45,0.99851437603097004,0.99851448018688138,0.99851442305937066,0.99851423174160148,0.99851393300051428,0.99851357247584227,0.99851314810546243,0.99851267187289938]
[12.46,0.99851457460256765,0.99851482574870809,0.99851488667336474,0.99851478775287894,0.99851456079041812,0.99851425397607474,0.99851387141678227,0.99851342698737089]
[12.47,0.9985146548638445,0.99851507192981659,0.99851526801138779,0.99851527675338037,0.99851513433803096,0.99851489057220366,0.99851455775835296,0.99851415152035072]
[12.48,0.99851461233958017,0.99851521460629233,0.99851556295863031,0.99851569488353054,0.99851564864018272,0.99851547738022572,0.99851520298045082,0.99851484267651691]
[12.49,0.99504561143542858,0.998515250127751,0.99851576816355159,0.9985160386454397,0.99851609915488226,0.99851601053854877,0.99851580324216027,0.99851549637382786]
[12.5,0.99495714356267417,0.99507362344704731,0.99851588063021934,0.9985163052485071,0.99851648146728078,0.99851648578007202,0.99851635466933286,0.99851610967337856]
[12.51,0.99486666527479461,0.99499057719099904,0.99510559221483408,0.9952128375755952,0.99851679145835015,0.99851689937731325,0.99851685398117895,0.99851667899226981]
[12.52,0.9947748918638234,0.99490548205145501,0.99502791195846285,0.9951415599667337,0.99523409064196711,0.99851724760316019,0.99851729749943585,0.99851720101851404]
[12.53,0.99468147834246912,0.99481981437936606,0.99494799992132243,0.99506713928328927,0.99516399787080911,0.99525417443125053,0.9985176821192645,0.99851767307987593]
[12.54,0.99458653144561715,0.9947323966930085,0.99486828991041087,0.99498904973562241,0.99509233828732091,0.96807201010394861,0.96810466906477755,0.96813731596192387]
[12.55,0.967864996184987,0.96789784026299974,0.96793066784163662,0.9679634806412466,0.9679962792433725,0.96802906484236884,0.96806183717138039,0.96809459863984837]
[]
[]
[]
["                  μ\n  λ",5.6000000000000001E-2,5.7000000000000002E-2,5.8000000000000003E-2,5.8999999999999997E-2,0.06]
[12.525,0.99510479222794246,0.99519926796020264,0.99528710487831318,0.99851749738243223,0.99851744354851979]
[12.526,0.99509727442966045,0.99519224296427589,0.9952805902569638,0.99851753555124978,0.99851749049674154]
[12.526999999999999,0.99508976136309979,0.99518520333024196,0.99527397767560444,0.99851757311030753,0.99851753695440459]
[12.528,0.99508226631241636,0.99517813760090124,0.99526740583176498,0.99851761007465833,0.99851758285173076]
[12.529,0.99507469096762968,0.9951710743479848,0.99526079759693953,0.99851764642695096,0.99851762821073475]
[12.53,0.99506713928328927,0.99516399787080889,0.99525417443125053,0.9985176821192645,0.99851767307987593]
[12.531000000000001,0.99505957653156563,0.99515689530660889,0.99524754177072583,0.9985177172571259,0.99851771739923045]
[12.532,0.99505194506247996,0.99514976212340511,0.99524086403036249,0.99851775171650503,0.99851776121124036]
[12.532999999999999,0.99504433137168746,0.99514261731567577,0.99523420921080741,0.99531946784658309,0.99851780447226801]
[12.534000000000001,0.99503662414185534,0.99513546662820362,0.9952275161891353,0.99531321978379839,0.96816282107104368]
[12.535,0.99809282701303759,0.9951283055032778,0.99522081166162779,0.99530695210519526,0.96815857663348193]
[]
[]
[]
["                  μ\n  λ",5.8000000000000003E-2,5.8999999999999997E-2,0.06,6.0999999999999999E-2,6.2E-2]
[12.532,0.99524086403036249,0.99851775171650503,0.99851776121124036,0.96820384557906158,0.96823638054663286]
[12.532999999999999,0.99523420921080741,0.99531946784658309,0.99851780447226801,0.96819961875979543,0.96823216411197743]
[12.534000000000001,0.9952275161891353,0.99531321978379839,0.96816282107104368,0.96819538818384332,0.96822794552158287]
[12.535,0.99522081166162779,0.99530695210519526,0.96815857663348193,0.9681911559030093,0.96822372409918167]
[12.536,0.99521408982693804,0.96812172819874842,0.96815432986767969,0.96818692007771912,0.96821950021343739]
[12.537000000000001,0.99520736158456513,0.96811746747611016,0.96815008004425884,0.96818268230964599,0.96821527364427784]
[12.538,0.99520062239637797,0.96811320360454101,0.96814582842151653,0.96817844124134678,0.96821104471278185]