Page 1 of 1

UK Gilt prices in Excel

Posted: July 25th, 2023, 9:35 am
by AleisterCrowley
Can I drag in UK Gilt current prices (bid and offer preferably) to my Excel tracker?
I've tried using the short name (TN24 etc) but it doesn't work - it drags in Tartisan Nickel Corp...

A trial with BT.A is working fine

Re: UK Gilt prices in Excel

Posted: July 29th, 2023, 1:47 pm
by heathmount
Hi

I've been testing out the new HYPTUSS code using the SharePrices website and it pulls in my UK Gilt prices fine including TN24. It looks like the code takes the mid price but the Buy/Sell prices are there as well and no doubt could be returned with a bit of tweaking.

heathmount