View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
chillihawk
 
Posts: n/a
Default Financial Function : Price

You will get 2 periods (1 in 2008 and 1 in 2012) where the total annual
numerator will be larger than the denominator (ie 366/365 if your
frequency was 1). This is due to the leap year. Rolling back from
your maturity date these will be 14/Jan/08 - 14/Jul/08 and 14/Jan/12 -
14/Jul/12. Set up the function to price these periods in isolation,
compare with Act/Act and that should clear up any discrepancies.