[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[RT] Re: Excel calc for treasury bond yield



PureBytes Links

Trading Reference Links

the excel formula "rate" will get you there, assuming you don't want 
to deal with details like purchase between pmt dates.  You could also 
do it with a string of payments as a cash flow steam and "IRR"  If 
done as of an interest payment date either should get you to the 
correct answer.

Chris

--- In realtraders@xxxx, "Earl Adamy" <eadamy@xxxx> wrote:
> I'm looking for an excel formula which calculates bond yield to 
maturity for
> treasury bonds ... must handle bonds purchased at premium/discount. 
Thanks.
> 
> Earl


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Universal Inkjet Refill Kit $29.95
Refill any ink cartridge for less!
Includes black and color ink.
http://us.click.yahoo.com/4bQK.B/MkNDAA/ySSFAA/zMEolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
realtraders-unsubscribe@xxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/