Indian Institute of Quantitative Finance
Indian Institute of Quantitative Finance
Center of Finance Excellence - Quantitative Finance and Risk Management
Industry Partners
and Clients

In fo Current Courses

News Letter

Advanced Financial Modelling Certificate Programs:
VBA Programming for Finance
Derivatives Valuation & Risk Analytics

Financial Modelling using spreadsheets like MS Excel are used in many fields like investment banking, risk analysis, valuations, investment management, credit analysis, scenario analysis, financial projections, project evaluation, etc. These are implementation-oriented courses in which practicing Risk Modellers, Investment Bankers and Treasury Professionals teach the latest techniques and modeling skills that are used in the industry.

Many finance professionals who want to develop complex financial models and risk management professionals who have the theoretical background of the risk management models, find theirs skills to be inadequate when it comes to implementing the models and feel handicapped as it often requires considerable amount of programming in VBA. Merely knowing how to record or even write some odd macros in VBA is not of any help to them. There is no specialized course in IT domain that teaches VBA programming from basics and with exclusive focus on writing these kind of applications, a course like “VBA Programming for Finance”. This is why we have designed these courses tailor-made for imparting these skills. These programs are designed for people who do not have any kind of prior programming background and want to learn VBA programming for developing applications related to finance.

These courses comprises of modules on VBA Programming for Finance (which is a prior recorded lecture based module for participants not having any knowledge of computer programming) and Derivatives Valuation and Risk Analytics using VBA. The courses starts with learning the basic programming concepts in general and then learning programming using MS Excel VBA with specific focus on programming for high-end investment banking financial applications so that the candidates can relate their learning with their work. Then it goes on to learning implemention of valuation models of derivative instruments of various asset classes using the models being used in the industry and then learning to carry out risk analysis and implement various risk models for various asset classes.

Click here to get the Brochure and detailed Syllabus for the programs

Click here to see our student testimonials

MoreInformation Course Objective
These are "hands-on" courses, with extensive use of computers and spreadsheets. The objective is to develop VBA programming, spreadsheet and modelling skills for creating computer-based models for analyzing a variety of decision problems facing today’s financial managers and investment banking professionals. The assignments are designed to be similar to assignments delegates will encounter in their jobs.

Click here to get the Brochure and detailed Syllabus for the programs

MoreInformation Learning Outcomes
Delegates will learn to :
  • Write VBA programs for implementing advanced functionalities in Excel
  • Carry out Monte Carlo Simulations in Excel
  • Carry out Fixed Income Analytics in Excel
  • Price Derivative Instruments of Different Asset Classes Using Latest Models
  • Do Practical Implementation for Market Risk Analytics
  • Do Practical Implementation for Credit Risk Analytics

    MoreInformation Who Should Attend
  • Financial Analysts
  • Research Analysts
  • Risk Analysts
  • Credit Analysts
  • Investment Managers
  • Finance Controllers
  • Subject Matter Experts
  • Managers from corporates
  • Management students
  • IT Professionals

    MoreInformation Course Details (Online Weekend Course)
    Timings Saturdays and Sundays - 4:00 PM to 7:00 PM (Indian Standard Time)
    Course VBA Programming for Finance
    Commencement date Online Recorded Lectures
    Course duration50 Hours
    Course feeINR 10,000/- inclusive of taxes
    Course Certificate Program in Derivatives Valuation and Risk Analytics
    Commencement dateMay 21, 2017 (Online)
    Course duration60 Hours
    Course feeINR 45,000/- plus taxes

    Candidates registering in groups are eligible for discount on the course fee.

    MoreInformation Registration Process

    You may register online by filling up the form given here .

    Modes of payment

    Mode 1 - Cheque/Demand Draft
    Payments are accepted in the form of Cheque/DD in favor of "INDIAN INSTITUTE OF QUANTITATIVE FINANCE PVT. LTD." payable at Mumbai. Please mention your name, email, telephone number and your course of interest along with the payment.

    Please mail your payment to :
    Indian Institute of Quantitative Finance
    Module No. 624, Mastermind IV,
    Royal Palms IT Park, Goregaon (E),
    Mumbai - 400065

    Mode 2 - Wire Tranfer (NEFT/RTGS)
    Payments can also be made through internet banking. Please contact us for details of making payment through internet banking.

    Contact Details

    Mumbai Office:
    Module No. 624, Mastermind IV,
    Royal Palms IT Park, Goregaon (E),
    Mumbai - 400065

    Office Hours:
    Weekdays : 10:00 AM - 7:30 PM
    Saturdays & Sundays : 2:30 PM - 7:30 PM

    Contact Person:
    Nitish Mukherjee : +91-22-28797660 / +91-9769860151

  • Copyright © Indian Institute of Quantitative Finance Pvt Ltd. All Rights Reserved