When it comes to the price function, there is this act/act and act/365.
Can anybody explain to me how does this work for excel.

Price(Settlement,Maturity,Rate,Yield,Redemption,Fr equency,Basis)
Settlement = 31 Mar 2006
Maturity = 14 Jul 2014
Rate = 6%
Yield = 5%
Redemption = 100
Frequency = 2
Basis :
Act/365 = 3
Act/Act = 1

I am trying to do a manual calcualtion based on these 2 basis. I
managed to recalculate the Act/Act but i cant do the Act/365. I believe
it has something to do with my period calcualtion.

Can anybody help me out? Thanks in advance.:)


--
Infinity
------------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725
View this thread: http://www.excelforum.com/showthread...hreadid=525601