Interest Rate and Bond Definitions

Before we really get into the meat of any posts I think it’s a good idea to start with some basic definitions and notation around interest rates. I have chosen some conventions which I think are clear and avoid confusion and in most cases consistent with other literature I have come across (though not all).…

Hello World and MsgBox in VBA

A traditional first programming exercise is the “Hello World” program and this is what we are going to cover in this post. ┬áIn the process we are going to take a look at how to use a message box in VBA to display some information to the user, how to configure these message boxes in…