I am looking to get the yields and spreads from a past date on some sovereign bonds from Bloomberg via excel formula.
For example i want to get the yield and spread of a UK sovereign bond with a 10 year maturity. I am not retrieving the information i want with the following formula:
=BDH(GUKG10Y , *yield field name* , *past date*)
Where GUKG10Y is the ticker.
Can anyone help advise whether this can be done via excel formula?
Thanks
-A
Bookmarks