Visual Basic for Financial Professionals
The site provides financial professionals with VBA code snippets and Excel projects that can be useful in their work. Some demos can be watched on our youtube channel . If you have questions, comments or suggestions use the
Contact Us link to send us an email.
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
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
Simple tool to set buy/sell targets and track prices and dividends
Overview of
Visual Basic
Procedures, Keywords, Constructs and Code
composition
An example of Excel Add-in containing useful functions for retrieval of price data
An example
of COM Add-in containing useful functions for
market data exchange
Examples of common controls and embedded objects
Sending email and
using Outlook events to process data
Sending email using
Lotus Notes
Writing and
generating html body text with Excel
OpenProcess, GetExitCodeProcess
SetCurrentDirectory, CoRegisterMessageFilter
UrlDownlodToFile
