We can use the YIELD() function in Excel to compute the yield of most government bonds. One exception is Italian Government Bonds (BTPs).
I suspect the reason that the YIELD() function doesn't match Bloomberg is because Italian Government bonds have special pricing conventions. In particular, yields are calculated using annual compounding even though coupons are paid are semi-annually.
Is there a way to work around this edge case?