Visual Basic for Financial Professionals
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.
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
Sending email and using Outlook events to process data
Sending email using Lotus Notes
Writing and generating html body text with Excel
Why VBA
Why and how to learn Visual Basic
Overview of Visual Basic
Procedures, Keywords, Constructs and Code composition
OpenProcess, GetExitCodeProcess
SetCurrentDirectory, CoRegisterMessageFilter
UrlDownlodToFile
