Is there a way to calculate yield and duration on asset paying monthly. Currently excel allow only calculation on quarterly paying assets.
Thanks