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