Visual Basic for Applications, or VBA, is a programming language that you can use to code within Word, Excel and other Microsoft Office applications.
You can do some pretty useful stuff with it, like automated report generation or creating user interfaces for complex financial models.
Today, though, we’re going to solve a really simple problem: making custom shortcuts [...]

In the first Speed Excel tutorial, we covered the uses of relative and absolute referencing, how to zip around a sheet using the Ctrl key and how to name cells.
Today, we’re going to cover how to quickly format cells, manage complex models and how to move to input and output cells in a flash…
The rest [...]

Back in 2008, I did a subject called FINS2624: Portfolio Finance. My strongest memory of the class has nothing to do with the material we covered (primarily the capital asset pricing model, aka CAPM); rather, it’s watching my tutor convert a series of daily asset prices into returns. He could do things in Excel I [...]

Chris Pearson examines Matthew Brooks and Paul Nojin’s Australia-specific quantitative finance findings.

Learn how you can use academic studies to improve your investing or trading activities.