The old Fixedincome web site Corporate Bond Lists

[morgleman]

The old Fixed income web site used to have a link to GBP Corporate Bonds. You could view the bonds list by price , yield, and alphabetical orders. It was a very simple way of seeing current prices etc. Anyone have a link to something similar on lemon fool or elsewhere

[air04]

Well.. I scrape prices from HL and this is it. It is not perfect and I did it as a activity some time ago. Definitely room for improvement.

https://docs.google.com/spreadsheets/d/ ... 9&range=A1

Are you asking about the spreadsheet Mark Taber had created? https://docs.google.com/spreadsheets/d/ ... sp=sharing

[88V8]

Well.. I scrape prices from HL and this is it. It is not perfect and I did it as a activity some time ago. Definitely room for improvement.
https://docs.google.com/spreadsheets/d/ ... 9&range=A1

Are you asking about the spreadsheet Mark Taber had created? https://docs.google.com/spreadsheets/d/ ... sp=sharing

Well done for saving Mark's list. I recall that the live pricing broke down long ago, I think it takes a good deal of effort to prevent link decay.

V8

[air04]

Well done for saving Mark's list. I recall that the live pricing broke down long ago, I think it takes a good deal of effort to prevent link decay.

V8

It can now be done using HL or youinvest . I sometimes used Power Automate Desktop(PAD), so that it scrapes from my browser, in that way it will always work.

Below is for google spreadsheet as an example to get the LIVE(15 min delay) prices as an example

Code: Select all

=index(IMPORTXML("https://www.youinvest.co.uk/market-research/LSE:GACA","//*[contains(concat(' ', normalize-space(@class), ' '), 'ajb-inline-block')]"),1,2)
=index(IMPORTXML("https://www.youinvest.co.uk/market-research/LSE:GACA","//*[contains(concat(' ', normalize-space(@class), ' '), 'ajb-inline-block')]"),2,2)

[morgleman]

Thanks for the replies. The coding looks a bit daunting to me. What I liked about the old site was the comprehensive list of Corporate bonds and the ability to quickly re-order the list view in yield or price or name. I don't think it was a real time list, just a daily list. It would have been particularity interesting and useful when looking at the state of retail bonds issued over the past five years some of which might be attractively priced now that bond prices have dropped. Trouble is I can't remember them all to go looking for them by individual names. I read somewhere (Daily Telegraph I think) that Tesco Personal Finance, 3.5% might be worth buying> suppose I could look up the prices and charts on LSE site but, as I say, a listing of all of them would be good. I did put it forward in the suggestions forum but don't know whether anyone will pick it up. I was lucky I avoided Wasps and dumped Eros early. However most of my short dated retails bands are underwater at the moment. I am 80 now so bonds in my ISA are the way to go. The shares I have are down about 40 % so that and spend it!

[bruncher]

The items listed were predominantly issued by financial institutions - banks, building socs and insurers. Since 2008 there seems much less available and

I wonder if the bank-issued prefs might be safer that insurance prefs this time around, because the insurers are potentially on the hook for pension issues following the special budgetary operation?

[NickDale]

Bondscape was the site, no longer exists.
I have an old copy of the spreadsheet, most have matured now.
Here's whats left, i haven't checked any of them

EL23	Linde Finance Bv	5.875	24-Apr-23
EGC3	GE Capital Uk Funding	5.125	24-May-23
ESP3	Scottish Power UK Plc	6.75	29-May-23
EHS3	HSBC Bank Plc	6.5	07-Jul-23
EA23	Anglian Water Services Financing Plc	6.875	21-Aug-23
ER23	RWE Finance Bv	5.625	06-Dec-23
ENG4	National Grid Co Plc	5.875	02-Feb-24
ES24	Severn Trent Wtr Util Fin	6.125	26-Feb-24
EC24	Citigroup Inc	5.875	01-Jul-24
EE25	European Investment Bank	5.5	15-Apr-25
EK25	Kreditanstalt fuer Wiederaufbau	5.5	18-Jun-25
EU26	United Utilities Electricity plc	8.875	25-Mar-26
ENR6	National Air Traffic	5.25	31-Mar-26
ECT6	Citigroup Inc	5.15	21-May-26
EB26	Barclays Bank Plc	5.75	14-Sep-26
ECU6	Aviva Plc	6.125	16-Nov-26
EL27	Land Securities Plc	5.391	31-Mar-27
ENG8	National Grid Co Plc	6.5	27-Jul-28
EI28	Italy (Republic of)	6	04-Aug-28
EE28	European Investment Bank	6	07-Dec-28
EG28	General Elec Cap Corp	5.25	07-Dec-28
EBT8	British Telecommunications PLC	5.75	07-Dec-28
EKW8	Kreditanstalt fuer Wiederaufbau	6	07-Dec-28
EST9	Severn Trent Wtr Util Fin	6.25	07-Jun-29
ET29	Tesco Plc	6	14-Dec-29
EPG0	Procter & Gamble Co	6.25	31-Jan-30
ER30	RWE Finance Bv	6.25	03-Jun-30
EC30	Citigroup Inc	6.5	16-Aug-30
EW20	Wal-mart Stores	5.75	19-Dec-30
EED1	Electricite De France	5.875	18-Jul-31
EB31	BAA Plc	5.75	10-Dec-31
EP31	Prudential Finance Bv	6.125	19-Dec-31
EE32	European Investment Bank	5.625	07-Jun-32
EV32	Vodafone Group PLC	5.9	26-Nov-32
ET33	Tesco Plc	5.5	13-Jan-33
EH33	HSBC Bank Plc	5.375	22-Aug-33
EG33	Glaxosmithkline Cap Plc	5.25	19-Dec-33
ESL5	Segro PLC	5.75	20-Jun-35
EG37	General Elec Cap Corp	4.875	18-Sep-37
ELC8	Lcr Financial Plc	4.5	07-Dec-38
EE39	European Investment Bank	5	15-Apr-39

Gilts

T24I	UK Gilt Index-linked Stk	2.5	17-Jul-24
TR25	Uk Gilt Treasury Stk	5	07-Mar-25
TR27	Uk Gilt Treasury Stk	4.25	07-Dec-27
TR28	Uk Gilt Treasury Stk	6	07-Dec-28
T30I	UK Gilt Index-linked Stk	4.125	22-Jul-30
TR30	Uk Gilt Treasury Stk	4.75	07-Dec-30
TR32	Uk Gilt Treasury Stk	4.25	07-Jun-32
T2IL	UK Gilt Index-linked Stk	2	26-Jan-35
T4Q	Uk Gilt Treasury Stk	4.25	07-Mar-36
TR38	Uk Gilt Treasury Stk	4.75	07-Dec-38
T42	Uk Gilt Treasury Stk	4.5	07-Dec-42
T46	Uk Gilt Treasury Stk	4.25	07-Dec-46
TR4Q	Uk Gilt Treasury Stk	4.25	07-Dec-55
CN4	Uk Gilt Consols	4	Perpetual
WAR	Uk Gilt War Loan Stk	3.5	Perpetual
CV3H	Uk Gilt Conversion Stk	3.5	Perpetual
T3UD	Uk Gilt Treasury Stk	3	Perpetual
CN2H	Uk Gilt Consols	2.5	Perpetual
T2H	Uk Gilt Treasury Stk	2.5	Perpetual

[air04]

What I liked about the old site was the comprehensive list of Corporate bonds and the ability to quickly re-order the list view in yield or price or name.

I was probably not clear in the last message. https://docs.google.com/spreadsheets/d/ ... 9&range=A1 is the automatically updated price(thanks to Google and HL), taken from https://www.hl.co.uk/shares/corporate-b ... /gbp-bonds and https://www.hl.co.uk/shares/corporate-b ... and-others . That information is consolidated and sorted by "Years To Maturity". Click on the link in the line to get bid/offer as per HL.

[morgleman]

Tks. I think this link provides the info I need

https://www.hl.co.uk/shares/corporate-b ... /gbp-bonds