Logo

VbaFin.com

Visual Basic for Financial Professionals
Home
The purpose of this site is to provide financial professionals with VBA code snippets and complete projects that can be useful in their work and development. Below is the list of our current portfolio.

Extracting Data
Retrieving option chain using the Subscribe method of the BlpData class
Retrieving different data using the AdxRtList, AdxRtHistory and MrvInstrument classes
Retrieving option chain from Yahoo!Finance using the Excel QueryTable class
Retrieving option chain from www.cboe.com using the InternetExplorer class
Demonstrating how to use Murex scripts to control the application with VBA
 
Excel Projects
Comprehensive tool to manage equity swap resets and set up new deal templates
Retrieves Index Weights and Dividends Data from Bloomberg and Calculates Index Dividend Points
Dividends and Corporate Actions notification tool
Building Volatilty Surface and using the SABR model for calibration

Working with Email
Sending email and using Outlook events to process data
Sending email using Lotus Notes
Writing and generating html body text with Excel
  
VBA General
Why VBA
Why and how to learn Visual Basic
Overview of Visual Basic
Procedures, Keywords, Constructs and Code composition

Windows API Functions
OpenProcess, GetExitCodeProcess
SetCurrentDirectory, CoRegisterMessageFilter
UrlDownlodToFile