UK GILTS - not available, is it possible please?

Support Questions
1

UK GILTS are the UK Treasuries issued by the UK Government. In the UK they are very popular because they don’t pay capital gains tax and are safe.

For some reason I cannot seem to be able to create a Gilt as an asset, so I can do it manually, but I rather ask before I do as updating will also have to be manual. BTW, I think this happens in excel too.

(What people do in many cases is to build a Gilt “Ladder” for income, so buy Gilts at different maturity dates and coupon rates to have very safe, capital gains free income but with income from the coupon, which is taxed). Being able to have this feature in capitally would be fantastic.

For example United Kingdom Bonds, T26, Gilt 0.125% 30jan2026, GBP (GB00BL68HJ26) does not come up. I think it is an access problem although if you do a google search you can find it or looking in the LSE:

  1. ISIN

    GB00BL68HJ26

  2. CFI

    DBZTFR

  3. FIGI

    BBG00SSK93Y0

  4. SEDOL

    BL68HJ2

  5. Ticker

    UKT 0.125 01/30/26

thank you!

Polu

1 Answer

1
2

Hi, yes, currently we don’t have them. As I understand, they’re government-issued bonds, that you buy directly - not on the market?

If yes, then they can be created manually with Interest Based Pricing - you create them once (as a Bond type) and once set-up, they will create payout transactions automatically. If interest rates are dynamic, you can model that too.

We currently have support for Polish direct-to-consumer governments bonds that are using the above mechanism. Gilts could be added in the future though if the interest is large enough (as long as there’s a data source, and they’re direct-to-consumer, not market-traded assets).

thank you for the quick answer Rafal! Gilts can be direct to consumer from the government website or they are available on the secondary market through brokers and banks. I think this might be one of those difficult ones to implement I guess as the data is available but it has to be scraped from websites or behind some free paywalls. issue is getting the current market price. btw. Is there a template I could fill to automatically load existing bonds rather than input one by one? Happy to do it and share it with the group. sorry learning about the platform.

 –

There is an excel sheet I just found in the UK Goverment site that shows the close price for every gilt for the previous day, all input is just the close date. https://www.dmo.gov.uk/data/pdfdatareport?reportCode=D10B. is there a way i could automate that to extract against my gilt holding? not asking for a feature, just curious

 –

These are two different things. For direct-to-consumer, you just setup interest based pricing. It's currently not possible to build a preset to import these in bulk, but if you're tech-savvy, you can create a JSON file. Probably an AI could do that to if shown an example JSON file exported from Capitally with one "direct" Gilt set up. See here: https://www.mycapitally.com/help/interest-based-pricing

 –

For market-traded, you simply create an asset and update it's market price from time to time. It IS possible to import prices in bulk - both for one day for multiple assets, or multiple days for a single asset. See here https://www.mycapitally.com/help/setting-custom-asset-prices & here: https://www.mycapitally.com/help/import-from-a-file

 –

hi thank you Rafal. I have set the bonds in manually and added the bond rededemption (sale) date so i can see when the future cash will be there, it is soooo cool, thank you. Now I wanted to get the intermediate coupons but I can't seem to get the "interest" within the prices tab, it is not there. am I selecting the wrong asset? happy to send you a screen shot if that helps. thank you! BTW, the more i use Capitally the more I like it, congratulations and thank you!

 –