Thanks alot Prince. Much appreciated.
Regards,
Boreh
On 13 December 2012 11:59, Prince wrote:
> Hi Kip,
>
> Just copy this function and paste it in your workbook. The bold one last
> line i have updated into this.
>
> Function PRICE364(settlement As Date, maturity As Date, rate As Double,
> yl
Hi Kip,
Just copy this function and paste it in your workbook. The bold one last
line i have updated into this.
Function PRICE364(settlement As Date, maturity As Date, rate As Double, yld
As Double, redemption, frequency)
'Initialize Variables
Dim COUPNCD As Date
Dim COUPPCD As Date
coup = 0
Hi expersts,
I am trying to run the attached macro to get price of a bond. Please assist
me get to know what i am doing wrong. Its not giving me any value, did i
miss a step?
Regards,
Boreh
On 11 December 2012 15:00, Robinson Boreh wrote:
> Hi Prince,
> Thanks for your feedback.
> Attached is
Hi Prince,
Thanks for your feedback.
Attached is an excel sheet with the macro and am getting zerodid i do
it wrong?
Thanks and regards,
Boreh
On 11 December 2012 14:27, Prince wrote:
> Hi Kip,
>
> I got 91.7021557489662 value in price variable and i call this function
> as per the param
