VBA Programming for Finance

New York Institute of Finance

How long?

  • 2 days
  • in person

What are the topics?

New York Institute of Finance

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Business Analytics

Business Analytics courses will introduce you to a popular and diverse profession. A business analyst is a specialist in many IT fields as well as in ...

Read more about Marketing

Marketing courses will plunge you into the vast field of marketing. In these courses, you will learn a variety of topics that cover each stage of runn...

Reviews

Comprehensive course analysis

Unbiased reviews from past participants
Global companies alumni of this course worked for
Positions of participants who took this course
Countries where most past participants are from
FREE
Individual needs analysis

Who should attend

Financial analysts and anyone seeking to become a better financial modeler.

About the course

This course will teach you the essential elements of Excel/VBA to build practically useful applications and conduct data analysis for finance.

This course is a component of the Data Analysis and Programming for Finance Professional Certificate

Prerequisite knowledge:

  • Familiarity with financial instruments and markets
  • Intermediate to advanced MS Excel skills

*CURRICULUM *

Day 1

MODULE 1: VBA FUNDAMENTALS

  • The VBA IDE
  • Recording and running macros
  • Data types, variables, constants and arrays
  • Functions and subroutines
  • Private vs. public procedures
  • Built-in functions and statements

MODULE 2: VBA PROGRAMMING TOOLS

  • Variable scope
  • Flow control, loops and exception handling
  • A Black-Scholes function
  • Calling Solver with VBA
  • Automating bond yield computations
  • Monte Carlo simulation

Day 2

MODULE 1: ADVANCED VBA TOPICS

  • Passing arguments to subroutines and functions
  • Pass by value vs. pass by reference
  • The Excel object model
  • Debugging
  • Error trapping
  • Creating add-ins

MODULE 2: WORKING WITH DATA

  • External data, files, databases and websites
  • Reading and writing .csv and .txt files
  • Sharing data with other MS Office applications
  • Accessing Bloomberg data with VBA

WHAT YOU'LL LEARN

DESK-READY SKILLS

  • Learn the elements of programming in VBA
  • Build an option pricer in VBA
  • Develop a Monte Carlo simulation engine with VBA
  • Write VBA code to access Bloomberg data and websites

PREREQUISITES

  • Familiarity with financial instruments and markets
  • Intermediate to advanced MS Excel skills

VBA Programming for Finance at New York Institute of Finance

From  $1,700
Add coaching to your course booking

Coaching can personalize and deepen learning for you and your organization.


Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Business Analytics

What will you learn from Business Analytics courses? First of all, you will learn about the profession of a business analyst, his duties, and what such a specialist does. You will get various soft skills, such as organizing teamwork, for example, acc...

Read more about Marketing

During Marketing courses, you will learn how to develop a business idea and create the right website to promote your product. You will gain the skills to analyze your business performance and make key decisions that improve the efficiency of your bus...

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.