[PDF] Advanced Modelling in Finance using Excel and VBA

Can excel and VBA be used in finance?

This is a dummy description. This new and unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. Advanced Modelling in Finance provides a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s.

What is advanced excel with financial modeling?

Advanced Excel with Financial Modeling is a financial spread-sheet application developed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

What is Excel & VBA?

No. 4 bestseller in 'General Finance' (erivativesreview.com, December 2001) This unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. It takes a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s.

How can VBA help in investment decision-making?

The professionals can use VBA to create macros that simulate the investment scenarios to get an overview of the expected results/effects. In such a way, it can eliminate human emotions that may interfere with the decision-making process and instead rely on a simulated analysis that is close to reality.