Build a Complete Bond Pricer in VBA

Jack Tellington

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Lessons (32m)
    • 1. Introduction To The Bond Instrument

      2:48
    • 2. Create an Userform

      8:06
    • 3. Manage The Data Storage Management

      4:01
    • 4. Instantiate The Object

      5:10
    • 5. Implement The Formula

      6:54
    • 6. The Userform From Excel to VBA

      4:46

About This Class

In this course you will learn how to create a bond pricing tool . You will get to know important new functionalities on VBA, from create manually an unesthetic tool on a spreadsheet to structuring and optimimizing your work using the Userform. You will also learn some best practices on how to manage the data storage on VBA using the class.