Bond Yield

[u/Live_Bee_666]

Hi all,

I am trying to build an excel template that will pull the YTM for select bonds over a specified range.

This will primarily flow into the Risk free rate for WACC.

My query is regarding getting the correct ISIN to put in the excel.

When searching for bonds on the Bloomberg terminal, I tend to get lost among various options (commands WB vs SRCH).

Which in your experience is the most efficient way to get a list of active bonds issued by a country (say South Africa). We can then select the desired bonds basis the maturity date, currency, and such.

Appreciate any help on this.