New answers tagged


You will use the YIELD() and PRICE() functions in Excel. There's really no difference between historic duration calculation and current. You just need the price and settle day. Here's how you do it: Get the settlement day for the day that you are interested. For TSY's it's the next business day. Get the price on the day you care about. Use YIELD() to ...

Top 50 recent answers are included