HOW VISUAL BASIC FOR EXCEL WORKS?

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

How to create a Macro in Excel?

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

WHAT IS EXCEL VBA?

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

What are Stock Options?

A Financial Option is a Contract between two parties that gives the Right to Buy or Sell an Underlying Security at a predefined Price for a limited Period of Time.   What is an Option Contract? In an Option Contract there...

Read More

Options Greeks calculation with Python

Aplying the BlackScholes formula we can relatively easily calculate the different greeks of the options. Options greeks are the parameters that are going to tell us how the option prices is going to performance in relation to...

Read More

Excel Management with Python Pandas

Here I share three excel functions that can be useful when working with Excel Files. When working with data, we must define an input and output way of dealing with data. As I used to work with Visual Basic in Excel, I feel more...

Read More
  • 1
  • 2