The Achilles trick

There are various bits of clever maths I use here and there I like to refer to as “tricks”.  In fact I use them often enough to give them my own pet-names.  The one we are going to cover in this post is one I use quite a lot and in particular when deriving closed…

Simple annuities key formulas

Annuities are going to pop up everywhere on TAoQF so it’s a good idea to understand them and have some easy to remember ways of deriving key results. In this post we give a brief reminder of these and it’s intended it will be used as a reference for future (rather than a tutorial). Key…

Basic VBA Bonus: simple error handling

This is the first of two bonus lessons within the basic VBA course.  The aim is to improve how your code handles run time errors – these are the errors that occur when your code is running (as opposed to compile time errors/syntax errors).  When we mean simple error handling we mean dealing with errors…

Basic VBA 7: Going loopy!

We have already seen a number of examples of how to iterate over a given set of data and perform some action.  In this post we formalise these techniques and learn a few additional ways of doing it.  Each method we cover has a similar structure but each differs in the details of how we…