PDA

View Full Version : Basic VBA code Help



imrou_the_f
01-12-2021, 07:44 AM
Hello Guys,

I need to realize a VBA code and it is really new and difficult for me, can you help building a code regarding these informations ?

Date of calculus: Februrary 8th 2015
Date of maturity: July 4th 2022
Frequency of coupon: 2
Mode of adjustement: 0
Type of broken coupon: 0
Date of start (emission of the bond): July 4th 2012

1.) List all the cashflow payment dates using the above information

2.) List all the cashflow payment dates using the adjustment mode 2

3.) List all the cashflow payment dates using the adjustment mode 2, and having 4 payment per year

Thanks for all

snb
01-13-2021, 04:14 AM
Regardez: https://forum.excel-pratique.com/