Posts  / #POST-254122
REDDIT

Box Spread Yield vs Bloomberg

M
Oct 8, 2026 · 16:15

I want to calculate an effective yield for an SPX box Spread such that it can be directly comparable to the yield that shows up on Bloomberg for a US Treasury with similar maturity.

What would be the best formula to use and does it need to take extra settlement days past maturity into account?

I was using BC2 function for a 3m maturity and it seemed high so not sure if there was a better spot. Thanks!