I think that the Date of Settlement was the date I purchased the bond.
Nothing to do with the original issue date, nor the maturity date

The parameters are
Syntax: YIELDMAT(S, M, I, R, PR[, B])

S = settlement date
M = maturity date
I = issue date
R = interest rate at date of issue
PR = the price of the security per $100 face value
B = (Optional) the day count basis to be used:

0 or omitted 30/360

So
My question remains
Example (dates UK format dd mm yy)

Yield to maturity 10.00%
Sett Date 31/12/2009
Maturity 31/12/2010
Issue Date 30/12/2009
Coupon yearly 10.000%
Price now 100.00
Days basis 3

But if the Issue date changes you get

Yield to maturity 9.09%
Sett Date 31/12/2009
Maturity 31/12/2010
Issue Date 31/12/2008
Coupon yearly 10.000%
Price now 100.00
Days basis 3

Which is wrong - you are paying out 100 now at 10% and will get 110 in one
year, so the yield to maturity should be 10% - does not matter when the bond
was issued







"Sean Timmons" wrote:

Based on MS Help, the rate and term are based on date of issue (not date of
settlement). So, if the security was issues on 1/1/08 on a 30 year bond, the
maturity date is 1/1/38, regardless of settlement date.

"BarryHWhite" wrote:

Why does Yieldmat include an issue date ?
The yield to maturity should be from the settlement date to the maturity
date, subject to the rate of interest and the price of the bond

It does not matter when in the past it was issued

However I see that changing the issue date changes the yield to maturity

Help please