Compare courses
Register
New York Institute of Finance

VBA Programming for Finance

Oct 15—16, 2019
2 days
New York, New York, United States
USD 1295
USD 647 per day
Oct 15—16, 2019
Online
USD 1295

How it works

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with New York Institute of Finance.

Full disclaimer.

Description

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

Who should attend

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

Next dates

Oct 15—16, 2019
2 days
New York, New York, United States
USD 1295
USD 647 per day
Oct 15—16, 2019
Online
USD 1295

How it works

Show more