Bond valuation in vba RRS feed

  • Question

  • i am new to vba and i need your help.

    I tried to write a bond valuation code in vba but i couldn't make it.

    I need to have two tabs, one for data input (maturity date, settlement date, face value, yield, coupon rate and frequency) and another one with the results (present value, duration, convexity). 

    I want the code to calculate the aggregate cash flows and duration for all bonds in the first tab(may have bonds with different maturities etc). 

    Can anyone please suggest me a source or give me some help?
    As an example i post the following pictures :

    Monday, October 26, 2020 12:57 PM