Options valuation seems more an art than a discipline. I am trying at the moment to understand the differences in implied volatility among different strikes and expiry dates. As a first step, I’ve decided to download the...
HOW VISUAL BASIC FOR EXCEL ACCESS TO THE SPREADSHEET? Visual Basic for Applications (VBA) is an object-oriented programming language. Every application built in VBA will use different individual objects for performing the...Read More
WHAT IS THE VISUAL BASIC EDITOR? In the previous lesson we saw how to check the code generated when we record an Excel macro. This code was created in a new window and only can be maintained in it. This window is what we call...Read More
As we have seen in the previous post, it is possible to create Macros in Excel without the need for coding. For doing this, we need to record it using the Macro Recorder. Internally, a recorded Macro generates a VBA procedure...Read More
Excel VBA (Visual Basic for Applications) is the programming platform provided by Microsoft for Excel spreadsheets. As described in its name, it allows programming in Visual Basic language, adding functions for managing directly...Read More