Pricing source for UK government bonds (gilts)

[Bill Hackney]

I'm a UK based user.  I use Dan Gaier's MSMoneyQuotes to obtain prices for my listed securities.

I can't find any UK gilts (UK treasuries) either on MSN Money or using the MSMoneyQuotes financial instrument search tool Gaier Software - Financial Instrument - Search.  Of course, I might not be using the correct search string.....

I don't have a current FT subscription so I'm not sure if the FT Portfolio solution, using the -i switch in MSMoneyQuotes, will work.  I have a suspicion that the FT site won't allow you to add bonds to your Portfolio, in the first place.

I can't find UK gilts on Google Finance.  On Yahoo Finance I can find some gilts, but they seem to use a SG (Stuttgart, Germany) source (e.g. see here (GB00BL68HJ26.SG) stock price, news, quote and history - Yahoo Finance), which just looks wrong.  I'd expect the source to be LSE.

Has any other [UK] user found a suitable pricing source/feed for UK gilts?

Kind regards

Bill

[Cal Learner]

I tried searching for ISIN GB00BL68HJ26 and SEDOL BL68HJ2. I did not find these on MSN FT or for a non-SG version on Yahoo. HOWEVER the SG price seems plausible, and I suspect you can use that with PocketSense.   You will have to use the feature where you map the symbol for Money use, because Money will not take that long symbol (max 12 chars I think). This is from https://pocketsense.blogspot.com/2011/02/script-update-available-for-testing.html

13. Added options for Yahoo quotes:

• m:value:  Currency multiplier option. Quote values will be adjusted (multiplied) by this (optional) value during download.
• s:value: User defined symbol to send to Money (rather than Yahoo ticker symbol).  
  • Example:  BP.L  m:0.01  s:MyBP
  • Multiply quotes received for BP.L by 0.01 (i.e, convert from pence to pounds), before sending the results to Money.
  • Pass quote to Money with symbol=MyBP (rather than BP.L).  The Yahoo quote will be for ticker = BP.L, but Money will see it as ticker=MyBP.

https://www.ajbell.co.uk/our-services/investment-options/gilts/prices lists GB00BL68HJ26 but it does not seem to provide a download.

https://www.hl.co.uk/shares/corporate-bonds-gilts/bond-prices/uk-gilts also.

And more sites.

If you create a watch list on one of the sites, or just navigate to one of the sites, it may be easy enough to enter prices into Money manually-- maybe every week.

One way is Portfolio->UpdatePrices->UpdatePricesManually.  Use the drop-down list.

Alternatively, right-click an entry in the Portfolio, and choose SeePriceHistory ->UpdatePrices->UpdatePricesManually.

[First Name Last Name]

Hi Bill,

> Has any other [UK] user found a suitable pricing source/feed for UK gilts?

I am US-based so I am not really familiar with UK gilts but is this an example of the quote you are looking for?

https://live.euronext.com/en/product/bonds/GB0030880693-ETLX

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/395f8f8a-12b3-4d21-9caa-79d421ef9261n%40googlegroups.com.

[Stephen Google]

Sadly MSMoneyQuotes does not retrieve UK Gilt prices (nor National Grid for some odd reason). I use  a free Trustnet portfolio to obtain gilt prices which I then enter manually into Money. Trustnet does not give the current  indexed priced for index linked gilts so you have to multiply the index linked gilt price by the current index ratios from the DMO here https://www.dmo.gov.uk/data/pdfdatareport?reportCode=D1D

[Bill Hackney]

Thanks Cal

I'd already found the prices on the AJ Bell and HL websites but, as you say, there's no easy way to download those prices, so a manual price update to Money would need to be done (and I already have to do that for various unquoted securities that I hold, but it's a pain).  Unless, that is, anyone is aware of a scraping tool that could be used to scrape the prices from sites like AJ Bell or HL?

As you say, the SG price on Yahoo might be plausible.  I'm not currently a Pocketsense user (besides MSMoneyQuotes I've previously used hleofxquotes) so I'll gve that a try.  It would be so much nicer to use an automated route rather than to have to update manually.

Kind regards

Bill

[Bill Hackney]

Yes, that's it.  I'd never thought aboout looking at Euronext as a pricing source.  Looks like it might be possible to create a watchlist, so I'll explore that, albeit not sure that, even if I do, there'll be any easy way to push the prices into Money without having to load each price manually. 

[Bill Hackney]

Stephen

Thanks for your message.

I'll have a look at Trustnet.

In the interim, MSMoneyQuotes IS working for me with National Grid.  I'm using the symbol "NG." (i.e with the fullstop/period) in Money, and then in SymbolMap.csv I'm mapping it to aoc1bh